Technical Considerations for Migrating from Tableau Server to Tableau Cloud

This topic covers most of the technical considerations that may arise in a migration from Tableau Server to Tableau Cloud. It’s written for the administrators that currently manage Tableau Server and who are considering a migration to Tableau Cloud. We recommend that you review this topic as a primary step in your migration plan. Additionally, work with your account team to understand if a migration makes sense for your organisation.

The topic reflects the product capabilities in Tableau Server 2023.1.

For additional information and to initiate a migration to Tableau Cloud, visit the Tableau Cloud Migration(Link opens in a new window) site on Tableau.com.

Summary outline

This topic is organised into four major areas that are familiar to Tableau administrators. The following tables show a summary feature comparison between Tableau Cloud and Tableau Server within each major area. For more information on a given feature, see the corresponding section later in this topic.

Security, administration and governance
 Tableau CloudTableau Server
ComplianceSee Salesforce Compliance(Link opens in a new window) portal. Access to this site may require permission from your account manager.Managed by customer
Hosting and upgradesManaged by TableauManaged by customer
Site level administrationSingle site defaultManaged by customer
Telemetry dataLimitedManaged by customer
Observability dataAdmin Insights(Link opens in a new window) with Activity Log(Link opens in a new window)Managed by customer with repository access and Activity Log(Link opens in a new window)
Availability99.9% with SLA for Premium Support customersManaged by customer

 

Data Connectivity
 Tableau CloudTableau Server
FilesSupportedSupported
Applications and databasesSupported, with database-specific limitationsSupported
Custom connectivityLimited supportSupported
Cube data sourcesNot supportedSupported

 

User management and licensing
 Tableau CloudTableau Server
Licensing

Internal: role-based

External: role and usage-based

Internal: role and core-based

External: role and core-based

SSOSupportedSupported
Active Directory, Kerberos, LDAP directoryNot supportedSupported
Automated user and group managementOkta, OneLogin, Azure AD and custom tooling(Link opens in a new window)Active Directory, LDAP

 

Extensibility and external integrations
 Tableau CloudTableau Server
Automated tooling through APIsSupportedSupported
R and Python integrationSupportedSupported
EmbeddingSupportedSupported
CustomisationLimited supportSupported

Security, administration and governance

Security and compliance

Make sure Tableau Cloud security certifications meet your organisation's requirements. Tableau Cloud is compliant with ISO 27001/27017/27018 and SOC 2/3 and adheres to data privacy requirements such as those outlined in GDPR. To see a complete and up-to-date list of certifications go to the Salesforce Compliance(Link opens in a new window) portal. Access to this site may require permission from your account manager.

Additionally, Tableau Cloud and Salesforce adheres to the strictest standards for regional data security and privacy. Customer data never leaves the region in which it is hosted. Salesforce adopts a Shared Responsibility Model. In this model, we work with you to ensure that all the proper security and compliance controls are enabled by Salesforce and your organisation.

Hosting and upgrades

Tableau hosts and manages Tableau Cloud for customers. Tableau Cloud is always running the latest version of Tableau. Major upgrades are completed with zero downtime. Routine maintenance (activities like upgrades, backups, performance tuning, etc.) is performed to minimise downtime. In the case where downtime is required, maintenance occurs during pre-communicated windows. For more information about the Tableau maintenance schedule and how to sign up for maintenance notifications from Tableau Trust, see Tableau Cloud System Maintenance(Link opens in a new window).

Tableau Cloud is run in Amazon Web Services. You can choose to deploy your site in any of the AWS Regions listed here(Link opens in a new window).

Tableau takes daily backups of the environment for Disaster Recovery. However, these backups are for the purpose of restoring the system as a whole. Customers are responsible for maintaining backups of any files they want to recover if they’re removed or deleted from Tableau Cloud.

Site level administration

By default, Tableau Cloud deployments provide a single Site for deploying Tableau to your users. A single site model simplifies administration of the environment while allowing comprehensive governance scenarios as recommended in Blueprint(Link opens in a new window).

To ensure consistent performance across the platform, Tableau Cloud restricts sites with site capacity limits. See Tableau Cloud Site Capacity(Link opens in a new window) for a list of capacity types and associated allowances. The capacity restrictions include limits for overall storage and for tasks that you may perform on the site. You can evaluate if any of your use cases would be impacted by these limits by connecting to the Tableau Server repository and comparing usage to the site capacity limits. For more information about connecting to the repository, see Collect Data with the Tableau Server Repository.

Observability data

In Tableau Cloud, you can’t connect directly to the Tableau Server repository database. Instead, Site Admins have access to a Project called Admin Insights that contain pre-built observability dashboards and data sources. See Use Admin Insights to Create Custom Views(Link opens in a new window). Admin Insights help you to understand usage, performance, licensing, user management and more. You can also use the provided data sources to build custom reports or take advantage of Accelerators built on this data. For an example, see the Dashboard Load Times Accelerator(Link opens in a new window). Default data retention in Admin Insights is 90 days. With Advanced Management you receive an extended retention period of 365 days and get access to Activity Log(Link opens in a new window) for more detailed observability data.

Availability

Tableau Cloud offers a service level agreement (SLA) that guarantees monthly service availability of 99.9%. We provide this level of service to all Tableau Cloud customers. However, in the unlikely event availability falls short of 99.9%, only those customers subscribed to Premium Support for Tableau Cloud are eligible for a service credit on their account.

Tableau Cloud customers who subscribe to Standard Support or Extended Support benefit from the SLA because Tableau maintains 99.9% availability across all Tableau Cloud deployments. However, Standard and Extended Support customers can’t request service credits if Tableau Cloud fails to meet 99.9%.

Learn more about Technical Support Services(Link opens in a new window) and Premium Support(Link opens in a new window) for Tableau Cloud.

Data connectivity

Where your data resides determines which of the two connectivity options you use with Tableau Cloud:

  • Tableau Cloud can directly connect to the cloud data sources listed below. For direct connections, some databases require authorizing Tableau Cloud to access these data sources before you connect. See Authorise Access to Cloud Data Published to Tableau Cloud(Link opens in a new window).
    Supported Tableau Cloud connectors

    Alibaba AnalyticsDB for MySQL‡

    Alibaba Data Lake Analytics‡

    Alibaba MaxCompute‡

    Amazon Athena‡

    Amazon Aurora for MySQL‡

    Amazon EMR Hadoop Hive‡

    Amazon Redshift‡

    Apache Drill‡

    Azure Data Lake Storage Gen2‡

    Azure Synapse Analytics (SQL Server compatible)

    Box‡

    Cloudera Hadoop‡

    Databricks‡

    Datorama by Salesforce‡

    Denodo‡

    Dremio by Dremio‡

    Dropbox*‡

    Esri Connector‡

    Exasol‡

    Google BigQuery*‡

    Google Cloud SQL (MySQL compatible)‡§

    Google Drive‡

    Hortonworks Hadoop Hive

    Impala‡

    Kyvos‡

    MariaDB‡

    Microsoft Azure SQL Database‡

    Microsoft Azure Synapse Analytics‡

    Microsoft SQL Server‡

    MongoDB BI Connector‡

    MySQL‡

    OData‡

    OneDrive*‡

    Oracle‡

    Pivotal Greenplum Database‡

    PostgreSQL‡

    Presto‡

    Qubole Presto‡

    Salesforce‡

    SAP HANA (for virtual connections only)‡

    SharePoint Lists‡

    SingleStore (formerly MemSQL)‡

    Snowflake‡

    Spark SQL‡

    Teradata**‡

    Vertica‡

    *For more information about using OAuth 2.0 standard for Google BigQuery, OneDrive and Dropbox connections in Tableau Cloud, see OAuth Connections(Link opens in a new window).

    **Teradata web authoring currently doesn’t support query banding functionality. See Teradata(Link opens in a new window) for details.

    ‡Supports virtual connections if you have Data Management. See About Virtual Connections and Data Policies(Link opens in a new window) in the Tableau Cloud help for details.

    §Tableau Cloud doesn't support SSL using Google Cloud SQL.

  • For data that is stored on-premises or in a private cloud network, you can deploy Tableau Bridge. For a list of all the connectors that Tableau Bridge supports and doesn’t support, see Connectivity with Bridge(Link opens in a new window).

Files

Tableau Cloud supports various file types. Files hosted on cloud platforms like Google Drive, Dropbox, Box and S3 can use Tableau Cloud direct connectors to support both live and extract connections. Tableau Bridge supports file-based data connections for extracts, but doesn’t support live connectivity to file-based data.

Applications and databases

Tableau Cloud supports most of the same Connectors that Tableau Server supports, but there are some differences. Some databases require specific configuration to enable direct Tableau Cloud connectivity. See Allow Direct Connections to Data Hosted on a Cloud Platform(Link opens in a new window).

Tableau Cloud and Tableau Bridge don’t support authentication to a database using Kerberos.

Custom connectivity

Tableau Cloud is designed to use the same database Connector for every Tableau Cloud customer and therefore doesn’t support customer-specific connectivity solutions. The two notable exceptions are the Hyper API and Tableau Bridge, which can be used to extend or customise your connectivity. The Hyper API can create extracts that can be published to Tableau Cloud. Tableau Bridge can be used to extend some connectivity options, for example, ODBC, JDBC and Web Data Connectors. See Connectivity with Bridge(Link opens in a new window).

You can’t customise connectivity with Connector SDK (.taco) on Tableau Cloud or with Tableau Bridge.

If you’re using Virtual Connections as a part of the Data Management offering there may be differences specific to your desired connector. Verify that Tableau Cloud or Tableau Bridge supports your scenario.

Cube data sources

Tableau Cloud doesn’t support Cube Data Sources. Instead, we recommend that you connect directly to the underlying database that the cube is built on top of for greater flexibility in your analysis.

Data prep

Tableau Bridge doesn’t support running Tableau Prep Flows with Prep Conductor. Instead, follow the process in the KB article, How to Run Tableau Prep Conductor Flows with On-Premises Data in Tableau Cloud(Link opens in a new window), to automate data preparation.

Licensing and user management

Licensing

Tableau Cloud supports licensing with subscription role-based plans. Learn more at the Tableau Pricing(Link opens in a new window) page. To eliminate key management tasks, Tableau Cloud defaults to licensing users with login-based licence management (LBLM(Link opens in a new window)). Legacy perpetual licences and server core-based licensing aren’t supported.

Tableau Cloud doesn’t offer a “Guest” user. However, connected applications can be used to provide content for broader usage within your organisation. See Use Tableau Connected Apps for Application Integration(Link opens in a new window).

If you’re licensing Tableau Cloud for users outside of your organisation, usage-based licensing for those external use cases is available. See Raise Revenue and Lower Costs with Usage-Based Licensing for Tableau Embedded Analytics.

Single sign-on

Tableau Cloud supports single sign-on (SSO) through both SAML and OIDC. Direct integrations with Okta, Azure AD, One Login, Salesforce, PingOne and more are supported.

All users accessing Tableau Cloud are required to utilise multi-factor authentication (MFA) to authenticate into Tableau Cloud.

If you aren’t using an SSO provider, you can use Tableau Cloud’s built-in authentication type, TableauID with MFA. You can also create custom solutions with SAML or use Connected Applications(Link opens in a new window) for embedded solutions.

For more information, see the Authentication(Link opens in a new window) section in Tableau Cloud help.

Active Directory, Kerberos and LDAP

Tableau Cloud doesn’t support direct integration with Active Directory. However you can configure SAML with Azure AD(Link opens in a new window). to integrate with Tableau Cloud.

Additionally, most IdPs have an Active Directory integration that would suffice for authentication with Tableau Cloud. For an example, see Active Directory integration (Okta)(Link opens in a new window).

Tableau Cloud doesn’t support Kerberos authentication or using LDAP as an Identity Store.

Automated user and group management

Tableau Cloud uses System for Cross-domain Identity Management (SCIM) for automating the exchange of user identity information. There are several IdP-specific configurations available in Tableau Cloud. See Automate User Provisioning and Group Synchronisation through an External Identity Provider(Link opens in a new window).

The Tableau REST API(Link opens in a new window) and tabcmd 2.0(Link opens in a new window) supports many user and group automation tasks.

Tableau Cloud doesn’t support direct integration with Active Directory for user or group provisioning.

Extensibility and external integrations

Automated tooling

Tableau Cloud supports REST APIs, JavaScript APIs, Metadata APIs, Dashboard APIs, Webhooks and embedding in HTML pages for authenticated users. See Tableau Developer Tools(Link opens in a new window) for more information.

We recommend that you verify your use cases prior to a migration.

There are some differences to be aware of as you plan your automated tooling strategy for Tableau Cloud:

  • Tableau Server supports REST APIs for server-level administration. Tableau Cloud supports site-level administration.
  • Tableau Server supports a global list of Web Data Connectors. Tableau Cloud requires using Bridge to run extract refreshes for Web Data Connectors.
  • The connectors on the Tableau Exchange are only supported by Tableau Server.

APIs supported by Tableau Cloud are optimized for authentication with Tableau personal access tokens (PATs). Plan on refactoring your tooling to use PAT authentication as part of your migration to Tableau Cloud. See Personal Access Tokens(Link opens in a new window).

Extensibility

Tableau Cloud supports analytics extensions with both R and Python. See Configure Connections with Analytics Extensions(Link opens in a new window). However, Tableau Bridge doesn’t support analytics extensions, so these extensions are only compatible with data sources that don’t require Tableau Bridge.

Tableau Cloud doesn’t support R or Python script steps in a Prep flow(Link opens in a new window) authored or published to Tableau Cloud.

Embedding

Tableau Cloud supports embedding Tableau into other applications. It supports the Embedding API, various SSO options, and Tableau REST API for user and content management.

There are two main differences for embedding with Tableau Cloud vs Tableau Server:

Customisations

Tableau Cloud allows you to customise some aspects of the user experience like language, locale, custom logos and custom project images. See Customise the Site and Content Settings(Link opens in a new window).

Tableau Cloud doesn’t support custom URLs, custom fonts or custom welcome banners.

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