Adapters

Topics:

The following section provides descriptions of new features for adapters.

Change Data Capture for MySQL

The DataMigrator support for Change Data Capture now includes the MySQL database.

In order to use CDC with MySQL, you must install Java and MySQL client utilities on the system where the DataMigrator server is installed. Additionally, on that system, you must have the Environment Variable CLASSPATH pointing to the location where the Connector/J is installed.

Connection for [Delimited] Flat File Targets

In prior releases when using DataMigrator to write a Flat File or Delimited Flat file the first configured connection was always used.

There is now an option to select <local> for the local file system where the DataMigrator server is running. You can also select a connection that refers to an FTP or SFTP server that has been configured for the server.

Extended Bulk Load Availability

Extended Bulk Load is now available on EXASol, Informix, MS SQL Server, Netezza, ORACLE, and PostgreSQL.

Extended Bulk Load for Hive and Impala

Data can now be loaded to HDFS using Extended Bulk Load. When the Hive or Impala server is remote, FTP is used to move the file to load.

File Attributes from File Listener

There are now virtual fields available when using the File Listener with the MONITOR pick up mode. In previous releases, these fields were only available with a pickup strategy of MONITOR, which does not actually read the files. They are now also available when reading the file with a pickup strategy of IMMEDIATE.

The available virtual fields include:

INSTANCE_FULL

The full path and name of the file. This field cannot be used in conjunction with INSTANCE.

INSTANCE_SIZE

The size of the file in bytes.

INSTANCE_DATE

The date that the file was last modified.

INSTANCE_TIME

The time that the file was last modified.

Additional fields are available for UNIX and Linux systems.

Support SFTP Source from a DM Server on Windows

Unlike Linux, Windows does not include an SFTP client program. However, there are programs available that implement the protocol. You can use an SFTP server as a source or target from a DataMigrator Server running on Windows by installing a SFTP client program, such as PuTTY.

MS SQL Server ODBC Adapter in Linux

The MS SQL Server ODBC adapter is now supported on Linux Red Hat 6 Intel x64 platform, in addition to Windows.

Change Data Capture for MySQL and MariaDB

The DMC now supports Change Data Capture (CDC) for both MySQL and MariaDB adapters with a load type of IUD.

WebFOCUS

Feedback