Qlik Community

Technology Partners Ecosystem Documentation

Qlik Technology Partners Ecosystem

Announcement: Certain actions are currently causing a Page Not Found error. This is a known issue and we are working with the platform vendor to investigate and resolve it.

White Paper - Connecting to CosmosDB SQL API from Qlik Sense using the Qlik REST Connector


White Paper - Connecting to CosmosDB SQL API from Qlik Sense using the Qlik REST Connector


Cosmos DB is a fast growing, multi-modal database service in Microsoft Azure offering several API’s. Currently, the SQL API is the most popular and widely used API. When you create a Cosmos DB account, you must decide which API you want to use as the data will get stored in corresponding data model/format.


Turnkey global distribution

  • You can distribute your datato any number of Azure regions, with the click of a button. This enables you to put your data where your users are, ensuring the lowest possible latency to your customers.
  • Using Azure Cosmos DB's multi-homing APIs, the app always knows where the nearest region is and sends requests to the nearest data center. All of this is possible with no config changes. You set your write-region and as many read-regions as you want, and the rest is handled for you.
  • As you add and remove regions to your Azure Cosmos DB database, your application does not need to be redeployed and continues to be highly available thanks to the multi-homing API capability.

Multiple data models and popular APIs for accessing and querying data

The underlying atom-record-sequence (ARS) based data model that Azure Cosmos DB is built on natively supports multiple data models, including but not limited to document, graph, key-value, table, and column-family data models.

APIs for the following data models are supported with SDKs available in multiple languages:

  • SQL API: A schema-less JSON database engine with rich SQL querying capabilities.
  • MongoDB API: A massively scalable MongoDB-as-a-Servicepowered by Azure Cosmos DB platform. Compatible with existing MongoDB libraries, drivers, tools, and applications.
  • Cassandra API: A globally distributed Cassandra-as-a-Service powered by Azure Cosmos DB platform. Compatible with existing Apache Cassandralibraries, drivers, tools, and applications.
  • Gremlin API: A fully managed, horizontally scalable graph database service that makes it easy to build and run applications that work with highly connected datasets supporting Open Gremlin APIs (based on the Apache TinkerPop specification, Apache Gremlin).
  • Table API: A key-value database service built to provide premium capabilities (for example, automatic indexing, guaranteed low latency, global distribution) to existing Azure Table storage applications without making any app changes.

The SQL API can be interacted with using ODBC, REST, or native code bases such as .Net (Core and Standard), Java, Go, Node.js, or Python.

There are many connectivity methods validated with Qlik Partner Engineering:

  • SQL API using ODBC Connector in Qlik Sense
  • MongoDB API using the Qlik Sense MongoDB Connector (Beta currently, Oct 2018)
  • MongoDB SQL API using REST Connector in Qlik Sense
  • Mongo DB API using the gRPC connector for Qlik Core

The focus of this document is the details of connecting to CosmosDB SQL API with Qlik Sense using the REST Connector.

Labels (1)
Version history
Revision #:
2 of 2
Last update:
‎2019-02-22 11:53 AM
Updated by: