

Some JDBC drivers might not work with Tableau. Some JDBC drivers will support the full Tableau interactive experience, while others may work only for creating extracts. Tableau provides no guarantee or warranty that using the Other Databases (JDBC) connector with any particular JDBC driver or database will be able to successfully connect and query data. Tableau supports the ability to customize your JDBC data connection, which can improve the connection experience. Note: If you are using a version of Tableau Desktop before 2020.2, see the Driver Downloads (Link opens in a new window) page for instructions on installing Java. Starting with version 2020.2, all Tableau applications are bundled with the Java Runtime, so you don't have to install it separately. JDBC requires Java, which makes it platform-independent. This includes both official named connectors, such as Athena, and generic connector for use with other JDBC-based drivers, called Other Databases (JDBC).


If you don't see the variable, click New and add the variable and the directory in the Value.If you see the variable, make sure the Value column matches the directory containing tnsnames.ora.Scroll through the System variables list for the "TNS_ADMIN" variable.In the Advanced tab, click Environment Variables.Make sure the TNS_ADMIN environment variable points to the directory containing the tnsnames.ora file "C:\oracle\product\11.2.0\client\network\admin" and not "C:\oracle\product\11.2.0\client\network\admin\TNSNames.ora".If you do not have a tnsnames.ora file, save this TNSNames.ora file to C:\oracle\product\11.2.0\client\network\admin.If your tnsnames file does not have the warehouse, copy and paste the above text into your existing tnsnames.ora file.(ADDRESS = (PROTOCOL = TCP)(HOST = )(PORT = 1521))
