SAP HANA Periodic JSON Data Export
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
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
Related categories:
SQL
Oracle
SAP
MySQL
Database Development
JSON
Data Integration
SAP HANA
Automation
Data Management