Oracle Transformation

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

Example

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

Screenshot - Credentials link

The following SQL code creates user KEBOOLA_TRANSFORMATION, a schema with the same name, and grants the user read/write privileges 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 to 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.
  • 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 that this transformation, unlike the other transformations, runs on your Oracle Database server (it is not provisioned by Keboola) and you must ensure a flawless course.