CosmosDB Connection


With this connection type, it is possible to connect to Azure Cosmos DB, which is a globally distributed, multi-model database service that stores different types of items in various types of containers, depending on the API used. Jedox currently supports the APIs for SQL and for MongoDB.

Main Settings


The host name (DNS name) or the IP address of the server on which the database is located


The TCP/IP port number used by the database


Name, schema, or instance of the relational database

User name:

User name for the connection to the database


Password string for MongoDB can be found under Connection String→Primary Password on the Microsoft Azure Portal.

Password for SQL can be found under Keys→Primary Key on the Microsoft Azure Portal.

Cosmos Model/API:

MongoDB or SQL

Advanced Settings

Timeout (in s):

The server selection timeout in seconds. Default value is 0, which means it will try to make a connection endlessly.