Tableau Connector for SAP BusinessObjects BI

Build 24.0.9060

Configuring a Connection

After Installing the Connector you can connect and create a Data Source for data in SAP BusinessObjects BI.

Setting Up a Data Source

Complete the following steps to connect to the data:

  1. Under Connect | To a Server, click More....
  2. Select the data source called SAP BusinessObjects BI by CData.
  3. Enter the information required for the connection.
  4. Click Sign In.
  5. If necessary, select a Database and Schema to discover what tables and views are available.

Using the Connection Builder

The connector makes the most common connection properties available directly in Tableau. However, it can be difficult to use if you need to use more advanced settings or need to troubleshoot connection issues. The connector includes a separate connection builder that allows you to create and test connections outside of Tableau.

There are two ways to access the connection builder:

  • On Windows, use a shortcut called Connection Builder in the Start menu, under the CData Tableau Connector for SAP BusinessObjects BI folder.
  • You can also start the connection builder by going to the driver install directory and running the .jar file in the lib directory.

In the connection builder, you can set values for connection properties and click Test Connection to validate that they work. You can also use the Copy to Clipboard button to save the connection string. This connection string can be given to the Connection String option included in the connector connection window in Tableau.

Connecting to SAPBusinessObjectsBI

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

  • Url: The SAP BusinessObjects BI REST API URL. To discover this:

    1. Log into the Central Management Console.
    2. Choose Applications from the combo box.
    3. Select RESTful Web Service. The Central Management Console displays the access URL, which is http://{Server-Name}:6405/biprws by default.

  • AuthScheme: Set this to the type of authentication to use when connecting to SAP BusinessObjects BI.

Basic

To connect to SAP BusinessObjects BI using Basic authentication, set the AuthScheme to Basic, and set these properties:

  • User: The username of your instance.
  • Password: The password of your instance.

CyberArk

To connect to CyberArk, set the AuthScheme to CyberArk, and set these properties:

  • User: The CyberArk login name (user@domain).
  • Password: The CyberArk user's password.
  • SSOLoginURL: The app's single sign on URL.
  • SSOExchangeUrl: The url used for the exchange of the SAML token for SAP BusinessObjects BI credentials.

If you have configured MFA, you must use combinations of SSOProperties to authenticate using CyberArk. Set any of the following, as applicable:

  • MFAType: If you have configured MFA, set this to the name of the mechanism that should be selected during authentication.
  • MFAPassCode: If you have configured MFA, set this to a valid answer for the selected mechanism.
    If you set this to an empty or an invalid value, the connector initiates the out-of-band mechanism. The connector polls the API until the challenge is completed through user interaction before deciding on closing the connection.
  • MFATimeout: If you have configured MFA, set this to the number of seconds the connector should continue polling the API until the challenge is completed through user interaction. By default, the connector polls the API for 60 seconds before closing the connection.

Example connection string:

AuthScheme=CyberArk;SSOLoginURL='https://abc1234.id.cyberark.cloud/run?appkey=00000000-0000-0000-0000-000000000000&customerId=ABC1234';User=cyberarkUserName;Password=cyberarkPassword;SSOExchangeUrl=http://myserver:8080/biprws/saml/SSO;

Next Step

See Using the Connector to create data visualizations.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060