The following section provides descriptions of new features for adapters.
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.
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 is now available on EXASol, Informix, MS SQL Server, Netezza, ORACLE, and PostgreSQL.
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.
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:
The full path and name of the file. This field cannot be used in conjunction with INSTANCE.
The size of the file in bytes.
The date that the file was last modified.
The time that the file was last modified.
Additional fields are available for UNIX and Linux systems.
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.
The MS SQL Server ODBC adapter is now supported on Linux Red Hat 6 Intel x64 platform, in addition to Windows.
The DMC now supports Change Data Capture (CDC) for both MySQL and MariaDB adapters with a load type of IUD.
WebFOCUS | |
Feedback |