Visual Importer Professional is an automation tool. User can design Import, Export and SQL scripts, add them to the Package and schedule it for execution on regular basis.
Visual Importer Professional stores all information in the repository. Unlike DTS, SSIS and Oracle Warehouse builder Visual Importer Professional can receive emails and process attachments as well.
All FTP operations also supported. By combining simple Package Items togetherVisual Importer Professional helps small businesses and Fortune 100 companies to automate complicated business processes and everyday tasks.
ReadVisual Importer Professional FAQ ,Watch Online Flash Demo ,Read Product Documentation (PDF). Works out of the box, Backed up by Free, Fast, Unparalleled SupportWhat Can Visual Importer Professional do?
Visual Importer Professional is designed to automate database loading process. Typical usage of it would be download files from FTP Server, load them into the database, run stored procedure or Sql script and send email to administrator once package is completed.
Unlike Oracle SQL loader, BCP, DTS or SSIS Visual Importer Professional can also add new and update old records based on primary key. Some examples of what customers use thisETL tool for include:Load Data From:Multiple Delimited or Fixed width Text filesMultiple Excel files + Multiple Excel SpreadsheetsMultiple MS Access Databases + Multiple TablesMultiple DBF FilesMultiple TablesMS Sql ServerAny ODBC DatabaseInto: Oracle 7-11g database SQL server 7- 2008 ODBC sourceTransformations and Tasks:Add Records Update Records Delete Records Add New and Update existing Records Apply Functions to Datab.