Data sources#
Querona reaches a data source in one of three ways. The Provider type column below tags each source accordingly — a source can offer more than one (Microsoft Excel, for example, is built-in, readable over ODBC, and reachable with a commercial driver) — and you can filter the list by it.
Built-in — ships with Querona; nothing to install (a few sources need a vendor client library). For example SQL Server, Oracle, MySQL, PostgreSQL, REST, JSON and XML.
Standard driver — install a standard ODBC, JDBC, OLEDB or ADO.Net driver — usually free, or supplied by the source vendor.
Commercial driver — install and license a commercial connector (CData, Devart, Progress DataDirect).
Important
Standard and commercial drivers use the same interfaces (ODBC / JDBC / OLEDB / ADO.Net); the difference is that commercial connectors are not bundled with Querona and are licensed separately. Built-in and standard drivers are the out-of-the-box path. For where to find commercial drivers, see ADO.Net and third-party drivers.
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 OLEDB data drivers useful for your purpose or contact Querona support.
Alphabetical list#
Data source name |
Category |
Provider type |
Technology (Vendor) |
|---|---|---|---|
ACT! CRM |
CRM & Marketing |
Commercial driver |
ADO.Net (commercial) |
DBMS & NoSQL & Big Data |
Standard driver |
ODBC |
|
DBMS & NoSQL & Big Data |
Standard driver |
ODBC |
|
Act-On |
CRM & Marketing |
Commercial driver |
ADO.Net (commercial) |
Acumatica ERP |
CRM & Marketing |
Commercial driver |
ADO.Net (commercial) |
Adobe Analytics |
CRM & Marketing |
Commercial driver |
ADO.Net (commercial) |
Alfresco |
Collaboration |
Commercial driver |
ADO.Net (commercial) |
Alibaba Data Lake Analytics |
DBMS & NoSQL & Big Data |
Built-in |
MySQL |
Alibaba AnalyticDB for MySQL |
DBMS & NoSQL & Big Data |
Built-in |
MySQL |
DBMS & NoSQL & Big Data |
Standard driver |
JDBC |
|
DBMS & NoSQL & Big Data |
Built-in |
MySQL |
|
Amazon Aurora for MySQL |
DBMS & NoSQL & Big Data |
Built-in |
MySQL |
Amazon DynamoDb |
DBMS & NoSQL & Big Data |
Commercial driver |
ADO.Net (commercial) |
Amazon Marketplace |
Collaboration |
Commercial driver |
ADO.Net (commercial) |
DBMS & NoSQL & Big Data |
Built-in, Standard driver, Commercial driver |
ADO.Net (MySQL), ODBC (Amazon), ADO.Net (commercial) |
|
Amazon S3 |
Miscellaneous |
Commercial driver |
ADO.Net (commercial) |
DBMS & NoSQL & Big Data |
Standard driver, Commercial driver |
ODBC, ADO.Net (commercial) |
|
DBMS & NoSQL & Big Data |
Standard driver |
ODBC |
|
Apache HBase |
DBMS & NoSQL & Big Data |
Commercial driver |
ADO.Net (commercial) |
DBMS & NoSQL & Big Data |
Standard driver, Commercial driver |
JDBC (Cloudera), ADO.Net (commercial) |
|
DBMS & NoSQL & Big Data |
Built-in |
Native (YouNeedIT) |
|
DBMS & NoSQL & Big Data |
Built-in |
Native (YouNeedIT) |
|
DBMS & NoSQL & Big Data |
Standard driver |
ODBC |
|
Authorize.Net |
Financial & E-Commerce |
Commercial driver |
ADO.Net (commercial) |
AWS Data Management |
Collaboration |
Commercial driver |
ADO.Net (commercial) |
Basecamp |
Collaboration |
Commercial driver |
ADO.Net (commercial) |
Blackbaud FE NXT |
Accounting |
Commercial driver |
ADO.Net (commercial) |
BOX |
Collaboration |
Commercial driver |
ADO.Net (commercial) |
BugZilla |
Collaboration |
Commercial driver |
ADO.Net (commercial) |
DBMS & NoSQL & Big Data |
Built-in |
ADO.Net (Yandex) |
|
DBMS & NoSQL & Big Data |
Built-in |
Native (YouNeedIT) |
|
Couchbase |
DBMS & NoSQL & Big Data |
Commercial driver |
ADO.Net (commercial) |
Documents & Files |
Built-in, Standard driver, Commercial driver |
Native (YouNeedIT), ODBC (Microsoft), ADO.Net (commercial) |
|
Databricks |
DBMS & NoSQL & Big Data |
Built-in, Standard driver |
Native (YouNeedIT), ODBC (Databricks) |
DBMS & NoSQL & Big Data |
Standard driver |
ODBC (Datastax) |
|
DBMS & NoSQL & Big Data |
Standard driver |
ODBC (Microsoft) |
|
DBMS & NoSQL & Big Data |
Standard driver |
PostgresSQL (PostgreSQL), ODBC (Denodo) |
|
Datarobot |
Miscellaneous |
Commercial driver |
ADO.Net (commercial) |
DigitalOcean |
Collaboration |
Commercial driver |
ADO.Net (commercial) |
DropBox |
Collaboration |
Commercial driver |
ADO.Net (commercial) |
EBay |
Financial & E-commerce |
Commercial driver |
ADO.Net (commercial) |
ElasticSearch |
DBMS & NoSQL & Big Data |
Commercial driver |
ADO.Net (commercial) |
Collaboration |
Commercial driver |
ADO.Net (commercial) |
|
Epicor ERP |
ERP |
Commercial driver |
ADO.Net (commercial) |
E*Trade |
Financial & E-Commerce |
Commercial driver |
ADO.Net (commercial) |
EverNote |
Collaboration |
Commercial driver |
ADO.Net (commercial) |
Exact Online |
Accounting |
Commercial driver |
ADO.Net (commercial) |
DBMS & NoSQL & Big Data |
Standard driver |
ADO.Net (Exasol), ODBC (Exasol) |
|
Social Networking |
Commercial driver |
ADO.Net (commercial) |
|
FedEx |
Financial & E-Commerce |
Commercial driver |
ADO.Net (commercial) |
DBMS & NoSQL & Big Data |
Standard driver |
ADO.Net (Firebird) |
|
FreshBooks Accounting |
Accounting |
Commercial driver |
ADO.Net (commercial) |
FTP |
Collaboration |
Commercial driver |
ADO.Net (commercial) |
Generic SQL |
Built-in |
Native (YouNeedIT) |
|
GMail |
Collaboration |
Commercial driver |
ADO.Net (commercial) |
Google Ad Manager (DoubleClick For Publishers) |
CRM & Marketing |
Commercial driver |
ADO.Net (commercial) |
Google Ads (AdWords) |
CRM & Marketing |
Commercial driver |
ADO.Net (commercial) |
Google Analytics |
CRM & Marketing |
Commercial driver |
ADO.Net (commercial) |
DBMS & NoSQL & Big Data |
Standard driver, Commercial driver |
ODBC/JDBC (Google), ADO.Net (commercial) |
|
Google Calendar |
Collaboration |
Commercial driver |
ADO.Net (commercial) |
Google Campaign Manager (DoubleClick CM) |
Collaboration |
Commercial driver |
ADO.Net (commercial) |
Google Contacts |
Collaboration |
Commercial driver |
ADO.Net (commercial) |
Google Directory |
Collaboration |
Commercial driver |
ADO.Net (commercial) |
Google Drive |
Data services & Files |
Commercial driver |
ADO.Net (commercial) |
Google Search |
Miscellaneous |
Commercial driver |
ADO.Net (commercial) |
Google Sheets |
Data services & Files |
Commercial driver |
ADO.Net (commercial) |
Google Spanner |
DBMS & NoSQL & Big Data |
Commercial driver |
ADO.Net (commercial) |
DBMS & NoSQL & Big Data |
Built-in |
MySQL |
|
HighRise CRM |
CRM & Marketing |
Commercial driver |
ADO.Net (commercial) |
DBMS & NoSQL & Big Data |
Built-in |
Thrift (YouNeedIT), Hive |
|
HPCC |
DBMS & NoSQL & Big Data |
Commercial driver |
ADO.Net (commercial) |
HubSpot |
CRM & Marketing |
Commercial driver |
ADO.Net (commercial) |
IBM Cloudant |
DBMS & NoSQL & Big Data |
Commercial driver |
ADO.Net (commercial) |
IBM Cloud SQL Query |
DBMS & NoSQL & Big Data |
Commercial driver |
ADO.Net (commercial) |
DBMS & NoSQL & Big Data |
Built-in |
ADO.Net (IBM) |
|
DBMS & NoSQL & Big Data |
Commercial driver |
ADO.Net (commercial) |
|
Generic SQL |
Built-in |
Native (YouNeedIT) |
|
Collaboration |
Built-in, Commercial driver |
Native (YouNeedIT), ADO.Net (commercial) |
|
Data services & Files |
Built-in |
Native (YouNeedIT) |
|
Kintone |
Collaboration |
Commercial driver |
ADO.Net (commercial) |
LDAP Directory Services |
LDAP |
Commercial driver |
ADO.Net (commercial) |
Social Networking |
Commercial driver |
ADO.Net (commercial) |
|
Magento |
CRM & Marketing |
Commercial driver |
ADO.Net (commercial) |
MailChimp |
CRM & Marketing |
Commercial driver |
ADO.Net (commercial) |
DBMS & NoSQL & Big Data |
Built-in |
MySQL (MySQL) |
|
Marketo |
CRM & Marketing |
Commercial driver |
ADO.Net (commercial) |
MarkLogic |
DBMS & NoSQL & Big Data |
Commercial driver |
ADO.Net (commercial) |
DBMS & NoSQL & Big Data |
Standard driver |
ODBC (Microsoft) |
|
Microsoft Active Directory |
Miscellaneous |
Commercial driver |
ADO.Net (commercial) |
Microsoft Azure CosmosDb |
DBMS & NoSQL & Big Data |
Commercial driver |
ADO.Net (commercial) |
Collaboration |
Built-in, Commercial driver |
Native (YouNeedIT), ADO.Net (commercial) |
|
Microsoft Azure Data Management |
Collaboration |
Commercial driver |
ADO.Net (commercial) |
DBMS & NoSQL & Big Data |
Built-in, Standard driver |
Native (YouNeedIT), Hive (JDBC) |
|
DBMS & NoSQL & Big Data |
Built-in |
MySQL |
|
Microsoft Azure Table Storage |
DBMS & NoSQL & Big Data |
Commercial driver |
ADO.Net (commercial) |
Azure Synapse Analytics |
DBMS & NoSQL & Big Data |
Built-in |
Ms SQL Server |
Microsoft Bing Ads |
CRM & Marketing |
Commercial driver |
ADO.Net (commercial) |
Microsoft Bing Search |
Miscellaneous |
Commercial driver |
ADO.Net (commercial) |
Microsoft Dynamics365 Business Central |
Financial & E-Commerce |
Commercial driver |
ADO.Net (commercial) |
Microsoft Dynamics CRM |
CRM & Marketing |
Commercial driver |
ADO.Net (commercial) |
Microsoft Dynamics365 Finance and Operations |
Collaboration |
Commercial driver |
ADO.Net (commercial) |
Microsoft Dynamics365 Sales |
Collaboration |
Commercial driver |
ADO.Net (commercial) |
Microsoft Dynamics CRM |
CRM & Marketing |
Commercial driver |
ADO.Net (commercial) |
Microsoft Dynamics GP |
Accounting |
Commercial driver |
ADO.Net (commercial) |
Microsoft Dynamics NAV |
Financial & E-Commerce |
Commercial driver |
ADO.Net (commercial) |
Documents & Files |
Built-in, Standard driver, Commercial driver |
Native (YouNeedIT), ODBC (Microsoft), ADO.Net (commercial) |
|
Microsoft Excel Online |
Collaboration |
Commercial driver |
ADO.Net (commercial) |
Microsoft Exchange |
Collaboration |
Commercial driver |
ADO.Net (commercial) |
Microsoft Office365 |
Collaboration |
Commercial driver |
ADO.Net (commercial) |
Microsoft Project |
Miscellaneous |
Commercial driver |
ADO.Net (commercial) |
Microsoft SharePoint |
Collaboration |
Commercial driver |
ADO.Net (commercial) |
Microsoft SharePoint Excel Services |
Data services & Files |
Commercial driver |
ADO.Net (commercial) |
Microsoft SQL Analysis Services |
DBMS & NoSQL & Big Data |
Commercial driver |
ADO.Net (commercial) |
DBMS & NoSQL & Big Data |
Built-in |
ADO.Net (Microsoft) |
|
MongoDb |
DBMS & NoSQL & Big Data |
Commercial driver |
ADO.Net (commercial) |
DBMS & NoSQL & Big Data |
Built-in |
ADO.Net (MySQL) |
|
NetSuite CRM & ERP |
ERP & CRM |
Commercial driver |
ADO.Net (commercial) |
OData Services |
Data Services & Files |
Commercial driver |
ADO.Net (commercial) |
Generic SQL |
Built-in |
Native (YouNeedIT) |
|
Odoo ERP |
ERP |
Commercial driver |
ADO.Net (commercial) |
Generic SQL |
Built-in, Commercial driver |
ADO.Net (commercial) |
|
OFX |
Financial & E-Commerce |
Commercial driver |
ADO.Net (commercial) |
Open Exchange Rates |
Financial & E-Commerce |
Commercial driver |
ADO.Net (commercial) |
DBMS & NoSQL & Big Data |
Built-in |
ADO.Net (Oracle) |
|
Oracle Marketing Cloud (Eloqua) |
CRM & Marketing |
Commercial driver |
ADO.Net (commercial) |
Oracle Sales Cloud |
CRM & Marketing |
Commercial driver |
ADO.Net (commercial) |
PayPal |
Financial & E-Commerce |
Commercial driver |
ADO.Net (commercial) |
DBMS & NoSQL & Big Data |
Built-in |
ADO.Net (MySQL) |
|
Pervasive SQL (Btrieve) |
DBMS & NoSQL & Big Data |
Commercial driver |
ADO.Net (commercial) |
Pivotal GreenPlum |
DBMS & NoSQL & Big Data |
Commercial driver |
ADO.Net (commercial) |
DBMS & NoSQL & Big Data |
Built-in |
ADO.Net (PostgreSql) |
|
Quandl |
Financial & E-Commerce |
Commercial driver |
ADO.Net (commercial) |
QuickBooks Desktop |
Accounting |
Commercial driver |
ADO.Net (commercial) |
QuickBooks Online |
Accounting |
Commercial driver |
ADO.Net (commercial) |
QuickBooks POS |
Accounting |
Commercial driver |
ADO.Net (commercial) |
Reckon |
Accounting |
Commercial driver |
ADO.Net (commercial) |
REDIS |
DBMS & NoSQL & Big Data |
Commercial driver |
ADO.Net (commercial) |
Data services & Files |
Built-in |
Native (YouNeedIT) |
|
RSS |
Data services & Files |
Commercial driver |
ADO.Net (commercial) |
SAGE 50 UK |
Accounting |
Commercial driver |
ADO.Net (commercial) |
SAGE Intacct |
Accounting |
Commercial driver |
ADO.Net (commercial) |
SalesForce Chatter |
Collaboration |
Commercial driver |
ADO.Net (commercial) |
SalesForce Einstein Analytics |
Miscellaneous |
Commercial driver |
ADO.Net (commercial) |
SalesForce & Force.com |
CRM & Marketing |
Commercial driver |
ADO.Net (commercial) |
Salesforce Marketing Cloud |
CRM & Marketing |
Commercial driver |
ADO.Net (commercial) |
SAP Business One |
ERP |
Commercial driver |
ADO.Net (commercial) |
SAP Concur |
Financial & E-Commerce |
Commercial driver |
ADO.Net (commercial) |
ERP |
Commercial driver |
ADO.Net (commercial) |
|
DBMS & NoSQL & Big Data |
Built-in |
ADO.Net (SAP) - requires SAP Client installation |
|
SAP Hybris C4C |
Financial & E-Commerce |
Commercial driver |
ADO.Net (commercial) |
Financial & E-Commerce |
Standard driver |
JDBC (SAS) |
|
SendGrid |
CRM & Marketing |
Commercial driver |
ADO.Net (commercial) |
ServiceNow |
Collaboration |
Commercial driver |
ADO.Net (commercial) |
SFTP |
Data services & Files |
Commercial driver |
ADO.Net (commercial) |
Shopify |
Financial & E-Commerce |
Commercial driver |
ADO.Net (commercial) |
Slack |
Collaboration |
Commercial driver |
ADO.Net (commercial) |
SmartSheet |
Collaboration |
Commercial driver |
ADO.Net (commercial) |
Snowflake |
DBMS & NoSQL & Big Data |
Commercial driver |
ADO.Net (commercial) |
Splunk |
Collaboration |
Commercial driver |
ADO.Net (commercial) |
Square |
Financial & E-Commerce |
Commercial driver |
ADO.Net (commercial) |
Stripe |
Financial & E-Commerce |
Commercial driver |
ADO.Net (commercial) |
Sugar CRM |
CRM & Marketing |
Commercial driver |
ADO.Net (commercial) |
Suite CRM |
CRM & Marketing |
Commercial driver |
ADO.Net (commercial) |
SurveyMonkey |
Collaboration |
Commercial driver |
ADO.Net (commercial) |
DBMS & NoSQL & Big Data |
Built-in |
ADO.Net |
|
DBMS & NoSQL & Big Data |
Built-in |
ADO.Net (Teradata) |
|
Twilio |
CRM & Marketing |
Commercial driver |
ADO.Net (commercial) |
Social Networking |
Commercial driver |
ADO.Net (commercial) |
|
UPS |
Financial & E-Commerce |
Commercial driver |
ADO.Net (commercial) |
Veeva CRM |
CRM & Marketing |
Commercial driver |
ADO.Net (commercial) |
Veeva Vault |
Collaboration |
Commercial driver |
ADO.Net (commercial) |
DBMS & NoSQL & Big Data |
Built-in |
ADO.Net (Vertica) |
|
Wasabi Object Storage |
Miscellaneous |
Commercial driver |
ADO.Net (commercial) |
WordPress |
Collaboration |
Commercial driver |
ADO.Net (commercial) |
XBase |
DBMS & NoSQL & Big Data |
Commercial driver |
ADO.Net (commercial) |
Xero Accounting |
Accounting |
Commercial driver |
ADO.Net (commercial) |
Data services & Files |
Built-in |
Native (YouNeedIT) |
|
YouTube |
CRM & Marketing |
Commercial driver |
ADO.Net (commercial) |
YouTube Analytics |
CRM & Marketing |
Commercial driver |
ADO.Net (commercial) |
Zendesk |
Collaboration |
Commercial driver |
ADO.Net (commercial) |
Zoho CRM |
CRM & Marketing |
Commercial driver |
ADO.Net (commercial) |