How to configure a Data Lake to store data from ServiceNow?

[Manthan98]

Hi Experts,
I have a custom table (u_cat_item_feedback) that stores user feedback for specific catalog items. The requirement is to transfer this data to a data lake and then delete records older than 12 months. I understand that Table Cleaner rules can handle the deletion, but I need guidance on the data lake integration.

As a beginner in this area, I would greatly appreciate any insights on the following:

1. What data lake solutions are available and easy to integrate with ServiceNow?
2. Are there any existing plugins or spokes that could simplify this process?
3. Any recommendations on the best approach for implementing this?

[Ankur Bawiskar]

@Manthan98 

will ServiceNow push data to data lake -> If yes then you need to discuss with data lake team to share the Endpoint and how it expects the data

If data lake will be pulling data from that table of ServiceNow -> if yes then you need to create a scripted REST API and accept the request and give data of that table as API response

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Manthan98]

Thank you @Ankur Bawiskar for quick response. This is helpful.
Could you please throw more light on

1. What data lake solutions are available and easy to integrate with ServiceNow?
2. Are there any existing plugins or spokes that could simplify this process?

[Ankur Bawiskar]

@Manthan98 

there is no spoke for that.

You will have to build custom solution for this.

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Ankur Bawiskar]

@Manthan98 

Hope you are doing good.

Did my reply answer your question?

If my response helped please mark it correct and close the thread so that it benefits future readers.