UiPath SQL Data Extraction Workflow
Budget: ₹100 – ₹400 INR
I need a UiPath workflow that connects to our SQL Server environment, extracts defined datasets, processes them according to a few business rules, and stores both the raw and processed results in target tables. The goal is to remove the manual SQL querying and file manipulation we handle each day and let the robot do it reliably on a schedule.
Key points I must see covered:
• Secure connection handling—credentials come from Windows Credential Manager, never hard-coded.
• Parameter-driven queries so I can change date ranges or table names without editing the XAML.
• In-workflow data validation (null checks, type conformity) before any write-back occurs.
• Exception handling that logs detailed messages to Orchestrator and rolls back the transaction when an error is thrown.
• A concise README explaining how to deploy the package and map it to an Orchestrator schedule.
Please build the solution in the current Long-Term Support version of UiPath Studio, use the official Database activities, and keep everything modular (separate sequences for extract, transform, load). I will provide the exact table list and transformation rules once we start; the finished project should be ready for direct import into Orchestrator followed by a quick test run on my machine.
Key points I must see covered:
• Secure connection handling—credentials come from Windows Credential Manager, never hard-coded.
• Parameter-driven queries so I can change date ranges or table names without editing the XAML.
• In-workflow data validation (null checks, type conformity) before any write-back occurs.
• Exception handling that logs detailed messages to Orchestrator and rolls back the transaction when an error is thrown.
• A concise README explaining how to deploy the package and map it to an Orchestrator schedule.
Please build the solution in the current Long-Term Support version of UiPath Studio, use the official Database activities, and keep everything modular (separate sequences for extract, transform, load). I will provide the exact table list and transformation rules once we start; the finished project should be ready for direct import into Orchestrator followed by a quick test run on my machine.
Related categories:
Copywriting
Data Processing
Data Entry
SQL
Microsoft Access
Copy Typing
Data Extraction