1

I have need of regarding HIVE table using Informatica and then write the data after some transformations to MS SQL table.

Can anyone please let me know what is the driver / connector required to connect to Apache HIVE from Informatica. Is there any specific Informatica version from which this is supported?

Koushik Chandra
  • 1,565
  • 12
  • 37
  • 73

1 Answers1

1

Informatica Big Data Edition (BDE) supports Hive both as a source and target.

More information: BDE User Guide

Marek Grzenkowicz
  • 17,024
  • 9
  • 81
  • 111
  • Could you please provide the link pointing to the Informatica documentation in this case. – Koushik Chandra Apr 12 '16 at 05:06
  • @KoushikChandra What exactly do you need to know? Here's a [BDE User Guide](https://marketplace.informatica.com/mpresources/docs/IN_960_BDETrial_UserGuide_en.pdf). – Marek Grzenkowicz Apr 12 '16 at 11:10
  • As of now I am not very clear of the requirement, but only thing I know is that the Informatica version whatever the client is using is different from BDE, so I think read will not supported .. right? – Koushik Chandra Apr 15 '16 at 06:41
  • It is important to remember that you need to use Informatica Developer, not Informatica PowerCenter Designer. – Marek Grzenkowicz Apr 15 '16 at 08:39