Transformation

Transformation is the main screen of Advanced ETL Processor where all ETL processes are designed.

Mapping Screen Overview

Working with Reader

• Datasource is a Text File(s)
• Datasource is a XML File(s)
• Data Source is JSON File(s)
• Datasource is a Excel File(s)
• Datasource is a QVX File(s)
• Datasource is a QVD File(s)
• Data Source is a Tableau Hyper File(s)
• Datasource is a Windows Event Log
• Data Source is MS Access Database(s)
• Data Source is DBF File(s)
• Data Source is ODBC Connection
• Data Source is JDBC Connection
• Data Source is OleDB Connection
• Data Source is MongoDB Connection
• Data Source is MS SQL Server
• Data Source is MS SQL Server CE
• Data Source is Oracle
• Data Source is MySQL/MariaDB
• Data Source is PostgreSQL
• Data Source is Interbase/Firebird
• Data Source is SQLite
• Data Source is File System
• Data Source is POP3 Email
• Data Source is IMAP4 Email
• Data Source is Office 365 Email
• Data Source is HL7
• Data Source is Google Spreadsheet
• Data Source is RSS Feed
• Data Source is SalesForce
• Data Source is BrightPearl
• Data Source is Twitter
• Data Source is BDE
• Data Source is HTTP
• Data Source is Microsoft Message Queue
• Data Source is RabbitMQ
• 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
• Miscellaneous Transformation Functions
• XML and HTML Transformation Functions
• JSON Transformation Functions
• Regular Expression 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 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/MariaDB
• 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 HL7 Server
• Target type is BDE
• Target type is a SMS
• Target type is a Microsoft Message Queue
• Target type is RabbitMQ
• Target type is a Tableau TDE File
• Target type is a Tableau Hyper File
• Target type is Google Spreadsheet
• Target type is a Stored Procedure

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