Skip to main content

SAP Business Objects

You can use SAP Business Objects to query and visualize data by means of Dremio Cloud.

Supported Versions

SAP Business Objects 4.0+

Prerequisite

Download, install, and configure the ODBC driver for Arrow Flight SQL.

Connecting to Dremio Cloud

  1. Open Information Design Tool.

  2. Select File > New > Project.

  3. Set the name of the project and click Finish.

  4. Right-click the project and select New > Relational Connection.

  5. Specify a name for the relational connection and click Next.

  6. Select the Generic ODBC3 datasource driver and click Next.

  7. Follow either of these steps:

    • Select Use existing data source and select the Arrow Flight SQL ODBC DSN.

    • Select Use connection string, select the Arrow Flight SQL ODBC driver, and specify this base connection string:

      Base connection string
      HOST=data.dremio.cloud;PORT=443;token=<personal-access-token>;
      UseEncryption=true;DisableCertificateVerification=false;

    See Connection Parameters for additional connection parameters that are available.

  8. (Optional) Test the connection.

  9. Click Finish.

Dremio schemas and tables are now available.