Advanced ETL Processor Professional and Enterprise Documentation

Table of Contents

• Introduction
• Requirements
• Key features
• Demo Data
• Options
• User Interface

Directories and Connections

• Directories
• Active Directory
• RabbitMQ Connection
• Apache Kafka Connection
• Microsoft Message Queuing Connection

Database Connections

• Oracle Connection
• JDBC Connection
• Microsoft SQL Server Connection
• ODBC Connection
• MySQL/MariaDB Connection
• PostreSQL Connection
• Intebase/Firebird Connection
• OleDB Connection
• MongoDB Connection
• SQLite Connection
• Microsoft SQL Server CE Connection
• BDE Connection

Email Connections

• POP3 Connection
• IMAP4 Connection
• SMTP Connection
• Office 365 Connection

Cloud Connections

• FTP Connection
• SMS Connection
• SalesForce Connection
• TCP/IP Connection
• Google Spreadsheet Connection
• BrightPearl Connection
• Slemma Connection
• Twitter Connection
• Tableau Connection
• Cloud Storage Connection
• Amazon Connection
• Azure Connection
• Telegram Connection

Import Script

Transformation

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 a 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 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 Slemma
• 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 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 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
• Working with date and time fields

SQL Scripts
Lookups
Reports
Email Templates

Packages

• Debugging Package
• Using Variables
• Working with Filenames and Directories

Package Actions

• Transformation Action
• Import Action
• SQL Data Check Action
• SQL Script Action
• Package Action
• FTP Action
• HTTP Download Action
• HTTP Form Action
• Soap Action
• XSLT Transformation Action
• Archive Action
• Receive Email POP3 Action
• Receive Email IMAP4 Action
• Receive Office 365 Email Action
• Send Email Action
• External Application Action
• File Operation Action
• Check File Action
• File Metadata Action
• Check Directory Action
• Compare Files Action
• Check Disk Space Action
• Excel Operation Action
• Backup Repository Action
• Clear Log Action
• Pause Action
• Check Date Action
• Report Action
• Export Data Action
• Show Message and Ask Question Action
• Set Variable Action
• Script Action
• Check Connection Action
• PING Server Action
• Case Action
• GPG4WIN Action
• SMS Action
• Loop Action
• Twitter Action
• Publish Tableau File Action
• Cloud Storage Action
• Amazon S3 Action
• Azure Blob Action
• Change Encoding Action
• Get Telegram Message Action
• Post Telegram Message Action
• Check License Action
• Extract MIME Data Action
• Send RabbitMQ Message Action
• Receive RabbitMQ Message Action
• Send Apache Kafka Message Action
• Receive Apache Kafka Message Action

Version Control
SQL
Objects Library
Dynamic File names
Date formats
Scripting Language
Supported Functions List
Regular Expressions

Execution Automation

• Using Command Line Interface
  
• Scheduler
  
• Event Monitors
  
• Execution Log
  

Unattended Execution

• Execution Agent
  
• Directory Monitor
  
• FTP Monitor
  
• POP3 Monitor
  
• IMAP4 Monitor
  
• Office 365 Monitor
  
• MSMQ Monitor
  
• HTTP Monitor
  
• Management Console
  

Repository Database