Skip to Content

SAP Data Services Code Page Issue.

Hi ,

I have different source systems with MSSQL server database.

I have one database with Arabic_CI_AS and another database with SQL_Latin1_General_CP1_CI_AS.

That's why we created the staging database and DWH layer with UTF-8 ( Sybase IQ).

For the source( MS SQL) I have created the data store with :

Language : Arabic (ara)

Code Page : CP1256

Sever Code Page : UTF-8

My Target database ( Sybase IQ) for both schemas ( Staging & DWH) settings are below:

Language : Arabic (ara)

Code Page : UTF-8

Sever Code Page : UTF-8

But after loading the data into the staging target table I can see the data from table view but If i want to see from the Sybase IQ interactive sql tool , I am getting junk characters. I tried to load the staging loaded data into the DWH layer In this case both table view and interactive sql , I am seeing junk characters only.

If I try to load with bulk load option then I can see the data in interactive sql but I cannot see the data in the view table option.

Because of this issue I am unable to load any table into my DWH layer.

It is very urgent.

Please help me to resolve this issue.

Thanks & Regards,

Ramana.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Posted on Dec 07, 2015 at 10:06 AM

    Hi Ramana,

    What is the Collation of the database schema for DWH Layer

    Can you check with the collation 1256ARA if it is feasible for the database

    Regards

    Arun Sasi

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 08, 2015 at 09:55 AM

    We had the same issue. We also have an utf-8 SAP IQ database as target.

    For us, the solution was the following.

    1. Use a DSN (ODBC) instead of a direct connection for your SAP IQ datastore;

    2. While creating the ODBC, go to Advanced and change the value Charset to utf-8

    Hope this helps 😊


    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.