ibi  WebFOCUS 

Learn how to connect ibi WebFOCUS to an Exasol database using the Exasol OBDC driver.

Exasol takes no responsibility for changes in functionality or terms of use for third-party tools. For more details about the compatibility and use of these tools with Exasol, refer to the respective software vendor’s website.

Prerequisites

  • The Exasol ODBC driver must be installed. To learn more, see ODBC Driver.

  • Your Exasol database must be running and reachable from the environment where the tool is used.

Exasol SaaS

  • The IP address of the host where the tool is running must be in the allowed IP address list in Exasol SaaS. To learn how to allow traffic to your database, see Network security (SaaS).

  • To connect the tool to an Exasol SaaS cluster you will need the connection string and a personal access token (PAT) for authentication. To learn how to get the connection details, see Connect to Exasol SaaS.

Connect ibi WebFOCUS to Exasol

Configure a new data source in ibi WebFOCUS using the following connection details:

  • Connection Name: Name to identify this connection.

  • System: Connection string to the Exasol database.

    For Exasol SaaS, use the connection string provided in the web console as hostname.

  • Security: Authentication method to be used when connecting the user to the database.

  • User: The name of the Exasol user.

  • Password: The password of the Exasol user.

    For Exasol SaaS, use a valid personal access token as password.

  • Additional connection string keywords: Can be used to add options to the connection string (optional).

For more information about how to use ibi WebFOCUS with Exasol, refer to the WebFOCUS documentation.