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.
0 Comments
Yes, Oracle GoldenGate supports capturing data from the compressed tables.
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. |
Oracle GoldenGate for InformixTips and Trick for Oracle GoldenGate for Informix. Getting Started
Resources
Archives
June 2017
Categories |