v2022.08 ETL+ Source Types

An ETL+ source type defines the type of a data source or source system.

Source Type List

• Acumatica Cloud (OData): Native optimized connection.

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

• Amazon Marketplace: ODBC. Native connection under construction.

• Asana: ODBC. Native connection: WIP.

• Azure SQL: Native optimized connection.

• BigCommerce: ODBC. Native connection: WIP.

• CSV (text file): Native optimized connection.

• Facebook: ODBC. Native connection: WIP.

• FedEx: ODBC. Native connection: WIP.

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

• GoogleAds: ODBC. Native connection: WIP.

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

• Google BigQuery: ODBC. Native connection: WIP.

• Google Sheets: Beta native connection: Documentation is a WIP.

• GraphQL: ODBC. Native connection: WIP.

• HubSpot: ODBC. Native connection: WIP.

• Instagram: ODBC. Native connection: WIP.

• JSON: ODBC. Native connection: WIP.

• Jira: ODBC. Native connection: WIP.

• LinkedIn: ODBC. Native connection: WIP.

• Mangento: ODBC. Native connection: WIP.

• MailChimp: ODBC. Native connection: WIP.

• Marketo: ODBC. Native connection: WIP.

• MongoDB: ODBC. Native connection under construction.

• MS Access: Native optimized connection. Doc WIP.

• MS Dynamics 365 Business Central (BC, NAV, Navision): 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. Native connection: WIP.

• MS SQL Server: Native optimized connection.

• MySQL: Beta native connection: Documentation is a WIP.

• NetSuite: Requires Suite Analytics enabled. See ODBC. Native connection: WIP.

• OData: Native and optimized OData v3 and v4 connection.

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

• Oracle: Beta native connection: Documentation is a WIP.

• PostgreSQL: Native connection. Doc WIP.

• Providex: Optimized ODBC connection

• QuickBooks: ODBC. Native driver under construction.

• Quickbooks Online: ODBC. Native connection: WIP.

• 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. Native connection: WIP.

• Sage X3: Native optimized connection.

• Salesforce.com: ODBC. Native connection: WIP.

• Sellercloud.com: Python.

• SAP Business One: ODBC. Native connection: WIP.

• SAP HANA: ODBC. Native connection: WIP.

• ServiceNow: ODBC. Native connection: WIP.

• Shopify: ODBC and Python. Native connection: WIP.

• SmartSheet: ODBC. Native connection: WIP.

• Snowflake: ODBC. Native connection: WIP.

• Stripe: ODBC. Native connection: WIP.

• Sugar CRM: ODBC. Native connection: WIP.

• SurveyMonkey: ODBC. Native connection: WIP.

• Text Files (CSV): Native optimized connection.

• TSheets: ODBC. Native connection: WIP.

• Teradata: ODBC. Native connection: WIP.

• Twitter: ODBC. Native connection: WIP.

• UPS: ODBC. Native connection: WIP.

• USPS: ODBC. Native connection: WIP.

• XML: ODBC. Native connection: WIP.

• Zoho CRM: ODBC. Native connection: WIP.

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

Source Type Legend

• Optimized Native 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. Native Connection: WIP: ETL+ will use available ODBCs to extract data from the data source. Contact us if the ODBC fails to correctly render data.

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

• v2022.08 ETL+ Source Types (ETL Source panel)

  • v2022.08 ETL+ Data Sources

• For information on connecting to various data sources see v2022.08 ETL+ Source Types

  • For more technical information about these data connections Source Systems and IT