Product Tour
forums
Use these forums to ask questions and discuss Tableau.
SQLite support
Posted April 2nd, 2008 by A.Loomis
Hi,
Hope this is the right place for requests....
I'm asking for SQLite support http://www.sqlite.org/
THANKS!
Angela
Subscribe to the comments on "SQLite support"
Comments
Thanks for the suggestion Angela. As we continue to consider additional data sources you're feedback helps guide our decision.
Are there other people out there who are wishing for SQLite support? How about other data sources?
I would imagine that support for SAS data files should be a priority. Many of my clients use SAS for analytics and it's visualization capabilities are privative unless you take hours to create charts
We could use support for SQLite
Yes, we would appreciate sqlite support as well. Alternatively, if there was an API or some kind of developer kit we could use for writing our own database plugins, or an ODBC plugin, that would also be useful.
Yes on the SQLite and SAS datasets.
MANY BLESSINGS!
Peace and All Good!
Michael
Add SQLite support PLEASE!
-Tim Cash
Our IT folks tell me that we can probably already use SQLite as long as their is a way to use OBDC to connect to the data source. What does that mean and is that possible today?
Michael
I'd also asked for sqlite support, since we use that often for quick databases we generate from code. I have a project that I recently undertook to convert an archive of daily automated build emails (with a textual table of results) into a sqlite database with ~500,000 records so I could mine the data.
My solution was to use the sqlite ODBC driver (available from http://www.ch-werner.de/sqliteodbc/) to set up a connection suitable to link into a blank Access database. Then I could use Tableau's Access import to start visualising the data in the sqlite database.
Two main problems:
- it's VERY slow. sqlite is usually relatively fast for this sort of thing, and the performance through Access and ODBC was just dismal.
- Tableau doesn't support COUNT DISTINCT through Access, which I could have done with.
But it was enough to get me going. I'd still like native sqlite support (primarily for the performance improvement) but it's not impossible to use data in sqlite databases even now.