Install and configuring JDBC Driver in SAP Java stack

[Former Member]

Hi Experts,

We are fetching data from GRC to BIW, for this we are using UD Connect in biw.

For this we need to configure and installed the JDBC Connectors.

Please suggest how to go about this.

Thanks,

Vijay

[Reagan · Accepted solution]

Check the suggestions provided in this SAP note for DB Connect mechanism

518241 - DB Connect in BW for an external Oracle database

If you still want to configure UDConnect then try changing the Driver Name with the below strings and see if it helps.

Driver Name: jdbc.oracle.OracleDriver
FixedCatalog : null
FixedSchema: null
Password : password of biw user id
URL: jdbc:oracle:thin:@PS-WIN-GRCQA:1527:VGQ
UserName : BIW user id

com.sap.portals.jdbc.oracle.OracleDriver

oracle.jdbc.driver.OracleDriver

com.oracle.jdbc.driver.OracleDriver

Refer to this SAP note

773401 - Configuring Portal JDBC System connection properties

Regards

RB

[Former Member · Accepted solution]

Hi RB,

Thank you so much.

DBConnect - It is not possible to develop multi-dimensional reports in BIW. So we are going for UD Connect.

And my problem is solved.

Solution : Upgraded JDK version 1.4 to 1.6, and we changed some configuration settings.

---

Thanks&Regards,

Vijay

[sumit_goel553]

check this link

http://scn.sap.com/docs/DOC-45748

[Reagan]

Hello

This has been discussed numerous times on SCN.

If you need to create a JDBC connection you need to deploy the source database drivers and then create a connection using Visual Admin or using NWA.

1348227 - JDBC connectivity to third party databases

Regards

RB

[Former Member]

Hi All,

I installed the oracle Jdbc drivers, but we are facing below error.

"Could not connect to database. Connection is inactive or does not support JDBC"

Please suggest.

---

Thanks & Regards,

Vijay

[Reagan]

After deploying the drivers in the Java stack did you create the JDBC connection in the BI Java stack ?

If yes then provide the details of the connection.

Regards

RB

[Former Member]

Hi RB,

Below are the information.

DriverName - com.sap.portals.jdbc.oracle.OracleDriver

FixedSchema - SAPSR3DB

Password - password of Schema user id.

URL - jdbc:sap:oracle://172.16.0.155:1521;SID=VGQ

UserName - BIW System User id [BASIS2]

--

Thanks & Regards,

Vijay

[Former Member]

Hi,

Kindly suggest.

---

Thanks & Regards,

Vijay

[Former Member]

Hi,

Kindly suggest.

---

Thanks & Regards,

Vijay

[former_member188883]

Hi Vijay,

Have you referred the document link which I shared earlier. It has step by step instruction to configure JDBC on AS-JAVA platform. We have followed the same procedure and could achieve desired results.

Hope this helps.

Regards,

Deepak Kori

[Former Member]

Hi Deepak,

Thank you so much for the reply.

I followed that document and i have some few quires regarding below.

Connector container---> ManagedConnectorFactory--->Properties

We given below latest values in j2eesever

Driver Name: jdbc.oracle.OracleDriver

FixedCatalog : null

FixedSchema: null

Password : password of biw user id

URL: jdbc:oracle:thin:@PS-WIN-GRCQA:1527:VGQ

UserName : BIW user id

Above information is it valid?

---

Thanks,

Vijay

[former_member188883]

Hi Vijay,

Information looks ok to connect BW system. Do you face any issue with such an entry ?

Regards,

Deepak Kori

[Former Member]

Hi Deepak,

Thanks for the quick response.

Yes, we are getting error while testing the connection with URL [http://172.16.0.90:50000/TestJDBC_Web/TestJDBCPage.jsp].

Error Message:

Error!

Could not connect to database. Connection is inactive or does not support JDBC.

---

Thanks,

Vijay

[former_member188883]

Hi Vijay,

It looks to me a driver issue

Can you download the driver from the information shared in the sap help below

BI JDBC Connector (SAP Library - Enterprise Reporting, Query, and Analysis)

Just for the information please share following details

1) BIW OS and DB platform

2) GRC OS and DB platform

Hope this helps

Regards,

Deepak Kori

[former_member188883]

Hi Vijay,

I could a useful document on GRC integration with BI.

SAML Response from SAP ID Service

Hope this helps.

Regards,

Deepak Kori

[Reagan]

It appears to me that the connection the target system is not working and could possible be due to a port issue (just guessing)

What is the database used by the BI system ?

Regards

RB

[Former Member]

Hi Deepak,

1. BIW OS - AIX 6.1 and DB - 11.2.0.2.0

2. GRC OS - WindowsServer 2008 and DB - 11.2.0.2.0

--

Thanks,

Vijay

[Former Member]

Hi RB,

BI System DB - 11.2.0.2.0 and port is 1527 [it is mentioned in the tns and listener].

--

Thanks,

Vijay

[Reagan]

If both the systems are using Oracle databases then why don't you use DBCON ?

SAP Library - BC Computing Center Management System

Creating a DBCON Entry (SAP Library - BC R/3 Database Guide: MS SQL Server)

Regards

RB

[Sriram2009]

Hi

Check this SAP Notes

1347514 - How to setup and configure the webi/deski JDBC connection for the Microsoft SQL Server 20...

1602614 - How To Install And Configure Microsoft SQL JDBC Drivers

  831162 - FAQ: XI 3.0 / PI 7.0 / PI 7.1 / PI 7.3 JDBC Adapter

Check the SCN blog

Configuring the JDBC Adapter - Advanced Adapter Engine - SAP Library

Regards

Ram

[former_member188883]

Hi Vijay,

Refer to SCN document below.

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

Hope this helps.

Regards,

Deepak Kori