Importing Data
In order to load data from the data source into the data target user must define data mapping between target table and data source.
Possible data sources are:
- Multiple Delimited or Fixed width Text files
- Multiple Excel files + Multiple Excel Spread sheets
- Multiple MS Access Databases + Multiple Tables
- Multiple DBF Files
- Multiple Clarion DAT Files
- XML Files
- JSON Files
- QVX files
- QVD files
- OleDB
- Any ODBC compliant database
- Any JDBC compliant database
- Full support for OLE DB
- Direct connection to Oracle, SQL Server, MySql, PostgreSQL, SQLite, MongoDB, SQL Server Compact and Interbase/Firebird
- Multiple Tables
- Windows Event Log
- Active Directory
- RSS
- Google Spread Sheets
- SalesForce
- BrightPearl
- Twitter
Import screen is designed to allow a user to create, delete, modify, and test data mapping to the target databases.
In the beginning, the simplest way to create an Import script is to use the import script wizard.
- To create a new Import click System Menu→ New→ Import.
- Fill in the Description edit box with the name of an Import you are about to create.
- Follow wizard Instructions
Mapping editor screen overview
- Double click on any demo Import.
- Import editor will appear
Main tool bar
- Data Target options
- Loads Import Script From the file
- Saves Import Script to the file
- Saves as
- Saves Import to the Repository
- Refreshes fields list fro the database
- Checks Import for mapping errors
- Data preview
- Allows the user to clear field mapping
- Hides mapping panel
- Data Import
- Manage Versions
- Add Version
- Revert to the previous version
- Make Import Script Read Only
Source tool bar
- Data source options
- Refreshes Source data
- Adds new column
- Deletes last column
- Auto map the source fields to the target fields
- Filter
- Records to Show
- Sources file name/ table name
Mapping panel
Mapping panel is designed to provide 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:
If Error option apply to Calculations and Date formats only
SQL Statements
Visual Importer ETL provides functionality to execute SQL statements before and after data import.
- In order to Execute several SQL statements user must specify SQL statements delimiter.
- SQL statements are run against target connection
- No select statements allowed.
Template tab
Log File tab
Rejected Records Tab
