{"id":46553,"date":"2017-02-24T17:02:48","date_gmt":"2017-02-24T11:32:48","guid":{"rendered":"http:\/\/www.tothenew.com\/blog\/?p=46553"},"modified":"2017-02-24T17:04:57","modified_gmt":"2017-02-24T11:34:57","slug":"advantages-of-an-etl-tool-in-content-migration","status":"publish","type":"post","link":"https:\/\/www.tothenew.com\/blog\/advantages-of-an-etl-tool-in-content-migration\/","title":{"rendered":"Advantages of an ETL Tool in Content Migration"},"content":{"rendered":"

Recently, I was introduced to a new technology called ETL (Extract, Transform and Load) which I can use to simplify and to increase the productivity of my daily tasks as AEM migration developer. There are various ETL tools available, some of them are listed here<\/a>.\u00a0I chose Talend, as it is built on top of Eclipse IDE and supports custom Java code.<\/p>\n

Outlined below are some of the advantages almost all ETL tools have over writing custom migration scripts from scratch:
\n<\/strong><\/p>\n

    \n
  1. Visual flow<\/b>: All ETL tools provide a visual flow of the system’s logic which makes the migration process a lot more interactive than creating the scripts in a plain IDE. Generally, there is no manual coding required to create a basic migration process<\/a> due to the availability of the out-of-the-box modules. This reduces the learning curve for any new adopters.<\/span><\/span>\"Visual<\/a><\/li>\n
  2. Choice of Programming language<\/b>: Whenever there is a need to write code, it can be written in a programming language of your choice. This totally depends on coding languages supported by an ETL tool. This makes the tool more comfortable to use and hence reduces the learning curve.<\/span><\/li>\n
  3. Modularity<\/b>: An ETL tool is completely based on independent modules which are like black boxes and are only concerned about the input they receive and the output they produce. You can very easily plug in\/out, using drag and drop\/delete option respectively without disturbing other modules.<\/span><\/li>\n
  4. Performance<\/b>: The optimized and performance tested modules help achieve a task in the least time possible.\ufffc<\/span><\/li>\n
  5. Easy understanding and maintenance<\/b>: The click and drag programming snippets help achieve a basic task even if a person doesn’t know any programming language like append or replace some text in strings. The visual aspect helps in increasing understanding of the logic and in easy maintenance of the scripts. <\/span>
    \n<\/span>Here are a few examples:<\/strong><\/p>\n