Allow Live Connections to Data Hosted on a Cloud Platform

 

You have many options for managing the data underlying your Tableau Cloud workbooks. You can choose how to keep the data current based on your business needs. Depending on the data source, you can leverage a live connection, or you can create an extract and define an extract schedule to keep the data fresh. You can also embed credentials or require users to provide credentials for accessing the data when they open views that connect to content.

If you maintain relational data on a cloud platform, you can use live connections to that data when you publish workbooks and data sources to Tableau Cloud. When you use a live connection, you don't need to publish a static extract of the data.

Enable encrypted connections

Encrypting connections using SSL is an option for underlying data sources. You can enable SSL encryption for connections to your hosted SQL data when you create the connection in Tableau Desktop. Complete the following steps to enable encrypted connections.

Tip: Make sure that Tableau Cloud is on your data provider's authorised list (safe list).

  1. In Tableau Desktop, connect to the data.

  2. In the Server Connection dialog box, select the Require SSL tick box.

  3. For PostgreSQL, SQL Server-compatible connections and other connections that don't have an option to embed certificates in the data source, click OK to finish.

    For some compatible connections, linked text appears under the Require SSL tick box. This indicates that you can specify an alternative certificate file to use, such as a self-signed certificate.

  4. (Optional) Use a self-signed or other custom certificate to connect to this data over SSL.

    1. Select the link text that appears.

    2. In the Configure and Use SSL Certificate dialog, specify the certificate’s .pem file.

      For example, for MySQL connections to data hosted on Amazon RDS, you can point to Amazon’s self-signed certificate file at this address.

Untrusted certificates

If you are using certificates that aren't trusted by Tableau Cloud, such as self-signed certificates or certificates signed by your company's internal CA, you may have problems connecting from Tableau Cloud. Try one of the following solutions.

  • If your connector allows embedding custom certificates, then use that. (This is the method used in the previous section)
  • Get new certificates for your database that are signed by a trusted public CA.
  • Use Tableau Bridge, which is Tableau’s connection proxy. You can configure your certificates to be trusted on the machine running Bridge, either by using TDC files, properties files or by installing your certificates in the Windows System Trust Store.

Supported connectors

Refer to the "Tableau Cloud" tab in the Creators: Connect to Data on the Web topic for the list of supported connectors.

For more information about supported features by connector, refer to the specific connector topic in the Supported Connectors section of the Tableau User Help.

Note: Not all connectors in this list are supported by Tableau Prep Conductor. To see the supported list of connectors, open Tableau Prep Builder and expand the Connect pane.

See also

Thanks for your feedback!Your feedback has been successfully submitted. Thank you!