AWS SQL Data Pull Pilot

I need a small-scale pilot that automatically extracts financial data from our AWS-hosted SQL database (Amazon RDS for SQL Server) and delivers it to our on-prem network server.

Core goals
• Connect securely to the RDS instance, authenticate with our IAM or SQL credentials, and query the required financial tables.
• Package the results in CSV or another lightweight format we can archive locally.
• Transfer the file over our VPN/SFTP share and confirm successful arrival with basic logging and error handling.
• Provide a parameterised script or lightweight utility (Python, PowerShell, or similar) plus a concise README so my team can adjust schedules and credentials without touching the code.

Success criteria
• End-to-end run completes from AWS to our network server in <5 min on a sample dataset.
• Logs show clear pass/fail status and capture any exceptions.
• Code is clean, commented, and ready for extension to a full production workload if this pilot proves solid.

If this initial pull works smoothly, I’ll extend the engagement to include incremental updates, monitoring, and additional data domains.