Skip to Content
author's profile photo Former Member
Former Member

Remote cubes in BW 3.5 with UDConnect

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Oct 14, 2005 at 10:00 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.