Oracle

Oracle is a relational database created in the late 1970s and is still in use today. The pipeline of data from Oracle to the Data Warehouse created by Kondado allows you to replicate your tables and views to your analytical cloud, in full or incrementally (capturing new and updated data).

Adding the data source

To automate Oracle ETL with Kondado for your database, follow the steps below:

1) Add the Kondado IPs in the database server (and in your VPC) for the port that will be used to connect with Oracle (usually 1521)

2) On Kondado platform, go to the add data sources page and select the Oracle data source

3) Name your data source and fill in your database information

Now all you have to do is save the data source and start integrating Oracle data into the Data Lake or Data Warehouse.

Pipelines

Relationship Chart

Tables and Views

With our pipeline, you will be able to integrate tables as well as views
If your table has a datetime/timestamp type column that marks when a record was changed/inserted, your pipeline can be incremental
It will be necessary to define the primary key, which can be defined by several columns and refers to the column (or set of columns) that define a record as being unique
The created table will have a configuration similar to this:

Field	Type
col_x	text
col_y	text
col_z	text

Fields that are created as type text will undergo a transformation that will try to convert special characters into their equivalents (for example “é” becomes “e”). If this is not possible, the character will be removed.