NOTE! This site uses cookies and similar technologies.

If you not change browser settings, you agree to it. Learn more

I understand

Visual Importer ETL is designed to automate loading data into ANY database.

Visual Importer Achitecture

ETL Architecture

One Example of using Visual Importer ETL would be truncate table, load data into it, run stored procedure or Sql script, once loading is completed. Unlike Oracle SQL loader, BCP, DTS or SSIS Visual Importer ETL can also add new and update old records based on primary key.

Some more examples of what our customers use this ETL tool for include:

Load Data From:

  • Multiple Delimited or Fixed width Text files
  • Multiple Excel files + Multiple Excel Spreadsheets
  • Multiple MS Access Databases +  Multiple Tables
  • Multiple DBF Files
  • Multiple Tables
  • MS Sql Server
  • MS Sql Server CE
  • Oracle Database
  • MySQL
  • PostgreSQL
  • Interbase/Firebird
  • SQLite
  • OleDB
  • RSS Feed
  • Any ODBC Database
  • Any JDBC Database
  • QlikView QVX and QVD Files
  • SalesForce
  • BighPearl
  • Windows Event Log
  • Oracle 7-11g database
  • SQL server 7-2008
  • MySQL
  • PostgreSQL
  • Interbase/Firebird
  • SQLite
  • OleDB
  • Any ODBC Compliant Database
  • Add Records
  • Update Records
  • Delete Records
  • Add New and Update existing Records
  • Apply Functions to Database Fields
  • Apply user defined Date format
  • Run Sql script before and after loading data
  • Run calculations during import
  • Filter Source Data
  • Use Select Statement as a Data Source
  • Data Preview
  • Run import script from command line

If something went wrong Visual importer ETL writes detailed message into error log and writes a record into rejected records file.

Visit Support Forum Learn More Download Buy It
Our prior imports were done using VB. Our VB expert retired. No one in my group knows VB. So Visual Importer was the answer to the lack of VB skills problem my group experienced.
Ron Bradshaw,
IT Reporting Manager,
ConAgra Foods / Lamb Weston

Our customers






Australian Rugby Union
Databases we work with