Tuesday, January 3, 2017

Data Connectivity HA100

SAP HANA DB Connectivity Options


SAP BO BI Solutions Architecture:
Connectivity to SAP HANA 





ODBO - OLE DB for OLAP

1)      ODBO – OLE DB for OLAP
a.       Microsoft-driven specification for Multidimensional reporting
b.       Request are sent to the DB via MDX
2)      ODBC -Open Data Base Connectivity
a.       Microsoft-driven specification for Relational reporting
b.       DB requests are made via SQL
c.       Heavily adopted in industry
d.       No longer Microsoft centric -Unix and Linux drivers exist for ODBC
3)      JDBC – Java Data Base Connectivity
a.       Relational reporting driver specified by the java community. Popular on Unix platforms
4)      BICS – BI Consumer Services
a.       SAP proprietary interface that offers advantages for OLAP access over MDX on multidimensional reporting objects
b.       Common driver technology used by SAP BO Analysis, office edition and semantic layer based BO clients for connectivity to SAP NetWeaver BW


1)      What is the connection and requests sent for:
 Crystal Reports 2011 vs CR 2013 vs CR for enterprise to SAP HANA DB?

1)      CR 2011: JDBC + SQL
2)      CR 2011: ODBC + SQL
3)      CR Enterprise: JDBC/ODBC + SQL

2)      What is the connection and request for Webi and Dashboards to SAP HANA DB?
a.       JDBC/ODBC + Semantic Layer (relational Universe) + SQL

3)      What is the connection and request for Design Studio to SAP HANA DB?
a.       BICS/JDBC + SQL

4)      What is the connection and request for Analysis Office to SAP HANA DB?
a.       ODBC/BICS + SQL

5)      What is the connection and request for Analysis OLAP to SAP HANA DB?
a.       BICS/JDBC + SQL

6)      What is the connection and request for BEX(Explorer) to SAP HANA DB?
a.       JDBC + SQL

7)      What is the connection and request for Lumira to SAP HANA DB?

a.       JDBC + SQL


No comments:

Post a Comment