Connect Directly to MemSQL With Tableau 10
Connect Directly to MemSQL With Tableau 10
Using Tableau? Check out the most recent additions to the platform, including new and improved connectors, to help connect you to your data faster and more easily.
Join the DZone community and get the full member experience.Join For Free
Many of us have data in many places, waiting to be understood. That’s why we’re thrilled to announce we’ve added even more data-source options in Tableau 10. We want to help you gain value from your data, no matter where it lives.
Here’s what’s new.
MemSQL Named Connector
We love fast databases. It makes the experience of interacting with your database that much more enjoyable.
MemSQL is a database platform for real-time analytics. Using the new MemSQL named connector, you can analyze current and historical data together while MemSQL ingests millions of transactions per second.
MemSQL is also wire-protocol compliant with MySQL, so if you already have a MySQL driver installed, you can connect to MemSQL.
For more information on the MemSQL connector, see our post on the MemSQL site.
Presto Named Connector
Presto is another fast data source that’s part of the Hadoop ecosystem. It’s a distributed query engine for interactive data analysis that scales from gigabytes to petabytes.
Because it distributes queries, analysis can be pushed to where data lives. This means data living in Hive, Cassandra, relational databases, or a number of other sources can be connected to Presto for quick analysis.
Presto was originally built and maintained by Facebook, and now Teradata is supporting the platform for enterprise customers. With the support of Teradata, we built a new named connector for Presto. It only connects to Teradata Presto 141t today, but we plan on supporting even more distributions in the future!
Updates to SQL Server: Contained Databases
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. In Tableau 10, you can connect to these databases by supplying the database name right from the connection dialog as seen below.
Oracle Table Functions
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.
When you connect to Oracle, any table function you have access to will appear in the “stored procedure” section. Simply drag and drop the function to the canvas. If the table function contains any parameters, Tableau will prompt you for them.
In addition to stored-procedures support, Tableau 10 also supports Kerberos for Oracle. Enterprise environments utilizing Active Directory with Tableau can now have a seamless single sign-on experience with Oracle and Tableau.
Say Hello to JDBC with SAP HANA for Mac
To simply say “we now support HANA for Mac” would be a significant understatement. 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.
SAP HANA, not available via ODBC for Mac, is our first named connector using JDBC. 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.
You can connect via JDBC, create your workbook, and seamlessly publish it to a Windows Tableau Server to have the connection handled transparently to the user by ODBC.
Additional Investments in SAP
HANA for Mac is big, but SAP has gotten more love in Tableau 10. Tableau now supports SAP HANA parameters that are dynamically populated by SQL statements. It’s common to use relative dates in parameters to resolve the last month, quarter, etc. Tableau 10 supports these types of parameters.
We have also updated SAP HANA to support Initial SQL with parameters to enable advanced scenarios like row-level security, auditing, etc.
The Biggest Little Feature in Tableau 10: Remember Connection Details
Are you absolutely tired of filling in server details? Often requested, we have now delivered a little memory to save yours. Once you have successfully connected to a database, Tableau will remember every connection detail except the password. This memory is per user, so shared machines will not share connection settings. It’s already saving everyone time across the organization, and soon, it will help save customers’ time as well.
We hope these new data-source options make it even easier to see and understand all of your data. If you have ideas for more connectors or database updates, let us know in the Ideas Forum!
Learn More about Tableau 10
Tableau 10 includes a brand new look and feel, and a host of new features to help you prep, analyze, and share your insights even faster. Check out our Coming Soon page for details.
Published at DZone with permission of Arthur Gyldenege . See the original article here.
Opinions expressed by DZone contributors are their own.