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? Available 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)
Amazon Athena DBMS & NoSQL & Big Data No JDBC
Amazon Aurora DBMS & NoSQL & Big Data Yes MySQL
Amazon DynamoDb DBMS & NoSQL & Big Data No 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 Yes 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 JDBC (Yandex)
Cloudera DBMS & NoSQL & Big Data Yes Native (YouNeedIT); Hive (JDBC)
Couchbase DBMS & NoSQL & Big Data No ADO.Net (CData)
CSV/TSV Documents & Files No ODBC (Microsoft); ADO.Net (CData)
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 Hive, Thrift (YouNeedIT)
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)
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 No 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 (NetWeaver) ERP No ADO.Net (CData)
SAP HANA DBMS & NoSQL & Big Data Yes ADO.Net (SAP)
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 files 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)