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: 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. 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. |
Oracle GoldenGate for InformixTips and Trick for Oracle GoldenGate for Informix. Getting Started
Resources
Archives
June 2017
Categories |