Connect Portal 7.0 EHP 1 with database SQL 2000

[Former Member]

Hi,i need connect a database SQL 2000 (no-SAP) from the portal, but not understand the procedure. please, you have documentation???

Best Regards,

EDRS

[Former Member]

HI,

You have to use JDBC drivers template and set the correct properties over there to connect to external DB

Connector- Here you have to give connection url and driver class name.For different rdbms they will be

MSSQL driver:

com.sap.portals.jdbc.sqlserver.SQLServerDriver

MSSQL Connection URL:

jdbc:sap:sqlserver://<HostName>:<Port#r>;DatabaseName=<Instance>

User mapping

Distributed Query Engine :Portal to RDBMS connection. Provide system account of RDBMS( Admin credentials for backend connection)

Check this forum link for more details:

Regards,

Ashutosh

[Former Member]

Hi Ashutosh, for example:

data connection database no-SAP

SQL Server 2000

IP Servidor: 192.168.3.20

Usuario: name1

Clave: mbs11i

Base de datos: name1

I have create Iview in the portal??

Best Regards,

EDRS

[Former Member]

Hello Eli,

You need to install MSSQL driver in portal. Please go through the below PDF for more details.

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/58f4db47-0501-0010-a2bf-ff01b150f...

Good Luck.

Thanks,

Siva Kumar

[Former Member]

Hi Siva, try looking at the Microsoft page msbase.jar files, mssqlserver.jar, msutil.jar but I have not been found. You know where to download?

Best Regards,

EDRS

[Former Member]

Hello Eli,

Now I remember that the drivers mentioned in the given document are no longer exist. Microsoft release latest release. Please go through the note 639702 for more details like where to download.

You may need to download Microsoft SQL Server JDBC Driver 3.0 for your SQL server release. Please take a look at below link as well.

http://msdn.microsoft.com/en-us/sqlserver/aa937724

Thanks,

Siva Kumar

Edited by: Siva Kumar Arivinti on Jan 23, 2012 1:07 AM

[Former Member]

Hi Eli,

You can do it thru UD Connect from Portal. Please refer to below link for procedure.

http://help.sap.com/saphelp_nw04/helpdata/en/78/ef1441a509064abee6ffd6f38278fd/content.htm

Regards,

Arjun