Hello Everyone, Hope you are doing good
I would like to present this tutorial who are looking for integrating PostgreSQL With Uipath
Following steps are required
- Open Uipath Studio, and create new project
- From manage packages, search Database in All Packages and Download Uipath Database Activities Pack
- Create new activity and search for connect to data base and drag drop the activity.
- Then click configure connection button
- Edit connection setting will open, then click connection wizard
- Choose the Data source window that will open in it. Then drop down the options in Data sources in which select Microsoft ODBC Data Source. Then Click Data Provider drop down box and select .NET Framework Data Provider for ODBC.
- Then select Use user and refresh it then select PostgreSQL35W.
- Enter User name: postgres, Password : root (note: Password should be in Lowercase). And click Test connection. Test connection Succeeded message will be displayed in it.
For Reference
How to write data from PostgreSQL to Excel Sheet
-
In Connect to database activity, Create a new Variable to store info with variable type of Uipath.Database.Databaseconnection (If press ctrl+k on output, it will create variable type automatically).
-
Next search Run Query in database activity then drag and drop it. In edit query write the query Syntax within “query syntax”. For Example “select * from company” to select whole information from Company Table. Then create output variable for this activity to store value from sql database.
-
By using Excel Application scope we can write data from run query to excel by passing variables from run query.
Questions
For questions on your retrieval case open a new topic and get individual support
Feedback
Click button to share your thoughts
Best Regards
Gokul