-
1. Re: Generic ODBC connection to Access Database
Robert MortonDec 27, 2012 9:26 AM (in response to Rajendra Kodavati)
Hi Rajendra,
I was able to reproduce this problem within my environment as well, and I determined that the Access ODBC driver does not properly support the ODBC API for enumerating primary / foreign key constraints. You can suppress Tableau's attempt to use that API with the attached .tdc file (Tableau DataConnection Customization). Please copy that file to the 'Datasources' folder under 'My Tableau Repository' in your user documents folder, and then re-launch Tableau to pick up the changes. You can learn more about TDC files for Generic ODBC connections in this Knowledge Base article: http://kb.tableausoftware.com/articles/knowledgebase/customizing-odbc-connections
Without support for foreign key detection, Tableau will not be able to perform certain query optimizations for multi-table joins. Furthermore, the Generic ODBC connector can only operate using the SQL and ODBC standards, so it will not be as well tuned for the idiosyncrasies of Access SQL syntax as our first-class connector to Access is. I highly recommend using our first-class Access connector instead of ODBC, though I understand that there may be specific reasons why this is not possible in your case.
I hope this helps,
Robert
-
genericodbc-access.tdc.zip 372 bytes
-