• Home
    • 2018
    • 2017
  • Oracle GoldenGate
    • Core Platform
    • Cloud Service
    • For Oracle DB
    • For Big Data
    • For MySQL
    • For DB2 z/OS
    • For DB2 LUW
    • For DB2 i
    • For Informix
    • For SQL Server
    • For Teradata
    • For AWS Aurora
    • Foundation Suite
    • Use Cases
  • Data Management
    • General
    • Big Data
    • Oracle Database
    • MySQL
    • MS SQL Server
    • IBM DB2
    • IBM Informix
    • Teradata
    • SAP ASE
  • Data Science
  • IT
    • IT Management
    • IT Technology
  • Reading
  • About
Jinyu's Blog
About Data, Database, Integration and IT 

What is Oracle GoldenGate for Informix?

6/20/2017

0 Comments

 
Oracle GoldenGate for Informix replicats data to and from IBM Informix IDS database.  The major features include: 
  • DML(INSERT, DELETE, UPDATE) and TRUNCATE replication 
  • Support tables with data compression and column encryption 
  • Support fragmented tables 
The primary limitations are: 
  • No support of case sensitive tables and column names.
  • No support of collection data types (SET, MULTISET, LIST, ROW) and SQL_LONGVARCHAR
  • No dynamic wildcarding support
  • Can't read Informix archive logs
  • No DDL replication support
0 Comments

Why I get the column in table is ignored by CDC capture? 

9/28/2016

0 Comments

 
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
0 Comments

Can I install Oracle GoldenGate on a separate server? 

9/26/2016

0 Comments

 
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. 
0 Comments

How to map data types between Informix and Oracle Database?

9/25/2016

2 Comments

 
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. 
Informix Oracle
BOOL RAW,BLOB
CLOB CLOB
BLOB BLOB
CHAR with length <=2000 CHAR
CHAR with length > 2000 CLOB
VARCHAR, max length 255 VARCHAR2
DATE DATE
DATETIME TIMESTAMP, DATE
INTERVAL No Support
DECIMAL NUMBER
FLOAT NUMBER
SMALLFLOAT NUMBER
SMALLINT NUMBER
INT8 (INTEGER) NUMBER
BIGINT NUMBER
LVARCHAR CLOB
MONEY NUMBER
SERIAL NUMBER
SERIAL8 NUMBER
BIGSERIAL NUMBER
NCHAR NCHAR, max length allowed is 2000
NVARCHAR, max length 255 NVARCHAR2
BYTE LONG RAW,BLOB
TEXT CLOB
HTML CLOB
2 Comments

How to map Informix Boolean datatype to Oracle database?

9/25/2016

0 Comments

 
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.
0 Comments

Oracle GoldenGate for Informix 12.2 Release (12.2.0.1.1) 

1/31/2016

0 Comments

 
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.) 
0 Comments

How to determine the current Informix IDS and Client SDK version?

2/24/2015

0 Comments

 
Before implementing replication with Oracle GoldenGate for Informix, you need to check the Informix IDS database version and the Informix CSDK version. Oracle GoldenGate has the following requirements:
  • Oracle GoldenGate supports Informix 11.5, 11.7 and 12.10 databases but there are requirements on the versions of Informix IDS Database. Please refer to  Oracle GoldenGate Documentation -1.3 Informix Dynamic Server Requirements for more information.  
  • Operating System: Please refer to the latest certification matrix document. Note that: Oracle GoldenGate for Informix only supports 64-bit platforms.
  • Latest Informix CSDK is recommended. The version should be  after CSDK 4.10FC4.
You can confirm the information in your environment with the following commands:
In this example, the OS version is Windows 2012 and Informix IDS 12.10, CSDK is 4.10 FC4DE. You need to choose the GoldenGate download based on the OS type. For each download, Oracle GoldenGate supports Informix 11.5, 11.7 and 12.10 databases.
0 Comments

What is the support of encryption in Oracle GoldenGate for Informix? 

12/10/2014

0 Comments

 
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

Does Oracle GoldenGate for Informix support Informix IDS compression? 

12/9/2014

0 Comments

 
Yes, Oracle GoldenGate supports capturing data from the compressed tables. 
0 Comments

 Is the informix user required for Oracle GoldenGate extract?

12/8/2014

0 Comments

 
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.
0 Comments
<<Previous

    Oracle GoldenGate for Informix

    Tips and Trick for Oracle GoldenGate for Informix. 

    Getting Started
    1. What is Oracle GoldenGate for Informx
    2. ​Enable Informix Change Data Capture (CDC) 
    3. Install and Configure ODBC
    4. Install Oracle GoldenGate
    5. Configure One-Way Replication(Between Informix)
    6. Configure Two-Way Replication(Between Informix) 
    7. Set Up Initial Loading (Informix to Oracle)
    8. Configure One-Way Replication (Informix->Oracle)
    Resources
    • ​IBM Informix Homepage
    • Documentation: Oracle GoldenGate for Informix Installation Guide (12.2)

    Archives

    June 2017
    September 2016
    January 2016
    February 2015
    December 2014
    November 2014
    October 2014

    Categories

    All
    FAQs
    Feature
    How To
    Installation
    Release

    RSS Feed

Copyright © 2010-2027 Jinyu Wang.