Prerequisites for UNIX - connect_cdc_sqdata - Latest

Connect CDC (SQData) Installation
Product type
Software
Portfolio
Integrate
Product family
Connect
Product
Connect > Connect CDC (SQData)
Version
Latest
Language
English
Product name
Connect CDC (SQData)
Title
Connect CDC (SQData) Installation
Copyright
2024
First publish date
2000
Last edition
2024-07-30
Last publish date
2024-07-30T20:07:46.464596

The prerequisites refer to the hardware and software required in order to install Connect CDC (SQData) for UNIX.

Operating System

You must have one of the following operating systems running on your hardware.

  • RedHat Linux (7+ for TLS support)
  • SUSE Linux
  • IBM AIX

Hardware Requirements (Processors / Memory)

Component Requirement
Platform
  • Intel - Pentium III or higher
  • AMD - Athlon or higher
  • IBM AIX - RS/600, pSeries server
Memory 4 to 16 GB depending on use (Apply/Replicator Engines or Captures)
Optional Captures (Db2/LUW, Oracle) under 1 MB for configuration files
Db2/LUW and Oracle Capture Transient Storage Additional 2 to 4 GB

Software Requirements

Component Version
If you are accessing distributed databases, you need a database connectivity to at least one
  • Db2/LUW version 10.5 or higher
  • Oracle 19 or higher
  • PostgreSQL 13 or higher
  • Other ODBC compliant relational database management systems (RDBMS)
  • Cloud based databases including those supported by AWS RDS (PostgreSQL, Oracle, MySQL, etc.)
If you are transporting captured data using a Messaging Service
  • Librdkafka 1.8 or higher for Kafka (current version recommended for Azure Event Hub).
    Note: At a minimum, you can use version 1.3 for Azure Event Hub.
  • Libcurl for Confluent Schema Registry
  • IBM MQ (Apply Engine Target ONLY, IBM MQ deprecated from Capture)

Third party libraries

A number of open source and proprietary libraries may be required by Apply and Replicator Engines as well as Capture agents identified in the Component column along with Required (minimum) and Recommended versions.

Required -
Function/Library Component Recommended Linux AIX Comment
TLS Connections/Encryption
libgnutls.so Engines na - current o na TLS 1.2 minimum
Code Page Conversion (including utf-8)
libicuuc.so Engines na - current r r
ODBC (generic data interface)
libodbc.so2 Engines 2.0 - current r r Requires unixODBC on Linux / AIX
DB2 Connect
libdb2.so (native/ODBC) Capture/Engine na - current r r
HDFS file system
libhdfs.so Engine na - current r na
Oracle SQL*Net
libclntsh.so Capture/Engine na - current r r
Confluent AVRO Schema Repository HTTPS interface
libcurl.so Engine 4.0 - current o na Required for Confluent AVRO Schema Registry
Kafka (Message Broker)
librdkafka.so1 Engine 1.3 - 1.9.x o na
IBM MQ (Message Broker)
libmqic.so Engine 8.0+ r r
libmqic_r.so Engine 8.0+ r r
  • Required - Recommended
    • " 2 - current " means 2.0 is required while recommended is current
    • "na - current" means any version should work but current is recommended
  • Linux and AIX
    • r - Always required
    • o - Optional EXCEPT when required for Source/Target, e.g: librdkafka only required for Kafka (and compatibles)
    • na - Not applicable to OS Platform
  • librdkafka.so 1 - 0.10.0 is minimum level recommended (current version is recommended for Azure Event Hub)
    To make librdkafka and libcurl accessible
    1. Locate the directory where the library exist.
    2. Use this command:
      cd /lib64
ln -s librdkafka.so.30 librdkafka.so

      For example, librdkafka.so.30 is the existing file you have on your system and librdkafka.so is the soft link you want to create.

      Note: Use the same command for the libraries in the list.
  • libodbc.so 2 - Requires unixODBC on Linux / AIX.
  • Library search sequence is:
    • SQDATA_libname_LIBRARY (SQDATA_GNUTLS_LIBRARY=<path_to_softlink/>libgnutls.so)
    • LD_LIBRARY_PATH
    • PATH
Note: On RPM-based Linux distributions, YUM (Yellowdog Updater Modified) or DNF (Dandified YUM) can be used to install these libraries. For more information regarding YUM or other Package Managers see your Linux or AIX Systems Administrator.