About the Oracle connector plugin¶
From Sidra 2022.R3 version onwards, the autogenerated Transfer Query will be replaced by the DSU ingestion script. More information can be checked here .
The Oracle Connector (a Sidra plugin of type connector) enables seamless integration with Oracle enterprise relational database.
You can see more details of what is a Data Intake Process in this page.
Sidra's connector for Oracle allows to configure a Data Intake Process from a Oracle data source in a fast and easy way. The resulting configured Data Intake Process extracts data from any table and view in the source database and loads it into the specified Data Storage Unit at regular intervals. It relies on the Sidra Metadata Model for mapping source data structures to Sidra as destination and uses Azure Data Factory as underlying data integration mechanism within Sidra.
When configuring and executing this plugin of type connector, several underlying steps are involved to achieve the following:
- The necessary metadata and data governance structures are created and populated in Sidra: Data Intake Process, Provider, Entities, Attributes and needed relations among these.
- The actual data integration infrastructure (ADF Pipeline) is created, configured, and deployed.
The resulting Data Intake Process is configured in less than five-minutes. Once the settings are configured and the deployment process is started, the actual duration of the data ingestion from the created pipelines may vary from few minutes to few hours, depending on the data volumes.
After starting the Data Intake Process creation, users will receive a message that the process has started and will continue in the background. Users will be able to navigate through Sidra Web as usual while this process happens.
Once the whole deployment process is finished, users will receive a notification in Sidra Web Notifications widget. If this process went successfully, the new data structures (new Entities) will appear in the Data Catalog automatically, and the Data Intake Process will appear in the Data Intake section including this new data source.
Supported Oracle server versions¶
The supported Oracle server version by this connector plugin is:
- Oracle Database 19c.