ODBO Vs ODBC

[former_member191765]

Hi Experts,

Can you please let me know when we go ODBO/ODBC with XL. What are the advantages with respect to analysis

Thank you,

Ankur...

[michael_tocik5 · Accepted solution]

Hi Anjan,

     ODBO

• Requests are sent to the database via MDX
• This driver is typically used for your multidimensional cross-tab style reporting

     ODBC

• Requests are sent to the database via SQL

Standard SQL can read the tables while extended SQL can read the Information Models. MDX driver will only read the Information models.

[former_member191765 · Accepted solution]

Thank you.. looks I'm not going on right track.

[tfxz]

Hi,

if you want to use native Excel's pivot tables I recommend to use ODBO (MDX). It leverages the meta data in the HANA repository, i.e. it already understands what dimensions, hierarchies, measures exists rather than pure syntactical information like columns and their respctive data types.

Hope this helps.

Thomas

[Former Member]

Hi,

Am I correct in assuming you are referring to reporting off HANA? If so the choice would depend on what reporting tool you were using. Herewith a list of the BO clients you could be using;

• Crystal Reports
• Web Intelligence
• Dashboard Design
• Explorer
• Analysis, edition for Microsoft Office
• Analysis, edition for OLAP
• Visual Intelligence (I am still not sure if this is part of the BO Stack)

[former_member191765]

Hi

Thank you for your reply.

Yes.. I'm referring to reporting on HANA. I'm aware of BO client..

My question is.. We can analyze HANA data in Excel either by connecting through ODBO or ODBC.. I'm just wondering when would we go for ODBO or ODBC whata the advantages of each.

Thank you,

Anjan...