Multi source universe in IDT

[Former Member]

Hello,

We are trying to build a multisource universe based on salesforce. com and sql server databases. We have created a JDBC connection for salesforce.com and odbc connection for sql server. When trying to create a multisource universe the salesforce.com connection is greyed out. Multisource universe wroks fine when using sybase ODBC connection as well as sql server ODBC connection. It only fails with salesforce.com. We are able to create a standalone universe based on the salesforce.com connection using JDBC connectivity. Does IDT support multisource universe for salesforce.com?

Thanks,

Laxminarayana

[Henry_Banks]

HI Laxmi,

Just a reminder that SAP employees have an internal forum called BOPedia - please use it.

Please use Note 1561226 to help troubleshoot MSU. Youu2019ll need to use the DFAT to profile the workflow.

You probably need to unpack the JDBC .jar files into this server location (folder need to be manually created for each vendor): C:\Program Files\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\dataAccess\connectionServer\jdbc\drivers\jdbc

.... A similar problem was described here for Jaybird DB: https://cw.sdn.sap.com/cw/message/47421#47421

Regards,

Henry