MicroStrategy ODBC Driver for PostgreSQL Wire Protocol for Windows and Linux

The following information is required for setting up the driver connection for the MicroStrategy ODBC driver for PostgreSQL Wire Protocol:

• Data Source Name: A name to identify the PostgreSQL data source configuration in MicroStrategy. For example, Finance or PostgreSQL-1 can serve to identify the connection.
• Host Name: The name or IP address of the machine on which the PostgreSQL database resides. The system administrator or database administrator assigns the host name.
• Port Number: The port number for the connection. The default port number for PostgreSQL is usually 5432. Check with your database administrator for the correct number.
• Database Name: The name of the database to connect to by default. The database administrator assigns the database name.
• User Name: The name of a valid user for the PostgreSQL database.
• Enable SSL: The data is encrypted using SSL. If the database server does not support SSL, the connection fails.
• ValidatedServerCertificate: Determines whether the driver validates the certificate that is sent by the database server when SSL encryption is enabled.
• TrustStore: Enter the directory of the truststore file to be used when SSL is enabled.
• Host Name in Certificate: Enter a host name for certificate validation when SSL encryption and validation are enabled.