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
Steps:
1.) Go to SAP BW > RSA1 > Source System > UD Connect > ….
Right Clik on the UD connection name and Click on Connection Param.
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.
5.) Save and Close the Source System Dialog
6. )re Run the Execution of Info package.
Good Luck