Gain insight into your Azure Cosmos DB data with QlikView and Qlik Sense

Connecting data from various sources in a unified view can produce valuable insights that are otherwise invisible to the human eye and brain. As Azure Cosmos DB allows for collecting the data from various sources in various formats, the ability to mix and match this data becomes even more important for empowering your businesses with additional knowledge and intelligence.

This is what Qlik’s analytics and visualization products, QlikView and Qlik Sense, have been able to do for years and now they support Azure Cosmos DB as a first-class data source. The following table summarizes the variety of connectivity options you have for to getting Azure Cosmos DB data in QlikView and Qlik Sense.

Azure Cosmos DB API

Connectivity Method

Qlik detailed instruction

Qlik live demo

Core (SQL) API

REST

Connecting to Azure CosmosDB SQL API from Qlik Sense using the built-in REST Connector

Core (SQL) API

ODBC driver

Connecting to Azure Cosmos DB SQL API from Qlik Sense using the Azure Cosmos DB ODBC Connector

Azure Cosmos DB ODBC – Video Game Sales

MongoDB API

MongoDB Wire Protocol

Connecting to Azure Cosmos DB Mongo API from Qlik Sense using the Qlik MongoDB Connector

Azure Cosmos DB via Mongo DB API using Qlik Connector

MongoDB API

Qlik gRPC connector

Same as MongoDB Wire Protocol

Qlik Sense and QlikView are data visualization tools that combine the data from different sources into a single view. Qlik Sense indexes every possible relationship between entities in the data so that you can gain immediate insights into it without making the connections manually. You can visualize Azure Cosmos DB data by using Qlik Sense.

Here is a step-by-step guide on how to set up a Azure Cosmos DB account and configure the ODBC connection to it in Qlik Sense.

1. Create a Core (SQL) API account in Azure Cosmos DB.

2. Create a database with a collection in it. Keep in mind that Azure Cosmos DB allows you to provision throughput for your databases and collections as described as Request units in Azure Cosmos DB article.

3. Import the data. There are many ways to load data into Azure Cosmos DB collection, the simplest way is to use a tool called Azure Cosmos DB Data Migration tool. You can find a connection string on the keys page in the portal.

4. Next in Qlik Sense, you need to install an ODBC driver for Azure Cosmos DB and configure it following the instructions providing in our documentation, “Connect to Azure Cosmos DB using BI analytics tools with the ODBC driver.”

5. Open your app in Qlik Sense and click Add data from files and other sources. Select ODBC and configure an ODBC connection you created in previous step.

6. Next, choose the database and the collection with the imported data.

7. Add data to your app and configure your data insight visualizations. The following picture shows an example of the resulting view.

To learn more about Qlik tools and how to use them with Azure Cosmos DB please see the following resources.

Connect Qlik Sense to Azure Cosmos DB using our documentation, “Connect Qlik Sense to Azure Cosmos DB and visualize your data” to help guide you.

Please note, the above instructions and screenshots apply to Qlik Sense, but QlikView can also be connected to Azure Cosmos DB in a similar way. For more information visit the product pages for Qlik Sense, QlikView and Qlik Desktop.
Quelle: Azure

Cognitive Services Speech SDK 1.2 – December update – Python, Node.js/NPM and other improvements

Developers can now access the latest improvements to Cognitive Services Speech Service including a new Python API and more. Details below.

Read the updated Speech Services documentation to get started today.

What’s new

Python API for Speech Service

Python 3.5 and later versions on the Windows and Linux operating systems are supported.
Python is the first language that the Speech Service supports on macOS X (version 10.12 and later).
Python modules can be conveniently installed from PyPI.

Node.js support

Support for Node.js is now available, in addition to support for JavaScript in the browser. Through the npm package manager, developers can install the Speech Service module and its prerequisites.

The JavaScript version of Speech Service is now also available as an opensource project on GitHub.

Linux support

Support for Ubuntu 18.04 is now available in addition to pre-existing support for Ubuntu 16.04.

New features by popular demand

Lightweight SDK for greater performance

By reducing the number of required concurrent threads, mutexes, and locks, Speech Services now offers a more lightweight SDK with enhanced error reporting.

Control of server connectivity and connection status

A newly added connection object enables control over when the SDK connects to the Speech Service. You can also now subscribe to receive connection notifications that report the exact time of server connection and termination.

Unlimited audio session length support

For JavaScript, length restrictions for recorded audio sessions have been lifted. The SDK buffers the audio file and then automatically reconnects and retransmits audio data to the service.

Support for ProGuard during Android APK generation is also now available.

For more details and examples for how your business can benefit from the new functionality for Speech Services, check out release notes and samples in the GitHub sample repository for Speech Services.
Quelle: Azure