Excel Add-In for SAP BusinessObjects BI

Build 21.0.7930

Establishing a Connection

Configure a Connection Profile

From the CData ribbon, click Get Data and select From SAP BusinessObjects BI to launch the CData Query window. To setup your connection, you will have to click the Select button. Here you can set the connection settings, test the connection, and save the connection profile.

Connecting to SAPBusinessObjectsBI

To connect to your SAP BusinessObjects BI instance, you must set the following connection properties:

  • Url: Set this to the SAP BusinessObjects BI rest API URL. After logging into Central Management Console, choose Applications from the combo box.

    After that double click on RESTful Web Service and you'll see the access URL. By default it is, http://{Server-Name}:6405/biprws.

  • User: Set this to the username of your instance.
  • Password: Set this to the password of your instance.

Connection Properties

The Connection properties describe the various options that can be used to establish a connection.

Managing Connections

After successfully authenticating to SAP BusinessObjects BI you will be able to customize the data you are importing. To learn more about this, see Managing Connections.

See Also

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 21.0.7930