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
-
Open Information Design Tool and a new project.
-
Create a new Relational Connection using the Generic ODBC3 datasource driver.
-
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
-
In Information Design Tool, publish the Dremio connection to a repository.
-
Create a new Data Foundation.
-
Create a new Business Layer.
-
Publish the universe to a repository.
-
Open a web browser, go to Web Intelligence tool and select the published universe.
-
Configure the query.
Your Dremio dataset is ready to be used in Web Intelligence.