Troubleshooting
Problem
ITIC does not copy fields with Russian symbols correctly. Source Database : Collation of DB is "Cyrillic_General_CI_AS". (Microsoft SQL Server 2005 (9.0.4035))
Resolving The Problem
These are instructions to down load and use Microsoft JDBC driver to
address the issue:
1. Download the Microsoft driver
- Within 30 seconds browser will offer to open/save license page.
Select open
- Click on
"I Accept and I want to download the Microsoft Windows version" or
"I Accept and I want to download the UNIX version "
at the bottom of the page depending on your operating system
- Save the file
- Unzip the downloaded file and copy sqljdbc.jar file to Integration
Composer's lib folder
2. Modify INIT.BAT (or INIT.SH) file:
- Add
set JDBC_MS_SQLSERVER=%WORKAREA%\lib\sqljdbc.jar
to "DEFINE JDBC ENVIRONMENT VARIABLES" section
- Add
set CLASSPATH=%JDBC_MS_SQLSERVER%;%CLASSPATH%
to UPDATE THE CLASSPATH section
3. Start ITIC
4. Select Browse Data Source by Data
- On the Open Data Source screen select Generic JDBC driver in the
Connection Method drop-down list
- Put "com.microsoft.sqlserver.jdbc.SQLServerDriver" in the driver
field (without quotes)
- Put
"jdbc:sqlserver://<HOST_NAME>:<HOST_PORT>;databaseName=<DATABASE_NAME>;i
ntegratedSecurity=false;" in the URL field (without quotes) and replace
<HOST_NAME>, <HOST_PORT> and <DATABASE_NAME> with correspondent
values
- Provide User ID, Password and table owner
- Click Finish button
5. When schema opens find the data that contains russian characters and
see if they are displayed correctly in ITIC UI
6. Run the mapping and verify the data in TAMIT.
Was this topic helpful?
Document Information
Modified date:
27 February 2019
UID
swg21495949