With 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 “Unicode” Setting
1.) Go to SAP BW > RSA1 > Source System > UD Connect > ….
3.) Go to MDMP & Unicode Tab and Run Unicode Test you must have access to TCODE SM59
5.) Save and Close the Source System Dialog
6. )re Run the Execution of Info package.