Skip to main content

Cosmos DB

Integrating Cosmos DB with Osano​

Connecting to Cosmos DB​

In order for Osano to discover data stored in your systems, we must connect to those data providers via an API. We require, at minimum, read-only access to establish a connection to these providers. Each provider you connect may require different information. Please see the linked vendor documentation for instructions on where and how to obtain this data.

Prerequisites​

  • Ensure you have, at minimum, read access to the database/tables you want to discover data from.
    • The master key you provide follows the same permissions as the user that it originates from.
  • Find your master key from the left menu, Keys, in the Cosmos DB portal. You can find more information on how to find your master key here.
  • Find your cosmos DB account name. This is usually found on the top left of the Cosmos DB portal above the text Azure Cosmos DB account.
  • Ensure you have the correct name of the database you want to query for.

Step by step guide​

  1. Access Data Mapping Settings:

    • Navigate to the Data Mapping page in the Osano application.
    • Select Sources from the left-hand navigation menu.

  2. Select Cloud DB as Source type

  3. From the available SSO sources, select Cosmos DB.

  4. Configure Cosmos DB Integration:

    • Follow the on-screen instructions to configure your Cosmos DB integration.
    • Enter your master key in the Master Key field. This can be either the primary or secondary key from your Cosmos DB account.
    • Enter your Cosmos DB account name in the CosmosDB Account Name field.
    • Enter your Cosmos DB database you want to be queried for data in the Database Name field.
    • Click Save.

  5. View Cosmos DB Integration:

    • Once saved, you will see your Cosmos DB integration in the list of configured SSO sources.
    • Your integration will include tables that already exist in your Cosmos DB environment.

  6. Click into the Discovered Data to view the tables that synced from Cosmos DB.

  7. Create a new data store:

    • To proceed with creating a new data store, click on Review.
    • Follow the prompts to create a new data store.