...
If your source is not listed below, please contact us to discuss other ways to extract your data, such as custom coding, API, JDBC, ADO.NET , OLE DB, export to CSV, etc.
ActiveCampaign: ODBC.
Actian Vectorwise: Tableau.
Acumatica CRM: Native optimized connection.
Acumatica ERP: Native optimized connection.
Acumatica MRP: Native optimized connection.
Acumatica Cloud OData v3: Native optimized connection.
Acumatica Cloud OData v4: Native optimized connection.
Acumatica MS SQL Server: Native optimized connection.
Acumatica MySQL: Native optimized connection.
Acterys: Power BI.
Actian Vectorwise: Tableau.
ActiveCampaign: ODBC.
Adobe Analytics: ODBC.
Adobe Commerce: ODBC.
ADP: ODBC.
AfterShip: ODBC.
Ahrefs: ODBC.
Airtable: ODBC.
Alibaba AnalyticsDB: Tableau.
Alibaba Data Lake Analytics: Tableau.
Alibaba MaxCompute: Tableau.
AlloyDB: ODBC.
Amazon Athena: ODBC.
Amazon Aurora: ODBC.
Amazon DynamoDB: ODBC.
Amazon EMR Hive: ODBC.
Amazon Marketplace: ODBC.
Amazon Redshift: ODBC.
Amazon S3: ODBC.
Anaplan: Power BI, Tableau.
Apache Cassandra: ODBC.
Apache Drill: Tableau.
Apache Hive: ODBC.
Apache Impala: ODBC.
Apache Spark SQL: ODBC.
Asana: ODBC.
ASE: ODBC.
Assemble Views: Power BI.
AtScale Cubes: Power BI.
AtScale Models: Power BI.
Authorize.Net: ODBC.
Autodesk Construction: Power BI.
Automation Anywhere: Power BI.
Avalara AvaTax: ODBC.
Avro: ODBC.
Basecamp: ODBC.
BigCommerce: ODBC.
Bing Ads: ODBC.
Bing Search: ODBC.
BitSight Security Ratings: Power BI.
Blackbaud FE NXT: ODBC.
Bloomberg Data and Analytics: Power BI.
BQE Core: Power BI.
Box: ODBC.
Bugzilla: ODBC.
Bullhorn CRM: ODBC.
Cassandra: ODBC.
Celonis EMS: Power BI.
Certinia: ODBC.
Cin7 Core: ODBC.
ClickUp: ODBC.
Cloudant: ODBC.
Cognite Data Fusion: Power BI.
Cloudera CDH Hive: ODBC.
Cloudera Hadoop: Tableau.
CockroachDB: ODBC.
Common Data Service: Power BI.
Confluence: ODBC.
Cosmos DB: ODBC.
Couchbase: ODBC.
CouchDB: ODBC.
CSV (text file): Native optimized connection.
CYMA: ODBC.
Data Virtuality LDW: Power BI.
Databricks: ODBC.
Dataflows: Power BI.
DataStax: ODBC.
DB2: ODBC.
dBase: ODBC.
Datorama: Tableau.
Dear Inventory: ODBC.
Delighted: ODBC.
Denodo: Power BI, Tableau.
Device42: ODBC.
Digital Construction Works Insights: Power BI.
DocuSign: ODBC.
Emigo Data Source: Power BI.
EQulS: Power BI.
Dremio: Tableau.
Dropbox: ODBC.
eBay: ODBC.
Ebay Analytics: ODBC.
Elasticsearch: ODBC.
Email: ODBC.
Email Octopus: ODBC.
EnterpriseDB: ODBC.
Epicor: ODBC.
Epicor Kinetic: ODBC.
Esri Connector: Tableau.
eWay CRM: Power BI.
Exact Online: ODBC.
Exasol: Tableau.
xxxFacebook: TableauODBC.
Facebook Ads: ODBC. Facebook Ads: ODBC
FactSet Analytics: Power BI.
FedEx: ODBC.
FHIR: ODBC.
FinancialForce: ODBC.
Firebird: ODBC.
Freshbooks: ODBC.
FreshdeskAds: ODBC.
Freshsales: ODBC.
Freshworks CRM: ODBC.
Freshservice: ODBC.
FTP: ODBC.
Funnel: Power BI.
GitHub: ODBC.
Gmail: ODBC.
Global Shop Solutions (GSS): Optimized ODBC connection for Pervasive database.
Google Ad Manager: ODBC.
Google Ads: ODBC.
Google AdSense: ODBC.
Google Analytics: ODBC and Python.
Google Analytics 4: ODBC.
Google BigQuery: ODBC.
Google Calendar: ODBC.
Google Campaign Manager: ODBC.
Google Cloud SQL: Tableau.
Google Cloud Storage: ODBC.
Google Contacts: ODBC.
Google Data Catalog: ODBC.
Google Directory: ODBC.
Google Drive: ODBC.
Google Search: ODBC.
Google Sheets: Native optimized connection.
Google Spanner: ODBC.
GraphQL: ODBC.
Greenplum: ODBC.
Greentree: ODBC.
Hadoop Files (HDFS): Power BI.
HarperDB: ODBC.
HBase: ODBC.
HCL Domino: ODBC.
HDFS: ODBC.
Heroky Postgres: ODBC.
Hexagon PPM Smart API: Power BI.
Highrise: ODBC.
Hive: ODBC.
Hortonworks Hadoop Hive: ODBC.
HubSpot: ODBC.
IBM BigInsights: ODBC.
IBM Cloud Data Engine: ODBC.
IBM Cloud Object Storage: ODBC.
IBM Db2: ODBC.
IBM Db2 Warehouse on Cloud: ODBC.
IBM Informix: ODBC.
IBM PDA: Tableau.
Impala: ODBC. Impala
Indexima: ODBCPower BI.
Infor CRM: Native optimized connection to MS SQL Server.
Infor ERP: ODBC.
Instagram: ODBC.
Interbase: ODBC.
JAMIS Prime OData v3: Native optimized connection.
JAMIS Prime OData v4: Native optimized connection.
Jira: ODBC.
Jira Service Desk: ODBC.
Jira Service Management: ODBC.
JSON: ODBC.
Kintone: ODBC.
Klaviyo: ODBC.
Kognitwin: Power BI.
Kognitio: Tableau.
KQL Database: Power BI.
Kyligence: Power BI.
Kyvos: Tableau.
LDAP: ODBC.
LinkedIn: ODBC.
LinkedIn Ads: ODBC.
LinkedIn Sales Navigator: Tableau.
Macola: Native optimized connection to MS SQL Server.
Mangento: ODBC.
MailChimp: ODBC.
Mailjet: ODBC.
MapR Hive: ODBC.
MariaDB: ODBC.
Marketo: ODBC.
MarkLogic: ODBC.
Microsoft Access: Native optimized connection.
Microsoft Active Directory: ODBC.
Microsoft Azure Entra: ODBC.
Microsoft Azure Analysis Services: ODBC.
Microsoft Azure Billing: ODBC.
Microsoft Azure Blob Storage: Power BI.
Microsoft Azure Compute: ODBC.
Microsoft Azure Data Catalog: ODBCCosmos DB: Power BI.
Microsoft Azure Cost Management: Power BI.
Microsoft Azure Data Catalog: ODBC.
Microsoft Azure Data Explorer: Power BI.
Microsoft Azure Data Lake Storage: ODBC.
Microsoft Azure Databricks: Power BI.
Microsoft Azure Data Lake StorageDevOps: ODBC.
Microsoft Azure DevOpsHDInsight Spark: ODBCPower BI.
Microsoft Azure Reserved Virtual Machine: ODBC.
Microsoft Azure Resource Health: ODBC.
Microsoft Azure SQL: Native optimized connection.
Microsoft Azure Synapse: ODBC.
Microsoft Azure Synapse Analytics: ODBC.
Microsoft Azure Table: ODBC.
Microsoft Azure xxx: Power BI.
Microsoft Dataverse: ODBC.
Microsoft Dynamics 365 Business Central (BC, NAV): Native optimized connection to MS SQL Server.
Microsoft Dynamics 365 F&O: Native optimized connection to MS SQL Server.
Microsoft Dynamics 365 CRM: Native optimized connection to MS SQL Server.
Microsoft Dynamics 365 GP (Great Plains): Native optimized connection to MS SQL Server.
Microsoft Dynamics 365 NV (Navision): ODBC.
Microsoft Dynamics 365 SL: Native optimized connection to MS SQL Server.
Microsoft Excel: Native optimized connection.
Microsoft Excel Online: ODBC.
Microsoft Exchange: ODBC.
Microsoft Fabric: Contact us.
Microsoft Fabric Data Warehouse: Contact us.
Microsoft Fabric Lakehouse: Contact us.
Microsoft FoxPro: ODBC.
Microsoft Office 365: ODBC.
Microsoft OneDrive: ODBC.
Microsoft OneNote: ODBC.
Microsoft Planner: ODBC.
Microsoft Power BI XMLA: ODBC.
Microsoft Project: ODBC.
Microsoft SharePoint: ODBC.
Microsoft SharePoint Excel Services: ODBC.
Microsoft SQL Analysis Services: ODBC.
Microsoft SQL Server: Native optimized connection.
Microsoft Teams: ODBC.
Microstrategy for Power BI: Power BI.
Monday.com: ODBC.
MonetDB: Tableau.
MongoDB: ODBC.
MYOB Accounting Right: ODBC.
MySQL: Native optimized connection.
nCino: ODBC.
Neo4J: ODBC.
NetSuite: Requires Suite Analytics enabled. See ODBC.
NexusDB: ODBC.
OData: Native connection.
ODBC: Select the proper ODBC driver and follow the instructions.
Odoo: ODBC.
Oracle: Native optimized connection.
Oracle Autonomous Data Warehouse: ODBC.
Oracle CX Service: ODBC.
Oracle Eloqua: ODBC.
Oracle Essbase: Tableau.
Oracle Financials Cloud: ODBC.
Oracle HCM Cloud: ODBC.
Oracle Sales: ODBC.
Oracle SCM: ODBC.
Oracle Services Cloud: ODBC.
Outreach.io: ODBC.
Palantir Foundry: Power BI.
Parquet: ODBC.
Paxata: Power BI.
Paychex: CSV / Excel.
Paylocity: ODBC.
Paypal: ODBC.
Pervasive SQL: ODBC.
Phoenix: ODBC.
Pinterest: ODBC.
Pipedrive: ODBC.
Pivotal HD: ODBC.
Pivotal HDB: ODBCHDB: ODBC.
Planview Enterprise Architecture: Power BI.
Planview IdeaPlace: Power BI.
Planview Portfolios: Power BI.
Planview ProjectPlace: Power BI.
Podio: ODBC.
PostgreSQL: Native optimized connection.
Presto: ODBC.
Procore: Native optimized connection to MS SQL Server.
Profisee: Power BI.
Progress OpenEdge: ODBC.
Providex: Optimized ODBC connection
QMetry: ODBC.
Qubole Presto: Tableau.
QuestDB: ODBC.
Quora Ads: ODBC.
Quickbase: ODBC.
Quickbooks: ODBC.
QuickBooks Desktop: ODBC.
Quickbooks Enterprise: ODBC.
Quickbooks Online: ODBC.
Quickbooks Payments: ODBC.
Quickbooks POS: ODBC.
R Script: Power BI, Tableau.
Raisers Edge NXT: ODBC.
Reckon: ODBC.
Reckon Accounts Hosted: ODBC.
Redis: ODBC.
REST: ODBC.
RSS: ODBC.
Sage 100: ODBC.
Sage 100 MS SQL Server: Native optimized connection to MS SQL Server.
Sage 100 Providex: Optimized ODBC connection.
Sage 200: ODBC.
Sage 300: ODBC.
Sage 300 MS SQL: Native optimized connection to MS SQL Server.
Sage 300 Pervasive: Optimized ODBC connection.
Sage 50: Optimized ODBC connection.
Sage 500: Native optimized connection to MS SQL Server.
Sage Business Cloud Accounting: ODBC.
Sage Cloud Accounting: ODBC.
Sage CRE: ODBC.
Sage CRM: Native optimized connection to MS SQL Server.
Sage Intacct: ODBC.
Sage Pro: ODBC.
Sage Timberline: ODBC.
Sage X3: Native optimized connection to MS SQL Server.
Salesforce.com CRM: ODBC.
Salesforce Chatter: ODBC.
Salesforce Data Cloud: Tableau.
Salesforce Einstein: ODBC.
Salesforce Marketing: ODBC.
Salesforce Marketing Cloud Acct Eng: ODBC.
Salesforce MC: ODBC.
Salesforce Objects: Power BI.
Salesforce Pardot: ODBC.
Salesloft: ODBC.
SAP: ODBC.
SAP Ariba Procurement: ODBC.
SAP Ariba Source: ODBC.
SAP Business One: ODBC.
SAP Business Objects BI: ODBC.
SAP Business Warehouse Application Server: Power BI.
SAP Business Warehouse Message Server: Power BI.
SAP ByDesign: ODBC.
SAP BW/4HANA: ODBC.
SAP Concur: ODBC.
SAP Fieldglass: ODBC.
SAP HANA: ODBC.
SAP HANA XS Advanced: ODBC.
SAP Hybrids C4C: ODBC.
SAP Netweaver Gateway: ODBC.
SAP S/4HANA Cloud: ODBC.
SAP Success Factors: ODBC.
SAP Sybase ASE: ODBC.
SAP Sybase IQ: ODBC.
SAS Data Sets: ODBC.
SAS xpt: ODBC.
SellerCloud Ecommerce: Python.
Semrush: ODBC.
Sendgrid: ODBC.
SendGrid: ODBC.
Sendinblue: ODBC.
SequeLink: ODBC.
ServiceNow: ODBC.
ServiceNow ITSM: Tableau.
SFTP: ODBC.
Shippo: ODBC.
ShipStation: ODBC.
Shopify: ODBC and Python.
SingleStore: ODBC.
Siteimprove: Power BI.
Slack: ODBC.
SmartSheet: ODBC.
Snapchat Ads: ODBC.
Snowflake: ODBC.
SolarWinds Service Desk: Power BI.
Spark: ODBC.
Spatial File: Tableau.
Splunk: ODBC.
SQLite: ODBC.
Square: ODBC.
Starburst: ODBC.
Statistical File: Tableau.
Streak: ODBC.
Stripe: ODBC.
Sugar CRM: ODBC.
SumTotal: Power BI.
SuiteCRM: ODBC.
SurveyMonkey: ODBC.
Sybase: ODBC.
Sybase IQ: ODBC.
Tableau CRM Analytics: ODBC.
Tableau Data Source: Python.
Tableau Server: Python.
Tableau Cloud: Tableau.
Tally: ODBC.
TaxJar: ODBC.
TeamCity: ODBC.
TeamWork: ODBC.
Teradata: ODBC.
Teradata OLAP: Tableau.
Text Files (CSV): Native optimized connection.
TIBCO Data Virtualization: Power BI, Tableau.
Tier1: ODBC.
TigerGraph: ODBC.
Treez: ODBC.
Trello: ODBC.
Trino: ODBC.
TSheets: ODBC.
Tumblr: ODBC.
Twilio: ODBC.
Twitter (X): ODBC.
Twitter Ads (X Ads): ODBC.
UPS: ODBC.
USPS: ODBC.
Veeva: ODBC.
Veeva CRM: ODBC: ODBC.
Vena: Power BI.
Vertica: Power BI, Tableau.
Vessel Insight: Power BI.
Vimeo: ODBC.
Viva Insights: Power BI.
VMware Greenplum: ODBC.
Volusion: ODBC.
Walmart: Python.
Wave Financials: ODBC.
Weather: Python.
Web Data Connector: Power BI, Tableau.
Wistia: ODBC.
WooCommerce: ODBC.
WordPress: ODBC.
Workday: ODBC.
Wurk: ODBC.
xBase: ODBC.
Xero: ODBC.
Xero WorkflowMax: ODBC.
XML: ODBC.
Yellowbrick: ODBC.
Yelp: ODBC.
YouTube: ODBC.
YouTube Analytics: ODBC.
Zendesk: ODBC.
Zoho Books: ODBC.
Zoho Creator: ODBC.
Zoho CRM: ODBC.
Zoho Inventory: ODBC.
Zoho Invoice: ODBC.
Zoho People: ODBC.
Zoho Projects: ODBC.
Zoom: ODBC.
Zuora: ODBC.
If your source is not listed above, please contact us to discuss other ways to extract your data, such as custom coding, API, JDBC, ADO.NET, OLE DB, export to CSV, etc.
...
Native Optimized Connection: ETL+ has built-in and optimized code to extract data directly from the data source. Without this, people might need to code APIs to get the data.
Optimized ODBC Connection: ETL+ has been fine-tuned to extract ODBC data from this data source. Without this, people might need to code APIs to get the data.
ODBC. ETL+ will use available ODBCs to extract data from the data source. Contact us if the ODBC fails to correctly render data. See also ETL+ Source Driver for ODBC.
Power BI: Sources available to be extracted using Power BI as part of the BI toolset: https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-data-sources
Tableau: Sources available to be extracted using Tableau as part of the BI toolset: https://help.tableau.com/current/pro/desktop/en-us/exampleconnections_overview.htm
Terminology
Source Systems refers to business systems such as Acumatica, Sage 100, Quickbooks, SalesForce, and Hubspot.
Source type refers to a type of data connection or data store technology. For example ODBC and native optimized connections; data store/database technologies such as MS SQL Server, Google Sheets, OData, CSV files, Excel)ETL+ connects to supported sources via a source driver on the Source Objects panel.
...
| Excerpt | ||||
|---|---|---|---|---|
| ||||
Joni –Please speak to Arthur and me about why we should be using named Excerpts and the Insert excerpt macro to re-use content.This list of data sources supported by DataSelf appears on other pages in the kb, the most important being the http://kb.dataself.com home page. It’s there documentation and for search engine optimization (SEO). |
...