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!