Project Overview: Bi-Directional Data Migration System
In this project, I’ve developed a bi-directional data migration system that allows users to sync data between Excel and Supabase. The flow uses UiPath’s classic activities to automate data transfer in both directions through REST API calls.
Tech Stack are
UiPath Studio (Classic)– For building the automation workflows
Supabase – Cloud PostgreSQL database with RESTful API
Excel – Local data storage and manipulation
HTTP Requests – For API communication
JSON – Data format for serialization/deserialization
How It Works
- User selects direction of sync
- Data is read, serialized to/from JSON
- Sent/retrieved via Supabase API
- Logged and written to Excel
What’s Next?
- Auto-trigger sync on data changes
- Orchestrator-based scheduling
- Rollbacks & data integrity checks
Looking for Feedback & Collaboration
I’m eager to hear your thoughts on the project! Feel free to share your experience with automated data migration, or suggest improvements for the project. If you’ve worked on similar automations or integrations, I’d love to collaborate and exchange ideas.