Visual Importer Enterprise 7.514

Visual Importer Enterprise 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 Enterprise stores all information in the repository. Unlike DTS, SSIS and Oracle Warehouse builder Visual Importer Enterprise can send and receive emails and process attachments as well. All FTP operations also supported. By combining simple Package Items together Visual Importer Enterprise helps businesses and Fortune 100 companies to automate complicated business processes and everyday tasks.
Enterprise Version includes execution agent which can be run as Windows service

What Can Visual Importer Enterprise do?

Visual Importer Enterprise 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 Enterprise 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 compliant database Into: Oracle 7-10g database SQL server 7- 2005 Any ODBC compliant database Supported Repository Types: MS Access (Default Repository). Oracle MS Sql Server Interbase MySQL PostgreSQL	Add Records Update Records Delete Records Add New and Update existing Records Apply Functions to Database Fileds Apply user difined Date format Run Sql script before and after loading data Filter Source Data Use Select Statement as a Data Source Export Data from any database FTP Downloads and Uploads Create or Delete directories on FTP server Rename or delete files on FTP server Send Emails with attachments Receive Emails with attachments Save attachmets Compress files Decomress zip files Copy, move, rename, merge, delete files Compare files using MD5, size or creation date Check if file exist Shedule packages for execution Run bat files or execute any windows application Edit and run SQL Scripts Execute Packages from the command line
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

more info @http://www.dbsoftlab.com/index.php/ETL-Tools/Visual-Importer-Enterprise.html
Download: | Rapidshare | DepositFiles |