Importing Data

In order to load data from the data source into the data target, you must define data mapping between the target table and data source.

Supported data sources are:

• Multiple Delimited or Fixed width Text files
• Multiple Excel files + Multiple Excel Spreadsheets
• Multiple MS Access Databases + Multiple Tables
• Multiple DBF Files
• Multiple Clarion DAT Files
• QlikView QVX/QVD files
• Multiple Tables
• Oracle 7-12g database
• MS SQL Server
• ODBC source
• JDBC source
• Interbase/Firebird
• MySQL
• PostgreSQL
• SQLite
• MongoDB
• Ole DB
• XML
• JSON
• Windows Event log
• Google Spreadsheets
• SalesForce
• BrightPearl
• Slemma
• File System (Directory Metadata)
• RSS Feed

Imports Scripts screen is designed to allow the user to create, delete, modify, and test data mapping to the target databases.

1. Data Target options
2. Loads Import Script From the file
3. Saves Import Script to the file
4. Saves as
5. Refreshes fields' list from the database
6. Checks script for the errors
7. Data preview
8. Allows the user to clear field mapping
9. Hides mapping panel
10. Data Import

1. Data source options
2. Refreshes Source data
3. Adds new column
4. Deletes last column
5. Auto map the source fields to the target fields
6. Filter
7. Records to Show
8. Sources file name/ table name

Mapping panel provides the user with all information related to the mapping of one particular field. There are two ways of mapping: direct and through calculations.

Alternately you may hide Mapping panel and use grid to perform the mapping. See the picture below

Visual Importer ETL provides functionality to run SQL statements before and after data import.

• In order to Execute several SQL statements user must specify SQL delimiter
• SQL statements are run against target connection
• No select statements allowed