Applies to:
Denodo 8.0
,
Denodo 7.0
Last modified on: 03 Aug 2020
Tags:
Azure
Cloud
Cosmos DB
DSN
ODBC data sources
Goal
Azure Cosmos DB is Microsoft’s globally distributed multi-model database service. You can use Azure Cosmos DB to quickly create and query key/value databases, document databases, and graph databases, all of which benefit from the global distribution and horizontal scale capabilities at the core of Azure Cosmos DB.
This document describes how to connect Denodo with an Azure Cosmos DB SQL API account.
Prerequisites
The recommended way to connect Denodo with Azure Cosmos DB SQL API account is using Denodo's ODBC connectivity capabilities
Note: For versions prior to Denodo 8 If there are any issues while using a 64 bit ODBC driver, we recommend to follow the below steps:.
Connectivity
CREATE OR REPLACE DATASOURCE ODBC ds_cosmosdb DSN = 'cosmos' USERNAME = '' USERPASSWORD = '' CLASSPATH = 'jdbc-odbc' DATABASENAME = 'cosmosdb' DATABASEVERSION = '00.00.0000' FETCHSIZE = 1000 VALIDATIONQUERY = '' INITIALSIZE = 4 MAXIDLE = -1 MINIDLE = 0 MAXACTIVE = 0 EXHAUSTEDACTION = 1 TESTONBORROW = true TESTONRETURN = false TESTWHILEIDLE = false TIMEBETWEENEVICTION = -1 NUMTESTPEREVICTION = 3 MINEVICTABLETIME = 1800000 POOLPREPAREDSTATEMENTS = false MAXOPENPREPAREDSTATEMENTS = -1; |
Execute the modified VQL in the VQL shell and refresh the design studio by navigating to File > Refresh.
References