Visual Importer ETL Professional and Enterprise Documentation

• 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

Getting Started with import Scripts

• Importing Data
• Import Process

HowTo

• Load data from a Flat File(s)
• Load data from an ODBC Data Source
• Load data from Excel/Access/Dbf File(s)
• How To Clear Mapping
• Perform Calculations
• Filter data
• Work with Date fields
• Update or Deleting Records
• Use Database Specific functions

Data Sources

• Data Source is a Microsoft Access Database
• Data Source is a BDE
• Data Source is a DBF file(s)
• Data Source is Clarion dat file(s)
• Data Source is an Excel file(s)
• Data Source is an XML file(s)
• Data Source is an QlikView QVD file(s)
• Data Source is an QlikView QVX file(s)
• Data Source is a Tableau Hyper File(s)
• Data Source is an Interbase or Firebird Server
• Data Source is an JDBC connection
• Data Source is a MySQL/MariaDB Database
• Data Source is an ODBC Connection
• Data Source is an OleDB Connection
• Data Source is an Oracle Database
• Data Source is a PostgreSQL Database
• Data Source is a MongoDB Database
• Data Source is a RSS Feed
• Data Source is SalesForce
• Data Source is Slemma
• Data Source is a Google Spreadsheet
• Data Source is Brightpearl
• Data Source is Twitter
• Data Source is a Microsoft SQL Server
• Data Source is a Microsoft SQL Server CE
• Data Source is Windows Event Log
• Data Source is Active Directory
• Data Source is File System
• Data Source is JSON
• Data Source is Syslog
• Data Source is HTML Table

Data Targets

• Data Target is a ODBC Connection
• Data Target is a OleDB Connection
• Data Target is a BDE
• Data Target is a Oracle Database
• Data Target is a SQLite
• Data Target is an Microsoft SQL Server
• Data Target is an Microsoft SQL Server CE
• Data Target is a MySQL/MariaDB Database
• Data Target is a PostgreSQL Database
• Data Target is an Interbase or Firebird Database
• Data Target is a Tableau Hyper File
• Data Target is Slemma
• Data Target is Salesforce
• Data Target is an Stored Procedure

SQL Scripts
Reports
Email Templates

Packages

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

Package Actions

• 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 Meta Data 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

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

Execution Automation

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

Unattended Execution

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

Repository Database