|
Prerequisites |
Scroll |
The prerequisites refer to the hardware and software required in order to install Connect CDC SQData for UNIX.
Hardware (Processors/Memory)
The Connect CDC SQData for UNIX operates on the following hardware platforms:
•Intel - Pentium III or higher
•AMD - Athlon or higher
•IBM AIX - RS/600, pSeries server
•Memory - from 4 to 16 GB depending on use (Apply/Replicator Engines or Captures)
Hardware (Disk)
•Installation TAR File - 24 MB (this file can be deleted after installation)
•Typical Installation - 50 MB
•Optional Captures (Db2/LUW, Oracle) under 1 MB for configuration files
•Db2/LUW and Oracle Capture Transient Storage - Additional 2 to 4 GB
Software
All Software vendors use the term "end-of-life" to describe the point beyond which an aging product is no longer supported. There are often two dates, a base and an extended End of Support date. Confirm that your installed software is supported. Precisely Connect CDC SQData will support operating systems and datastores supported by their respective vendors. See Release Notes for details on our Support lifecycle.
Operating System
You must have one of the following operating systems running on your hardware.
•RedHat Linux (7+ for zOS TLS connections)
•SUSE
•IBM AIX – Versions 7.1 and higher
Optional Software
If you are accessing distributed databases you will need database connectivity to at least one of the following:
•Db2/LUW version 10.5 or higher
•Oracle 18 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 plan on transporting captured data through a Messaging Service, you will need:
•Librdkafka 0.10.0 or higher for Kafka (current version recommended for AWS MKS and 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.so 2 |
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.so 1 |
Engine |
0.10.0 - 1.9.x |
o |
na |
|
|
|||||
IBM MQ (Message Broker) |
|||||
libmqic.so |
Engine |
8.0+ |
r |
r |
|
libmqic_r.so |
Engine |
8.0+ |
r |
r |
|
|
|||||
Notes: |
|||||
Required - Recommended |
" 2 - current " means 2.0 is required while recommended is current |
||||
Columns Linux, AIX |
r - Always required |
||||
librdkafka.so 1 |
0.10.0 is minimum level recommended (current version is recommended for Azure Event Hub) |
||||
libodbc.so 2 |
Requires unixODBC on Linux / AIX |
||||
Library search sequence is: |
1) SQDATA_libname_LIBRARY (SQDATA_GNUTLS_LIBRARY=<path_to_softlink/>libgnutls.so) |
||||
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.
