Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Can ETL informatica Big Data edition (not the cloud version) connect to Cloudera Impala?

We are trying do a proof of concept on Informatica Big Data edition (not the cloud version) and I have seen that we might be able to use HDFS, Hive as source and target. But my question is does Informatica connect to Cloudera Impala? If so, do we need to have any additional connector for that? I have done comprehensive research to check if this is supported but could not find anything. Did anyone already try this? If so, can you specify the steps and link to any documentation?

Informatica version: 9.6.1 (Hotfix 2)

like image 693
sun_dare Avatar asked Dec 23 '15 21:12

sun_dare


People also ask

What is the platform on which Informatica BDM is developed on?

Informatica BDM is capable to run created mappings by using the power of the hadoop platform.

Is Informatica Big Data?

Informatica Big Data Management enables your organization to process large, diverse, and fast changing data sets so you can get insights into your data. Use Big Data Management to perform big data integration and transformation without writing or maintaining external code.


1 Answers

You can use the odbc driver provided by cloudera.

http://www.cloudera.com/downloads/connectors/impala/odbc/2-5-22.html

For Irene, the you can use the same driver the above one is based the simba driver.

http://www.simba.com/drivers/hbase-odbc-jdbc/

like image 199
shaine Avatar answered Oct 19 '22 08:10

shaine