sap logoWith UD Connect you can now integrate the data for the source object into SAP BW. You can either extract the data, load it into SAP BW and physically store it there, or, as long as the prerequisites for this are fulfilled, you can read the data directly in the source using a SAP RemoteCube. Example SQL Server 2008…

But, when we tries to extract data from SQL Server 2008 x64 database to SAP BW NW7 with UD Connect , we get an error message.

The error message when executing an  Info Package to load/transfer data from SQL Server 2008 x64 to SAP BW NW7.

S:RSSDK:400 Cannot convert field DECIMALS of type NUM to int

to solve the problem you have to check the SQl Server “UnicodeSetting

Steps:

1.) Go to SAP BW > RSA1 > Source System > UD Connect > ….

Right Clik on the UD connection name and Click on  Connection Param.
sap udconnect menu

3.)  Go to MDMP & Unicode Tab and Run Unicode Test you must have access to TCODE SM59

4.) If your target system is Unicode, then you have to tick Unicode for Communication Type for Target System.
sap udconnect unicode

5.) Save and Close the Source System Dialog

6. )re Run the Execution of Info package.

Good Luck

Leave A Comment

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.