Data sources

Querona supports a lot of data sources out-of-the-box. Some of them are vendor-supplied drivers, or licensed from a 3rd parties, or drivers developed for Querona only.

Please note that:

  • Some providers require the installation of additional software.

  • If you do not plan to use a given data provider, you do not have to perform additional configuration actions indicated in the articles. For example, if you do not plan to use SAP Hana, you do not need to install SAP Hana client software.

  • The following data source provider sql dialects are pre-configured and are not user-customizable in GUI:

    • SQL Server,

    • Oracle,

    • MySql.

Below is a list of all data sources supported by Querona, grouped by category. To learn about the specific data provider support or limitations, please click the provider name.

Note

If the required driver does not exist on the list, please search the Internet for ADO.net, JDBC, ODBC or OLE-DB data drivers useful for your purpose or contact Querona support.

Alphabetical list

Data source name (click for documentation)

Category

Bundled?

Technology (Vendor)

ACT! CRM

CRM & Marketing

No

ADO.Net (CData)

Actian Matrix

DBMS & NoSQL & Big Data

No

ODBC

Actian Vector

DBMS & NoSQL & Big Data

No

ODBC

Act-On

CRM & Marketing

No

ADO.Net (CData)

Acumatica ERP

CRM & Marketing

No

ADO.Net (CData)

Adobe Analytics

CRM & Marketing

No

ADO.Net (CData)

Alfresco

Collaboration

No

ADO.Net (CData)

Alibaba Data Lake Analytics

DBMS & NoSQL & Big Data

Yes

MySQL

Alibaba AnalyticDB for MySQL

DBMS & NoSQL & Big Data

Yes

MySQL

Amazon Athena

DBMS & NoSQL & Big Data

No

JDBC

Amazon Aurora

DBMS & NoSQL & Big Data

Yes

MySQL

Amazon Aurora for MySQL

DBMS & NoSQL & Big Data

Yes

MySQL

Amazon DynamoDb

DBMS & NoSQL & Big Data

No

ADO.Net (CData)

Amazon Marketplace

Collaboration

No

ADO.Net (CData)

Amazon Redshift

DBMS & NoSQL & Big Data

Yes

ADO.Net (MySQL); ODBC (Amazon); ADO.Net (CData)

Amazon S3

Miscellaneous

No

ADO.Net (CData)

Apache Cassandra

DBMS & NoSQL & Big Data

No

ODBC; ADO.Net (CData)

Apache Drill

DBMS & NoSQL & Big Data

No

ODBC

Apache HBase

DBMS & NoSQL & Big Data

No

ADO.Net (CData)

Apache Kafka

DBMS & NoSQL & Big Data

Yes

Native (YouNeedIT)

Apache Spark

DBMS & NoSQL & Big Data

Yes

Native (YouNeedIT)

Aster Database

DBMS & NoSQL & Big Data

No

ODBC

Authorize.Net

Financial & E-Commerce

No

ADO.Net (CData)

AWS Data Management

Collaboration

No

ADO.Net (CData)

Basecamp

Collaboration

No

ADO.Net (CData)

Blackbaud FE NXT

Accounting

No

ADO.Net (CData)

BOX

Collaboration

No

ADO.Net (CData)

BugZilla

Collaboration

No

ADO.Net (CData)

ClickHouse

DBMS & NoSQL & Big Data

Yes

ADO.Net (Yandex)

Cloudera

DBMS & NoSQL & Big Data

Yes

Native (YouNeedIT)

Couchbase

DBMS & NoSQL & Big Data

No

ADO.Net (CData)

CSV/TSV, PDF, MSG, Text

Documents & Files

Yes

Native (YouNeedIT); ODBC (Microsoft); ADO.Net (CData)

Databricks

DBMS & NoSQL & Big Data

Yes

Native (YouNeedIT); ODBC (Databricks)

DataStax

DBMS & NoSQL & Big Data

No

ODBC (Datastax)

dBase

DBMS & NoSQL & Big Data

No

ODBC (Microsoft)

Denodo

DBMS & NoSQL & Big Data

No

PostgresSQL (PostgreSQL); ODBC (Denodo)

Datarobot

Miscellaneous

No

ADO.Net (CData)

DigitalOcean

Collaboration

No

ADO.Net (CData)

DropBox

Collaboration

No

ADO.Net (CData)

EBay

Financial & E-commerce

No

ADO.Net (CData)

ElasticSearch

DBMS & NoSQL & Big Data

No

ADO.Net (CData)

Email

Collaboration

No

ADO.Net (CData)

Epicor ERP

ERP

No

ADO.Net (CData)

E*Trade

Financial & E-Commerce

No

ADO.Net (CData)

EverNote

Collaboration

No

ADO.Net (CData)

Exact Online

Accounting

No

ADO.Net (CData)

Exasol

DBMS & NoSQL & Big Data

No

ADO.Net (Exasol); ODBC (Exasol)

Facebook

Social Networking

No

ADO.Net (CData)

FedEx

Financial & E-Commerce

No

ADO.Net (CData)

Firebird

DBMS & NoSQL & Big Data

Yes

ADO.Net (CData)

FreshBooks Accounting

Accounting

No

ADO.Net (CData)

FTP

Collaboration

No

ADO.Net (CData)

ADO.Net

Generic SQL

Yes

Native (YouNeedIT)

GMail

Collaboration

No

ADO.Net (CData)

Google Ad Manager (DoubleClick For Publishers)

CRM & Marketing

No

ADO.Net (CData)

Google Ads (AdWords)

CRM & Marketing

No

ADO.Net (CData)

Google Analytics

CRM & Marketing

No

ADO.Net (CData)

Google BigQuery

DBMS & NoSQL & Big Data

No

ODBC/JDBC (Google), ADO.Net (CData)

Google Calendar

Collaboration

No

ADO.Net (CData)

Google Campaign Manager (DoubleClick CM)

Collaboration

No

ADO.Net (CData)

Google Contacts

Collaboration

No

ADO.Net (CData)

Google Directory

Collaboration

No

ADO.Net (CData)

Google Drive

Data services & Files

No

ADO.Net (CData)

Google Search

Miscellaneous

No

ADO.Net (CData)

Google Sheets

Data services & Files

No

ADO.Net (CData)

Google Spanner

DBMS & NoSQL & Big Data

No

ADO.Net (CData)

HighRise CRM

CRM & Marketing

No

ADO.Net (CData)

Hortonworks Data Platform

DBMS & NoSQL & Big Data

Yes

Thrift (YouNeedIT), Hive

HPCC

DBMS & NoSQL & Big Data

No

ADO.Net (CData)

HubSpot

CRM & Marketing

No

ADO.Net (CData)

IBM Cloudant

DBMS & NoSQL & Big Data

No

ADO.Net (CData)

IBM Cloud SQL Query

DBMS & NoSQL & Big Data

No

ADO.Net (CData)

IBM DB2

DBMS & NoSQL & Big Data

Yes

ADO.Net (IBM)

Instagram

DBMS & NoSQL & Big Data

No

ADO.Net (CData)

JDBC

Generic SQL

Yes

Native (YouNeedIT)

JIRA

Collaboration

No

ADO.Net (CData)

JSON

REST

No

ADO.Net (CData)

Kintone

Collaboration

No

ADO.Net (CData)

LDAP Directory Services

LDAP

No

ADO.Net (CData)

LinkedIn

Social Networking

No

ADO.Net (CData)

Magento

CRM & Marketing

No

ADO.Net (CData)

MailChimp

CRM & Marketing

No

ADO.Net (CData)

MariaDb

DBMS & NoSQL & Big Data

Yes

MySQL (MySQL)

Marketo

CRM & Marketing

No

ADO.Net (CData)

MarkLogic

DBMS & NoSQL & Big Data

No

ADO.Net (CData)

Microsoft Access

DBMS & NoSQL & Big Data

No

ODBC (Microsoft)

Microsoft Active Directory

Miscellaneous

No

ADO.Net (CData)

Microsoft Azure CosmosDb

DBMS & NoSQL & Big Data

No

ADO.Net (CData)

Microsoft Azure Data Management

Collaboration

No

ADO.Net (CData)

Microsoft Azure HDInsight

DBMS & NoSQL & Big Data

Yes

Native (YouNeedIT); Hive (JDBC)

Microsoft Azure Table Storage

DBMS & NoSQL & Big Data

No

ADO.Net (CData)

Azure Synapse Analytics

DBMS & NoSQL & Big Data

Yes

Ms SQL Server

Microsoft Bing Ads

CRM & Marketing

No

ADO.Net (CData)

Microsoft Bing Search

Miscellaneous

No

ADO.Net (CData)

Microsoft Dynamics365 Business Central

Financial & E-Commerce

No

ADO.Net (CData)

Microsoft Dynamics CRM

CRM & Marketing

No

ADO.Net (CData)

Microsoft Dynamics365 Finance and Operations

Collaboration

No

ADO.Net (CData)

Microsoft Dynamics365 Sales

Collaboration

No

ADO.Net (CData)

Microsoft Dynamics CRM

CRM & Marketing

No

ADO.Net (CData)

Microsoft Dynamics GP

Accounting

No

ADO.Net (CData)

Microsoft Dynamics NAV

Financial & E-Commerce

No

ADO.Net (CData)

Microsoft Excel

Documents & Files

Yes

Native (YouNeedIT); ODBC (Microsoft); ADO.Net (CData)

Microsoft Excel Online

Collaboration

No

ADO.Net (CData)

Microsoft Exchange

Collaboration

No

ADO.Net (CData)

Microsoft Office365

Collaboration

No

ADO.Net (CData)

Microsoft Project

Miscellaneous

No

ADO.Net (CData)

Microsoft SharePoint

Collaboration

No

ADO.Net (CData)

Microsoft SharePoint Excel Services

Data services & Files

No

ADO.Net (CData)

Microsoft SQL Analysis Services

DBMS & NoSQL & Big Data

No

ADO.Net (CData)

Microsoft SQL Server

DBMS & NoSQL & Big Data

Yes

ADO.Net (Microsoft)

MongoDb

DBMS & NoSQL & Big Data

No

ADO.Net (CData)

MySql

DBMS & NoSQL & Big Data

Yes

ADO.Net (MySQL)

NetSuite CRM & ERP

ERP & CRM

No

ADO.Net (CData)

OData Services

Data Services & Files

No

ADO.Net (CData)

ODBC

Generic SQL

Yes

Native (YouNeedIT)

Odoo ERP

ERP

No

ADO.Net (CData)

OLE-DB

Generic SQL

Yes

ADO.Net (CData)

OFX

Financial & E-Commerce

No

ADO.Net (CData)

Open Exchange Rates

Financial & E-Commerce

No

ADO.Net (CData)

Oracle

DBMS & NoSQL & Big Data

Yes

ADO.Net (Oracle)

Oracle Marketing Cloud (Eloqua)

CRM & Marketing

No

ADO.Net (CData)

Oracle Sales Cloud

CRM & Marketing

No

ADO.Net (CData)

PayPal

Financial & E-Commerce

No

ADO.Net (CData)

Pervasive SQL (Btrieve)

DBMS & NoSQL & Big Data

No

ADO.Net (CData)

Pivotal GreenPlum

DBMS & NoSQL & Big Data

No

ADO.Net (CData)

PostgreSQL

DBMS & NoSQL & Big Data

Yes

ADO.Net (PostgreSql)

Quandl

Financial & E-Commerce

No

ADO.Net (CData)

QuickBooks Desktop

Accounting

No

ADO.Net (CData)

QuickBooks Online

Accounting

No

ADO.Net (CData)

QuickBooks POS

Accounting

No

ADO.Net (CData)

Reckon

Accounting

No

ADO.Net (CData)

REDIS

DBMS & NoSQL & Big Data

No

ADO.Net (CData)

REST

Data services & Files

No

ADO.Net (CData)

RSS

Data services & Files

No

ADO.Net (CData)

SAGE 50 UK

Accounting

No

ADO.Net (CData)

SAGE Intacct

Accounting

No

ADO.Net (CData)

SalesForce Chatter

Collaboration

No

ADO.Net (CData)

SalesForce Einstein Analytics

Miscellaneous

No

ADO.Net (CData)

SalesForce & Force.com

CRM & Marketing

No

ADO.Net (CData)

Salesforce Marketing Cloud

CRM & Marketing

No

ADO.Net (CData)

SAP Business One

ERP

No

ADO.Net (CData)

SAP Concur

Financial & E-Commerce

No

ADO.Net (CData)

SAP ERP

ERP

No

ADO.Net (CData)

SAP HANA

DBMS & NoSQL & Big Data

Yes

ADO.Net (SAP), requires SAP Client installation

SAP Hybris C4C

Financial & E-Commerce

No

ADO.Net (CData)

SAS

Financial & E-Commerce

No

JDBC (SAS)

SendGrid

CRM & Marketing

No

ADO.Net (CData)

ServiceNow

Collaboration

No

ADO.Net (CData)

SFTP

Data services & Files

No

ADO.Net (CData)

Shopify

Financial & E-Commerce

No

ADO.Net (CData)

Slack

Collaboration

No

ADO.Net (CData)

SmartSheet

Collaboration

No

ADO.Net (CData)

Snowflake

DBMS & NoSQL & Big Data

No

ADO.Net (CData)

Splunk

Collaboration

No

ADO.Net (CData)

Square

Financial & E-Commerce

No

ADO.Net (CData)

Stripe

Financial & E-Commerce

No

ADO.Net (CData)

Sugar CRM

CRM & Marketing

No

ADO.Net (CData)

Suite CRM

CRM & Marketing

No

ADO.Net (CData)

SurveyMonkey

Collaboration

No

ADO.Net (CData)

Sybase

DBMS & NoSQL & Big Data

Yes

ADO.Net

Teradata

DBMS & NoSQL & Big Data

Yes

ADO.Net (Teradata)

Twilio

CRM & Marketing

No

ADO.Net (CData)

Twitter

Social Networking

No

ADO.Net (CData)

UPS

Financial & E-Commerce

No

ADO.Net (CData)

Veeva CRM

CRM & Marketing

No

ADO.Net (CData)

Veeva Vault

Collaboration

No

ADO.Net (CData)

Vertica

DBMS & NoSQL & Big Data

Yes

ADO.Net (Vertica)

Wasabi Object Storage

Miscellaneous

No

ADO.Net (CData)

WordPress

Collaboration

No

ADO.Net (CData)

XBase

DBMS & NoSQL & Big Data

No

ADO.Net (CData)

Xero Accounting

Accounting

No

ADO.Net (CData)

XML

Data services & Files

No

ADO.Net (CData)

YouTube

CRM & Marketing

No

ADO.Net (CData)

YouTube Analytics

CRM & Marketing

No

ADO.Net (CData)

Zendesk

Collaboration

No

ADO.Net (CData)

Zoho CRM

CRM & Marketing

No

ADO.Net (CData)