Visual Importer 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.
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.
Very fast and reliable. Capable of performing calculation during import, may also execute SQL statements before and after import.
Integrated expression builder, comprehensive error log, rejected records file. Source Data Filtering, Multiple source tables and files. Unlike Oracle SQL loader, BCP, DTS or SSIS, Visual Importer can also add new and update old records based on the user-defined key.
Supported Repository Types:
* MS Access (Default Repository).
* MS Sql Server
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
* Oracle 7-10g database
* SQL server 7- 2005
* ODBC source
* 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
The license of this software is Free Trial Software, the price is $100.00, you can free download and get a free trial.