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