Integration with Data lake DB

[RajkiranPaul]

We are working on an integration with data lake DB from RSA . Data lake db is using Hive framework to store raw data. Do we have any OOTB  integration approach present  to connect with data lake db and pull /push the records?  if not,then what are the alternative approaches ? Kind help

[MHelmy · Accepted solution]

If you take a look at the discussion here Re: How to setup Identity Governance & Lifecycle collector with Cloudera? . In theory we should be able to connect to any JDBC-based database connection.

I found a few links online explaining how to use JDBC with Hive Data Lake, but I am no expert here and have no idea how relevant this is 🙂

https://gpdb.docs.pivotal.io/5240/pxf/hive_jdbc_cfg.html

https://docs.cloudera.com/HDPDocuments/HDP3/HDP-3.1.5/integrating-hive/content/hive_connecting_hive_...

https://docs.cloudera.com/runtime/7.1.0/integrating-hive-and-bi/topics/hive_connecting_hive_to_bi_to...

Hope this helps.