Visual Importer ETL Documentation

• Introduction
• Requirements
• Key features
• Importing Data
• Import Process

HowTo

• Loading data from a Flat File(s)
• Loading data from an ODBC Data Source
• Loading data from Excel/Access/Dbf File(s)
• How To Clear Mapping
• Performing Calculations
• Filtering data
• Working with Date fields
• Updating or Deleting Records
• Loading data from the Cross/Pivot table
• Using Database Specific functions

Data Sources

• Data Source is a Microsoft Access Database
• Data Source is a BDE Connection
• 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 JSON 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 an MySQL/MariaDB Database
• Data Source is an ODBC Connection
• Data Source is an OleDB Connection
• Data Source is an SqLite Database
• Data Source is an Oracle Database
• Data Source is a PostgreSQL Database
• Data Source is a Microsoft SQL Server
• Data Source is a Microsoft SQL Server CE
• Data Source is a MongoDB Database
• Data Source is a RSS Feed
• Data Source is a SalesForce
• Datasource is Slemma
• Data Source is a Google Spreadsheet
• Datasource is Brightpearl
• Data Source is Twitter
• Data Source is Windows Event Log
• Data Source is Syslog
• Data Source is Active Directory
• Data Source is File System
• Data Source is HTML Table

Data Targets

• Data Target is a ODBC Connection
• Data Target is a OleDB Connection
• 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 Database
• Data Target is a PostgreSQL Database
• Data Target is an Interbase or Firebird Database
• Data Target is Tableau Hyper File
• Data Target is BDE
• Data Target is SalesForce
• Data Target is Slemma
• Data Target is a Stored Procedure

• Error Handling
• Date Formats
• Scripting Language
• Supported Functions List
• Command Line Interface
• Registering Software