MicroStrategy ONE

MicroStrategy ODBC Driver for Amazon Redshift Wire Protocol for Windows and Linux

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

  • Data Source Name: A name to identify the Amazon Redshift data source configuration in MicroStrategy. For example, Finance or Redshift-1 can serve to identify the connection.
  • Host Name: The server name or IP address of the machine on which the Amazon Redshift data source resides. Contact your system administrator for the server name or IP address.
  • Port Number: The port number for the connection. In most cases, the default port number is 5439, but you should 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.
  • 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.