SAP Business Objects

Prerequisites

Dremio Business Objects integration requires:

• SAP Business Objects 4.0+
• Download, install, and configure the ODBC driver for Arrow Flight SQL.

Connecting to a Dremio cluster using Information Design Tool

1. Open Information Design Tool and a new project.

2. Create a new Relational Connection using the Generic ODBC3 datasource driver.

3. Select the Arrow Flight SQL ODBC DSN and test the connection.

Dremio schemas and tables are now available.

Using Dremio datasets in Web Intelligence Reports

1. In Information Design Tool, publish the Dremio connection to a repository.

2. Create a new Data Foundation.

3. Create a new Business Layer.

4. Publish the universe to a repository.

5. Open a web browser, go to Web Intelligence tool and select the published universe.

6. Configure the query.

Your Dremio dataset is ready to be used in Web Intelligence.