Oracle RDB
Overview
Semarchy xDI allows to work with Oracle RDB to produce fully customized Data Flows.
Third-party libraries
Due to licensing restrictions, we cannot distribute the Java libraries for this database. You must obtain them yourself.
After you have the necessary Oracle libraries, create a Oracle module for your project, and add the libraries to the module.
Supported Features
Common Features
Feature | Description |
---|---|
Reverse |
Metadata can be reverse engineered. |
DDL/DML Operations |
DML/DDL operations can be performed on the database, such as: Insert, Update, Select, Delete, Create or Drop. |
Integration Methods |
|
Load Methods |
|
Staging Methods |
This technology can be used as a staging to make data transformation, mutualization, and more. The following methods are supported:
|
Rejects |
Reject rules can be defined to filter or detect data that does not fulfill the rules during integrations. |
Replication |
Data can be replicated from or to this technology using Replicators. |
Sub-Metadata support
The Oracle component lets you create Sub-Metadata on Oracle RDB schema and query folder Metadata nodes.
To learn more about Sub-Metadata, see Work with Sub-Metadata.