in the future, we’ll enable generic jdbc connectivity and jdbc on tableau server, but the core work is available for you to try in tableau 10. Sap hana, not available via odbc for mac, is our first named connector using jdbc. over the last two releases, the connectivity team has been figuring out the infrastructure for tableau to support jdbc drivers in addition to odbc & oledb. To simply say “we now support hana for mac” would be a significant understatement. enterprise environments utilizing active directory with tableau can now have a seamless single sign-on experience with oracle and tableau. In addition to stored-procedures support, tableau 10 also supports kerberos for oracle. if the table function contains any parameters, tableau will prompt you for them. simply drag and drop the function to the canvas. When you connect to oracle, any table function you have access to will appear in the “stored procedure” section. In tableau 10, you can use table functions as a data source! table functions are a great way to simplify data access to otherwise complex data structures. in tableau 10, you can connect to these databases by supplying the database name right from the connection dialog as seen below. Microsoft sql server and azure sql support a new feature called “contained databases.” when a database is “contained,” it means user information is stored in the database rather than in the dbms, thus making the database more portable. Updates to sql server: contained databases it only connects to teradata presto 141t today, but we plan on supporting even more distributions in the future! with the support of teradata, we built a new named connector for presto. Presto was originally built and maintained by facebook, and now teradata is supporting the platform for enterprise customers. this means data living in hive, cassandra, relational databases, or a number of other sources can be connected to presto for quick analysis. it’s a distributed query engine for interactive data analysis that scales from gigabytes to petabytes.īecause it distributes queries, analysis can be pushed to where data lives.

Presto is another fast data source that’s part of the hadoop ecosystem. Memsql is also wire-protocol compliant with mysql, so if you already have a mysql driver installed, you can connect to memsql.įor more information on the memsql connector, see our post on the using the new memsql named connector, you can analyze current and historical data together while memsql ingests millions of transactions per second. Memsql is a database platform for real-time analytics. it makes the experience of interacting with your database that much more enjoyable. we want to help you gain value from your data, no matter where it lives. that’s why we’re thrilled to announce we’ve added even more data-source options in tableau 10. Many of us have data in many places, waiting to be understood.

Tableau connect to microsoft sql on mac