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	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	Native (YouNeedIT), 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 DevOps	Collaboration	No	Native (YouNeedIT), 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)
Percona Server	DBMS & NoSQL & Big Data	Yes	MySQL (MySQL)
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	Native (YouNeedIT), 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)

See also

• Create a connection