MicroStrategy ONE

MicroStrategy ODBC Driver for DB2 Wire Protocol for Windows and Linux

The following information is required for setting up the driver connection for MicroStrategy ODBC Driver for DB2 when running against IBM Db2:

  • Data Source Name: A name to identify the Db2 data source configuration in MicroStrategy. For example, Finance or Db2-Serv1 can serve to identify the connection.
  • Host Name: The name of the machine that runs the Db2 server.
  • Database Name: The name of the database to connect to by default, which is assigned by the database administrator.
  • Port Number: The Db2 server listener's port number. In most cases, the default port number is 50000, but check with your database administrator for the correct number.
  • Enable SSL: The data is encrypted using SSL. If the database server does not support SSL, the connection fails.
  • CryptoProtocolVersion: Specifies a cryptographic protocol or protocols that can be used when SSL is enabled.
  • 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.