Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Excerpt

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
    Excerpt
    namesource_type_list
    Excerpt

    Comprehensive list of data sources supported by DataSelf.

    ...

    List of 430+ Supported Data Sources (no-code/low-code)

    DataSelf solutions allow no-code data extraction, transformation, and loading from hundreds of source systems. Other sources might require low-coding or full-coding.

    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.

    ...

    ...

    • for Pervasive database.

    • Google Ad Manager: ODBC.

    ...

    • Google Ads: ODBC.

    • Google AdSense: ODBC.

    • Google Analytics: ODBC and Python.

    ...

    • Google Analytics

    ...

    ...

    ...

    ...

    ...

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

    ...

    ...

    • Microsoft Dynamics 365

    ...

    ...

    ...

    ...

    MS Project: ODBC.

    ...

    • .

    • 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

    ...

    ...

    • connection

    ...

    • .

    • ODBC: Select the proper ODBC driver and follow the

    ...

    ...

    Providex : Optimized ODBC connection

    ...

    QuickBooks: ODBC. Native driver under construction.

    ...

    Quickbooks Online: ODBC.

    ...

    ...

    ...

    ...

    ...

    If your source is not listed above, please contact us to learn more about ways we can efficiently extract data from your sourcesdiscuss other ways to extract your data, such as custom coding, API, JDBC, ADO.NET, OLE DB, export to CSV, etc.

    Important

    • Many data sources, ODBCs, and extraction methods might require additional licensing costs. Some might require you to acquire the drivers directly from vendors such as Microsoft, Salesforce, CData, Progress.com, and Devart. Please consult us and/or your data source providers.

    • It’s your responsibility to obtain rights to ODBC and other source license arrangements when required.

    • Some third-party sources above might not be compatible with your source system or are no longer available.

    ...

    Anchor
    legend
    legend
    isMissingRequiredParameterstrue
    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.

    • 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 source types supported sources 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
      • .

    ...

    Excerpt
    hiddentrue
    nameInternal_Note2JO

    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).
    ( https://dataself.atlassian.net/wiki/spaces/DS / http://kb.dataself.com )

    Excerpt
    hiddentrue
    name source_type_list

    Related Pages

    SearchKeywords: source typedrivers, json source types, data connections, databases, source type list, jsonsource type list, source types, json, json.

    Excerpt
    hiddentrue
    nameInternal_NoteI

    INTERNAL NOTES
    This page used to be named “ETL+ Source Types”.
    We are Replacing that term with “data sources”/supported data sources for the business side and ETL+ Source Drivers for the technical audience.

    source type, source types, source type, source types