![]() ![]() You need a working directory for the Java process (which is not a root process or one of the QT processes). Note that Tableau spawns several processes. Place SSLConfig.properties and truststore.jks in a working directory of your java program.Create truststore.jks from the SuperServer CA certificate: keytool -import -file CA.cer -alias CA -keystore truststore.jks -storepass 123456 -noprompt.Linux: /opt/tableau/tableau_driver/jdbc.Windows: C:\Program Files\Tableau\Drivers.Place the JDBC driver into the correct folder:.Configuring encrypted JDBC connection from Tableau Desktop Now we are ready to establish an encrypted JDBC connection from Tableau Desktop. I recommend first enabling SSL/TLS connections, then verifying that all clients (xDBC, WebGateway, Studio, NativeAPI, etc.) use encrypted SSL/TLS connections and requiring SSL/TLS connections only after that. Where: 0 - disabled, 1 - enabled, 2 - required.īefore you Require SSL/TLS connections, remember to enable SSL/TLS connections to the SuperServer for WebGateway and Studio. Set sc = #class(Security.System).Modify("SYSTEM". Enable (or Require) SuperServer SSL/TLS support::.Set sc = #class(Security.SSLConfigs).Create("%SuperServer". ![]() Set p("TLSMinVersion")=16 // Set TLSMinVersion to 32 to stick with TLSv1.3 Set p("Description")="Autogenerated SuperServer Configuration" Create %SuperServer SSL Configuration, which uses server cert/key from (1). I recommend doing it after establishing an initial encrypted connection.Ģ. Optionally, generate client cert/key for mutual verification. # cp /tls/vars /opt/install/easy-rsa/easyrsa3/pki/vars This topic is described in the documentation, but to summarise it, you need to do three things: Securing SuperServerīefore we start with client connections, you need to configure SuperServer, which by default runs on port 1972 and is responsible for xDBC traffic to accept encrypted connections. While documentation on configuring TLS with Java clients covers all possible topics on establishing an encrypted JDBC connection, configuring it with Tableau might be a little bit tricky, so I decided to write it down. In this article, we will establish an encrypted JDBC connection between Tableau Desktop and InterSystems IRIS database using a JDBC driver. ![]()
0 Comments
Leave a Reply. |