Home Data Replication i5/OS Change Data Capture for Informatica Power Center
Tuesday, 20 March 2012 23:40

i5/OS Change Data Capture for Informatica Power Center Featured

Written by 
Rate this item
(8 votes)

Version 1.2.3 of the Data Queue connector for Power Center support all data queue types and enables reading i5/OS database changes in real time. New name of the product is "Data Queue & CDC Connector for i5/OS". Data available in the i5/OS journal are propagated to Informatica Power Center. Power Center real time edition is the only licence requirement.   


Manual for the version is available for download:


Power Center connector for i5/OS Change Data Capture (CDC) is available hier:

The above zip file contains sample workflows and mappings which shows how to use the data queue and CDC connector. 


The Power Center connector for i5/OS (former as/400) Change Data Capture (CDC) is being used to build solution in which database changes in near real time are applied to any database supported by Informatica PowerCenter.It virtually means to any database. On i5/OS (as/400) database changes are deposited to journal (transaction log). The connector makes the changes available to PowerCenter mapping. Having the changes available to PowerCenter is easy to develop fully functional cdc replication to any database.

As example, in 8 hours was build mapping which reads changes from i5/OS (as/400) database which are deposited to journal and applies them to SQL database.  The changes where applied to 60 tables. The process was proven to survive TCP/IP connection failures and restart of operating system.


The replication is being used in my firm (which is one of the world leading insurance companies).

Licence for Informatica PowerCenter Real Time edition is required.





Read 13478 times Last modified on Thursday, 22 October 2015 19:08