Hi everybody!
I try to export my Oracle view data to Excel sheet using Oracle Data Integrator.
English text is exported good, but russian (cyrillic) is wrong!
Help me please, how can I configure datasources and encoding.
After export to excel data has cp1252 encoding, but there is no place where such encoding is configured!
Information:
Oracle DS use jdbc:oracle:thin and NLS_LANG=AMERICAN_AMERICA.CL8MSWIN1251 (in windows registry and environment variables, same to database).
ODI starting with product.conf:
AddVMOption -Dfile.encoding=Cp1251
AddVMOption -Dsun.jnu.encoding=Cp1251
AddVMOption -Duser.language=ru
AddVMOption -Duser.country=RU
(and I see such values in Help-About-Properties).
Excel DS use jdbc:odbc and charSet=cp1251 property.
Oracle 12c, ODI 12c.
If I execute simple java code (write results of query to System.out) with -Dfile.encoding=Cp1251 option - russian language displays correct.
But ODI - does not.
I would be glad any advice!
Regards, Andrew.