首页 > 代码库 > Reporting in HANA

Reporting in HANA

 

 

 

 

HANA 1.0 provides various interface reporting options

?

ODBO – OLE DB for OLAP

    Microsoft-driven specification for multidimensional ( cross-tab style ) reporting

    Requests are sent to the database via MDX ( MultiDimensional eXpression language )

?

ODBC - Open DataBase Connectivity

    Microsoft-driven specification for relational reporting

    Database requests are made via SQL( Structured Query Language)

    Heavily adopted in industry

    No longer Microsoft-centric  --  Unix and Linux drivers exist for ODBC

 

 JDBC - JAVA DataBase Connectivity? 

     Relational reporting drivers specified by the java community.

     Popular on Unix platforms.?

 

BICS – BI Consumer Services

?  SAP Proprietary interface that offers advantages for OLAP access over MDX on multidimensional reporting object.?

 

SQLDBC is SAP native database SDK

Reporting in HANA