Dremio Cloud
Dremio Software
 
On this page

    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.