MicroStrategy integration steps (NEW, beta)

The MicroStrategy integration in Collibra Data Intelligence Cloud enables you to harvest MicroStrategy Intelligence Server metadata and create new MicroStrategy assets in Data Catalog. Collibra analyzes and processes the BI metadata and presents it as assets of specific types, retaining their original names.

Important To access MicroStrategy data, you have to use the In-memory Dataset connection method in MicroStrategy, not the Live Connect connection method. If the data is not stored in memory, the MicroStrategy APIs can't access it.

Steps

  1. Prepare a domain for MicroStrategy ingestion.
    If you already have a domain reserved for ingestion of the new MicroStrategy assets, you can skip this step.
  2. Prepare the Data Catalog physical data layer.
  3. Download and install the lineage harvester.
  4. Prepare the lineage harvester configuration file.
  5. Prepare the <source ID> configuration file.
  6. Start the lineage harvester again in the console and run the following command:
    • for Windows: .\bin\lineage-harvester.bat full-sync
    • for other operating systems: ./bin/lineage-harvester full-sync
    7. When prompted, enter the password or client secret to connect to your Collibra Data Intelligence Cloud and Tableau environment. The passwords are encrypted and stored in /config/pwd.conf.

What's next?

You can check the progress of the ingestion in Activities. The results field indicates how many relations were imported into Data Catalog.

After the metadata is ingested in Data Catalog, you can go to the domain that you specified in your lineage harvester configuration file and view the newly created assets. These assets are automatically stitched to existing assets in Data Catalog.

You can also view the MicroStrategy technical lineage.

Warning We strongly recommend that you not edit the full names of any MicroStrategy assets. Doing so will likely lead to errors during the synchronization process.

Warning We highly recommend that you do not move the ingested assets to another domain. If you do, the assets will be deleted and recreated in the initial Data Catalog BI domain when you synchronize MicroStrategy. As a consequence, any manually added data of those assets is lost.