HomeAnalytics & dataSAP BusinessObjects BI (ODBC)

SAP BusinessObjects BI (ODBC)

Connect SAP BusinessObjects BI to Interact Advanced Analytics using the AWS Athena ODBC driver.

Before you start

To connect SAP BusinessObjects BI to Interact Advanced Analytics, you need:

  • SAP BusinessObjects BI
  • The AWS Athena ODBC driver

Interact Advanced Analytics uses AWS Data Lake technologies for data querying, analysis and retrieval.

Overview

The setup largely follows the steps in ODBC connectivity, which covers the ODBC configuration in depth.

The setup is documented in detail in CData: Athena ODBC and SAP BusinessObjects.

JDBC integration is also covered on the SAP Community if you need an alternative. See Combining the best of big data and SAP BusinessObjects.

Ports

Port 443 is used to communicate with the Data Lake, and port 444 is used to stream query results back from the Data Lake to the BI tool. Both ports must be open. See the Athena ODBC v2 driver documentation.

Section: Analytics & data