Connect

You can connect via ODBC (both DSN and DSN-less, on Windows and Linux) or JDBC (on MAC, Windows and Linux). Note that for Workstation on MacOS, JDBC is the only supported driver.

PostgreSQL drivers are shipped with MicroStrategy releases. There are two out-of-the-box PostgreSQL ODBC drivers and one OOTB PostgreSQL JDBC driver.

• MicroStrategy ODBC driver for PostgreSQL wire protocol

• PostgreSQL Unicode(x64)

• MicroStrategy JDBC driver for PostgreSQL wire protocol

Retrieval of PostgreSQL data from MicroStrategy REST APIs is supported. 

The following table summarizes connection support based on the operating system.

Workstation/Intelligence Server OS	MicroStrategy Version	Driver	Driver File	Driver Version
Mac   Workstation	MicroStrategy 2021 Update 5	MicroStrategy JDBC driver for PostgreSQL wire protocol	mypostgresql.jar	6.0.0.000318
Windows Workstation	MicroStrategy 2021 Update 5	MicroStrategy ODBC driver for PostgreSQL wire protocol	mypsql64.dll	7.10.06.465
		MicroStrategy JDBC driver for PostgreSQL wire protocol	mypostgresql.jar	7.16.0465
Windows I-Server	MicroStrategy 2021 Update 5	MicroStrategy ODBC driver for PostgreSQL wire protocol	mypsql64.dll	7.10.06.465
		MicroStrategy JDBC driver for PostgreSQL wire protocol	mypostgresql.jar	6.0.0.000318
		PostgreSQL Unicode (x64)	psqlodbc35w.dll	12.02.0000
Linux I-Server	MicroStrategy 2021 Update 5	MicroStrategy ODBC driver for PostgreSQL wire protocol	MYpsql64.so	7.16.0465
		MicroStrategy JDBC driver for PostgreSQL wire protocol	mypostgresql.jar	6.0.0.000318
		PostgreSQL Unicode (x64)	psqlodbcw.so	12.02.0000