Regarding ODBC/JDBC driver

[Former Member]

Hi

To connect SAP BO Tools with HANA, document says ODBC/JDBC thru SQL is required.

What does it mean.. Does connectivity need both or we can use any one of them?

Anybody know when to use which one?.

To my understanding, i feel either one of them can be used...but when it has to be used?

No document explains on this.. pls share if any document.

Regards

Magalingam

[former_member182277]

Hi,

Please find the below link

http://www.sdn.sap.com/irj/scn/index?rid=/media/uuid/d0894550-cde1-2e10-adb2-a0df19f67b31

Hope it's clear your doubt.

Regards,

Neha Singla

[hai_murali_here]

Hi,

To Connect BO Tools to HANA,using jdbc driver is recommended.ODBC will be used by the Tools like Analysis for Office and Excel in somecases(through MS SQL Query option).

You can create a relational connection using the jdbc driver in IDT and can publish to BOE CMC which can be used for the creation of Universe so that BO Tools like Dashboard,Crystal Reports,WebI and Explorer can consume HANA data through this JDBC Connection.

Hope this helps you.

Rgds,

Murali

[Former Member]

Hi,

You can use both JDBC / ODBC connections.JDBC connection is the best. For more details look into - SAP BOBJ Data Access Guide

Regards,Balaji