1 of 1 people found this helpful
This data source is not enabled by default. You need a special key to turn it on, and I don't think we give them out any more as InterSystems isn't particularly interested in working with us on the connector, so it doesn't make sense to distribute something we can't support well.
I've heard of people connecting to Cache directly via generic ODBC - but they then immediately make an extract of the data that they want to work with vs. using a "live" connection.
Hope this helps.
In version 6.1, Tableau help exposed an XML file to assist in these connections -- that link is now dead. Can someone publish what was in the XML file (I'm presuming it isn't that big of a file).
Old version 6.1 online help link -- in the doc it mentions an XML file which is a dead link....
Another way to populate Tableau with this data may be via third-party. I know IRI reaches Intersystems’ Cache data with a proprietary driver, as it’s listed here, and they populate Tableau with prepared data subsets that are easier to ingest anyway; for example:
http://www.iri.com/blog/business-intelligence/faster-simpler-big-data-prep-tableau/http://www.iri.com/blog/business-intelligence/faster-simpler-big-data-prep-tableau/. It’s a cost to get at it with that tool, but I see there are speed and functional pick-ups generally that way.
We are using IntersyStems and I am new to Tableau. Anything changed from 3 years ago regarding connection to Cache? I've tried "other Database (ODBC)", but it didn't work. I am currently on full version of 9.3 for a trial period of 14 days.
Never mind. I was able to connect!