Connecting to Azure Cosmos instead of MongoDB gives you the benefit of setting up your repository inside of your existing Azure cloud environment. As the protocols for Azure Cosmos is based off of MongoDB, this allows DCA Wrangler to store document-based data in both repositories. This guide will show you how to connect your DCA Wrangler visualization to Azure Cosmos DB.


Create an Azure Cosmos DB Instance

First, from the Microsoft Azure homepage, you will need to open Azure Cosmos DB and create a new Cosmos DB Account. Ensure that your API is set to MongoDB. This should take about 5 minutes to deploy.

Get the Connection String

Once the deployment is complete, copy the Primary Connection String to your clipboard:

Connect the DCA Wrangler

With the copied connection string, open the DCA Wrangler. In these steps, we will configure the connection for a Spotfire group. This is the most common scenario. In the next section, we will demonstrate how to do this for a single user for troubleshooting.

  1. Open Spotfire
  2. Navigate to Tools > Administration Manager.
  3. Select the tab Preferences and find the group for which you will give access to this database for their DCA Wrangler visualizations.
  4. Navigate to Ruths.ai > Energy Analytics.
  5. Press Edit to open the Edit Preferences Dialog.
  6. Press the ellipsis button on the right to open the DBPreferenceInfo Collection Editor

  7. Click Add to create a new database connection.

  8. Enter the string you copied from Azure into the Key and then give it a name!


  9. Press OK and close out of all the windows.


Testing a Connection String

To test a connection string for a single user, follow these steps:

  1. Open Spotfire
  2. Import a minimal Well Header and Production dataset as Data Tables.
  3. Create a DCA Wrangler visualization and configure the minimum visualization properties.
  4. In the top right corner, press the "Load" Button.  
  5. Click "Configure DB Connection".

    This will prompt the Petro.ai Panel to open
  6. Click "Database Connection" on the Petro.ai Panel

  7. Use Petro.ai Database drop-down to select your database connection.
    *these are pictures of connection strings. Your database connection selection will be different.

  8. Wait for Successful connection.
    On the Petro.ai Panel 

        On the DCA Wrangler visualization.        

To learn more about Petro.ai Panel click here

For additional information on RAI DCA Wrangler documentation, click here