Oracle Transformation

Oracle database is a multi-model database management system produced and marketed by Oracle Corporation.

Example

After you create a configuration, the first step is to configure database credentials using the Database Credentials link:

Screenshot - Credentials link

The following SQL code creates user and schema KEBOOLA_TRANSFORMATION and grants privileges read/write only to this schema.

CREATE USER KEBOOLA_TRANSFORMATION IDENTIFIED BY "secretPassword20" QUOTA UNLIMITED ON USERS;

GRANT CREATE SESSION TO KEBOOLA_TRANSFORMATION;
GRANT CREATE TABLE TO KEBOOLA_TRANSFORMATION;

Fill in the credentials to the database. After testing the credentials, Save them:

Screenshot - Credentials

After you save the credentials, follow these steps for create a simple Oracle transformation:

  • set the input mapping from that table to source,
  • set the output mapping for the destination table to a new table in your Storage,
  • copy & paste the below script into the transformation code, and, finally,
  • save and run the transformation.
CREATE TABLE "result" AS SELECT * FROM "SOURCE";

Screenshot - Sample Transformation

You can organize the script into blocks.

Please keep in mind, unlike the other transformation, this transformation runs on your Oracle Database server (is not provisioned by Keboola) and you must ensure flawless course.