Cosmos DB

Solved!
OD
Level 2
Cosmos DB

Hello!

Is it possible to connect DSS to Cosmos DB? If so, is it done by installing Cosmos compatibility APIs for MongoDB or Cassandra, has it been tried and tested by users on DSS, and which compatibility API would you recommend?

Thanks

0 Kudos
1 Solution
sergeyd
Dataiker

Hi @OD 

We don't officially provide a connector for Cosmos DB currently. However, you might be able to connect to it by leveraging our existing MongoDB connector assuming that your Cosmos DB has been started with an API type that is MongoDB compatible.
 
Alternatively, you can also try connecting to Cosmos DB instance using the python recipe. You will need to use pymongo module for establishing the connection. 
 

View solution in original post

0 Kudos
3 Replies
sergeyd
Dataiker

Hi @OD 

We don't officially provide a connector for Cosmos DB currently. However, you might be able to connect to it by leveraging our existing MongoDB connector assuming that your Cosmos DB has been started with an API type that is MongoDB compatible.
 
Alternatively, you can also try connecting to Cosmos DB instance using the python recipe. You will need to use pymongo module for establishing the connection. 
 
0 Kudos
OD
Level 2
Author

Thank you @sergeyd 

It seems that Cosmos DB has compatible APIs only for specific versions of MongoDB: engine 3.2 and 3.6. Is the DSS connector also compatible with those versions?

Otherwise some work around with Pymongo should do.

0 Kudos
sergeyd
Dataiker

As far as I know, we don't have any restrictions on MongoDB versions:

https://doc.dataiku.com/dss/8.0/connecting/nosql/mongo.html

 

0 Kudos