✅ v2023.07
Tour of the main pages in ETL+
ETL+ Extract, Transform and Load (ETL) Page
This is ETL+ main page from where one can maintain your extraction, transform, and load process:Job page: ETL+ Job Page
Data Sources: ETL+ Source Types
Load Types: ETL+ Table Load Types
Log page: ETL+ Logging
Settings page: ETL+ Settings Page
Connecting to your Source System
If this ETL+ has already been connected to your source system (such as in new client’s installations), and this install will not be performing data extraction, then skip to step 10.
Otherwise, visit your source below to set up the ETL+ connection and then go to step 9.
Acumatica Cloud (OData)
Acumatica On-premises (MS SQL Server)
CSV files (text files)
Google Analytics
Google Sheets
HubSpot
MS Access
MS Dynamics BC (NAV, Navision)
MS Dynamics CRM
MS Dynamics GP (Great Plains)
MS Dynamics 365 (AX)
MS Excel
MS SQL Server
MySQL
NetSuite
OData
ODBC
Oracle
Quickbooks Online
Paychex
PostgreSQL
Sage 100 with MS SQL Server
Sage 100 with Providex
Sage 300
Sage 500
Sage CRM
Sage Intacct
Sage X3
Salesforce.com
Sellercloud.com
Shopify
Text files (CSV)
Other systems or entries without a link above: contact support@dataself.com
In rare instances, source systems may refuse connections from 64bit versions of ETL+.
If your source system(s) require ETL+ 32-bit:
Download the DataSelf ETL+ 32bits: DataSelf ETL Plus.exe file from DataSelf ETL+ Download Links.
Copy/paste DataSelf ETL Plus.exe into
C:\Program Files\DataSelf ETL Plusconfirm the overwrite prompt.
Connecting to Your Data Warehouse for the First Time
When you try to add to or change objects in the Target Objects panel for the first time you will need to configure the New Data Warehouse page.
Populate zData Warehouse (Reimports) data warehouse.
See zz_LoadOnce_Delete populates zData Warehouse (Reimports)
Scheduling ETL Processes
See ETL+ Job Page
Your ETL+ out-of-the-box deployment should be all set!
Related Pages
Keywords:
DataSelf ETL Plus, ETL+, Installation, Deploy, Deployment, Advanced Analytics