Stambia Data Integration allows to work with Oracle databases to produce fully customized Integration Processes.
The database structure can be entirely reversed in Metadata and then used in Mappings and Processes to design and adapt the business rules to meet the user's requirements.
- The Oracle JDBC driver must be installed in the Designer and Runtime
- If using SQL*Loader, an Oracle client must be installed on the machine where the Runtime is located
Stambia DI is a flexible and agile solution. It can be quickly adapted to your needs.
If you have any question, any feature request or any issue, do not hesitate to contact us.
You can find below the necessary resources to work with this Component in Stambia DI
|Component resources||You can find in download section the Component resources.||Component resources download|
You can find below an overview of what Stambia DI can do with Oracle databases
The database structure can be reversed in a dedicated Metadata
|DDL /DML Operations||
DML/DDL operations can be performed on the database, such as: Insert, Update, Select, Delete, Create or Drop
The databases can be used as a staging area to make data transformation, mutualization, ...
The following modes are supported:
Reject rules can be defined to filter or detect data that does not fulfill the rules during integrations.
Replication of databases is supported.
The replication source can be any rdbms, Flat files or XML files.
Slowly Changing Dimension Integrations
|Integrations can be performed using Slowly Changing Dimension (SCD)|
|Analyze of tables||The work and/or target table can be analyzed with ANALYZE TABLE or DBMS_STATS.GATHER_TABLE_STATS to optimize data loading during integrations|
|Change Data Capture||The Change Data Capture (CDC) allows to follow and store all the changes on the tables|