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?
Informatica Big Data Edition (BDE) supports Hive both as a source and target.
More information: BDE User Guide