Dremio Community

SAP Business Objects

Prerequisites

Dremio Business Objects integration requires:

  • SAP Business Objects 4.0+
  • Install Dremio Connector 64-bit for Business Objects servers and 32-bit for client tools.

Updating Dremio DSN Configuration for Business Objects

  1. Run the ODBC Data Sources (both 64-bit and 32-bit) Windows application.

  1. Open the System DSN tab, select ‘Dremio Connector,’ and hit the Configure button.
  1. Add the following to the end of the Advanced Properties in Dremio Connector DSN:
;NonZeroNameMaxLen=true;supportFullyQualifiedProjects=true

WARNING

Both 32-bit and 64-bit DSNs should be configured with the same name, configuration and additional parameters.

Connecting to a Dremio cluster using Information Design Tool

  1. Open Information Design Tool and a new project.

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

  1. Select the Dremio Connector DSN and test the connection.

  1. 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.
  1. Create a new Data Foundation.

  1. Create a new Business Layer.
  1. Publish the universe to a repository.
  1. Open a web browser, go to Web Intelligence tool and select the published universe.
  1. Configure the query.

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