Strategy One

Preview Feature: Import Data from Cognite Data Fusion

Cognite Data Fusion can be directly integrated as a Strategy data source. This is a preview feature.

Preview features are early versions of features and are not to be used in a production environment as the core behavior remain subject to change between preview and GA. By selecting to expose preview features, you can access these features and use them as you would any other dashboard functionality. The official versions of preview features are included in subsequent releases.

Create an OAuth 2.0 App in Cognite

  1. Create the OAuth 2.0 app following the directions in Register a custom web app in Microsoft Entra ID.

  2. Add redirect URI for Library or Workstation:

  • Library redirect URI: https://<servername>/MicroStrategyLibrary/auth/DIOAuthRedirect.jsp

  • Workstation redirect URI: http://127.0.0.1

Create a Cognite Data Source

After you Create an OAuth 2.0 App in Cognite, create the Cognite Data Source in Strategy.

  1. Open Workstation or Library.

  2. In the Navigation pane, click + next to Data Sources to add a new data source.

  3. In the Available Data Source Types, choose Cognite Data Fusion.

  4. Type the Name of the database role being created and, optionally, a Description. The Database Version is set to Cloud Gateway Cognite Data Fusion by default.

  5. From the Default Database Connection drop-down list, choose an existing database connection or add a new one.

    • To create a new database connection, choose an existing authentication service or add a new one. To create a new authentication service, follow the steps below

      1. Type a Display Name.

      2. The Identity Provider is set to Azure by default.

      3. Type the Client ID, Client Secret, and Directory(Tenant ID).

      4. Type the Scope in the format https://<your API website>/.default offline_access openid profile. The Library Web, Authoring Web, and Workstation URIs are automatically populated.

        For more information on creating an IAM object, see Manage OAuth Enterprise Security with Identity and Access Management (IAM) Objects.

  6. Click Save.

    The Test button is disabled for OAuth authentication.

  7. If you need to modify the connectivity information, click the pencil icon.

  8. Select the Projects to associate this database role with.

  9. Click Save.

    The Test button is disabled for OAuth authentication.

Import Data from Cognite

Once you have successfully created the required database role as described above, you can start importing data.

  1. Open Workstation or Library:

    • Workstation:

      1. In the Navigation pane of the Workstation window, click + next to Datasets.

      2. Select your Environment, Project, and Data Import Cube.

      3. Click OK.

    • Library:

      1. Click Create New + and select Dashboard.

  2. Select the Cognite database role. If this is your first time using the database role, a pop-up window displays for the Cognite Login.

  3. After you log in to Cognite, choose Custom API and select the API method (either Get or Post).

  4. Type the Table Name.

  5. If using Get, type the URL.

  6. If using Post, type the Body.

  7. Click Preview to view the first 50 rows of data.

  8. Save it as a customized template by clicking Save.

  9. Do one of the following:

    • Import the data by clicking Add Table.

    • Directly use the saved template to import data.

  10. Click Preview at the top right to view the sample data and adjust the column type.

  11. Publish the cube to Strategy with your data.