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

  • Double click on any demo Import.
  • Import editor will appear

Main tool bar

  1. Data Target options
  2. Loads Import Script From the file
  3. Saves Import Script to the file
  4. Saves as
  5. Saves Import to the Repository
  6. Refreshes fields list fro the database
  7. Checks Import for mapping errors
  8. Data preview
  9. Allows the user to clear field mapping
  10. Hides mapping panel
  11. Data Import
  12. Manage Versions
  13. Add Version
  14. Revert to the previous version
  15. Make Import Script Read Only

Source tool bar

  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

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

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.

For more technologies supported by our ETL Software see Advanced ETL Processor Versions and Visual Importer ETL Versions

Confused? Ask question on our ETL Forum

  • vimpe/importing_data.txt
  • Last modified: 25/12/2018 06:23
  • by admin