How to connect Impala/Hive with Informatica

[sid2707]

Hi Folks,

Can you kindly help to connect Impala with Informatica.I have gone through multiple blogs of Cloudera and Informatica but dint found the exact procedures to follow.

Thanks in advance

Sidharth

[MSharma]

Are you getting any error while connecting ?

what kind of security is enabled for LDAP ?

[sid2707]

I have enabled kerberos. I have installed informatica on Aix.Now, I am
trying to connect informatica with impala using jdbc connection but it's
not able to read the ticket from cache.

[MSharma]

it could be kerberos configuration issue on informatica server side.

can you share more detail ?

[Abhi]

Old thread but here is a way to connect to Hive and kudu using impala through Informatica Bigdata management

https://network.informatica.com/community/informatica-network/products/big-data/big-data-management/...

[alexmc6]

But with Informatica BDM you also have Blaze and Spark as alternative engines to Hive. The original post was quite vague and may not have been BDM related at all.

[Abhi]

I didnt quite understand your statement..why does it matter if BDM has other execution engines like Blaze and spark?

Impala itself is another execution engine like spark and blaze, we dont need to use impala jdbc connection in BDM using spark and Blaze you can just use it in native mode.