Automated e-Time to SAP Integration

Our e-Time machine stores every punch in its MSSQL back-end, but right now that data is exported and uploaded to SAP HR manually. It is slow, error-prone and holds up payroll. I need you to replace the manual step with a daily, unattended interface that:

• Reads the new attendance rows (Employee ID and their in/out timestamps) directly from the MSSQL tables.
• Runs a quick validation—duplicate punches, missing employee numbers, impossible times—before anything touches SAP.
• Posts the clean records into SAP HR/Time Management through the appropriate BAPI, IDoc or RFC so they appear in time evaluation the same day.
• Produces a simple log: how many records processed, how many rejected, and any error details.

A configurable schedule (Windows Task Scheduler, SAP background job, or similar) is fine as long as it runs every 24 hours without manual intervention. Keep the solution lightweight: standard .NET, Python, PI/PO, or ABAP function modules are all acceptable; just choose what you are comfortable supporting and document the connection details and code clearly.

When I can see the punches in SAP automatically each morning, with a concise success/error report in my inbox, I’ll consider the job done.