Remote cubes in BW 3.5 with UDConnect

[Former Member]

Has anyone attempted to create a remote cube in BW 3.5 using UDConnect to attach to a remote database?

We have installed and configured a JDBC connection to an Oracle database for our BW 3.5 system using UDConnect. We are able to successfully perform the 'smoke test' from the UDConnect whitepaper to see table structures from the external database.

Our problems occur within BW. We are able to define the UDConnect datasource, but after building a remote cube and attempting to extract data from the remote database, we receive errors like the follwoing:

#43411D3A75923749E100000089CE400B#SAPEngine_Application_Thread[impl:3]_2

6##0#0#Error#1#com.sap.ip.bi.sdk.datasource.beans.BI_SDK_Bean#Plain###Ms

gException: Cannot open the connection: Cannot connect to JDBC data source: The url cannot be null# #1.5#00306E06E4B8005300000028000037D000040257DCA57682#1128476308457#/App

lications/BI/UDI#sap.com/com.sap.ip.bi.sdk.datasource.ds#com.sap.ip.bi.s

dk.datasource.beans.BI_SDK_Bean#J2EE_GUEST#2##BS1#DM205324

Has anyone seen this? Research so far has suggested there might be a problem with the BI SDK java beans not deploying correctly. How do I check this in visual administrator? If they did not deploy properly, i would think that the UDConnect would not be working at all and we would not be able to run the TestJDBC application provided with UDConnect.

Any thoughts or suggestions are appreciated.

Thanks,

-Matt Schababerle

[Former Member]

Hi Matt,

the error message 'Cannot connect to JDBC data source: The url cannot be null' points in the direction of a possible misconfiguration in the Connector Container service of the Visual Administrator. The important thing to note is that the smoke test only works on the originally delivered connection with JNDI name SDK_JDBC. Could you please check with which connection SDK_... you work in the scenario mentioned in your posting. Does it have a value in the URL field?

Regards, Uwe