Visual Importer ETL Enterprise 8.0.3.1
Here is simple usage example: Download files from an FTP server, load them into the database, run stored procedure or SQL script and send email to the admin, once the package is completed. Unlike Oracle SQL loader, BCP, DTS or SSIS, Visual Importer Enterprise can also add new and update old records based on user defined primary key.
Let`s say, for example, you work at university and must publish results of exams from different departments. Visual Importer Enterprise can help you automate data processing without the need for more staff. It will enable you to process data sent via email and FTP without user intervention. Simply create a dedicated email account, design a package and that`s it - start processing data!
Another unique benefit of using Visual Importer Enterprise its ability to load data from multiple files or tables using mask.
If there is a problem it is very easy to resolve: Every package execution is logged. In case of loading errors, Visual Importer Enterprise writes a detailed message into the log and writes a record into the rejected records file.
The Enterprise version includes execution agent, which can be run as a Windows service.
- Addressed some SMTP problems
- Various bug fixes
- Addressed some issues related to working with MS SQL Server Compact edition
+ Order of fields was charged in connection dialog: user selects server name, enters the user name and password and finally user selects the database.
+ Even smaller executable now
- SMTP testing was fixed for SSL connection
+ CRC16,CRC24,CRC32,Adler32,CRC64,eDonkey,eMule,MD4,MD5,RIPEMD160,SHA1,SHA224,SHA256,SHA384,SHA512,Whirlpool checksums
+ Simplified Repository management
+ Execution log has Execution time percentage
+ Schedule package execution directly from the package designer
+ Breakpoints were introduced
+ Execute single package object option was introduced
+ More generic log viewer
+ Execution agent writes startup error messages in the log file
- Disappearing tree nodes problem was addressed
- Minor interface tweaks
- AV fixes
+ Standard print preview
+ Support for scrolling in Package editor
- Better error handling for ADO and MS Sql scripts
Added pause package execution object
Fixed bugs related to working with time fields in MySQL
Export into excel via DDE was introduced
Added Support for XSLT transformations
Ping Server and Check Database connection was introduced
Improved support for email processing
Various bug fixes
It is also possible to schedule package for execution directly from package designer
Various bug fixes
...With The Easy-To-Use Visual Importer ETL If...load database data, Visual Importer ETL is...Processing Speed Using Visual Importer ETL Standard...file into MS SQL Sever via BCP...we made sure Visual Importer works with...Tables * MS Sql Server * Oracle...Sql * PostgreSql *...XML * Any ODBC Database Visual Importer...
...Advanced ETL Processor extracts data...results of an ETL flow would look...like. Advanced ETL Processor can help...stored procedure or SQL script, once loading...is completed. Unlike Oracle SQL loader, BCP,...or SSIS, Advanced ETL Processor can also...by user. Advanced ETL Processor works directly...
...Advanced ETL Processor Professional is...a Codeless Automation Tool. It transfers...or file. Complete automation of business processes...SMTP, File operations, SQL scripts, Zip and...Unzip, ETL Task scheduler and...files, Oracle, MS SQL Server, Interbase/Firebird, MySQL,...PostgreSQL, SQLite, MS SQL Server Compact or...
...files,XML, Oracle, MS SQL Server, Interbase/Firebird, MySQL,...OleDB, SQLite, MS SQL Server Compact or...ANY ODBC compliant database. Great...may also execute SQL statements before and...competitors, such as Oracle SQL loader, BCP,...records file. The tool is typically used...stored procedure or SQL script. Many businesses...
...and Automate Entire Business Processes Transfer Data...or file. Complete automation of business processes...SMTP, File operations, SQL scripts, Zip and...Unzip, ETL Task scheduler and...files, Oracle, MS SQL Server, Interbase/Firebird, MySQL,...SQLite or any ODBC compliant database. Since...Advanced ETL Processor Enterprise is a codeless...