Hello,
Looking to see if anyone knows how to add a parameter often used in SQL Server called "MultiSubnetFailover" to a Tableau workbook connection. The only relevant information I have found regarding this is found is this discussion: null. This involves creating a custom .tdc file for Tableau server, but Tableau emphasizes that they do not support or test .tdc files (reference: https://kb.tableau.com/articles/howto/using-a-tdc-file-with-tableau-server)
Has anyone come across a solution to this? For instance, I work on a team with two server nodes (let's say nodes "A" and "B"), which can be failed over to one another in the case of disaster or power outage. For instance, if node A fails, the "always on availability group listener" then points to node B. This is accomplished through SQL Server connections by adding "MultiSubnetFailover=Yes" to the connection string.
I've tried connection Tableau to SQL server in this manner, however Tableau ignores the parameter i.e I can type "MultiSubnetFailover=hello", "MultiSubnetFailover=No", "MultiSubnetFailover=notARealValue" and am able to connect to the server without any issue (a clear indication that the parameter is ignored).
Please let me know if you have any advice or experience using .tdc files in a company in which many developers deploy new Tableau workbooks every week. I have not found too many tips on using these types of files, and I'm looking for insight on how this solution can be scaled to support an entire team (for instance, I don't want each developer creating or modifying any files outside the workbook that will end up on the server). In addition, I am looking to prevent any intensive manual work if the connection for every .tdc needs to change due to a possible server migration.
Thank you.
A .TDC file needs to be on the Tableau Server as well as on the developer's computer. The TDC file contains the necessary settings for the specific connection only and will only be invoked for that type of data source -- not the specific data source but the type e.g. MS SQL Server or GoogleAnalytics or Oracle or etc. The location on the Tableau Server varies with the major version, however, for Tableau Desktop you save the TDC file in the DATASOURCES folder of your Tableau Repository location. For example, here's where I have mine:
As you can see, this TDC is only for MS SQL Server connections.
Tableau doesn't support TDC files in the aspect like they do with their primary products. Thus you could ask for help and suggestions but they are not obligated to find you a solution. You will likely need to do experimentation yourself to figure out what works.
