Advanced ETL Processor Documentation

• Introduction
• Requirements
• Key Features
• Demo Data

Mapping Screen Overview

Working with Reader

• Data Source is a Text File(s)
• Data Source is a XML File(s)
• Data Source is JSON File(s)
• Data Source is an Excel File(s)
• Data Source is a QVX File(s)
• Data Source is a QVD File(s)
• Data Source is a Tableau Hyper File(s)
• Data Source is MS Access Database(s)
• Data Source is DBF File(s)
• Data Source is Clarion File(s)
• Data Source is ODBC Connection
• Data Source is JDBC Connection
• Data Source is OleDB Connection
• Data Source is MS SQL Server
• Data Source is MS SQL Server CE
• Data Source is Oracle
• Data Source is MongoDB Connection
• Data Source is MySQL
• Data Source is PostgreSQL
• Data Source is Interbase/Firebird
• Data Source is SQLite
• Data Source is File System
• Data Source is POP3
• Data Source is IMAP4
• Data Source is Office365 Email
• Data Source is HL7
• Data Source is Google Spreadsheet
• Data Source is RSS Feed
• Data Source is SalesForce
• Data Source is Slemma
• Data Source is BrightPearl
• Data Source is Twitter
• Data Source is BDE
• Data Source is HTTP
• Data Source is FTP
• Data Source is Microsoft Message Queue
• Data Source is RabbitMQ
• Data Source is a Windows Event Log
• Data Source is Syslog
• Data Source is Active Directory
• Data Source is HTML Table

Working with Validator

Validation Rules

• Validating Strings
• Validating Numbers
• Validating Dates
• Validating Times
• Miscellaneous Validations
• Validating Data using Regular Expressions

Working with Transformer

Transformation Functions

• Transforming Strings
• Transforming Numbers
• Date Transformations
• Time Transformations
• File Name Transformation Functions
• Lookup Transformation Functions
• XML and HTML Transformation Functions
• JSON Transformation Functions
• Regular Expression Transformation Functions
• Miscellaneous Transformation Functions

Working with Grouper
Working with Sorter
Working with Deduplicator
Working with UnPivot
Working with Pivot
Working with Clone Rows Object
Working with Fields Selector Object
Working with Fields Values Object
Working with Union All Object
Working with Log Object
Working with Joiner Object
Working with Data Buffer Object

Working with Writer

• Target type is a Text File
• Generating Insert Statements
• Target type is a XML File
• Target type is a JSON
• Target type is Excel File
• Target type is QlikView QVX File
• Target type is QlikView QVD File
• Target type is MS Access
• Target type is DBF
• Target Type is ODBC Connection
• Target type is Ole DB
• Target type is SQLIte
• Target type is MS SQL Server
• Target type is MS SQL Server CE
• Target type is Oracle
• Target type is MySQL
• Target type is PostgreSQL
• Target type is Interbase/Firebird
• Target type is File System
• Target type is SMTP Server
• Target type is IMAP4 Server
• Target type is Office 365 EMail Server
• Target type is SalesForce
• Target type is Slemma
• Target type is HL7 Server
• Target type is BDE
• Target type is a SMS
• Target type is a Microsoft Message Queue
• Target type is a RabbitMQ
• Target type is a Tableau TDE files
• Target type is a Tableau Hyper files
• Target type is Google Spreadsheet
• Target type is a Stored Procedure

• Generating Primary Keys and Defaults
• Running SQL Scripts
• How to Update/Delete Records

Date formats
Scripting Language
Supported Functions List
Command Line Interface
Dynamic File names
Registering Software