Version 2021

Connect to Google AlloyDB

All environments support Google AlloyDB, except MicroStrategy Cloud for Government (MCG).

  1. In Web, connect to an environment.

  2. In the Navigation pane, click , next to Data Sources.

  3. Find and select the Google AlloyDB data source.

  4. Assign a name to the data source and add a new database connection.
  5. Assign a name to the connection and enter the Host Name, Port Number, Database, and Username/password. Please note that Google Alloy DB also supports SSL/certificates.
  6. ODBC Connection string template:

    Copy
    DRIVER={MicroStrategy ODBC Driver for PostgreSQL Wire Protocol};
    HostName=1.1.1.1;
    PortNumber=5432;
    Database=test;
    EncryptionMethod=1;
    ValidateServerCertificate=1;
    TrustStore=?MSTR_TRUSTSTORE_PATH;
    hostNameInCertificate=alloy;

    JDBC connection string template:

    Copy
    JDBC;
    DRIVER={com.microstrategy.jdbc.postgresql.PostgreSQLDriver};
    URL={jdbc:microstrategy:postgresql://1.1.1.1:5432;
    DatabaseName=test;
    EncryptionMethod=SSL;
    ValidateServerCertificate=true;
    hostNameInCertificate=alloy};

  7. Test the connection and click Save.
  8. Choose the project and save the new data source you just created. Then you can use Datasets to import and analyze data.
  1. In MicroStrategy Web, click Create > Add External Data.
  2. Find and select the Google AlloyDB data source.

  3. Select an import option and click Next.

  4. Next to Data Sources, click New Data Source to add a new connection.

  5. Fill out the required data source information.

    ODBC connection string with Progress diver template:

    Copy
    DRIVER={MicroStrategy ODBC Driver for PostgreSQL Wire Protocol}; HostName=; PortNumber=; Database=; EncryptionMethod=1; ValidateServerCertificate=0;

    ODBC connection string with Native driver template:

    Copy
    DRIVER={PostgreSQL Unicode(x64)}; Servername=; Port=; Database=; DriverUnicodeType=1; UseDeclareFetch=1; Fetch=1000; SSLmode=require;

    JDBC connection string template:

    Copy
    JDBC;DRIVER={org.postgresql.Driver};URL={jdbc:postgresql://hostname:port/database}