Data Source - Oracle Database
- 03 Mar 2022
- Print
- DarkLight
- PDF
Data Source - Oracle Database
- Updated on 03 Mar 2022
- Print
- DarkLight
- PDF
Article Summary
Share feedback
Thanks for sharing your feedback!
Overview
Help page for setting up a data transfer from Oracle Database.
Settings
Step 1: General Settings
Oracle Database Connection Configuration | Yes | - | From the Oracle Database Connection Configurations created in advance, select the one with the necessary permissions for this transfer. If you have not previously created any Connection Configurations, click the Add Connection Configuration button to set up a new one. |
Database Name | Yes | - | Enter the database name containing the data you wish to transfer. |
Transfer Method | Yes | Query | Choose between either the Query or Incremental Load transfer methods. |
Query | Yes | - | Complete this field when using the Query transfer method. Write a query to extract the transfer data from Oracle Database. You can use custom variables to embed a value that will be dynamically set when the job executes. |
Table | Yes | - | Complete this field when the transfer method is set to Incremental Load. Enter the table name that contains the data you would like to transfer. |
Incremental Load Column Name | Yes | - | You can enter into this field when the transfer method is set to Incremental Load. For each transfer, the last value loaded from the column specified here will be saved as the Last Record Loaded. From the next transfer, only values higher than the Last Record Loaded, will be transferred. When using a unique and auto-increment column (e.g. id, created_at, etc.) enter it in this field. You can use comma separation to specify multiple columns. Note: you are unable to specify a column using the NUMBER data type, while using Incremental Load. |
Last Record Loaded | No | - | You can enter into this field when the transfer method is set to Incremental Load. When using Incremental Load, only data with a value higher than the value specified here will be transferred. If unspecified, a Full Load will occur. Do not change this value without a reason (such as if you need to re-load data from a specific date range), as there is a chance of data duplication. |
Was this article helpful?