Connect to Cosmos account using Studio 3T

To connect to a Cosmos account using Azure Cosmos DB's API for MongoDB, you must:

Create the connection in Studio 3T

To add your Cosmos account to the Studio 3T connection manager, perform the following steps:

  1. Retrieve the connection information for your Cosmos account configured with Azure Cosmos DB's API MongoDB using the instructions in the Connect a MongoDB application to Azure Cosmos DB article.

    Screen shot of the connection string page

  2. Click Connect to open the Connection Manager, then click New Connection

    Screen shot of the Studio 3T connection manager

  3. In the New Connection window, on the Server tab, enter the HOST (FQDN) of the Azure Cosmos DB account and the PORT.

    Screen shot of the Studio 3T connection manager server tab

  4. In the New Connection window, on the Authentication tab, choose Authentication Mode Basic (MONGODB-CR or SCARM-SHA-1) and enter the USERNAME and PASSWORD. Accept the default authentication db (admin) or provide your own value.

    Screen shot of the Studio 3T connection manager authentication tab

  5. In the New Connection window, on the SSL tab, check the Use SSL protocol to connect check box and the Accept server self-signed SSL certificates radio button.

    Screen shot of the Studio 3T connection manager SSL tab

  6. Click the Test Connection button to validate the connection information, click OK to return to the New Connection window, and then click Save.

    Screen shot of the Studio 3T test connection window

Use Studio 3T to create a database, collection, and documents

To create a database, collection, and documents using Studio 3T, perform the following steps:

  1. In Connection Manager, highlight the connection and click Connect.

    Screen shot of the Studio 3T connection manager

  2. Right-click the host and choose Add Database. Provide a database name and click OK.

    Screen shot of the Studio 3T Add Database option

  3. Right-click the database and choose Add Collection. Provide a collection name and click Create.

    Screen shot of the Studio 3T Add Collection option

  4. Click the Collection menu item, then click Add Document.

    Screen shot of the Studio 3T Add Document menu item

  5. In the Add Document dialog, paste the following and then click Add Document.

     {
     "_id": "AndersenFamily",
     "lastName": "Andersen",
     "parents": [
            { "firstName": "Thomas" },
            { "firstName": "Mary Kay"}
     ],
     "children": [
        {
            "firstName": "Henriette Thaulow", "gender": "female", "grade": 5,
            "pets": [{ "givenName": "Fluffy" }]
        }
     ],
     "address": { "state": "WA", "county": "King", "city": "seattle" },
     "isRegistered": true
     }
    
  6. Add another document, this time with the following content:

     {
     "_id": "WakefieldFamily",
     "parents": [
         { "familyName": "Wakefield", "givenName": "Robin" },
         { "familyName": "Miller", "givenName": "Ben" }
     ],
     "children": [
         {
             "familyName": "Merriam",
              "givenName": "Jesse",
             "gender": "female", "grade": 1,
             "pets": [
                 { "givenName": "Goofy" },
                 { "givenName": "Shadow" }
             ]
         },
         {
             "familyName": "Miller",
              "givenName": "Lisa",
              "gender": "female",
              "grade": 8 }
     ],
     "address": { "state": "NY", "county": "Manhattan", "city": "NY" },
     "isRegistered": false
     }
    
  7. Execute a sample query. For example, search for families with the last name 'Andersen' and return the parents and state fields.

    Screen shot of Mongo Chef query results

Next steps

  • Learn how to use Robo 3T with Azure Cosmos DB's API for MongoDB.
  • Explore MongoDB samples with Azure Cosmos DB's API for MongoDB.