Versions Compared

Key

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

...

For server operations, I favour Microsoft's ETL tool SQL Server Integration Services, due to:

  • its ease of use
  • abilitiy ability to add and use logic in determining when actions need to be undertaken
  • its rich features enabling further look-up and logic controls that can be written in an array of programming languages

...

The Developer Edition can be installed to a server, although it is severely limited on the amount of accessible cores and memory as it is by design, for development and test purposes; although the limitations still provide more than enough compute power for ETL packages.  

Whilst the install is a fairly straightforward process, I recommend that you follow the Microsoft guide here: https://docs.microsoft.com/en-us/sql/database-engine/install-windows/install-sql-server-from-the-installation-wizard-setup Just ensure that when you reach the Feature Selection page that you check the boxes for Integration Services:

Install integration ServicesImage Added

Though you can choose to not install the Scale Out Master options

Once you have installed SQL Server and SQL Server Integration Services using the SQL Server installer, you can now install SQL Server Data Tools which will also install a free instance of Microsoft Visual Studio

Install SSDT

Head on over to Microsoft to grab the latest version of SSDT: Download SQL Server Data Tools (SSDT) - SQL Server Data Tools (SSDT) | Microsoft Docs

And then simply run this installer

You should now be all set for automating Tableau Server.

Note

As I explained at the beginning of this article, you are free to use whichever tools you prefer to work with.

My preference is SQL Server Developer Edition and SQL Server Integration Services; both being commercially free is a great help