NOTE! This site uses cookies and similar technologies.

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

I understand

Load data into ANY database

from 31 datasources

VIS Mapping

One Example of using Visual Importer ETL would be truncate table, load data into it and run stored procedure or sql script once loading is completed.
Unlike Oracle SQL loader, BCP 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:

And:

  • Multiple Delimited or Fixed width Text files
  • Multiple Excel files + Multiple Excel Spreadsheets
  • Multiple MS Access Databases
  • Multiple Foxpro/DBF Files
  • Clarion
  • Oracle
  • MS SQL Server 6.5, 7.0, 2000, 2005, 2008, CE, Express
  • Firebird/Interbase
  • MySQL
  • PostgreSQL
  • SQLite
  • Any ODBC source
  • OLE DB
  • JDBC
  • BDE
  • Windows Event Log
  • XML Files
  • QVX Files
  • QVD Files
  • SalesForce
  • Brightpearl
  • Google Spreadsheets
  • Slemma
  • RSS Feed

Into:

  • Oracle
  • MS SQL Server
  • MySQL
  • PostgreSQL
  • SQLite
  • Interbase/Firebird
  • Any ODBC Compliant Database
  • OLE DB
  • JDBC
  • BDE
  • SalesForce
  • Slemma
  • 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

We are here to help

 Tutorials wiki dokuwiki 128 Hammer Spanner   help browser

Step-by-Step tutorials

Sharpen your skills by watching online tutorials and guides

Online Documentation

Read detailed online Wiki Documentation

Support Forum

Ask questions share ideas and discuss sulutions online

Contact Us

Use online contact form to ask questions

Could not find what you were looking for? Just ask