6.3 Connect to Live Databases

The power of products like Tableau is that they can automatically adjust to a live and dynamic data sources like a live SQL Server database. The advantage of that is that the visualizations will update immediately when the data sources update. To connect to a live SQL Server database in Tableau, click the "SQL Server" option on the left navigation pane. When the window opens that you see in Figure 6.1, use the credentials you see below this paragraph which may not be exactly the same as what you see in Figure 6.1.

• Server: mkshared.database.windows.net

• Database: shared

• Username: mkshared

• Password: 8ring0ataTogether

  • NOTE: Please avoid accidentally sharing or publishing this password. Otherwise, it gets picked up by web crawlers who then run up massive bills on my server and I have to change it mid-semester, which interrupts the class. Thank you!

TIP: Please note that when connecting to live databases, Tableau (and similar tools) may need to convert the data types from the raw database format. Watch Tableau: convert data types coming from live databases if you'd like help understanding this process and adjusting data types in Tableau.