Skip to main content

Tableau Connections

You can create connections to your Tableau instance from Alteryx Analytics Cloud (AAC). For more information, refer to Tableau.

If you are connecting AACAAC to any relational source of data, such as Redshift or Oracle, you must add the Alteryx Service to your whitelist for those resources. Refer to the allowlist documentation.

Configure

To create this connection:

  1. On the Import Data page, select the Plus sign and then select the Relational category.

  2. Select the Tableau card. You can also create connections through the Connections page. For more information, refer to the Connections page.

  3. Modify the properties as required.

    Property

    Description

    Connection Name

    Display name of the connection

    Description

    (Optional) Description of the connection, which appears in the application.

    Server URL

    The web address where the Tableau server is hosted.

    http(s)://<internal-domain>:<port>/ 

    or

     http://<host-ip>:<port>

    Site

    A logical grouping of users, content, and permissions within the Tableau Server or Tableau Cloud

    Credential Type

    Select the required credential type. For example, Basic or Personal Access Token

    Note

    The option varies based on the selection of the credential type

    If you have selected Basic, enter the following details:

    • User Name: User name to connect to the workspace.

    • Password: Password associated with the user name.

    If you have selected Personal Access Token, enter the following details:

    • Personal Access Token Name:

    • Personal Access Token Secret:

    Test Connection

    After you have defined the connection credentials type, you can verify that the Cloud Portal can use them to connect to the database.

Authentication Options

  • Basic authentication with username and password

  • SSL

Create via API

This connection can also be created using the API.

  • Type: jdbc

Troubleshooting

Error Message

Description

The TCP/IP connection to the host <hostname>and port <port> has failed

The host is not accessible. Please verify that the correct IP addresses have been whitelisted on the SQL server instance.

Login failed for user <username>

Permission denied. Please verify your credentials.

Astuce

Click the Test Connection button to check the connection credentials.

The certificate received from the remote server was issued by an untrusted certificate authority

There was an issue with the trusted certificate on the SQL Server instance. To disable validation of the certificate, add the following to the connection string options:

;trustServerCertificate=true;

Limitations

  • Publishing to Tableau is only supported for Designer Cloud > Designer Experience. Publishing to Tableau isn't supported for Trifacta Classic.

  • If the Date columns contain empty or null values, the data processing jobs will fail.

Dans cette section​: