Prior to Tableau 7.0 you can use the trick in this knowledge base article to replace one data source with another: http://kb.tableausoftware.com/articles/knowledgebase/replacing-data-source
Could you describe why you need an ODBC connection to Sybase IQ instead of the native connection?
Thanks for the response Robert. That trick looks fine to me....will try in a few minutes. Answering your question - because I am having issues getting Tableau Server to refresh an extract made from a Sybase IQ connection, when a colleague of mine has had no issues doing this via an ODBC connection to Sybase IQ.
Happy to stay with a native Sybase IQ connection if I can get Tableau Server to refresh my extract. Every time I request the extract it fails, with an ODBC error. Wierd, since my connection is clearly specified as Sybase IQ.
Ring a bell?
The first-class connections Tableau provides for systems like Sybase IQ still connect via the database ODBC driver. This may explain the error you are seeing on Tableau Server. Depending on the error, this may simply indicate that you do not have the correct Sybase IQ drivers installed on your Tableau Server machine. I suggest that you contact Tableau Support with your problem so they may determine if there's truly an issue with our Sybase IQ native connector. Please mention my name so I may have a chance to take a look.
Regarding the general-purpose ODBC connection (aka "Other databases (ODBC)"), please note that it does not have the purpose-built functionality for each data source that our first-class connections do. The generic ODBC connection is really intended to help users work with data sources we have not added support for yet, and in most cases will require that the user create an extract for the full performance and functionality users expect of Tableau connections.
I tried the Bookmark-driven trick to replace my connection (without changing or rebuilding my worksheet references) and that worked,
though it reminded me why I was using Sybase IQ connectivity in the first place.....my ODBC connection to IQ (at least for the custom
SQL I am using) returns garbage.
So, I will chase up the proper path of figuring out why my Tableau Server extract refreshes of a Sybase IQ connection isn't working, and I will
mention your name to get additional help.
Thanks very much for the quick discussion.
What is the exact ODBC error you get when you refresh the extract from the Tableau Server using Sybase connection?