About cookies on this site Our websites require some cookies to function properly (required). In addition, other cookies may be used with your consent to analyze site usage, improve the user experience and for advertising. For more information, please review your options. By visiting our website, you agree to our processing of information as described in IBM’sprivacy statement. To provide a smooth navigation, your cookie preferences will be shared across the IBM web domains listed here.
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.
[{"Product":{"code":"SSQHAB","label":"Tivoli Integration Composer"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"--","Platform":[{"code":"PF016","label":"Linux"},{"code":"PF033","label":"Windows"},{"code":"PF002","label":"AIX"}],"Version":"7.2;7.2.1","Edition":"Edition Independent","Line of Business":{"code":"","label":""}}]
Was this topic helpful?
Document Information
More support for:
Tivoli Integration Composer
Software version:
7.2, 7.2.1
Operating system(s):
Linux, Windows, AIX
Document number:
156681
Modified date:
27 February 2019
UID
swg21495949
Manage My Notification Subscriptions