SAP BusinessObjects BI (ODBC)
Interact Advanced Analytics uses the AWS Data Lake technologies to power the data querying, analysis, and retrieval. To connect SAP BusinessObjects BI to Interact's Advanced Analytics Solution, you will need:
- SAP BusinessObjects BI
- AWS Athena ODBC Driver
The setup largely mimics the steps outlined in the ODBC Connectivity page, as this covers the in-depth ODBC configuration steps.
The setup is documented in quite a lot of detail on this page.
https://www.cdata.com/kb/tech/athena-odbc-sap-businessobjects.rst
JDBC integration has also been covered on the SAP Community if you need an alternative.
https://blogs.sap.com/2017/08/21/combinging-the-best-of-big-data-and-sap-businessobjects/
Ports
It is worth noting that whilst port 443 is used for communicating with the Data Lake, port 444 is used to stream query results back from the Data Lake to the BI tool, so both ports need to be open.
https://docs.aws.amazon.com/athena/latest/ug/odbc-v2-driver.html
Updated 7 days ago