Details: When reading the report file, I got the "OGG-10302  The column comment_text in table <table_name> r having datatype text:12 is ignored by CDC capture? 
Answer: The problems is these datatype are not supported by IBM CDC API. GoldenGate support them via FETCHCOLS. The following data types need to use FETCHCOLS:

• TEXT, BYTE, LOB (BLOB, CLOB), HTML

Details: The question is if the CDC libraries are on Server 2, Informix IDS is on Server 1. Can we install OGG on Server 2  to and extract from Server 1? How about replicat?
Answer: Yes, you can. Oracle GoldenGate for Informix supports the remote capture and delivery. Please make sure you setup the ODBC connection correctly, and the remote operating system has the same endian as the source operation system. 

Created 2/25/2015  Last Updated: 9/25/2016

The following is the data type mapping for Oracle GoldenGate replication between Oracle and Informix IDS database. 

The Boolean datatype (Informix.Boolean) in Informix database is a binary value (0 or 1). You can't map it to Oracle Varchar2.or CHAR(1).  You need to use Oracle RAW datatype: 

• Informix -> Oracle  [ BOOLEAN -> RAW(1)]
• Oracle -> Informix [RAW(1) -> BOOLEAN]

If the mapping is not correction defined,you will get the "It is not possible to convert between the specified types." error.

Oracle GoldenGate for Informix 12.2.0.1.1 was released in February 2016. In this version, the following new features are implemented: 

• Automatics Heartbeat Table: heartbeat tables are created for the end-to-end replication monitor.
• Metadata in Trail: No need to use defgen or use the SOURCEDEFS/ASSUMETARGETDEFS parameter. 
• Parameter Insight: The info param command in GGCSI now provides parameter definitions.
• One Billion Trail Files: Trail files sequence number can be night digits. 

Starting this release, only Informix IDS 11.7 and 12.1 are supported. (Informix 11.5 is dropped from the support.) 

Answer: Informix IDS supports the use of column-level encryption to store sensitive data in an encrypted format. After encrypting sensitive data, such as credit card numbers, only users who can provide a secret password can decrypt the data. The CDC API can read the column data from logical logs in encrypted format and consequently the Oracle GoldenGate Extract process will write the encrypted column data to the trail file. This ensures that security is not compromised.

Details: In regards to 1.3.3.: "The Oracle GoldenGate Extract process must connect as the Informix user, and only to the SYSCDC database. This user has all of the database privileges that are required by Oracle GoldenGate to capture data from an Informix database. The credentials are used in the Oracle GoldenGate parameter files in a secure manner. You will be prompted for this information during the configuration instructions. Is connecting to the Informix as the Informix user the only option for the GoldenGate Extract? Can we create another Informix user with similar privileges?
Answer: The Informix user is required for the capture. Please refer to CDC API documentation for more info.  for more info.