Data Exchange supports execution of a bulk data transformation and a changed data transformation of non-English databases as follows:
Table 6. Kanji and 8–bit non-English Support
Transformation | Supported Language | Supports... |
Enterprise Database Server to SQL Server, Oracle, or Kafka data stores | Kanji and 8-bit non-English | Data but not the schema names |
RDMS to SQL Server, Oracle, or Kafka data stores | Kanji, Gaiji, and 8-bit non-English | Kanji data and schema names; Gaiji data but not schema names; 8–bit non-English data but not schema names |
SQL Server to Enterprise Database Server | Kanji and 8-bit non-English | Data and schema names |
Data Exchange supports Gaiji for transformation from Enterprise Database Server to SQL Server, Oracle Database, or Kafka Data store. For this, you must:
Upgrade to the latest XlateEbcdic (for MCP 17 and 18) on the Windows server where Data Exchange Runtime Service is installed.
Prepare a CharacterMappings.txt file of your Unicode Gaiji to JBIS8 Gaiji.
Refer to the ClearPath Enterprise Servers MultiLingual System Administration,Operations, and Programming Guide for more information.