![]() ![]() Fewer driver limitations means that more functions are available. One example of how Tableau changes behaviour based on what the driver reports is the list of functions available when creating a calculated field. Tableau uses a feature-discovery API in ODBC to question a database driver about the functionality it supports. There are differences in how each database vendor implements capabilities of the ODBC standard. How Tableau determines the capabilities of the ODBC driver The ODBC driver is responsible for the proper conversion of all these requests to the syntax of the target database. The SQL language itself supports complex concepts such as nested queries, correlated subqueries, temporary tables and a variety of functions that can be used in select, where, group by, join clauses and more. The ODBC specification includes syntax for making function requests, join syntax, data types and data type conversions. The driver converts your request to the actual format the Oracle database requires, which is this: select name from emp where birthdate > '29-DEC-87' In effect, the ODBC driver is a translation layer to convert from a general-purpose request to the database-specific request.įor example, the ODBC specification details that dates should be specified in SQL statements by using the syntax: The ODBC driver, usually provided by the database vendor, accepts requests in this standard syntax and converts the request to the native format that the target database prefers. The basis of ODBC is a standard syntax for SQL queries that is used by software applications to connect to and request data from databases. ODBC (Open Database Connectivity) is an industry standard that enables a wide variety of software to access data. By using ODBC, you can access any data source that supports the SQL standard and implements the ODBC API. Tableau has a connector that uses the ODBC standard. ![]() In that case, you still might be able to connect Tableau to the database. These connectors take advantage of capabilities and optimisations specific to these data sources, and they're developed and tested to ensure they are robust and provide good performance.īut you might be working with a database that Tableau doesn't have a connection for. Tableau includes built-in connectors for many databases. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |