Pyramid Analytics OS

Learn how to connect Pyramid Analytics OS to your Exasol database.

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

  • A PRO user account for Pyramid Analytics OS.

  • 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 Pyramid Analytics OS to Exasol

Create a new Exasol source connection in Pyramid Analytics OS with the following connection properties:

  • Display Name: A name that will be displayed for the Exasol database in Pyramid Analytics.

  • Server IP Address: The hostname or IP address of the Exasol database.

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

  • Port: The Exasol database port (8563).

  • 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.

  • Optional Parameters: If the Exasol database has any parameters required for the connection, specify them here.