Cosmos DB

OD
OD Partner, L2 Admin, Dataiku DSS Core Designer, Dataiku DSS & SQL, Dataiku DSS Core Concepts, Registered Posts: 5 Partner
in Setup & Configuration

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

· Share on Facebook

Best Answer

  • Sergey
    Sergey Dataiker, Dataiku DSS Core Designer, Dataiku DSS & SQL, Dataiku DSS Core Concepts, Registered Posts: 365 Dataiker
    Answer ✓

    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.
    · Share on Facebook

Answers

  • OD
    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.

    · Share on Facebook
  • Sergey
    Sergey Dataiker, Dataiku DSS Core Designer, Dataiku DSS & SQL, Dataiku DSS Core Concepts, Registered 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

    · Share on Facebook
Bookmark this topic

Categories

Setup Info
    Tags
      Help me…