DataSelf ETL+ User Guide

ETL+ Agent (DataSelf Agent)

• DataSelf Agent Service - Configure for Auto Start

ETL+ Sign in Page

• Password Requirements for DataSelf Applications

ETL+ Extract, Transform and Load (ETL) Page

• ETL+ Source Objects Panel
• ETL+ Target Objects Panel
• ETL+ Extract SQL Statement Panel
• Using the zData Warehouse
• ETL+ Design Page
• ETL+ Freeze

ETL+ Table Load Types

• ETL+ Load Upsert
• ETL+ Load Replace
• ETL+ Load Append
• ETL+ Force Load All
• ETL+ Load
• Delta Load Combinations -- Upsert, Replace, Append, Load All

ETL+ Job Page

• Passing Arguments to Command Line Scripts in ETL+
• Running ETL+ Jobs on Demand

ETL+ Settings Page

• ETL+ Email SMTP Settings

ETL+ Logging

• ETL+ Log Records
• ETL+ Debug Levels & Logging Levels

ETL+ Data Sources

• ETL+ Extraction from All Data Sources
• ETL+ Data Source List

ETL+ Data Warehouse

• ETL+ and Schemas
• New Data Warehouse Page

ETL+ Troubleshooting

• ETL+ Error Messages
• ETL+ Installation Troubleshooting
• Testing Connections to DS Cloud Server
• Extraction Errors
• Upsert Missing or Duplicating Rows
• "Driver installation failure" "Access database engine" / Excel
• Access Database Engine: Required for ETL+ Excel, .csv & MS Access
• Convert version? Message.
• Warning: CSV ... has duplicated column name(s)
• ETL+'s "Hidden Folders"
• No Log Records for Run Job