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 administrator access to your Cosmos DB account.
• 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.