SAP HANA Periodic JSON Data Export

Job ID: 40222164

Budget: $8 – $15 USD

I need a techno-functional specialist who knows SAP HANA inside-out to set up an automated pipeline that pulls data from three live modules—Financial (FI), Production Planning (PP) and Plant Maintenance (PM)—and ships it to a remote server on a fixed schedule.

Here is what I am after:

• Build or configure the job inside HANA Server (HANA DB with query language access, or any proven method you recommend... No additional connector licenses will be bought) so that it extracts the required tables and views, converts the output to clean JSON and pushes it to the destination path via SFTP or a comparable secure protocol.
• The transfer must run on a schedule that I can adjust easily (hourly, daily thrice weekly, etc.) without redeploying code. Preferably leave the cron definition to me
• Include basic logging and error handling so I can see when a run succeeds or fails.
• Provide clear hand-over documentation and a brief walkthrough so my in-house admin can maintain or tweak the job.

You will get direct access to a sandbox system first, followed by production once the solution is validated. If you have already built similar scheduled JSON exports from FI, PP or PM data before, let me know—samples or brief references will help me decide quickly.

My estimate 10 to 12 hours