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