forums

Use these forums to ask questions and discuss Tableau.

switching data sources from access to SQL

Posted December 11th, 2007 by bfarinella
in Data Sources and Performance

I recently switched my data source from an access database to a SQL database. Is there any way to have the existing workbooks use a new SQL server connection rather then the access database?

Bill

Add new comment

Comments

On December 13th, 2007 Erin Easter said:

Hi Bill. Right now Tableau doesn't support editing the connection to point at a different type of data source (e.g., Access to SQL Server). We are aware that it is a feature many would like to have and I'll let you know if it makes it onto a feature list.

Although it is unsupported, some people have had success in editing the XML of the workbook. That means that they open the work book using a text editor instead of Tableau and modify the information between the <connection> and </connection> tags. To get an idea of how to modify the connection you can compare your Access workbooks to a workbook that connects to your SQL Server data source.

This is unsupported and undocumented and could cause problems with your workbooks. If you decide to try it you should definitely back up your workbooks first.

reply
Syndicate content Subscribe to the comments on "switching data sources from access to SQL"