Take full advantage of your prepared data anywhere you need it
Do you want to use the cleaned data to run machine learning models or any other data science use cases? No problem, just load the data to the database that is already connected to your data science tools, and you are all set. Do you want to take advantage of the governance that your organization put in place around your database systems? With Tableau Prep writing the output to database tables, you can leverage all the monitoring, auditing, governance and access control your organization has built around your databases.
Loading data to databases is no longer a complicated task
Traditionally, loading data to databases correctly is a complex, error-prone, and a time-consuming process. Tableau Prep simplifies the process for both analysts and advanced users alike. Whether you need to create a new table, replace or append data to an existing table, that task is no longer as daunting. Tableau makes the process visual and direct, so you can ensure the right data is written to the right fields, in the right format to the database. Have you ever been loading data when suddenly you lose your network connection or the database unexpectedly goes down? You don’t want partial data loaded, especially if you’re just appending rows. This becomes a worry of the past with our approach to loading the data into a temporary database table first, and only moving it to the destination table upon the completion of the data load. This helps to fully safeguard your data before it’s moved to its permanent location.
Writing to external databases and incremental refresh are a perfect match
Earlier this year we introduced incremental refresh for Tableau Prep flows. Now with the ability to write to external databases, you can incrementally load data directly to database tables, reducing data movement and making your Tableau Prep flows even more efficient. Imagine you have a Tableau Prep flow that reads transaction data from your input data source and loads it into a database table. By combining incremental refresh with the “Add to existing table” option you can optimize your flows by appending only newly added rows to your destination table. And you can take this one step further by scheduling this flow in Tableau Prep Conductor to run on a regular basis so you know your data is always up to date.
More visibility, more automation with Data Management
If you use Tableau Server or Tableau Online, you can get a lot more out of the new write to external database capabilities by using Tableau Data Management in your Tableau sites. Write to database is fully integrated with Tableau Catalog. With this integration, the database tables are immediately included in the lineage and impact analysis, so admins and data stewards can keep track of where the data is going. This data is also available via the Metadata API as well as in the Postgres database, enabling admins to monitor where the data is being written. Finally, any newly created tables are available in the Tableau Server and Tableau Online search, and when connecting to data in both Tableau Desktop and web authoring—making these new tables more easily discoverable and accessible. With Tableau Prep Conductor, you can schedule and manage your Tableau Prep flows that write to your databases at scale, allowing them to run on a regular basis in a centralized, scalable and reliable server environment, thus ensuring your data is always up to date.
Add comment