DB Connect for MS SQL External Database

[Former Member]

While pulling data in BW from MSSQL Database by DB Connect, I faced this problem

of NO MAPPING AVAILABLE FOR DataSource XXXXXXX. Assign an InfoSource.

and Errors in source system.

My BW System is currently at following patch level

SAP_BW - Patch Level 009

SAP_BASIS - Patch Level 033

SAP_ABA - Patch level 033.

I saw a note for the same on OSS (Note Number: 354972) but the source code corrections are already implemented in my BW system.

Any help regarding this will be most appreciated.

Thanking you all in advance..

Regards,

Parthiv Shah

[Former Member]

Hi Parthiv

I've faced the same problem in linking SAP BW with MS SQL via DBconnect. In order to solve it u should to check the profile if the user who has create the view that u want to import in BW envirnoment. those view, as u probably knows, have to be namend in uppercase and the user-creator has to be used, in BW, for the setting of the DBconnect in the source system workbench (modelling).

The problem is the profile of the user. check for his plicy..he has to be under the profile DB_DDLADMIN and he has to have the flag for SELECT in his permission..

cheers.

Luca

[alexander_peter]

Hi ,

Thank you for this question. What you are reporting looks to me like a bug in the system. The channel for such questions is the Service Marketplace http://service.sap.com/. Please post it there.

Best regards,

Alex PETER, SAP AG