ActianCorp / actian_tableau_connector

Tableau connector (aka taco) for Actian Avalanche, Vector, and Ingres
https://extensiongallery.tableau.com/products/936
Apache License 2.0
1 stars 4 forks source link

Update ODBC connection dialog files to v2 #56

Closed hab6 closed 1 month ago

hab6 commented 1 month ago

The Actian Tableau ODBC connector is updated to bring it in line with Connection Dialog v2 guidelines that were published in Tableau SDK documentation via PR 928 on March 3, 2022.

Note that the Actian Tableau JDBC connector was already updated via PR 26 to use the Connection Dialogs V2 framework.

The changes to the ODBC connection dialog include removing the free form Options field which, according to Tableau Security Considerations, is a security vulnerability, stating that "connectors with such fields will not be approved for the Tableau Exchange".

The workaround for setting non-sensitive driver properties (according to the referenced Tableau Security Considerations document) is to add them as separate fields on the Advanced tab using the Connection Dialogs V2 framework.

The need for these changes was discovered during certification work (II-12701) to prepare the latest release of the Actian Tableau JDBC and ODBC connectors for publishing to Tableau Exchange. Ticket II-15215 tracks the issue for the Actian Tableau ODBC connector.

The changes provide a Driver field on the Advanced tab of the ODBC connection dialog which can optionally be used to specify a different ODBC driver than the default. These changes were tested with Actian Client 1.0.0-139 and Actian Ingres 12.0 GA on Windows 10 x86_64.

image

The ODBC connection dialog will be further updated in a separate PR to provide support for Federated Identity Management (FIM/SSO).