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

Host:

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

Port:

The TCP/IP port number used by the database

Database:

Name, schema, or instance of the relational database

User name:

User name for the connection to the database

Password:

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.