I will sync sql database with saudi zatca phase 2 fatoora API


About this gig
Are you using a desktop SQL system, local ERP, or legacy POS in Saudi Arabia facing ZATCA Phase 2 compliance holds?
Upgrading your entire software ecosystem is expensive and unnecessary. I build lightweight, secure intermediate API listeners and middleware (C#, Python, Node.js) that sit between your existing SQL database (MS SQL, MySQL, PostgreSQL, Oracle) and the Saudi Fatoora portal.
Every invoice printed by your cashiers is automatically signed, stamped, and transmitted to ZATCA in real time without changing your staff's workflow.
Enterprise ZATCA Middleware Capabilities
Database Table Monitoring: Automated triggers/listeners detect new sales records instantly.
Payload Generation: Auto-converts database rows into compliant ZATCA UBL 2.1 XML files.
Real-time API Push: Submits payloads to the Phase 2 clearance/reporting portal endpoints.
QR Code & Hash Write-Back: Grabs returned Base64 TLV QR codes and writes them back to your SQL database for instant thermal receipt printing.
Offline Fail-Safe Queue: Caches local transactions during internet outages and auto resubmits when reconnected.
Supported Systems: MS SQL Server, MySQL, PostgreSQL, Oracle, SQLite, Custom ERPs.
Avoid massiv
Get to know Razan
Senior API Engineer Shopify ZATCA Phase 2 E Invoicing Specialist
- FromSaudi Arabia
- Member sinceAug 2026
Languages
English
Other Software Development Services I Offer
FAQ
What happens if our internet connection drops at the store?
A: I configure an asynchronous offline queue. The system stores transactions locally with proper hash sequences (PIH/ICV) and pushes them to ZATCA the moment the internet reconnects.
Do we need to replace our existing POS or desktop SQL system?
A: No. The sync engine works in the background. Your staff continues using your current system as usual while the script handles all ZATCA API calls silently.

