Information View to Hadoop Data

[former_member606766]

How do we sync the data between Hana Information views and Hadoop.

We have information views with some logic written and we would like these data to flow into hadoop as well. Since the information views are runtime objects how do we ensure the data gets replicated into hadoop despite of the input parameters (raw data prior to input parameter)? Is that even a possibility?

Secondly, lets say we have a user with xyz restrictions on row level on the information view and how does that work with Hadoop?

[deodutt_dwivedi]

Hi Sam,

You need to use an ETL tool to perform this data transfer, you can use SQOOP, NIFI etc for the same. In SQOOP, you can write .config(option) files and mention your query based on views, along with input parameters, connection details such as host-name, port, user id password. You will need an user id in HANA to perform this task where the access control can be provisioned.Now regarding the raw data without the input parameters not sure what you meant by this. In case you need to replicate tables, you can write a query over the table and digest the same way mentioned above.

Regards,

Deo