Integration of UiPath Document Understanding with External Databases

Help Documentation
,
1

Hello UiPath enthusiasts,

I’m exploring ways to integrate UiPath Document Understanding with external databases in my workflow. How can I efficiently extract data from documents using Document Understanding and then store or update this information in an external database? Are there any recommended activities or practices to achieve a seamless integration between Document Understanding and external databases in UiPath Studio?

2

Hi @Dhanu_Varma

To get info about DU

To connect UiPath with db,Refer the below video

Hope it helps!!

3

Integrating UiPath Document Understanding with external databases involves a practical approach:

  1. Extract Data with Document Understanding: Utilize Document Understanding activities, such as the “Machine Learning Extractor” or “FlexiCapture,” to extract relevant data from documents.
Machine Learning Extractor
{
   Input: Document
   Output: Extracted Data
}
  1. Transform Data for Database Insertion: Use activities like “Assign” or “Invoke Method” to transform the extracted data into a format suitable for insertion or update in the external database.
Assign
{
   TransformedData = TransformData(ExtractedData)
}
  1. Database Connection with UiPath.Database.Activities: Leverage the “Connect,” “Insert,” or “Update” activities from the UiPath.Database.Activities package to establish a connection with your external database and perform the necessary operations.
Connect
{
   ConnectionString: "YourDatabaseConnectionString"
}
  1. Transaction Handling: Implement transaction handling to ensure data consistency. Use the “Begin Transaction” and “Commit Transaction” activities to wrap database operations.
Begin Transaction
{
   Connection: DatabaseConnection
}
  1. Error Handling and Logging: Implement robust error handling mechanisms, including the use of the “Try-Catch” activity, to capture and log any errors that may occur during database interactions.
Try
{
   // Database operations
}
Catch (Exception ex)
{
   // Log the exception
}

By following these steps, you can seamlessly integrate UiPath Document Understanding with external databases in your UiPath Studio workflow.

1 Like
4

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.