Visual Composer, JDBC

[Former Member]

Hi all Gurus out there.

I am struggeling a littel bit with the Visual Composer where I would like to connect to a MSSQL database an greate some iViews based on tables and views in the Database to be used in SAP EP 6.0 NW`04

I have done the following.

1. Patched up the with the SDM so that the portal is able to use the BI(Business Intelligence) kit - regarding steps from the "SAP NW Visual Composer Installation Guide page 8 and 9". Here I had to deploy BIMMRXX.sca and BIUDXX.sca files with the SDM tool.

2. From there I had to go to the Post-Installation Activities for the "SAP Business Warehouse 3.5" guide at page 25 to perform some tasks in the Visual Admin.

3. In Visual Admin I had to go to Connector Container, selected the sap.com/com.sap.ip.bi.sdk.dac.connector.jdbc/BI_JDBC_CONNETOR and selected the Managed Connection Factory-Properties to perform changes to get access to my MS SQL database.

Driver Name = com.microsoft.jdbc.sqlserver.SQLServerDriver

FixedCatalog = mydb

FixedSchema = dbo

Password = my password

Username = sa

URL = jdbc:sap:sqlserver://XX.XX.XX.X:1433;DatabaseName=mydb

4. In the portal, I went to System Admin - System Conf - System Landscape - New from Par file - System - com.sap.portal.systems.BIUDI file and selected SAP_BI_JDBC and created a system

In UserManagement I have set the selection to admin,user

In ConnectionPorperties I have set:

Connection URL= jdbc:sap:sqlserver://XX.XX.XX.X:1433;DatabaseName=mydb

Driver Class Name = com.microsoft.jdbc.sqlserver.SQLServerDriver

Fixed Catalog = mydb

Fixed Schema = dbo

I have then set the Alias to SAP_BI_JDBC and peformed the usermapping with userID = sa and Password = my password.

5. I then tried to test the connection and get the result that says "Retrieval of default alias successful, Connection failed. Make sure user mapping is set correctly and all connection properties ar correct"

So obviosly something is wrong some place, but where?????

6. I then tried in the Visual Composer to create a page and iview, From the iview level i selcted BI from the toolbar and BI QUuery Wizard - get the welcome screnn -Next- Get Available systems and selected the JDBC Connections and my system called SAP_BI_JDBC, Next - Selected All Data and Next - and get the error message as follows.

Error - 21003: Cannot retrieve catalogs and schemas. Failed to connect to backend system. Check your system definition and user proveliges...

And again, What have I performed that is not correct??

Please help me out

Regards

Kay-Arne

[Former Member]

Maybe I will not earn some useful points, but I would like to share with you my experience with EP, JDBC and suburbia.

I made the same operations described by Kay-Arne S. Aarlie with the following differences:

1. bis - I installed Microft JDBC driver before configuring JDBC Connector with Visual Admin. Do not forget to set up CLASSPATH in order to "see" the 3 jar files that make up the Microft JDBC

2. bis - I used the following JDBC Driver Name = com.microsoft.jdbc.sqlserver. Remember to follow the instrunctions on p. 25 of "SAP Business Warehouse Installation 3.5" to perform some tasks in the Visual Admin. You have to use the same name when you set-up the library name on point #7 (p. 31 of the above mentioned document). In this case library:com.microsoft.jdbc.sqlserver

3. bis - I used the following

URL = jdbc:microsoft:sqlserver://XX.XX.XX.X:1433;databaseName=Northwind

and not URL = jdbc:sap:sqlserver://XX.XX.XX.X:1433;DatabaseName=mydb

4. bis - I used the following

URL = jdbc:microsoft:sqlserver://XX.XX.XX.X:1433;databaseName=Northwind

and not URL = jdbc:sap:sqlserver://XX.XX.XX.X:1433;DatabaseName=mydb

4. ter - To play safe restart your EP

Check your configuration with

http://EPserver:portNumber/TJdbc/servlet/TestJdbc

you should see info about Northwind

Hope this could help

Ciao

Giuseppe

[Former Member]

Solved

[Former Member]

Hi Kay,

I am having the same problem.

Can you please tell me how you fixed it

Thanks

[Former Member]

We have the same problm here. Is it posible to post the solution here in SDN?

THX & Regards,

Denis

[Former Member]

I'm sorry, but was the solution too much to mention, or describe? I am experiencing the identical issue. Sure would be helpful if I knew the solution to the problem.