Strategy integration preflight checks

The Strategy (formerly MicroStrategy) technical lineage integration supports both on-premises deployments and Strategy Cloud. To ensure successful metadata ingestion and lineage generation, complete the following preflight checks.

Note MicroStrategy has been renamed to Strategy. The MicroStrategy connection and Technical Lineage for MicroStrategy capability names in the UI will be updated to reflect the new name in a future release.

In your Strategy environment

Strategy Cloud deployment

REST API authentication must be enabled in your Strategy environment. If it isn't enabled, contact Strategy Support.

On-premises deployment

The integration uses a set of specific API calls to communicate with the Strategy Library. During the process, the integration loads all required cookies and maintains the session to ensure a complete metadata harvest from both in-memory and live-connect datasets.

  • You need the following Admin API permissions:
    1. The first call we make to Strategy is to authenticate. We connect to:
      <MSTR URL>:<Port>/MicroStrategyLibrary/api-docs/ and use GET api/auth/login.
      For complete information, see the Strategy documentation.
      If this API call can be made successfully, you can ingest the metadata.
    2. The same connection:
      <MSTR URL>:<Port>/MicroStrategyLibrary/api-docs/, but with GET api/model/tables/<tableId>.
      For complete information, see the Strategy documentation.
      This endpoint is needed to create lineage and stitching.
  • You need permissions to access the library server.
  • The lineage harvester (deprecated) uses port 443. If the port is not open, you also need permissions to access the repository.
  • You have to configure the Strategy Modeling Service. For complete information, see the Strategy documentation.

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

Note Freeform SQL is supported for reports (not cubes or dossiers) if you have MicroStrategy update10 or newer, or MicroStrategy ONE.

Using a proxy server

If you are using a proxy server, confirm with your Collibra Admin that your proxy server is configured to access the library server.

Using a custom URL to connect to the Strategy Library Server

Important This requirement applies only if you are connecting to a proxy server.

If you're using a custom URL to connect to the Strategy Library Server, you have to specify the URL. Specify the URL in the MicroStrategy Library URL field, in your Edge capability.

In your Collibra environment

Lineage enablement

  • Technical lineage via Edge is enabled in your Collibra environment.

Edge

  • You either created and installed an Edge site or were granted a Collibra Cloud site.
    Important If you're using a Collibra Cloud site, go the Collibra Cloud site documentation to check if your data source is supported.
  • The Edge site status must be Healthy.

Network and proxy configuration

  • Edge can connect to all Collibra Data Lineage service instances in your geographic location.
  • Optionally, you've connected to a proxy server.
  • Optionally, use a custom certificate to allow the Edge capability to connect to your data source. In this case, you've saved the certificate as "ca.pem" in the same directory as the Edge site installer. If you've saved the certificate in another directory, use the --ca argument in the Edge site installation command.

Collibra permissions

You can connect to Collibra Data Lineage by using the basic or OAuth authentication method. The following permissions are required only if you use the basic authentication method. 

To create a new target domain for asset ingestion:

To create a Strategy connection (the MicroStrategy connection in the UI):

To connect to Collibra Data Lineage service instances via OAuth authentication:

To add an Edge capability:

To synchronize technical lineage: