PI to connect HANA database

[Former Member]

Dear All,

PI wants to connect HANA database in order to perform Database operations.

For that I need to deploy HANA Jdbc Driver into PI.

1) Where can I find this HANA JDBC Driver ? Can I download from Market place?

2) What is exact procedure to follow after find the Driver?

I didn't clear still after I followed few documents in SDN. can you please clarify me step by step.

Thank you
Sateesh

[Former Member]

SAP PI on HANA datbase .implementing PI on HANA didn't make sense in real scenario also

[Former Member]

Hi Gurus,

Please help me to install. HANA JDBC (2.1.19) ver in PI 7.1,tried with the help of JSPM a lot but failed.

Any one have doc of deploying HANA Jwdc.other than posted doc PI to HANA connection.

Thanks

Santhosh

[vicky20691]

Hi Santosh,

Follow the above.

regards,

Vikas

[vicky20691]

Hi,

Here is the page from SAP itself

Connect to SAP HANA via JDBC - SAP HANA Developer Guide for SAP HANA Studio - SAP Library

and after that the channel configuration is as usual.

More info -

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

Regards,

Vikas

[Former Member]

Hi Raghuram & Vikas,

Thanks for your posting on this.

I am working on for getting the Driver

My main situation here is what are steps to follow to deploy HANA JDBC Driver in PI.

As you know we already have MSSQL and Oracle drivers in PI. I do not want to loose these drivers while deploying HANA JDBC driver.

Please suggest some steps. thank you

Sateesh

[former_member186851]

Hello Satheesh,

Deploying the drirvers is same as you do for other JDBC drivers.

[vicky20691]

hi sateesh,

it will not harm the drivers which are already there. just deploy as usual jms/jdbc drivers are deployed.

[Former Member]

Hi,

Now I have HANA JDBC Driver in my hand. Now I want to deploy this Jar file into PI.

You must know we had deployed Oracle, MSSQL jar files into PI several years ago.

My question now is : If I want to deploy HANA  JDBC jar file into PI, then do I need to combine Oracle & MSSQL jar files along with HANA JDBC jar file.

Please clarify me on my question.

Thank you

Sateesh

[former_member186851]

Hello Sathessh,

No need.If you have already Oracle and MSSQL drivers deployed,Just Deploy HANA Drivers,IT will work.

[vicky20691]

No Sateesh,

You do not need to have it combined with anything.

You can deploy using SUM or NWDS and then check it in NWA->System Information.

Regards,

Vikas

[former_member186851]

Hello Sateesh,,

1) Where can I find this HANA JDBC Driver ? Can I download from Market place?

You can refer the below link

http://a248.g.akamai.net/n/248/420835/f121d4f3e204a9ba09067cc3866b1a0cb926b3d62472ca74fb51cc1e62955a...

2) What is exact procedure to follow after find the Driver?

After installing the drivers its like normal JDBC scenario, configure channel and query operaitons.