Qlik Community

Technology Partners Ecosystem Documentation

Qlik Technology Partners Ecosystem

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

Employee
Employee

White Paper - Connecting to CosmosDB SQL API from Qlik Sense using the CosmosDB ODBC 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.

COSMOS DB KEY CAPABILITIES

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 using the SQL API via the ODBC Connector.

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