CosmosDB Connection

Access level: read

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.

Connection 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
Timeout (in s) The server selection timeout in seconds. Default value is 0, which means it will try to make a connection endlessly.

 

Updated October 24, 2024