Visual Importer Enterprise simplifies and speeds up the process of importing data into any database, from any source. It also automates tasks like FTP, email, file operations, SQL scripts, and Zip and Unzip. It directly integrates with various databases.
Visual Importer ETL Enterprise is a versatile software platform that enables you to build high performance data integration solutions for data warehousing and business automation. It includes an array of powerful tools and wizards to create and debug automation packages with ease. This solution can automate business processes including FTP, Email, File operations, SQL scripts, Zip and Unzip, ETL Task scheduler, and comprehensive logging.
This software solution incorporates comprehensive support for various file formats including Excel, MS Access, DBF, XML and Text files, Oracle, MS SQL Server, Interbase/Firebird, MySQL, PostgreSQL, SQLite, or any ODBC compliant database.
The software platform enables users to automate the extraction of data, transforming the data, and loading the data with a single package. Additionally, the software has the ability to add new and update old records based on user-defined primary key. This is a feature that significantly sets it apart from other solutions such as Oracle SQL loader, BCP, DTS or SSIS.
Visual Importer Enterprise is ideal for different businesses that need to automate data processing. For instance, if you work in a university, you can automate data processing without the need for extra staff. It can help you automate the processing of results from exams received via email or FTP with minimal user intervention. Simply create a dedicated email account, design a package, and start processing data!
Another outstanding aspect of the Visual Importer Enterprise is the ability to load data from multiple files or tables using mask. If there is any issue, the software has an extensive logging feature that creates a detailed log of every package execution, which makes it very easy to resolve errors.
The Enterprise version of the software includes an execution agent, which runs as a Windows service to ensure that the packages run as scheduled. Overall, this software solution is an ideal choice for businesses that need to automate data integration and business automation.
This software solution incorporates comprehensive support for various file formats including Excel, MS Access, DBF, XML and Text files, Oracle, MS SQL Server, Interbase/Firebird, MySQL, PostgreSQL, SQLite, or any ODBC compliant database.
The software platform enables users to automate the extraction of data, transforming the data, and loading the data with a single package. Additionally, the software has the ability to add new and update old records based on user-defined primary key. This is a feature that significantly sets it apart from other solutions such as Oracle SQL loader, BCP, DTS or SSIS.
Visual Importer Enterprise is ideal for different businesses that need to automate data processing. For instance, if you work in a university, you can automate data processing without the need for extra staff. It can help you automate the processing of results from exams received via email or FTP with minimal user intervention. Simply create a dedicated email account, design a package, and start processing data!
Another outstanding aspect of the Visual Importer Enterprise is the ability to load data from multiple files or tables using mask. If there is any issue, the software has an extensive logging feature that creates a detailed log of every package execution, which makes it very easy to resolve errors.
The Enterprise version of the software includes an execution agent, which runs as a Windows service to ensure that the packages run as scheduled. Overall, this software solution is an ideal choice for businesses that need to automate data integration and business automation.
What's New
Version 9.2.6.8:
+ Improved: Software registration process
+ Improved: JSON Data Handling
+ Added: Support for SQL Server 2017
- Fixed: Issues with loading data into varchar(max) field
- Improved: SQL Server error handling