What Driver name/class and url are to be provided?

[Former Member]

I have created a new alias for jdbc in the portal along with the user-mapping...........as a result i can see jdbc system in the system drop-down box.............but i m having some problem while making the connection with portal as it is asking for driver name/class and url and also other details..........my back-end server is MS SQL...........What Driver name/class and url are to be provided in this case or any other details required?????

thank you very much............

[Former Member]

JDBC settings for SQL Server should look like this:

Driver:

com.sap.portals.jdbc.sqlserver.SQLServerDriver

URL:

jdbc:sap:sqlserver://<server>:<port>;DatabaseName=<database_name>

e.g.

jdbc:sap:sqlserver://mysqlserver:1433;DatabaseName=Northwind

For more info look at SapNote #773401.

Hope that helps.

BR/marek

[Former Member]

Hi Deep,

There is a how-to posted on SDN regarding how to connect and configure the BI JDBC Connector.

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/library/uuid/6209b52e-0401...

This document describes the jdbc driver to use etc.

Hope this helps,

Cheers,

Scott