QBoard » Big Data » Big Data - Data Ingestion Tools : Sqoop, Flume, Kafka, Nifi.. » Sqoop vs Informatica Big Data edition for Data sourcing
User Dashboard

Sqoop vs Informatica Big Data edition for Data sourcing

Back To Topics
Tags : hadoop hive sqoop informatica-powercenter
  • 319 1

    I have a option of using Sqoop or Informatica Big Data edition to source data into HDFS. The source systems are Tearadata, Oracle.

    I would like to know which one is better and any reason behind the same.

    Note: My current utility is able to pull data using sqoop into HDFS , Create Hive staging table and archive external table.

    Informatica is the ETL tool used in the organization.

    Regards Sanjeeb

      December 14, 2021 12:08 PM IST
    0
  • 259

    Although this was asked an year ago, sharing new features in Informatica

    Informatica BDM version 10.1 supports Sqoop connectivity i.e. you can use Sqoop to read the data from RDBMS and load it into Hadoop/Hive

    Also, there are many new features in BDM version 10.2, especially the parameterization support in the developer tool and dynamic mappings.

      January 6, 2022 12:59 PM IST
    0