Installation
Answer: Informix Dynamic Server provides a Change Data Capture API for external clients to capture transaction data from Informix IDS online logical logs. The API relies on the syscdc system database in IDS, which contains the change data capture functions and system tables. Running the syscdcv1.sql creates the syscdc database.
Note: The syscdc database can only be accessed or connected via the user informix.
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 thedatabase privileges that are required by Oracle GoldenGate to capture data from an Informix database. The credentials of this user must be supplied 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 priv's ?
Answer: The informix user is required for the capture. Please refer to IBM CDC API documentation for more info.
Details: The question is if the CDC libs 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. The remote capture and delivery is supported by Oracle GoldenGate. Please make sure you setup the ODBC connection correctly.
Feature
Answer: Oracle GoldenGate support capture data from compressed tables.
Question: What is the support of encryption in Oracle GoldenGate for Informix?
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.
Extract/Replicat Setup
Details: Informix database needs a colon(:) as the catalog delimiter for a fully qualified table name, i.e salesdb:contacts. How to specify such tables in Oracle GoldenGate parameter file?
Answer: Oracle GoldenGate for Informix requires user to use "." for fully qualified names, e.g. database_name.schema_name.table_name. For the example table, you can use salesdb.contacts. If there is a first_name column in the contacts table, you can use the following syntax: salesdb.contacts.first_name.