Skip to main content
Version: I2023.1.0

Connecting to AtScale from Tableau by Using a Tableau Data Source (TDS) File

Tableau data source files have the .tds file extension. Data source files are shortcuts for quickly connecting to data sources from Tableau Desktop.

Data source files do not contain the actual data but rather the information necessary to connect to a data source. AtScale generates a .tds file for every published cube.

Before you start​

  • Obtain the .tds file for the project you need. For details, see Getting Cube Connection Information.
  • In case you are using Kerberos for authentication, follow the steps in the "Getting Kerberos details" section below.

Getting Kerberos details​

When using Kerberos authentication with Tableau version 2020.4 or newer, you need to do the following:

  1. Obtain the .tds file for the project, and open it with a text editor.

  2. Locate the connection element within the connection > named-connections > named-connection element.

    It should contain several attributes, like connection-type and authentication-type.

  3. Locate the kerberos-host, kerberos-realm, and kerberos-service attributes, and copy their values.

    Here is an example: :

    kerberos-host="kerberos.internal.example.com"
    kerberos-realm="INTERNAL.EXAMPLE.COM"
    kerberos-service="atscaler"

Procedure​

  1. Double-click the .tds file. Doing so launches the Tableau Desktop application.

  2. Enter your AtScale username and password, and click OK.

    If user accounts for AtScale are managed in Google's G Suite Directory, authenticate by using your Google account ID (Gmail address) and the temporary session password.

    image

  3. If the connection is not successful, click Edit Connection and make sure that the connection details look correct.

    • When using Kerberos:

      1. In the Authentication field, select Kerberos.
      2. In the Realm, Host FQDN, and Service Name fields, enter the values you obtained from the .tds file.

    • If HiveServer2 is not selected automatically, it probably means the ODBC driver is not installed correctly on your machine.

      image

  4. If the connection is successful, the Tableau worksheet will open showing the Data available in the AtScale cube. Drag one dimension and one measure to Columns and Rows to run a test query.

    image

What to do next​

If you republish a cube that is used in a workbook, in Tableau you must replace the data source for the workbook, pointing to the new .tds file. Refer to the Tableau documentation for the steps for replacing a data source.