White Paper - Connecting to CosmosDB SQL API from Qlik Sense using the Qlik REST Connector
COSMOS DB OVERVIEW
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.
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.