Visual Importer 7.6.4 is a Database Management product from dbsoftlab.com, get 5 Stars SoftSea Rating, 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).
* Oracle
* MS Sql Server
* Interbase
* MySQL
* PostgreSQL
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:
* Oracle 7-10g database
* SQL server 7- 2005
* ODBC source
Main functions:
* 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 business & finance software is Free Trial Software, the price is $120, you can free download and get a free trial before you buy. If you want to get a full or nolimited version of Visual Importer, you can buy this business & finance software.