Configure Connection to BI Source

Alation Cloud Service Applies to Alation Cloud Service instances of Alation

Customer Managed Applies to customer-managed instances of Alation

After you install the Tableau OCF connector, you must configure the connection to the Tableau BI source.

The various steps involved in configuring the Tableau BI source connection setting are:

Provide Access

You can configure the visibility of a BI source and its child objects such as Folders and Reports on the Access tab of the settings page.

Configure BI Source Visibility

Applies from release 2023.3.5

On the Access tab, follow these steps to set the BI source visibility:

  1. Select one of the following options for setting privacy level:

    • Public BI Server—The BI source will be visible to all users of the catalog.

    • Private BI Server—The BI Source will be visible to users who have been granted the BI Server Admin or Viewer permissions. It will be hidden for all other users.

  2. Add one or more BI Server Admins or Viewers in the User Access section if required.

For more information on access to BI sources, see Configure Access to OCF BI Sources.

Configure BI Folder and Report Visibility

Applies from release 2024.1.4

On the Settings under a BI Folder or Report, follow these steps to set visibility:

  1. Check the option Enable explicit permission to change access permission defined at the parent level object.

    This enables and allows permissions at the object level. By default, the access permissions are inherited from the parent level and are not editable.

  2. Select one of the following options to set a privacy level:

  • Public—The BI folder or report will be visible to all users of the catalog.

../../../_images/BI_Folder_Access.png
  • Private—The BI folder or report will be visible to users that have been granted the BI Server Admin or Viewer permissions. It will be hidden for all other users.

../../../_images/BI_Report_Access.png
  1. Add one or more BI Server Admins or Viewers in the User Access section if required.

For more information on how to enable the feature and configure access to a folder or report, see Configure Access to OCF BI Folders and Reports.

Connect to Data Source

To connect to the BI source, you must perform these steps:

  1. Provide the Tableau URI

  2. Configure Authentication

  3. Test the Connection

  4. Configure Additional Connection Settings

  5. Configure Logging

Important

The Alation user interface displays standard configuration settings for credentials and connection information stored in the Alation database. If your organization has configured Azure KeyVault or AWS Secrets Manager to hold such information, the user interface will change to include the following buttons adjacent to the respective fields:

../../../_images/SnowflakeOCF_New_Vault_Button.png

By default, you see the user interface for Standard. In the case of Vault, instead of the actual credential information, you must select the source and provide the corresponding key. For details, see Configure Secrets for OCF Connector Settings.

Provide the Tableau URI

Before using the JDBC URI format, understand the JDBC URI format and parameters for the PostgreSQL OCF connector.

URI Format

Use the URL of Tableau Server or Tableau Cloud.

Example: https://tableau2021.alationcatalog.com

Provide the JDBC URI in Alation

To provide the JDBC URI in the Alation UI, perform these steps:

From Alation version 2024.1.2 and connector version 1.9.0

  1. On the Settings page of your Tableau BI source, go to the General Settings tab.

  2. In the Provide the Tableau URI section, enter the JDBC URI.

  3. Click Save.

Configure Authentication

Alation supports the following authentication types for the Tableau BI source:

  • Basic authentication (username and password)

  • Active Directory (username and password)

  • Personal Access Token

  • SSL authentication

Tableau Server

Configure authentication for Tableau Server:

From Alation version 2024.1.2 and connector version 1.9.0

  1. On the Settings page of Tableau BI source, go to the General Settings tab.

  2. In the Configure authentication step, Choose Tableau Server.

Basic Authentication:

To configure Basic authentication, perform these steps:

  1. In the Configure authentication step, click on the Basic tab.

  2. Provide the service account Username, Password and the Site ID(s) (optional) separated by comma.

Note

If the Site ID field is blank, connector will extract all the sites. To extract only the default site, use selective extraction by selecting the appropriate projects.

  1. To use SSL with Basic authentication, turn on the Upload SSL Certificate toggle, and upload the SSL certificate.

  2. Click Save.

Personal Access Token:

To configure Personal Access Token authentication, perform these steps:

  1. In the Configure authentication step, click on the Personal Access Token tab.

  2. Provide the Token name, Token secret and the Site ID(s) (optional) separated by comma.

Note

If the Site ID field is blank, connector will extract all the sites. To extract only the default site, use selective extraction by selecting the appropriate projects.

  1. To use SSL with Personal Access Token authentication, turn on the Upload SSL Certificate toggle, and upload the SSL certificate.

  2. Click Save.

Tableau Cloud

Configure authentication for Tableau Cloud:

Note

Only Personal Access Token authentication is supported for Tableau Cloud.

From Alation version 2024.1.2 and connector version 1.9.0

  1. On the Settings page of Tableau BI source, go to the General Settings tab.

  2. In the Configure authentication step, Choose Tableau Cloud.

  3. Provide the Token name, Token secret and the Site ID(s) separated by comma.

  4. To use SSL with Personal Access Token authentication, turn on the Upload SSL Certificate toggle, and upload the SSL certificate.

  5. Click Save.

Test the Connection

The connection test checks BI source connectivity. Alation uses the JDBC URI to connect to the BI source and to confirm when the connection is established.

After specifying the JDBC URI and configuring authentication, test the connection.

To validate the network connectivity, go to General Settings > Test Connection of the Settings page of your Tableau BI source and click Test.

A dialog box appears confirming the status of the connection test.

Configure Additional Connection Settings

Apart from the mandatory configurations that you perform to connect to the BI source in the General Settings tab, you can configure the following additional settings:

Configure BI Server Lookup URI

Specify the URI of the BI server to redirect users to BI objects from the respective catalog pages using the Connector link.

From Alation version 2024.1.2 and connector version 1.9.0

  1. On the Settings page of Tableau BI source, go to the General Settings tab.

  2. In Advance Settings (optional) section, provide the BI sever lookup URI.

Enable or Disable Automatic Lineage Generation

You can enable or disable the lineage for the BI source to be generated automatically during metadata extraction.

For Alation version 2024.1.2 and connector version 1.9.0

Go to General Settings > Advanced settings of the Settings page of your Tableau BI source and enable or disable the Disable automatic lineage generation toggle.

Disable the Disable automatic lineage generation toggle when you want to automatically generate the lineage.

Enable this option when you do not want lineage to be automatically generated and prefer to create lineage manually or using an API.

By default, automatic lineage generation is enabled.

Cross-System Lineage:

Cross-System Lineage is to generate lineage between this Tableau BI source and any supported data source by this connector. To generate the cross-system Lineage, specify the host name and the port number of this BI source on the RDBMS connector’s General Settings > Application Settings > BI Connection Info field in the format mentioned below:

Host_Name:Port_Number

Example: adb-8443049157651279.19.azuredatabricks.net:443

../../../_images/powerb17.png

Note

This image is from the supported data source General Settings page.

Configure Logging

To set the logging level for your PostgreSQL OCF data source logs, perform these steps:

For Alation version 2024.1.2 and connector version 1.9.0

  1. On the Settings page of your Tableau OCF BI source, go to General Settings > Connector logs.

  2. Select a logging level for the connector logs and click Save.

    The available log levels are based on the Log4j framework.

Delete the BI Source

To delete the BI Source, refer Delete a BI Source.

Note

For Tableau OCF Connector version 1.9.0 and newer, the delete option is available only on the Sources > Manage Settings > BI Servers page.