ETL and Data Integration tools - Modern ETL software for everyone

Visual Importer ETL News

Pause data transformation

You asked we did it. Latest version of Visual Importer ETL can pause data transformation package execution.

It can be used in a lot of situations for example to wait for ftp file to arrive.

Pause execution example

Automatic File Compression

Visual Importer ETL provides extended support for automation of comression and decompression operations , it supports wide range of archive file formats such as

Zip archive *.zip;*.jar;*.ear;*.war;*.cbz;*.apk;*.wsz;*.wal;
*.xpi;*.crx;*.dfsz;*.pcv;*.bsz;*.mskin;*.wmz;*.ipa;*.docx;
*.xlsx;*.pptx;*.sxw;*.sxi;*.sxt;*.sxd;*.sxc;*.sxm;*.sxg;*.stw;
*.sti;*.std;*.stc;*.odh;*.odd;*.odt;*.odm;*.ods;*.ots;*.odg;
*.otg;*.odp;*.otp;*.odf;*.odb

BZip2 archive *.bz2;*.bzip2;*.tbz2;*.tbz
7z archive *.7z
Tar archive *.tar
GZip archive *.gz;*.gzip;*.tgz;*.tpz
Swf archive *.swf

About data compression

Data compression refers to the process of encoding large files in order to reduce the number of bytes. Smaller files occupy lesser memory space and are also easier to transfer over a network, which could be the Internet, intranet or a LAN. The automation of compression files can be of great help here.

Compression involves applying an algorithm to the required data that removes the redundant bits. Redundancy is very common in most types of computer files. Visual Importer compression mechanism gets rid of this redundancy thus compressing the file. Breaking them into smaller parts and sending them over a network can compress files that are extremely large. These files are then reassembled at the receiving end to get back the original data.

Making ETL Tools Better every day

New version of Visual Importer ETL is available for download

Changes are:

Ping Server and Check Database connection was introduced, It is also possible to schedule package for execution directly from the package designer.

What is PING?

Ping operates by sending Internet Control Message Protocol (ICMP) echo request packets to the target host and waiting for an ICMP response. In the process it measures the time from transmission to reception (round-trip time) and records any packet loss. The results of the test are printed in form of a statistical summary of the response packets received, including the minimum, maximum, and the mean round-trip times, and sometimes the standard deviation of the mean. (source wikipedia)