Connecting Bold BI to SAP Databases and Products
Bold BI does not provide direct connector support for connecting to SAP products. However, it does offer support for connecting to the SAP HANA database through an ODBC connector and other options. This article will guide you through the available options for connecting Bold BI to SAP databases and other SAP products.
Connecting to SAP HANA Database via ODBC
Bold BI supports connecting to the SAP HANA database using an ODBC connector. To set up this connection, you can follow the detailed instructions provided in the user guide for connecting to an ODBC data source:
Connecting to SAP Products via Web API
In addition to the ODBC connector, Bold BI can connect to most SAP products that support REST APIs using the Web API connector. Below is a list of some SAP products that have REST API support and can be connected to Bold BI:
- SAP Advanced Business Application Programming (ABAP)
- SAP HANA (formerly known as High Performance Analytics Appliance)
- SAP CRM (Customer Relationship Management)
- SAP Analytics Cloud
- SAP ERP
- SAP Hybris
- SAP BusinessObjects Web Intelligence
- SAP Crystal Reports
Steps to Connect Using Web API Connector
- Identify the REST API Endpoint: Determine the REST API endpoint for the SAP product you wish to connect to.
- Configure the Web API Connector: In Bold BI, navigate to the Web API connector and configure it with the necessary endpoint, authentication, and parameters.
- Test the Connection: Ensure that the connection is successful by testing it within the Bold BI interface.
- Create Data Visualizations: Once connected, you can start creating data visualizations and dashboards using the data retrieved from the SAP product.
Using CDATA to Connect SAP to Bold BI
If you are using CDATA, you can connect SAP to Bold BI by creating a virtual SQL Server Database for SAP data. This allows you to build dashboards in Bold BI using SAP data. For more information, refer to the following resources:
- CDATA documentation on Creating SAP Dashboards in Bold BI
- CDATA documentation: Connecting to CData Connect Server from Bold BI
- CDATA Data Connectors in Bold BI
Additional Support
If you require a direct connector for any specific SAP product or need further assistance, please contact Bold BI Support to evaluate the available options for establishing a connection.
References
By following these guidelines, you can effectively connect Bold BI to various SAP databases and products, enabling comprehensive data analysis and visualization.
