Oracle ERP Financials is a cloud-based financial management platform. Oracle ERP Financials is built on the Oracle database.
|Custom Data||check||All tables and fields|
Follow our step-by-step Oracle ERP Financials setup guide to connect Oracle ERP Financials with your destination using Fivetran connectors.
Once Fivetran is connected to your Oracle ERP Financials instance, we sync all the tables in the schemas for which we have READ permissions. We import each source table in full before moving onto the next table.
We then update your data at regular intervals. Our update strategy depends on whether or not your table has a
last_modified_date column (also known as a timestamp column).
Table with a timestamp columnlink
We pull all of the table’s new and changed data using your archived redo logs and LogMiner. If data in the source changes (for example, you change a data type), Fivetran automatically detects and persists these changes to your destination.
Table without a timestamp columnlink
We re-import the table in full. To avoid slowing down our syncs, we may not re-import the table during every incremental sync. The frequency with which we re-import the table is based on how fast we can ingest it from Oracle ERP Financials. This speed is entirely dependent on Oracle’s performance.
|Table Import Duration||Import Frequency|
|3 seconds or less||Every incremental sync|
|Between 3 seconds and 5 minutes||Twice a day|
|More than 5 minutes||Once a week|
We mark tables that take longer than 3 seconds to import as
not recommended in your Fivetran dashboard. We also include a message about how frequently Fivetran syncs those tables. By default, we exclude
not recommended tables from your syncs because they degrade performance. However, you can choose to include them.
Oracle ERP Financials’ schema follows the schema rules on our Oracle database connector page.
Syncing empty tables and columnslink
Fivetran can sync empty tables and columns for your Oracle ERP Financials connector. For more information, see our Features documentation.