2 Replies Latest reply on Jan 28, 2013 7:24 AM by Ashim Datta

Data connection- change

Ashim Datta Jan 27, 2013 11:22 PM

I have created a tableau file by extracting all data from the source. So every time when the database refreshes, I need to refresh all my extracts.

I want this to happen dynamically. By dynamic, I mean that my extracts should be automatically refreshed every time the database is updated.

Will changing the connection from "Copy all data" to "Live connect" help in this case? If so then please let me know how to do so?

Also please let me know about the performance issues that might crop up if I change the connection type

1. Re: Data connection- change

Robin Kennedy Jan 28, 2013 1:30 AM (in response to Ashim Datta)

Ashim,

When you 'Connect live', Tableau will send queries directly to your database so in effect whenever your database is updated with new data, Tableau will be querying the most up to date version of your data. To change the connection type from an Extract to a live connection, you should un-tick the 'Use Extract' option from the data source menu.

Bear in mind that now queries are running against your database, you should make sure that the queries are not going to impact any live operation of the db, and that your tables are optimised for querying (i.e. have appropriate indices etc)

You can read more about using Extracts here:
http://kb.tableausoftware.com/articles/knowledgebase/data-extracts-accessing-data-offline
http://www.theinformationlab.co.uk/2011/01/20/tableau-extracts-what-why-how-etc/
Like Show 0 Likes(0)

Actions
2. Re: Data connection- change

Ashim Datta Jan 28, 2013 7:24 AM (in response to Robin Kennedy)

Hey Robin,

Thanks a lot. This really helped
Like Show 0 Likes(0)

Actions

Tableau Community Forums