PI - JDBC Adapter - JDBC Driver Install

[Former Member]

Do we need to install JDBC driver to connect with externeral databases using JDBC adapter in PI 7.0 (to connect with SQL Server)?

It is required to install JDBC driver in XI 3.0, but I was told by Basis that it is not required to install in PI7.0. They said, it come with deiver which we can use to connect SQL Server directly. I checked for this info at several places, based on what I read, we need to install JDBC driver.

Any thoughts??

thanks..

[Former Member · Accepted solution]

Hi Hari,

You need to install JDBC Driver in XI 3.0 as well as XI 7.0.

Download the following JDBC Driver. Once you deploy this driver you would be able to connect to SQL Server 2005 as well as 2000.

.

<a href="http://www.microsoft.com/downloads/details.aspx?familyid=6d483869-816a-44cb-9787-a866235efc7c&displaylang=en">SQL Driver</a>

Regards,

Sumit

[former_member529475]

YOU need to install JDBC Drivers in PI7.0. to use JDBC Adapter...

Check this for installing Drivers...

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/70ffd890-0201-0010-708f-d5dad2df...

Check this document:

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/70ffd890-0201-0010-708f-d5dad2df...

For Drivers...

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/bf4b1055-0d01-0010-32a3-b3848d77...

Cheers..

Vasu

<i>** Reward Points if found useful **</i>

[Former Member]

Hari,

No they would have mistaken. You need to install the drivers to use JDBC adapter.

Check this document on how to install them:

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/70ffd890-0201-0010-708f-d5dad2df...

Regards,

---Satish