| Description |
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.
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.
A short view of Features:
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
Some more Features:
Data Sources
Delimited files
Fixed Width Files
Pivot tables
Excel Spreadsheets
DBF Files
MS Access Databases
Multiple Source Files
Multiple Source Tables
Any ODBC Compliant Database
Data Targets
Oracle Direct Path Loading
Oracle Arrays Inserts
MS Sql Server
Any ODBC Compliant Database
Transformations
Adding Records
Updating Records
Deleting Records
Adding new and Updating old Records
Conditional Loading
User definable date formats
Transformation Functions
Sql Before
Sql After
Rejected Records File
Transformation Log
Command Line interface
Data Preview
Repository
MS Access
MS Sql Server
Oracle 7-10
MySql
Interbase
PostgreSQL
Repository synchronization
Directories
Connections
Imports
Exports
Sql Scripts
Lookups
Scheduler
Execution Logging
Packages
Packages
Imports
Exports
Sql Scripts
Check Files
Compare Files (creation date, file size or MD5)
File Operations (copy,delete,rename,etc)
External applications
Email Notifications
Ftp operations Uploads, Downloads, Create Remote directory, Delete File
Zip (zip and unzip)
Pop 3 Email receiver
SQL Data Check
Execution Agent
Runs as Windows service
System Req:
Microsoft Windows 98/ME/NT 4.0/2000/XP/2003
-------------------------------------
HeartBug in your service ;-)
|
!
3 
3 
