Hello Everyone,
My question is in regards to extracting data from a local 2012 SQL Server database.
We have a user who has a local 2012 SQL Server database they access and create reports from. So we created a "Site" in Tableau Server so they can publish their own reports.
But the issue they're having is when they publish their report using data from their local SQL Server database, they get an error about connecting to their database.
I was thinking the user could create an extract from their local SQL Server database and then publish it to their Tableau Server Site.
Would that work since the extract is just a snapshot of their data and would it try to connect to their local database still?
Any help or advice would be greatly appreciated.
In order for the workbook to connect to the data source:
Embedded Credentials is allowed on the Tableau Server
Make sure the proper version of drivers are installed on your Tableau Server for SQL Server.
Make sure credentials are embedded during the publishing process
Yes, they can create an extract and publish it to the Tableau Server, thus being a static extract (a snapshot) that will not connect to the SQL Server.
