Tableau is a rapidly growing Business Intelligence (BI) tool and a Data Visualization software developed to transform the way Data Analytics is used by organizations to solve business problems. Tableau comes with an extensive set of features and tools that help in making the most of business data. Tableau presents the Data Visualization in an easy-to-understand format of dashboards and worksheets. In short, Data Analysis is a walk in the park with Tableau tools and this blog will take you through the Tableau Content Migration tool.
Tableau makes working with data really easy with real-time high-level analytics, extensive modeling, and custom development. However, users are constantly seeking ways to copy content between projects and this is where the Tableau Content Migration tool comes in. The Tableau Content Migration tool provides an easy way to migrate content between Tableau Server projects. Let’s get started.
Tabel of Contents
What is Tableau?
Image Source: www.commons.wikimedia.org
Tableau is a prominent Business Intelligence (BI) & Data Visualization tool used by companies and organizations all over the world for reporting and analyzing huge volumes of data. Developed by Pat Hanrahan, Christian Chabot, and Chris Stolte, Tableau helps in transforming raw data to a format that is easily understood by professionals at any level in an organization. Since its inception in 2003, Tableau has allowed leading industries to cut analysis time and make their organizations more data-driven.
Reading this you’re probably thinking Excel already does that, so what’s different about Tableau? Well, Tableau’s innovation was entirely focused on Visual Analysis, and it has a plethora of features and offers you so much more control over what your visualization looks like. While Excel allows users to evaluate data and do calculations, Tableau’s intuitive visualizations help you to convey your data graphically and in a visually attractive and understandable format. Tableau users can further interact and engage with data graphically to quickly uncover business insights.
Key Features of Tableau
Here a some of the key features responsible for the immense popularity of Tableau.
- Multipurpose Dashboard: Tableau comes with an intuitive dashboard that allows even the non-technical users to perform quick Data Analysis and create visualizations. Users can create high-level graphs and dashboards using its easy-to-use drag and drop functionality.
- Extensive Data Sources: Tableau houses over 200 connectors and drivers that allow users to securely connect to multiple third-party applications and external data sources such as Relational Databases, Big Data, Cloud, Spreadsheets, and more.
- Powerful Collaboration: Users working on different projects can collaborate with each other on Tableau. Users can further share the dashboard on the Cloud, making it accessible to anyone from anywhere.
- Advanced Visualizations: Tableau has a vast collection of advanced Data Visualization techniques. Users can easily visualize data in the form of Charts, Tables, Graphs, Plots, Maps, etc.
- Tableau Community: Tableau has a large community of active users, Developers, and Analysts. Being a part of this community allows you to continuously learn, upskill, build powerful connections, and offer mentorship to newcomers.
Hevo Data is a No-code Data Pipeline that offers a fully managed solution to set up data integration from 100+ Data Sources (including 30+ Free Data Sources) and will let you directly load data to a Data Warehouse to be visualized in a BI tool such as Tableau. It will automate your data flow in minutes without writing any line of code. Its fault-tolerant architecture makes sure that your data is secure and consistent. Hevo provides you with a truly efficient and fully automated solution to manage data in real-time and always have analysis-ready data.
Get started with hevo for free
Let’s look at some of the salient features of Hevo:
- Fully Managed: It requires no management and maintenance as Hevo is a fully automated platform.
- Data Transformation: It provides a simple interface to perfect, modify, and enrich the data you want to transfer.
- Real-Time: Hevo offers real-time data migration. So, your data is always ready for analysis.
- Schema Management: Hevo can automatically detect the schema of the incoming data and map it to the destination schema.
- Scalable Infrastructure: Hevo has in-built integrations for 100’s of sources that can help you scale your data infrastructure as required.
- Live Monitoring: Advanced monitoring gives you a one-stop view to watch all the activities that occur within Data Pipelines.
- Live Support: Hevo team is available round the clock to extend exceptional support to its customers through chat, email, and support calls.
Sign up here for a 14-day free trial!
What is Tableau Content Migration Tool?
With every organization generating data like never before, companies often look to have a competitive edge in the market. Data Analytics and Business Intelligence are the best ways to gain business-critical insights in this age of Data-Driven Decision-Making. The term’s meaning is really in the name itself, it means collecting and using relevant content to make informed and smarter business decisions. This solely leads to an increase in the net content volume. With more and more people working with data on a regular basis, it becomes necessary to ensure that Tableau content can be discovered, migrated, and collaborated upon.
Tableau Content Migration tool, as the name suggests, is primarily used to move Tableau Server content from one project to another. You can migrate content between projects on a single Tableau Server installation or between projects on separate Tableau Server installations. Users can further build a “Migration Plan” that can be used a single time or can be used as a template for multiple migrations.
The Tableau Migration tool gives users the flexibility to move, maintain, and manage content based on specific requirements. This helps in making the content more discoverable by users and streamlines the collaboration process. Tableau Content Migration tool comes with many features that help in accomplishing multiple tasks related to content migration and maintenance.
Installation Requirements
The Tableau Content Migration tool supports only Windows Operating System, hence you’d need a Windows OS to install the Content Migration tool. Before installing the migration tool, you must be able to connect the site you’re migrating (source site) to the Tableau Server Computer and the Tableau Server Computer to the site you’re migrating to (destination site). One must ensure that both the source and destination sites have a valid Server Management Add-on license.
The Tableau Content Migration Tool can connect to Tableau Server versions 2019.3 and later. Before installing the Tableau Migration tool, make sure that your system supports the minimum requirements as mentioned below:
- Microsoft Windows 8 or newer (x64)
- 4 GB memory or larger
- Intel Core i3 or AMD Ryzen 3 (Dual-Core)
- 2 GB HDD or larger.
- Enough free disk space to store the application and its logs.
Also, make sure that the REST API is enabled on Tableau Server. If not enabled, you can run the tsm configuration get -k api.server.enabled command to enable this.
Content Migration Tool Installation
You would need the Administrator access to the computer to proceed with the installation. Follow the below-mentioned steps to install the Tableau Content Migration Tool:
- You can download the Content Migration Tool installer (Tabcmt-64bit-<version>.exe) from the Tableau Server Management release page. Download the installer as per the version of your Tableau Server.
- Once the download is finished, you can open and run the Tableau Migration Tool Setup file.
- Accept the License Agreement and click on “Install”.
- The User Account Control dialog box will now open up, click on “Yes” to allow the installer to make necessary changes.
How to Use Tableau Content Migration Tool?
Tableau Content Migration tool makes the process of Tableau Server migrations quite straightforward. Users can easily build a Migration Plan that can be scrutinized and repeated over time for migrations. A Migration Plan is based on batch processing meaning any number of Workbooks and Data Sources can be migrated with ease. However, the Tableau Server user account(s) must have an Explorer role or higher to proceed.
Before getting started, it is important to understand that each Migration Plan file is generated with a unique Encryption Key corresponding to the application that created the plan. You can view your Encryption Key from Help > Settings.
Image Source: www.help.tableau.com
Follow the below-mentioned steps to get started with the Content Migration Tool Tableau.
Step 1: Start
The first step of the Migration Process is to create a plan. This plan can be saved, modified, and re-used for further migration processes.
- Now, click on “Create New Plan” to create a new plan, or click on “Browse for a Plan” to select an existing plan.
Image Source: www.help.tableau.com
- All of your saved Migration Plans will be stored in the My Documents > Tableau Content Migration Tool Plans folder by default.
Image Source: www.help.tableau.com
- You can also duplicate and modify an existing Migration Plan and save it as a new plan. To do so, select the plan you want to copy and click on “Duplicate”.
Step 2: Planning
Once you’ve created your plan, it’s now time to build it. To build a Migration Plan you must select the Source and Destination Servers in the Servers section of the Planning phase.
Image Source: www.help.tableau.com
Use the below-mentioned steps to sign in to Tableau Server.
- Click on “Sign in to Tableau”.
- The “Select a Server” dialog box will open, you can select a saved connection and click on “Continue”.
Image Source: www.help.tableau.com
- However, if there are no saved connections, click on “Add or edit saved connections” to add a new connection.
- Enter your credentials and click on “Sign In”.
- After signing in, you can select the site you wish to use.
- To modify your selection, click on “Select a different source/destination”. You can use these steps to sign in to Source and Destination Servers.
- After you’ve successfully signed in to both Source and Destination Servers, click on “Next”.
Next up, you need to select the Source Projects from which the Workbooks and Published Data Sources will be migrated. You’ll have 2 options when selecting Source Projects: All Projects, and Specific Projects.
Image Source: www.help.tableau.com
- Select the “All Projects” option to select all the projects from the Source Site specified.
- Or, you can select the “Specific Projects” option to select only specific projects from the Source Site specified.
Image Source: www.help.tableau.com
- After selecting the Source Projects are selected, select the Project Options to apply for the destination.
Image Source: www.help.tableau.com
- After selecting the “Source Projects”, click on “Next”.
The next step requires you to prepare your Workbooks for migration. All of the Workbooks available in the Source Site and Projects are displayed on the “Workbook Selection” page.
Image Source: www.help.tableau.com
- There are 3 ways to choose the Workbooks, you can either select specific Workbooks by clicking on each of them, or you can select Workbooks based on a rule/criteria, or you can entirely select all the Workbooks in the source. You can refer to the Workbooks section for detailed instructions.
- After selecting the Workbooks, click on “Next”.
The next step requires you to select Published Data Sources.
Once you’re done with that, the next step requires you to create any scripts that you want to run with your Migration Plan before or after migration.
- The Pre Migration step is for the scripts that you want to run before the migration process. You can click on “Enable” to activate the script run. Hovering the cursor over the active fields will help you fetch the help information available.
Image Source: www.help.tableau.com
- You can select the “Custom script” option from the Run drop-down to enter your custom pre-migration script. The script will be executed as a *.cmd file.
- The Post Migration step is for the scripts that you want to run after the migration process. You can click on “Enable” to activate the script run. Hovering the cursor over the active fields will help you fetch the help information available.
Image Source: www.help.tableau.com
- You can select the “Custom script” option from the Run drop-down to enter your custom pre-migration script. The script will be executed as a *.cmd file.
- Click on “Next” to configure the Plan Options.
Image Source: www.help.tableau.com
- You can hover your cursor over the ‘question mark’ appearing next to every option to get contextual assistance for a particular option.
- After configuring the Plan Options, click on “Verify & Run” to complete the Planning phase of your migration.
Step 3: Migration
You are now ready to run the batch process for migration. Before running the migration, a plan summary will be displayed for your verification.
Image Source: www.help.tableau.com
- You can click on any section to modify it. Once you’ve verified the details, click on “Run’ to start the migration process.
- You will now be prompted about any unsaved changes that will be saved while running the migration. Click on “Yes” to proceed.
Image Source: www.help.tableau.com
- The migration process will start and you can view the overall plan progress from the status bar.
Image Source: www.help.tableau.com
- Once the Migration Plan finishes running, you can click the bottom tabs to check the output and other relevant information regarding the migration process.
Image Source: www.help.tableau.com
- Click on “Done” to finish.
Use Cases of Tableau Content Migration Tool
- Content Promotion: The Content Migration Tool Tableau can be used to create content in development sites. You can further perform routine migrations to staging or production environments.
- Tailoring Content for Customers: You can use the Content Migration tool to customize content for your customers when working in a consulting scenario. Each Workbook can be used as a template for your Migration Plan, allowing you to customize them with text, images, etc., for specific customers.
- Content Migration: The primary use case of the Content Migration Tool Tableau is to migrate content between Tableau Servers.
- External Content Sharing: In addition to moving content between Tableau Servers, you can also share internal content with external users fostering collaboration. And, you can do so without allowing access to your site using the Content Migration tool. This allows collaborators to view and modify only select content, without affecting content stored on your internal Server.
- Maintenance Tasks: You can use the Content Migration Tool to perform a variety of maintenance tasks such as restoring accidentally removed content from the production Tableau Server, managing archiving stale content, maintaining a backup Tableau Server environment, etc.
Limitations of Tableau Content Migration Tool
- Tableau Content Migration Tool will not migrate the Users, Groups, and Site settings server-level configurations from the Source Site to the Destination Site.
- Content Migration Tool will not migrate the Data-driven alerts, Subscriptions, Custom views, Favorites, and Comments user configurations from the Source Site will not be migrated to the Destination Site.
- Content Migration Tool can only connect to Tableau Server versions 2019.3 and later. Hence, it can’t support the migration of Workbooks and Published Data Sources saved before version 2018.1.x.
- Content Migration Tool will not migrate the content metrics and descriptions of Workbooks and Data sources on the Source Site to the Destination Site.
- Content Migration Tool will not migrate the Tableau Prep flows published to the Source Site to the Destination Site.
Conclusion
Tableau is a prominent Data Visualization and BI tool that allows users to integrate various Data Sources and create attractive Charts, Dashboards, and Reports according to user-specified data that can be shared easily. However, the Tableau content must be maintained and governed such that users can discover, consume, and share content between Tableau Servers easily.
This blog introduced you to Tableau and took you through various aspects of the Tableau Content Migration tool. Tableau makes Business Analysis more efficient through intuitive, interactive, and easy-to-use services. Moreover, analyzing and visualizing your data by loading it into a Data Warehouse from Tableau can be cumbersome. This is where Hevo comes in.
visit our website to explore hevo
Hevo Data with its strong integration with 100+ Sources & BI tools allows you to not only export data from sources & load data in the destinations, but also transform & enrich your data, & make it analysis-ready so that you can focus only on your key business needs and perform insightful analysis using BI tools such as Tableau.
Give Hevo Data a try and sign up for a 14-day free trial today. Hevo offers plans & pricing for different use cases and business needs, check them out!
Share your experience of working with the Tableau Content Migration tool in the comments section below.
Raj is a skilled data analyst with a strong passion for data analysis and architecture, having a flair for writing technical content as well. With extensive experience in handling marketing data, Raj has adeptly navigated abstract business problems to derive actionable insights that drive significant results.