Free ETL Tools

ETL tools (Extract, Transform And Load) is a type of data migration tools helps data scientists or data analysts perform data pulling, data cleansing and data processing from various data warehouse source and consolidate data and store to another centralised data warehouse to generate business intelligence (BI) reports or do predictive analysis.

So, ETL tools normally do three main types of data process such as below:

  1. Extracts data from homogeneous or heterogeneous data sources
  2. Transforms the data for storing it in proper format or structure for querying and analysis purpose
  3. Loads it into the final target (database, more specifically, operational data store, data mart, or data warehouse).

If you’re doing big data project, modern data management or data ware house project, below are the free ETL tools or open source ETL tools worth to check out and understand their ETL functionalities.

Free ETL tools or Open Source ETL Tools:

Talend ETL (Talend Open Studio for Data Integration)

Talend ETL tools is free ETL makes it easy to manage all ETL process, from initial ETL design on through ETL data load execution. It comes with user friendly modern data process modelling tool that allows any user to participate in the initial ETL design work.

Meanwhile, Talend ETL have a comprehensive data connectors list to make it easy to data scientist or data analyst to implement data connections between diverse database types, file formats, and enterprise applications.

Free Talend ETL - Free ETL

Talend ETL also bundles with free ETL data mapping and data transformations, including string manipulations, automatic lookup handling, an option to use ELT rather than ETL, and much more.

Best part of Talend ETL support for highly scalable distributed ETL data load execution that can leverage a grid of commodity computers.

Talend ETL Open Studio – Free ETL

Apatar ETL – Open Source ETL Software

Apatar ETL is a cross-platform open source free ETL tool provides various database, application files connectivity that allows developers, database administrators, and business users to integrate data information between a variety of data sources and formats.

apatar ETL - Free ETL

It has an intuitive user interface that requires no coding to set up a data integration job.

Apatar ETL tool support many popular applications and data sources such as Oracle, MS SQL, MySQL, Sybase, DB2, MS Access, PostgreSQL, XML, InstantDB, Paradox, BorlandJDataStore, Csv, MS Excel, Qed, HSQL, Compiere ERP, SalesForce.Com, SugarCRM, Goldmine, any JDBC data sources and more.

Visit Apatar ETL


GeoKettle – Free Geo Spatial ETL tool

GeoKettle Free Geo Spatial ETL

GeoKettle is a powerful free ETL designed to integrate various geo spatial data sources or GIS data to build geospatial data warehouses. Besides data integration, GeoKettle free geo spatial tool also do data transformation like data cleansing, correct data errors, change data structure and make geo spatial compliant to defined standards and others.

GeoKettle Geo Spatial Supports format:

  • Spatial database types: PostGIS, Oracle spatial, MySQL, Microsoft SQL Server 2008, Ingres and IBM DB2
  • SOLAP (Spatial OLAP) system: GeoMondrian
  • Geo files (data formats): Shapefile, GML, KML, OGR
  • OGC Web services: Sensor Observation Service (SOS), Catalogue Web Service (CSW)

Visit GeoKettle Geo Spatial ETL

KETL – Free Java ETL Tool

KETL is java based free ETL Tools that scalable, platform independent ETL engine–enables complex ETL transformations to be executed in a highly efficient manner.

The best part of KETL is their supports job execution and scheduling manager–dependency-driven job execution model that allows any data analysts or data administrators to perform time scheduling task like executes pre-defined SQL statement via JDBC, executes XML defined jobs and executes an operating system command.

Meanwhile, KETL also support comprehensive data sources transformation like extracting and loading of relational, flat file and XML data sources, via JDBC and proprietary database APIs.

Visit KETL Java ETL

Pentaho’s Data Integration

Free Pentaho Data Integration

Pentaho Data Integration, also known as Kettle, delivers powerful extraction, transformation, and loading (ETL) capabilities. It has intuitive, graphical, drag and drop design environment like Talend Open studio to visually design transforms and jobs that extract your existing data and make it available for easy reporting and analysis.

Meanwhile, Pentaho data integration, free ETL software enable data analyst to deliver data from multiple data sources, while enriching, cleansing, and transforming the data. Best part of Pentaho ETL support by third party plugins to enhance ETL functionalities.

Meanwhile, Pentaho support various data source, database, files or format such as Any database using ODBC on Windows, Oracle, MySQL, AS/400, MS Access, MS SQL Server, IBM DB2, PostgreSQL, Intersystems Cache, Informix, Sybase, dBase, Firebird SQL, MaxDB (SAP DB), Hypersonic, CA Ingress and others.

Visit Pentaho Data Integration

Share with us if you know other Free ETL or Open Source ETL should included on above list.

FTPS (FTP over SSL) vs SFTP (SSH File Transfer Protocol)

ftps sftp

SSH File transfer protocol, SFTP or File Transfer protocol via Secure Socket Layer, FTPS are the most common secure FTP communication technologies used to transfer computer files from one host to another host over a TCP networks. Both SFTP and FTPS offer a high level file transfer security protection with strong algorithms such as AES and Triple DES to encrypt any data transferred.


But the most notable differences between SFTP and FTPS is how connections are authenticated and managed.

FTPS is FTP utilising Secure Secure Layer (SSL) certificate for Security. The entire secure FTP connection is authenticated using an User ID, Password and SSL certificate. Once FTPS connection established, FTP client software will check destination FTP server if the server’s certificate is trusted.

The SSL certificate will considered trusted if either the certificate was signed off by a known certificate authority (CA) or if the certificate was self-signed (by your partner) and you have a copy of their public certificate in your trusted key store. All username and password information for FTPS will be encrypted through secure FTP connection.

Below are the FTPS pros and cons:


  • The communication can be read and understood by a human
  • Provides services for server-to-server file transfer
  • SSL/TLS has good authentication mechanisms (X.509 certificate features)
  • FTP and SSL support is built into many internet communications frameworks


  • Does not have a uniform directory listing format
  • Requires a secondary DATA channel, which makes it hard to use behind firewalls
  • Does not define a standard for file name character sets (encodings)
  • Not all FTP servers support SSL/TLS
  • Does not have a standard way to get and change file or directory attributes

SFTP or SSH File Transfer Protocol is another secure Secure File Transfer Protocol is designed as a SSH extension to provide file transfer capability, so it usually uses only the SSH port for both data and control. When your FTP client software connect to SFTP server, it will transmit public key to the server for authentication. If the keys match, along with any user/password supplied, then the authentication will succeed.

Below are the SFTP Pros and Cons:


  • Has only one connection (no need for a DATA connection).
  • FTP connection is always secured
  • FTP directory listing is uniform and machine-readable
  • FTP protocol includes operations for permission and attribute manipulation, file locking, and more functionality.


  • The communication is binary and can not be logged “as is” for human reading
    SSH keys are harder to manage and validate.
  • The standards define certain things as optional or recommended, which leads to certain compatibility problems between different software titles from different vendors.
  • No server-to-server copy and recursive directory removal operations
  • No built-in SSH/SFTP support in VCL and .NET frameworks.

Overall most of FTP server software support both secure FTP technologies with strong authentication options.

But SFTP will be clear winner since it’s very firewall friendly. SFTP only needs a single port number (default of 22) to be opened through the firewall.  This port will be used for all SFTP communications, including the initial authentication, any commands issued, as well as any data transferred.

FTPS will be more difficult to implement through a tightly secure firewall since FTPS uses multiple network port numbers. Every time a file transfer request (get, put) or directory listing request is made, another port number needs to be opened.  Therefore it have to open a range of ports in your firewalls to allow for FTPS connections, which can be a security risk for your network.

FTP Server software that supports FTPS and SFTP:

  1. Cerberus FTP Server
  2. FileZilla – Most famous free FTPs and FTPS server software
  3. Serv-U FTP Server

Linux and Mac Visual Studio – Visual Studio Code

Visual Studio Code, a linux and Mac Visual Studio version allow developers building their modern web and cloud applications in more efficient ways on any platform, featuring deep integration with existing Microsoft developer tools.

Visual Studio Code

The Linux and Mac Visual Studio version offers a  modern text editor with rich code assistance, which allows developer coding / building their web and cloud application in JavaScript, TypeScript, ASP.NET 5, and other modern computer languages with wide variety of web application frameworks.

Since Visual Studio is famous with their IDE debugging, the Linux and Mac Visual Studio Code also can diagnosis issues on web and cloud application with integrated debugging tools for Node.js, TypeScript, and JavaScript. Set breakpoints in your code, break on exceptions, watch variables, step through your code, or navigate up the call stack, as well as attaching to local running processes.

Other features on Linux and Mac Visual Studio Code are customisable bindings, syntax highlighting, bracket matching, auto indentation, and snippets, with support for dozens of languages. Types of web programming supported on Visual Studio Code are JavaScript, C#, C++, PHP, Java, HTML, R, CSS, SQL, Markdown, TypeScript, LESS, SASS, JSON, XML, and Python as well as many other common file formats.

Mac Visual Studio Code

Other impressive about Visual Studio Code also bundles with great web technologies tool such as HTML, CSS, Less, Sass, and JSON. Code also integrates with package managers and repositories, and builds and other common tasks to make everyday workflows faster. And Code understands Git, and delivers great Git workflows and source diffs integrated with the editor.

If you’re hardcore Microsoft product developer, Visual Studio Code also integrate with Microsoft’s existing cloud development solutions powered by Azure or Visual Studio Online. So, the entire application development can streamlined and faster the development process.

Overall, Visual Studio Code can consider as another serious IDE development tool to build and debug modern web and cloud applications.

Visual Studio Code is free to download and available on your favourite platform – Linux, Mac OSX, and Windows.

Download Visual Studio Code

5 Eye-Opening Facts You Need to Know About Bots and DDoS Attacks

If there’s one thing bots are good for, it’s crawling websites on behalf of search engines and social media platforms to help those sites gain visibility. But if there’s two things bots are good for, it’s that, and helping people who don’t know much about internet security sound like they do. When in doubt, blame it on bots. Someone’s website went down for two days to a DDoS attack? Darn bots. Someone else’s website is getting inundated with spam? Geez, bots strike again. And someone else’s website got its content scraped? Come on bots, take a break.

The reason it’s so easy to blame everything on bots is because there are so many bots out there doing so much stuff on the internet that they’re involved in pretty much everything. Most people have no idea how pervasive, busy and even malicious bots can be. But for the good of websites everywhere, that has to change. Here are five facts about bots that will open your eyes to what’s really happening on the internet and on your website.

Fact 1: Your website is very popular with the bot demographic.

Bots both good and bad are busy little buggers, and they account for between 56 and 80% of all website traffic. “But wait,” you may be thinking, “I run a small custom cat sweater website. There’s no way I’m getting that much bot traffic.” Here’s a couple pieces of bad news for you. The first is that you run a custom cat sweater website. The second is that it’s those small sites with up to 1000 visitors per day that are getting 80.3% bot traffic. Medium-sized sites with up to 10,000 visitors are getting 63.2% bot traffic, and large sites with a million plus daily visitors are getting 56.2%.

Even though a large number of those bots are good bots, that’s still a big chunk of your traffic being accounted for by non-humans. This isn’t to say that you can no longer brag about your traffic numbers. Hey, go ahead. Just be aware that you aren’t getting your site in front of as many actual eyeballs as you previously thought, and keep that in mind when you’re laying out your marketing strategies.

Fact 2: Your website is more popular with the bad bot demographic than the good.

Now that you’ve absorbed the shock of how much of your traffic isn’t coming from actual people, here’s another kick in the pants: 29% of all website traffic comes from bad bots. Good bots make up about 27% of all traffic. No matter if your site falls into the above small, medium or large categories, nearly one-third of all your traffic comes from malicious bots. Malicious bots are responsible for things like DDoS floods, hackings, click fraud campaigns, content scraping and spam.

Fact 3: The only kind of bots consistently displaying growth are the worst ones.

With bots accounting for so much web traffic, you wouldn’t be misguided in thinking that bots must be constantly growing. However, you would be incorrect. Overall bot activity actually declined 10% from 2013 to 2014. There is one category of bots that have displayed growth, though, and those would be impersonator bots, the most advanced malevolent bots.

While overall bot activity was declining from 2013 to 2014, impersonator bot traffic grew almost 10% in the same period. Impersonator bots are the only type of bot that have displayed growth consistently over the last three years. So what exactly are impersonator bots? They’re bots that pretend to be something they aren’t in order to bypass website security and wreak havoc, like launching DDoS attacks. Impostor Google bots are common, and other types include bots that imitate browser capabilities, spy bots, bots disguised by proxy servers, and of course DDoS bots.

bot traffic report

Source + Hi-Res image: Incapsula 2014 Bot traffic report

Fact 4: Impostor Google bots are the third most frequently used bots in DDoS attacks.

Everyone with a website wants to rank high in Google, and that means Google’s own bots are given unfettered access to any website they visit. Much like how celebrities are given special treatment everywhere they go. The thing is, sometimes it’s only someone pretending to be Bradley Cooper that placed that order for a complimentary bottle of $1000 champagne. And sometimes it’s an impostor posing as a Google bot to creep and crawl all over your website. So while your website is designed to roll out the welcome mat for Google bots, it’s also designed to do the same for convincing and dangerous impostors. In fact, internet security firm Incapsula found that a full 4% of all bots that appear to be Google bots are, in fact, impostors. It only gets worse from there: the same Incapsula study found that 23.5% of those Google impostors are being used in Layer 7 DDoS attacks.

Fact 5: Not everyone involved in a botnet has bad intentions.

A botnet is pretty much what it sounds like: a large grouping of bots organized by attackers to inflict major damage on a target website. Using that broad definition, it’s easy to paint everyone involved with the same brush. However, most people if not everyone whose computers have become involved in a botnet don’t have bad intentions. For that matter, most of the people involved in a botnet don’t have any sort of intention at all. That’s because they probably don’t even know they’re involved in a botnet.

Within the internet security community, botnets are often called zombie armies. That’s because a botnet is a group of computers that have been taken over for malicious purposes, typically with the use of malware. Without the computer owner even knowing, their machine is controlled by an external source and used for malicious reasons. DDoS attacks are a common botnet activity.

So with all that said, you see why blaming it on the bots is such a sound strategy. They’re incredibly common, incredibly busy, and they can be incredibly malicious.

Talk Helper – Free Skype Call Recorder

There are a lot of Skype Video recorder or Skype audio recorder in the market. Most of these Skype call recorder able to record Skype video conferencing or record Skype audio conversation in high recording quality.

Over here, we want to introduce another Skype call recorderTalk Helper, a reliable tool to record Skype audio and video calls in high quality format on Windows such as it will save Skype voicemails and video messages in AVI files with XVID codec supported and all Skype audio calls can be saved in MP3 or WAV format with stereo or mono option supported.

The best part of Talk Helper is totally free for personal and commercial use.

Talk Helper - Free Skype Call Recorder
Talk Helper – Free Skype Call Recorder

After finishing the Skype call conversation, you can navigate to C:\Users\ [Username]\Documents\TalkHelper, to access all Audio and Video recordings.

TalkHelper Features – Free Skype Call Recorder:

  • Save Skype Voicemail and Video Message Easily: The plugin helps user to save Skype voicemails and video messages instantly by just a click of a button. The files are saved locally on the disk which can be playback with suitable media player.
  • Auto Record Feature: TalkHelper starts recording all incoming and outgoing video and audio calls automatically as this feature gets enabled as soon as call is connected with Skype. User can turn off this in settings and can manually turn it on when they require. Also, there is an option to pause/stop recording in real time with just one click.
    Supports all versions: TalkHelper works smoothly on Windows, with current as well as older Skype versions

TalkHelper is a great Skype Call Recorder plugin to record all those important skype call conversations to browse through them when needed.

Supported platforms: Windows Vista / Windows 7 / Windows 8/ Windows 8.1 (32bit or 64bit)

Download Talk Helper – Free Skype Call Recorder

Besides that, there are other Skype call recorder you can consider: iFree Recorder