Visual Importer Professional | | 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 together Visual Importer Professional helps small businesses and Fortune 100 companies to automate complicated business processes and everyday tasks. Download a Free Trial or get the latest version today from only $220.
Read Visual Importer Professional FAQ , Watch Online Flash Demo , Read Product Documentation (PDF).
| | Works out of the box, Backed up by Free, Fast, Unparalleled Support | What 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 adminstrator 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 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
- Any ODBC Database
Into: Supported Repository Types:- MS Access (Default Repository).
- Oracle
- MS Sql Server
- Interbase
- MySQL
- PostgreSQL
| | Every package execution is logged,If something went wrong Visual importer Profesional writes detailed message into the log and writes a record into rejected records file.
Visual Importer Professional runs on Microsoft Windows 98/ME/NT 4.0/2000/XP/2003 | Online Flash Demos and Tutorials | Creating basic Visual Importer Package
How to load data from an email attachment into MS Sql Server Database
Working with the Repository | How our customers use Visual Importer Professional | Let’s say, for example, you work for Retail Company with 200 shops. Every morning you receive Excel files with total sales from every store via email and would like to load them into the Data warehouse. Visual Importer Professional can help you automate data processing without the need for more staff in the shops and in the company HQ. It will enable you to process data sent via email and FTP without any intervention. Simply create a dedicated email account, design a package and that’s it - start processing data! Shop Package  HQ Package | Visual Importer Professional Screenshots | Click on thumbnail to see the screenshot
| Related Products | | Visual Importer loads data into ANY database from Text, Excel, MS Access, DBF files or any ODBC compliant database. It is easy to use and was designed especially for non technical users. Visual Importer Enterprise is an ETL tool 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 adminstrator once package is completed. Visual Importer Enterprise includes execution agent which can be run as a Windows service. Advanced ETL Processor is designed to automate extracting data from ANY database, transform, validate it and load into ANY database . Typical usage of it would be extract data from Excel File,Validate Date Formats, Sort data, deduplicate it and load it into Oracle database, run stored procedure or Sql script, once loading is completed. Unlike Oracle SQL loader, BCP, DTS or SSIS Advanced ETL Processor can also add new and update old records based on primary key Feature matrix |
|
