how to read chinese char from SAP and store to Netezza using DS

[tristar]

Hello everyone,

I am trying to build a job in DS to read, from our SAP system, chinese values and save them in Netezza DB.

First problem:

which kind of properites I need to set in R3 datastore ?

We use ftp mode to transfer data from SAP to job server.

Any particular setting in the file?

Second problem:

If I open with DS a SAP table (for example KNA1) in order to see chinese character, I see only littlel square.

I think that i need to set some properties.(code page?if so, which value?)....but I am not able to find the rigth one.

Third problem:

which kind of data type I need to set on query fields to be sure that i will not loose any information?Is varchar enough?

So to summarize:

what I should to set and do in my DS structure in order to be able to read correctly chinese data from SAP system?

Any help is appreciate

Thanks and Regards

Matteo

[former_member289290 · Accepted solution]

You need to choose locales that support the characters you are extracting. See a section called 'Locales and Multi-byte Functionality' in the Reference Guide for more information on the supported locales and encodings. Using a unicode codepage may be best if processing from different codepages.

Set the job server to use your chosen locale (utf-8 for unicode), unless your opperating system is already configured with it, in which case you can leave as <default>. The the SAP datastore and the SAP Transport Format for the file will use this codepage by default.

If you are getting truncation of characters in Netezza than make sure the columns are nvarchar or big enough to support the multibyte characters. Also check the Netezza client is configured correctly. The varchar columns in queries shouldn't truncate any data if the correct codepage is being used by the engine.

Regarding the unprintable characters seen in Designer. Designer uses the SAP GUI to communicate with SAP, so there may be a problem with the SAP GUI configuration.

Regards

Dan

[tristar · Accepted solution]

Thank you for your answer.

Actually I have fixed the problem of Data Services .

I have enabled East Asian language on Windows server and also I have set property Code Page with cp936 value and it displays correctly both on sap gui and Data services proper chinese character.

Now I try to prepare a dataflow and do some tests...

Matteo

[tristar · Accepted solution]

I did following:

set r3 datastore code page to cp936.

result: I can see the same values both on Dataservices and SAP gui.

Now I have created a simple job to read NAME1 from KNA1.

KNA1 is varchar 35.

I have create under netezza a table with nvarchar field (both 35 and 70 length)

database under netezza is utf-8.

When i run the job, i got no error, but the final result is a different sequence of chinese character.

If i copy and past on google translator the value from sap gui and Data Services, the result matches, but it differs from the translation read from netezza table.

Just to understand, the file produced on R3 system (data transport) is in utf or latin format?

On SAP system data are stored in chinese simplified.

Any suggestions?

About the local of job server, what should I set?

Thanks

Matteo