A colleague provides a Data Analyst with access to a folder that has the following files.
• Sales.csv
• Book1.json
• Sales.tds
• Export.mdb
Which file can contain information for connecting to an external data source, such as an SQL Server database?
A colleague provides a Data Analyst with access to a folder that has the following files.
• Sales.csv
• Book1.json
• Sales.tds
• Export.mdb
Which file can contain information for connecting to an external data source, such as an SQL Server database?
Export.mdb is a Microsoft Access database file. .mdb files can store data tables, relationships, queries, and also linked external data connections — including to external databases like SQL Server. In Tableau, you can connect directly to an .mdb file and it may contain data pulled from or linked to external SQL Server tables. So Export.mdb can contain information for connecting to external data sources like SQL Server.
A .tds file (Tableau Data Source) contains: Metadata about the data source (field names, data types, calculated fields) Connection details for external sources like SQL Server, Oracle, MySQL, etc. Formatting, default aggregations, aliases, and more