Connect via JDBC

The JDBC driver is supported on all platforms (Mac/Windows/Linux). The configuration is the same as shown above for the DNS-less ODBC driver. From an end-user perspective, there is no difference between an ODBC and JDBC driver. JDBC drivers only support DSN-less connection. For MacOS, you can only access data using a JDBC driver.

Sample JDBC connection string for connecting PostgreSQL via shipped JDBC driver:

JDBC;DRIVER={com.microstrategy.jdbc.postgresql.PostgreSQLDriver};URL={jdbc:microstrategy:postgresql://{hostname}:{port};DATABASENAME={database};EncryptionMethod=SSL;ValidateServerCertificate=false;fetchTWFSasTime=TRUE};