Extract country-wise holiday lists from open websites into SAP tables

[kumar_c_4]

📣 Open for Any Wild and Cost-Efficient Ideas!

Hi everyone!

I’m on the hunt for effective ways to extract country-wise holiday lists from open websites into SAP tables for BW modeling and reporting.

What tools or techniques have you found useful for web scraping and data transformation? Any tips for integrating this data into SAP BW effectively?

[GSinghdeo]

There are several open websites which allow access to their holiday database via API calls.

A possible design could be something like below:
1. Create an ABAP program which leverages the CL_HTTP_CLIENT=>CREATE_BY_URL method to make API calls to the open website database.

2. Save the API response in a SAP table.

3. Expose the table data via CDS/HANA view and use it in your BW model. 

References:

Client Architecture (SAP Library - Components of SAP Communication Technology)