Cosmos DB
OD
Partner, L2 Admin, Dataiku DSS Core Designer, Dataiku DSS & SQL, Dataiku DSS Core Concepts, Registered Posts: 5 Partner
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
Best Answer
-
Sergey Dataiker, Dataiku DSS Core Designer, Dataiku DSS & SQL, Dataiku DSS Core Concepts Posts: 365 DataikerHi @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.
Answers
-
OD Partner, L2 Admin, Dataiku DSS Core Designer, Dataiku DSS & SQL, Dataiku DSS Core Concepts, Registered Posts: 5 Partner
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. -
Sergey Dataiker, Dataiku DSS Core Designer, Dataiku DSS & SQL, Dataiku DSS Core Concepts Posts: 365 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