ETL+ Source Types

Comprehensive list of data sources, source systems, source types, data connections and databases supported by DataSelf. How to deploy ETL+ for each. See Legend for terminology.

Source Type List

• Acumatica Cloud (OData): Native optimized connection. See ETL+ Source Driver for OData.

• Acumatica On-premises (MS SQL Server): Native optimized connection.

• Amazon Marketplace: ODBC. Native connection under construction.

• Asana: ODBC.

• Azure SQL: Native optimized connection.

• BigCommerce: ODBC.

• CSV (text file) : Native optimized connection. See ETL+ Source Driver for Text Files (.CSV)

• Facebook: ODBC.

• FedEx: ODBC.

• Global Shop Solutions (GSS): Optimized ODBC connection for Pervasive database.

• GoogleAds: ODBC.

• Google Analytics: Python. Ask us for more information about our Google Analytics solution.

• Google BigQuery: ODBC.

• Google Sheets : Native optimized connection. See ETL+ Source Driver for Google Sheets.

• GraphQL: ODBC.

• HubSpot : ODBC.

• Instagram: ODBC.

• JSON: ODBC.

• Jira: ODBC.

• LinkedIn: ODBC.

• Mangento: ODBC.

• MailChimp: ODBC.

• Marketo: ODBC.

• MongoDB: ODBC. Native connection under construction.

• MS Access : Native optimized connection. See ETL+ Source Driver for MS Access.

• MS Dynamics 365 Business Central (BC, NAV): Native optimized connection to MS SQL Server.

• MS Dynamics 365 FinOp: Native optimized connection to MS SQL Server.

• MS Dynamics 365 CRM: Native optimized connection to MS SQL Server.

• MS Dynamics 365 GP (Great Plains) : Native optimized connection to MS SQL Server.

• MS Excel : Native optimized connection.

• MS Project: ODBC.

• MS SQL Server : Native optimized connection. See ETL+ Source Driver for Microsoft SQL Server.

• MySQL : Native optimized connection.

• NetSuite: Requires Suite Analytics enabled. See ODBC.

• OData: Native and optimized OData v3 and v4 connection. See ETL+ Source Driver for OData.

• ODBC: Select the proper ODBC driver and follow the prompts.

• Oracle : Native optimized connection. See ETL+ Source Driver for Oracle.

• PostgreSQL : Native optimized connection. Contact us for source driver documentation WIP.

• Providex : Optimized ODBC connection

• QuickBooks: ODBC. Native driver under construction.

• Quickbooks Online: ODBC.

• Sage 100 MS SQL Server: Native optimized connection.

• Sage 100 Providex: Optimized ODBC connection.

• Sage 300: Native optimized connection to MS SQL Server.

• Sage 500: Native optimized connection to MS SQL Server.

• Sage CRM: Native optimized connection to MS SQL Server.

• Sage Intacct: ODBC.

• Sage X3: Native optimized connection.

• Salesforce.com : ODBC.

• http://Sellercloud.com : Python.

• SAP Business One: ODBC.

• SAP HANA: ODBC.

• ServiceNow: ODBC.

• Shopify: ODBC and Python.

• SmartSheet: ODBC.

• Snowflake: ODBC.

• Stripe: ODBC.

• Sugar CRM: ODBC.

• SurveyMonkey: ODBC.

• Text Files (CSV): Native optimized connection.

• TSheets: ODBC.

• Teradata: ODBC.

• Twitter: ODBC.

• UPS: ODBC.

• USPS: ODBC.

• XML: ODBC.

• Zoho CRM: ODBC.

Please contact us to learn more about ways we can efficiently extract data from your sources.

Legend

• 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.

• 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 source types via a source driver on the Source Objects panel.

Pricing & Cost Considerations

• MS Excel and CSV are free of charge.

• When required, it’s your responsibility to obtain rights to ODBC and other source license arrangements.

Related Pages

• ETL+ Source Objects Panel – connects data sources to ETL+.

  • ETL+ Source Drivers

  • Source Systems and IT

• ETL+ Source Types – see the pages in this section

Search: source type, json source types, source type list, json

source type list, source types, json, json

source type, source types, source type, source types