Visual Importer is briefly an ETL tool for data storage. ET L stands for Extract Transform Load, which means extraction, refinement, and loading of information. The information stored in the data warehouse is ultimately used for strategic decisions for the managers of an organization, while the database and even an ERP system may be one of the raw and unrefined inputs to the data warehouse.
Storing information in a data warehouse requires steps. In the Extract step , raw data is first collected from one or more different sources. In the Transform neighborhood, the data is refined and ready to be stored in the warehouse, and in the last step, Load, the refined information is stored in the data warehouse without any changes. There are many software tools for this, and Visual Importer is one of the powerful programs in this field.
This software includes graphical tools and wizards for creating and debugging automation packages, FTP operations, executing SQL commands, managing files and extracting data from various data sources. Unlike DTS, SSIS and Oracle Warehouse builde tools, this program also has the ability to send and receive emails and process attachments. Visual Importer has helped hundreds of businesses automate their business processes and day-to-day tasks by combining different ETL steps into a single software package.
Features of Visual Importer:
- Automation of complex business processes
- Import data to different databases
- Execute SQL scripts
- Compress files and decompress them
- Compress files using MD5
- Copy, cut, rename and delete files
- Upload and download files
- Receive and process emails and their attachments
- send mail
- And …
Supported destination databases:
- MS SQL Server
- Interbase / Firebird
- Any ODBC Compliant Database
- OLE DB
Windows Vista / Vista 64 bit / 7/7 64 bit / 8/8 64 bit / 2008 / Server 2012/10/10 64 bit
Available in the Readme.txt file.