Azure Cosmos DB Connection

abhish

Hello,

We thinking to connect the cosmos db using a JDBC connection in our ADS. However, we did not see cosmos db as an option on the dropdown list in the external system setting. So, trying to see if anyone here has the answer to our question below:

Do Experian ADS support Cosmos db?

If Yes, has anyone here made this connection yet?

If no, then are there any alternatives to reach to cosmos db from ADS?

Thanks

Josh Boxer

Hello

Data Studio can support JDBC drivers from third-parties. It is easy to set this up once you have the driver: https://docs.experianaperture.io/data-quality/aperture-data-studio-v2/get-started/configure-external-systems/#thirdpartydrivers~jdbc-databases

Alternatively extracting the required data to Azure blob storage and importing it from there will be faster than JDBC for large volumes of data.

abhish

Hello, Josh,

Do you know where we can get the third-party driver that we need for Cosmos DB? We try to look it up online and there are a lot of different drivers available. Just want to make sure we are trying the one that will work on Experian.

Henry Simms

Hi @abhish , in general any modern / type 4 JDBC driver should work with Data Studio. I've just successfully tested a Cosmos DB connection using the CData Azure Cosmos DB driver's 30-day free trial option. The driver supports several different authentication types, and I just tried the basic Account Key auth, meaning my Data Studio External System's custom connection string looked like this:

jdbc:cdata:cosmosdb:AccountEndpoint=https://<Cosmos_DB_account_name>.documents.azure.com:443/;AccountKey=<PRIMARY_KEY>;

This allowed me to successfully load documents in a collection, represented by the driver as a normalized table, into a Data Studio dataset.

Note that I haven't extensively tested the driver.