DRAFT
Library of ETL+ strategies, solutions, procedures/recipes, and Best Practices for ETL+. A ‘toolkit’ of strategies, patterns, technical recipes, techniques, and best practices for using and configuring ETL+ to achieve different goals.
⚒️ TERMINOLOGY (What is a 'Playbook” or whatever we are calling this)
Alternative Names:
-
DataSelf ETL+ Solution Library (Joni)
-
(DataSelf) ETL+ Recipes
-
ETL+ Best Practices ETL+ Strategies and Best Practices
-
ETL+ User Guide (prefix w/ DataSelf if the parent directory isn’t visible)
Name already in use: DataSelf ETL+ User Guide
This section will be removed or greatly shortened once we decide on a name and description.
DRAFT: Is not published to kb.dataself.com
DS Staff Input Invited
A ‘toolkit’ or library of documented procedures, solutions, examples, and guidelines for specific tasks or scenarios using DataSelf ETL+ such as …
-
Design patterns are reusable solutions to commonly occurring ETL+ configuration problems. They are general, proven solutions to commonly encountered challenges that have been tested and refined over time by experienced developers.
-
Can include templates, checklists, and other resources to help ensure that development work is consistent and efficient.
-
Playbooks are procedures, guidelines and best practices. A place to share proven solutions and avoid ‘re-inventing the wheel’.
Candidate Names
Toolkit, Guidebook, Best practices repository, ETL+ solutions library, ETL+ Design Patterns, Design templates, Software patterns. See DRAFT Uses of "PlayBook" in Software
Playbook Directory
Importing from Specific Data Sources
-
ETL+ for Acumatica Cloud (OData) Section about ETL+, Acumatica and OData.
-
ETL+ for Acumatica SQL (On-prem or Private Cloud) -
ETL+ for Agility -
ETL+ for BigQuery Google Cloud -
ETL+ for CSV and Text Files The Text File source driver can import .csv format files.
-
ETL+ for Google Sheets How to connect your Google Sheets to ETL+ for data extraction. Also how to map cells on Google sheets to target tables in the data warehouse.
-
ETL+ for HubSpot -
ETL+ for MS Access -
ETL+ for MS Excel ETL+ reads and extracts data from Microsoft Excel XLS, XLSX, and XLSM files.
-
ETL+ for MS Dynamics BC / NAV (Business Central, Navision) -
ETL+ for MS Dynamics GP (Great Plains) -
ETL+ for MS SQL Server -
ETL+ for MySQL -
ETL+ for NetSuite How to configure NetSuite for ETL+ and configure ETL+ to connect to NetSuite as a data source.
-
ETL+ for OData DataSelf uses the OData protocol for Acumatica and supports OData for other data sources. See also ETL+ for Acumatica Cloud (OData)
-
ETL+ for ODBC (DSN) -
ETL+ for Oracle -
ETL+ for Pervasive ODBC (DSN) -
ETL+ for PostgreSQL -
ETL+ for Quickbooks Desktop & Enterprise -
ETL+ for Quickbooks Online -
ETL+ for Sage 100 Providex -
ETL+ for Sage 100 MS SQL Server -
ETL+ for Sage 300 -
ETL+ for Sage 500 -
ETL+ for Sage CRM -
ETL+ for Sage Intacct -
ETL+ for Sage X3 -
ETL+ for Salesforce How to deploy ETL+ for Salesforce. See also Salesforce Technical Details
-
ETL+ for SAP Business One (SAP B1) -
ETL+ for Shopify -
ETL+ for Google Analytics
-
Configuration Configuring ETL+ describes modifying/adjusting ETL+ settings, options, preferences or parameters.
Configuration settings allow users to tailor ETL+ to specific users needs or preferences.