Release 5.0.1
Page tree


Support | Blog | Contact Us 

Versions Compared

Old Version 2

changes.mady.by.user docuser1

Saved on

compared with

New Version Current

changes.mady.by.user docuser1

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

D toc

This section describes the basics of creating Tableau Server connections from within the application.

Info

NOTE: You can export Tableau format (TDE) files as part of exporting results from the platform. For more information, see Export Results Window.

Limitations

  • This connection type only enables publication. 
    • You cannot read data from Tableau Server.
    • Publish-only connections must be created in the Connections page.

Create Tableau Server Connection

You can create the connection through the application or through the command line interface.

Create through application

Any user can create a Tableau Server connection through the application.

Info

NOTE: Only an administrator can make a Tableau Server connection available for all users.

Steps:

  1. Login to the application.
  2. In the menu, select Settings menu > Connections. See Connections Page.
  3. In the Connections page, click Create Connection. See Create Connection Window.
  4. In the Create Connection window, click the Tableau Server connection card.

  5. Specify the properties for your Tableau Server.

    PropertyDescription
    Server URL

    The URL to the Tableau Server to which you are connecting. To specify an SSL connection, use https:// for the protocol identifier.

    Info

    NOTE: By default, this connection assumes that the port number is 80. To use a different port, you must specify it as part of the Server name value: http://<Tableau_Server_URL>:<port_number>

    User NameThe username to use to connect.
    PasswordThe password associated with the username.
    Test ConnectionClick this button to test the connection that you have specified.
    Connection NameThe name of the connection as you want it to appear in the user interface.
    DescriptionThis description is displayed in the user interface.
    Available to All UsersCick this checkbox to make this connection available to all users of the platform.

    For more information, see Create Connection Window.

  6. Click Save. 

Create through CLI

This connection can also be created through the 

D s item
command line interface
command line interface
. Notes on creating the connection:

The CLI tools are stored in the following directory:

Code Block
/opt/trifacta/bin/

Example command (all one command):

Code Block
./trifacta_cli.py create_connection --user_name <trifacta_admin_username> --password <trifacta_admin_password> 
--conn_type rest_tableau --conn_name newTableau
--conn_port 80 --conn_description "This is my Tableau connection." 
--conn_host  example.com
--conn_credential_type basic --conn_credential_location ~/.trifacta/config_conn.json 
--conn_is_global --cli_output_path ./conn_create.out
ParameterDescription
create_connectionCLI action type. Please leave this value as create_connection.
--user_name

Username of the

D s item
itemaccount
to use. Please specify the full username.

--passwordPassword of the account.
--conn_typeThe type of connection. Set this value to rest_tableau.
--conn_name

The internal name of this connection.

Info

NOTE: This value must be unique within all of your connections.

--conn_descriptionA user-friendly description for this connection appears in the application.
--conn_hostHost of the Tableau Server instance.
--conn_port

Port number of the Tableau Server instance.

--conn_credential_typeThe type of credentials to use. Set this value to trifacta_service.
--conn_credential_location

Specify the location on the

D s item
itemnode
where the credentials file is located. See below for more information on the format of this file.

--conn_ is_global

Include this flag to make the connection public and available to all

D s item
users
users
. This flag requires no value.

Info

NOTE: After a connection has been made public, it cannot be made private. You must delete the connection through the CLI and then recreate it.

You cannot delete a connection if it has imported datasets associated with it. You can delete a connection without datasets, but the publication information associated with the connection is dropped.

--conn_skip_test

By default, any connection is tested as part of a create or edit action. Include this flag to skip testing the connection. This flag requires no value.

Tip

Tip: After creation, you can test the connection and modify it through the application. See Flows Page.

--cli_output_path

The path to the file where results of this command are written.

Info

NOTE: The user issuing the command must also have execute permissions on all parent folders in the specified cli_output_path.

Credentials file

For Tableau Server connections, you must create a credentials file and store it on the 

D s item
itemnode
 in a location that is accessible to the CLI. This location must be specified as part of the command. 

The format of this file should look like the following:

Code Block
{
  "username": "<userId>",
  "password": "<pwd_for_userId>"
}

where:

  • <userId> is the user identifier to connect to the Tableau Server.
  • <pwd_for_userId> is the password for the user in use.

For more information on the 

D s item
command line interface
command line interface
, see CLI for Connections.

© 2013-2023 Alteryx® Inc. Privacy Policy  |  Terms of Use