Stambia DI for IBM Informix

Stambia Data Integration allows to work with IBM Informix 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.

Prerequisites:

The IBM Informix JDBC driver must be installed in the Designer and Runtime

Note:

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.

Download

You can find below the necessary material to work with IBM Informix in Stambia DI

Name	Description	More Information	Download
Generic Templates	Package containing the generic Templates	Upgrade procedure Release notes	download previous releases
Informix Templates	The IBM Informix specificities are handled in dedicated Templates that can be found in this package Some are using generic tools that are shipped with the generic templates, make sure to import them too.	Upgrade procedure Release notes	download previous releases
CDC Templates	Package containing the CDC Templates	Upgrade procedure	download

Supported features

You can find below an overview of what Stambia DI can do with IBM Informix databases

Standard features

Name	Description
Reverse	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
Integration methods	Append Incremental Update
Staging	The databases can be used as a staging area to make data transformation, mutualization, ... The following modes are supported: staging as subquery staging as view staging as table
Reject	Reject rules can be defined to filter or detect data that does not fulfill the rules during integrations. Three type of rules can be created: Fatal, Warning, Reject Depending on the specified type, the rejected data will not be handle the same way Rejects of previous executions can also be recycled
Replication	Replication of databases is supported. The replication source can be any rdbms, Flat files or XML files.