Free ETL Tools

Free Talend ETL

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.

Remote Desktop Software To Replace TeamViewer

Teamviewer perhaps is the best remote desktop software or PC remote control software over the internet. It allows computer administrator having the possibility to remote controlling a Windows computers, Mac, ipad, iphone and any Android devices. All this remote assistance can be done in front of your workstation to gain the access to files, different folders and full control the computer. Plus more, this free remote desktop software also benefiting the computer administrator to monitor system health or use remote control to solve issues on the fly.

However, Teamviewer is not the only free remote desktop software on the market. But there are plenty of remote desktop software freeware can perform remote computer access functionality similar like teamviewer or more. So, below are  the list of free remote desktop software that we recommended.

Other Remote Desktop Software To Replace Teamviewer:

LogMeIn

log me in - mac Windows remote access computer software

LogInMe is a remote desktop software that provides full remote access on remote computer with sound effects, printing, big file transferring and many more. Meanwhile, this remote desktop software using a proprietary remote desktop protocol and SSL certificate to cryptographically secure communications between the remote desktop and the accessing computer. Plus more, Log Me In support on Windows computer and Mac.

Visit LogInMe

Microsoft Remote Desktop Connection

Remote Desktop Connection Windows mac

Microsoft also owning their own remote desktop software named as “Remote desktop connection”.  Windows based remote desktop connection allows Windows users using Macintosh computer or Windows computer to remotely control a Windows-based computer or Windows servers.

Microsoft Remote Desktop Connection offers:

  1. Audio Redirection allows users to run an audio program on the remote desktop and have the sound redirected to their local computer.
  2. File System Redirection allows users to use their local files on a remote desktop within the terminal session.
  3. Printer Redirection allows users to use their local printer within the terminal session as they would with a locally or network shared printer.

Meanwhile, Remote desktop connection software is a standard bundle software for Windows XP, Vista, Windows 7, Windows 8, Windows server 2003, Windows server 2008 and Windows server 2012. Windows user doesn’t need to pay additional money to get this remote access software.

Visit Microsoft Remote Desktop Software

UltraVNC 

UltraVNC Viewer

UltraVNC is an open source remote desktop software that displaying the screen of another computer (via internet or network) on your own screen. Once the remote PC connection established, you can use your mouse and keyboard to control the other PC remotely. It means that you can work on a remote computer, as if you were sitting in front of it, right from your current location. Plus more, Ultra VNC can remote access various operating system computer or server under Windows, Linux and Mac.

Visit UltraVNC

Radmin 3 Control Software

Radmin3 - remote admin software

Radmin means Remote Administrator, is a award winning commercial remote desktop software that lets you work like you are working in the real computer during accessing remote computers. Radmin offers tons of remote desktop features such as full control access mode, remote desktop view mode only, text messaging, voice chat, file transfer, remote telnet and remote computer / server shut down or restart action.

Meanwhile, Radmin 3 fully supports Windows 8 including User Account Control and Fast User Switching.

Visit Radmin 3

TightVNC

tightvnc viewer

TightVNC is a remote desktop software that compatible to any standard VNC software.

It also uses so-called “tight encoding” of areas, which is effectively a combination of JPEG compression and other types of encoding. TIghtVNC is possible to watch videos and play DirectX games through TightVNC over a broadband connection at a low frame rate and comes with many other common features of VNC derivatives, such as file transfer capability.

Visit TightVNC 

Remobo

remobo - remote desktop software

This free remote desktop software is different from others, which it provides a virtual private network connection between users to ensure highest security connectivity to access your computer files, share files, photos & media, secure all your messages and file transfers against hackers.

It also supports Windows, MAC & Linux.

Visit Remobo

Mikogo – Remote Desktop

mikogo cross platform remote access computer software

Cross platform free remote desktop software assist you conducting remote PC support services. Besides remote PC support, it also supports online meeting and web conference on the same. It can support share any screen content or application over the Internet in true color quality with up to 10 participants simultaneously, while still sitting at your desk.

To get started, the organizer need to start a session from their desktop, then they will receiving an unique 9-digit session ID from Mikogo server, plus distributes the session ID to their participants. Then others participants open their Internet browser, go to www.mikogo.com and click on “Join Session”.

There are no installations or registrations required for the participants. They simply run the software and enter the session ID. Once connection is instantly established, and the participants can view the organizer’s screen in real time via the Mikogo viewer window.

If you know any remote desktop software can be Teamviewer alternative, share with us !

Free Mac Password Manager To Secure Password Info

Keepass X Mac Password Management Free

Password manager application is a security password management software that provides virtual vault to store your login password information pertaining to email, application or other confidential stuff. This password manager application can help to remember various passwords being used in daily life. Meanwhile, a far easier and more convenient way of keeping your passwords both safe and secure is to use a password storage utility, which can be accessed with a single master password.

Over here, we will explain some of best password manager for mac, which allows create and maintain a secure, encrypted database of all your passwords on Mac OSX platform. Some of the password program for Mac are lightweight application and portable. Besides that, The password managers on below list have a variety of benefits that will make your computing life easier and more secure:

  • Encrypting passwords and data using Advanced Encryption Standard (AES)
  • Automatically and securely logging into websites as you’re surfing
  • Browser auto-fill for your personal info, so you can make quick work of shopping or registration
  • Helping you generate customizable, secure passwords so they’re not easily cracked
  • Backing up and restoring your passwords so you aren’t up a creek if something happens to your machine

Mac Password Manager list:

Passlook – Mac Password Manager freeware

Passlook Free mac password manager

 

Passlock mac password manager doesn’t have killer look or elegant interface, but it’s easy to use and allows you encrypted password within few steps. When you launch mac password manager tool, a small interface with search box and buttons labelled Find, Add New, and Help. You can store any details such as website or application name, username, password, description and website address (if any) on Passlook.

All entered password will automatically copied to Windows clipboard, letting you instantly paste it into the required location, should you need to. There also an “Export All Passwords” options on Passlook mac password manager that allows you copies the entire password database to clipboard, allowing you to paste the data in a text editor.

Besides that, the application also allows to specify a master password to lock PassLook, so no one but can only accesses the passwords database. To specify the master password, simply click ‘Lock Program’ from the File menu. There are also hotkeys available for all these functions.

Plus more, you can set custom security question and answer to help you reset the master password in case you forget in the future.

PassLook is a portable application that works on Windows and Mac OS X. The Password manager also can run on Windows 8 Pro, 64-bit.

Download PassLook – Mac Password Manager Freeware

LastPass – Universal Password manager for Mobile, Desktop and Web Browser.

Lastpass password manager

 

The main goal of LastPass password manager is allowing you remember one master password and knowing the rest of password information. The best part of LastPass is all your password data is securely synchronized across all devices giving you access to it anywhere at anytime.

On operating, LastPass Password Manager also has a form filler that automates password entering and form filling. It also supports password generation, site sharing and site logging. Meanwhile, they also offer a couple of different methods (such as an onscreen keyboard for password entry) to protect against keyloggers. Plus more, you can even import and export data, and securely share your login credentials with others and create secure notes.

Cost: Free. A Premium version is offered for $1 per month and includes mobile version, among many other features

Lastpass Supported Platform

  • Mobile OS:  Apple iOS, Blackberry, Windows Mobile, Windows Phone, Android, WebOS, Symbian
  • Operating System: Windows, Linux and Mac OS
  • Web Browser: Safari, Opera, Firefox, Internet Explorer and Google Chrome

Visit LastPass – Universal Password Manager

KeePassX – Open source Mac password manager

Keepass X Mac Password Management Free

 

KeePass is a free mac password manager that managing your passwords in a secure way on Mac. All you need remember one single master password or select the key file to unlock the whole password database. All passwords will be stored on database, which encrypted using 256bits secure encryption algorithms known as AES and Twofish.

Meanwhile, KeePassX has the ability to import passwords from PwManager (*.pwm) and KWallet (*.xml) files and allows you to export your passwords as text files.

Plus more, KeePass also support Windows and Linux besides of Mac platform

Visit KeepassX

Pastor – Simple Free Mac Password manager

Pastor simple password manager

 

Pastor is a simple password management solution that doesn’t contain many features. It can save all your passwords, logins, serials, registrations and other sensitive information with encrypted and password-protected.

Besides that, Pastor password management also built in password generator, and is extremely easy to use. Pastor also runs on Mac OS 10.2 and up, so it is a great choice for older Macs.

Visit Pastor

Password Bank Vault for Mac

Password bank vault Mac

 

This free password manager offers to store all your passwords information in one easy place with just one master password to remember. All stored passwords entries will be 128 bit encrypted.

It offers various features such as insert, edit , delete, sort, change master password, random password creation, password to clipboard & auto save. Plus more, Password Bank Vault for Mac also allows mac user import & export data to and from spreadsheets in CSV format, backup / restore database feature as well as a special lock screen facility for unwanted prying eyes.

Visit Password Bank Vault for Mac

Do you use any of the Mac password managers mentioned in this post? If so, what’s your opinion of them? If not, do you have any other free mac password manager you highly recommend?

Collabtive: Free Open Source Light Weight Project Management Tool

collabtive

Before starting off any Project or Assignment, it’s important to formulate a strategy or a plan, which will be followed during the course of project. Also, it needs to be within a pre-decided budget, and must be completed within a specified deadline. Hence, there is a requirement of continuous monitoring of the project by the Project Manager. However, managing such a thing without any software is next to impossible, because of multifarious jobs associated with a project. Microsoft Project can be one of the solutions, but it might repel those, who do not want to invest on the software.  In such a case, Collabtive Project Management Utility can come to your rescue.

Collabtive is free open source project management software. It is a PHP based, and therefore requires PHP support on the system. The utility can support unlimited project or tasks and there is no restriction on the number of users or members to be assigned to a project. It also facilitates role based permission management, file management, time tracking, generation of reports (in various formats), RSS feeds and email notifications.

As mentioned above, the software requires PHP support. The best way to achieve the same is by installing WAMP on the system. You can download it by clicking here. The following login screen will be displayed thereafter.

collabtive - online project management

 

Once the login is performed, the desktop will be visible. The desktop tab shows you all the current projects along with the calendar. It also lets you know the percentage of project completed and the number of days remaining for completion of project. You can also start a new project in this page and allocate the deadline.

collabtive2

 

The utility is also featured with an activity log, which shows the list of activities performed while managing projects. Thus it becomes easier for manager to track all the events later on.collabtive4

 

collabtive open source project management

The tasklists bar lets you assign tasks in a project. For example, you can add project members, assistants or may be some interview schedule.

Overall, Collabtive is a decent project management utility. Though, it lacks Gantt Chart and few other services that its counterpart features, but it`s definitely good for those who do not want to spend a penny on utilities like Microsoft Project. However, if you are not satisfied with this, then you can have a look at various other free project management tools by clicking here.

Download Collabtive – Online Project Management

Free DJ Software For Mac and Windows

Here is free DJ Software list that allows DJ in music industry to mix or composing the music. Most of the digital DJ (Digital deejaying) Software that listed below allow beginners and professional DJ composing digital music or remix original soundtrack to keep beat, playback, so you can listen to what you’ve composed, input. Plus more, Most of DJ software support various music formats such as MP3, WMA, AAC, OGG, WAV, FLAC or CDs in real time.

Some of DJ Software that going to introduce also can hook music instrument or microphone directly to your computer and notate a song you play or sing and tons of editing tools.

If you have some inclination towards the DJ-ing and are looking for free tools, below is the list of best free DJ Software for Mac and Windows.

Free DJ Software For Mac and Windows:

Mixx – Open Source MP3 DJ Mixing Software

Mixx – Free DJ Software

Mixx perhaps is one of the best free DJ software for Mac, Windows and Linux. This open source DJ software comes with stretch handling, crossfader curve control, music equalizer, vinyl control software and the most advanced MIDI controller to mix soundtrack on real life DJ equipment.

Mixx open source DJ software comes with dual decks, which each deck features a scretchable, scrolling waveform that marks beats and cue points, along with a whole-song waveform overview for quick seeking. Meanwhile, DJ can speed up and slow down songs without changing their pitch with time stretching plus their high-quality interpolator can also reproduce classic vinyl sounds like backspins.

Mixxx DJ software also features audiophile butterworth filters with adjustable EQ shelves and Crossfader curve control lets you deliver quick cuts or long, smooth crossfades.

Visit Mixx – Free DJ Software

Kramixer – Free Windows DJ Software

Kramixer – Free Windows DJ Softwae

Kramixer is free Windows DJ software has an impressive (and colorful) DJ remix interface for non-commercial use purposes. It’s a simple DJ software that allows DJ remix two audio channels and uses the FMOF engine. Meanwhile, this free DJ software also equipped with standard DJ real-time effects such as echo, reverb, low pass, and even a robotic effect that’s great for vocals. It’s also possible to record your mixes as MP3 files.

Kramixer free Windows DJ software is running on optimized mode by default, which is essentially core set of features that ensures that there aren’t any sound problems. To get the maximum out of Kramixer, you’ll need to switch to the full-featured mode that turns on all the available effects.

Visit Kramixer

DeKstasy – Free Mac DJ Software

Dekstasy – Free MAC DJ Software

Free Mac DJ Software comes with four 4 turntables together to help you do DJ-ing on Mac from the task of extracting tracks from audio CDs to looping, adding effects and to saving the final track.

With DeKstasy Free Mac DJ Software, you can:

  • Encode and import tracks from Audio CDs or records, or simply import pre-existing MP3’s.
  • Analyze a file’s BPM and create an exact beat signature for TRUE beat matching.
  • Play tracks on four virtual decks, all at once and all perfectly synced up.
  • Automatically beat match to any external audio signal — makes tag-teaming a breeze!
  • Easily loop sections of playing tracks, all live and in real time.
  • Visually set up the mix without worrying about the synchronization of the tracks, allowing you to stay focused on the mixer and not on the decks.
  • Organize all your tracks into virtual Crates and Albums.

Visit DeKstasy

Virtual DJ Software Free Home Edition

Virtual DJ – Free DJ Home Edition

Virtual DJ Home is available Free for non-commercial use. However, VirtualDJ Home comes with includes nearly all the features of Virtual DJ Pro, with only a few limitations.
If you don’t own or don’t plan to use any additional DJ hardware (mixer, turntable, DJ controller or video projector), then Virtual DJ Home will meet all your requirements. Plus more, Virtual DJ software support on Mac and Windows

Visit Virtual DJ Software Free Home Edition

Ultra Mixer 2 Free Edition 

UltraMixer – Free DJ Software

Ultra Mixer 2 free DJ software is available on Windows and Mac. This free DJ software give gives private users a first insight into the world of digital mixings. It works on the popular formats like MP3, OGG, WAV and integrated with Sound Players, which are used as turntables.

Ultra Mixer Free contains all basic functions a virtual DJ needs. The intuitive and clearly structured user interface enables you to use the software right away, and supports you on your way to the new Star DJ. However, UltraMixer Free contains a splash screen, that appears every time you start the program. You can dispose of this screen by purchasing a license.

Visit Ultra Mixer 2 Free Edition

If you know other free DJ software should include on above list, share with us!