Connectors built with the Connector SDK use either an ODBC or a JDBC driver to communicate with the database.
In general, we prefer JDBC connectors to ODBC connectors, as JDBC is cross-platform.
To learn more about JDBC drivers and Tableau, check Specify the right JDBC driver section in the user documentation.
If the driver only includes a single jar file, copy it to the JDBC driver location.
If the driver includes more than a single file, create a unique subfolder under JDBC driver location and include all required files.
This will create an isolated classloader for that driver.
To learn more about ODBC drivers and Tableau, check the Tableau and ODBC page in the user documentation
Tableau expects correct SQLStates to be returned in certain situations. Inaccurate SQLStates (for example, returning a generic error instead of SLQState 28000 for invalid credentials) may cause bugs in the connector.
|1002||Disconnect Error||Connection is disconnected|
|08001||Unable to Connect||Client unable to connect to server|
|28000||Invalid Authorization Specialization||User enters invalid credentials (Bad username\password, etc)|