# \#sql-database **URL:** https://forum.uipath.com/tag/sql-database/2493.md [Latest](https://forum.uipath.com/latest.md) · [Categories](https://forum.uipath.com/categories.md) · [Tags](https://forum.uipath.com/tags.md) --- ## [How to run packages in sql database](https://forum.uipath.com/t/how-to-run-packages-in-sql-database/5465496)
**Author:** [@Mathkar\_kunal](https://forum.uipath.com/u/Mathkar_kunal)\ **Replies:** 2\ **Last updated:** [September 29, 2025, 4:31am UTC](https://forum.uipath.com/t/how-to-run-packages-in-sql-database/5465496 "2025-09-29T04:31:31Z")
Hello, my requirement is need to run packages in sql. for now once we trigger the package we are getting mail in outlook. how can we do this using UiPath , after conencting to database? help me to resolve this --- ## [What is the logic in document understanding workflow to extract details from different documents like HealthCard, PR, Driving License, Bills etc in KYC onboarding process automation?](https://forum.uipath.com/t/what-is-the-logic-in-document-understanding-workflow-to-extract-details-from-different-documents-like-healthcard-pr-driving-license-bills-etc-in-kyc-onboarding-process-automation/3447850)
**Author:** [@Vaishnav\_Tej](https://forum.uipath.com/u/Vaishnav_Tej)\ **Replies:** 6\ **Last updated:** [August 8, 2025, 6:42am UTC](https://forum.uipath.com/t/what-is-the-logic-in-document-understanding-workflow-to-extract-details-from-different-documents-like-healthcard-pr-driving-license-bills-etc-in-kyc-onboarding-process-automation/3447850 "2025-08-08T06:42:00Z")
Hi Everyone, I’m practicing KYC onboarding process automation using UiPath Studio. But I’m stuck with the logic. Goal is to automate: Email reading & classification Document extraction & validation(Document Unde… --- ## [Unable to Connect MySQL Workbench with UiPath Studio](https://forum.uipath.com/t/unable-to-connect-mysql-workbench-with-uipath-studio/2756521)
**Author:** [@jai\_kumar2](https://forum.uipath.com/u/jai_kumar2)\ **Replies:** 4\ **Last updated:** [March 17, 2025, 6:01am UTC](https://forum.uipath.com/t/unable-to-connect-mysql-workbench-with-uipath-studio/2756521 "2025-03-17T06:01:51Z")
Hi, I need to connect MySQL Workbench to UiPath Studio, but I’m unable to configure the connection. MySQL Workbench is already installed and configured, and I can access the database tables on my system. However, I can’t… --- ## [Database connection working on windows-legacy but not working on windows](https://forum.uipath.com/t/database-connection-working-on-windows-legacy-but-not-working-on-windows/764582)
**Author:** [@AsadPathan2665](https://forum.uipath.com/u/AsadPathan2665)\ **Replies:** 12\ **Last updated:** [November 1, 2024, 1:08pm UTC](https://forum.uipath.com/t/database-connection-working-on-windows-legacy-but-not-working-on-windows/764582 "2024-11-01T13:08:13Z")
Hi All, we are able to connect DB on Window legacy but unable to connect DB working on Window. how to resolved this issue in window. --- ## [Get column value out from SQL where column name is same as input](https://forum.uipath.com/t/get-column-value-out-from-sql-where-column-name-is-same-as-input/771322)
**Author:** [@Ellen](https://forum.uipath.com/u/Ellen)\ **Replies:** 3\ **Last updated:** [October 3, 2024, 8:48pm UTC](https://forum.uipath.com/t/get-column-value-out-from-sql-where-column-name-is-same-as-input/771322 "2024-10-03T20:48:20Z")
I have a queue item with name TIM and that same name also exist as column name like TIM in database data in database look like this. Herry, Tim, Tomy , Date 0,1,0, 03-10-2024 0,1,1,02-10-2024 I want to read Tim valu… --- ## [Database connect activity does not open wizard](https://forum.uipath.com/t/database-connect-activity-does-not-open-wizard/380977)
**Author:** [@srujana13a5](https://forum.uipath.com/u/srujana13a5)\ **Replies:** 18\ **Last updated:** [August 29, 2024, 10:37pm UTC](https://forum.uipath.com/t/database-connect-activity-does-not-open-wizard/380977 "2024-08-29T22:37:47Z")
My system os is windows 8,so I installed sqlserver2017 and i am trying to connect my studio with database and i am facing an issue that is when i am clicking on connection wizard in connect activity i am unable to get th… --- ## [Sql query to find where is the machine is disconnected](https://forum.uipath.com/t/sql-query-to-find-where-is-the-machine-is-disconnected/759458)
**Author:** [@Hazem\_Saleh](https://forum.uipath.com/u/Hazem_Saleh)\ **Replies:** 6\ **Last updated:** [August 12, 2024, 12:09pm UTC](https://forum.uipath.com/t/sql-query-to-find-where-is-the-machine-is-disconnected/759458 "2024-08-12T12:09:47Z")
Hello all im trying to write a query to find if the AVD machine is disconnected for more than 5 minute Or the job has been not running for example we had login issue i can see everything on alert page in Orchestrato… --- ## [How to import data from comma separated text file having 30 lakh rows and 19 columns into SQL Database Table](https://forum.uipath.com/t/how-to-import-data-from-comma-separated-text-file-having-30-lakh-rows-and-19-columns-into-sql-database-table/750734)
**Author:** [@sharad.bodke](https://forum.uipath.com/u/sharad.bodke)\ **Replies:** 2\ **Last updated:** [July 1, 2024, 12:25pm UTC](https://forum.uipath.com/t/how-to-import-data-from-comma-separated-text-file-having-30-lakh-rows-and-19-columns-into-sql-database-table/750734 "2024-07-01T12:25:09Z")
I am trying to read data from comma separated text file having 30 lakh rows. As I am unable to add this large data into data table due to the limitations of data size. I am trying to add the data in database so that I ca… --- ## [Db2 query passing a list of strings as an variable](https://forum.uipath.com/t/db2-query-passing-a-list-of-strings-as-an-variable/749617)
**Author:** [@hannahscott216](https://forum.uipath.com/u/hannahscott216)\ **Replies:** 1\ **Last updated:** [June 26, 2024, 11:42am UTC](https://forum.uipath.com/t/db2-query-passing-a-list-of-strings-as-an-variable/749617 "2024-06-26T11:42:15Z")
I want to pass a list of numbers (as strings) as the lookup ( where invoice\_num will be the list of strings ) for a db2 sql query , how do I use the list of strings variable in my sql query ? --- ## [Procedure or function '\' expects parameter '@\', which was not supplied.. While exporting variables to MSQL store procedure](https://forum.uipath.com/t/procedure-or-function-proc-name-expects-parameter-value-which-was-not-supplied-while-exporting-variables-to-msql-store-procedure/739713)
**Author:** [@aryan.guru](https://forum.uipath.com/u/aryan.guru)\ **Replies:** 4\ **Last updated:** [May 30, 2024, 4:27pm UTC](https://forum.uipath.com/t/procedure-or-function-proc-name-expects-parameter-value-which-was-not-supplied-while-exporting-variables-to-msql-store-procedure/739713 "2024-05-30T16:27:58Z")
I have a store procedure in SQL in which I have an insert query in which I’m inserting several values as log of the transaction happened in UiPath flow, after configuring the “Executing Non Query” Activity I am getting t… --- ## [How to build up connectivity between UiPath Webhooks and SQL server?](https://forum.uipath.com/t/how-to-build-up-connectivity-between-uipath-webhooks-and-sql-server/739059)
**Author:** [@punya](https://forum.uipath.com/u/punya)\ **Replies:** 2\ **Last updated:** [May 7, 2024, 8:24pm UTC](https://forum.uipath.com/t/how-to-build-up-connectivity-between-uipath-webhooks-and-sql-server/739059 "2024-05-07T20:24:11Z")
Hi, I’m trying to connect UiPath Webhooks with SQL server for a project purpose. If anyone has tried the way of calling to server through webhooks, as building up the endpoint URL, I would really appretiate your help. T… --- ## [Unable to Insert Parameter while using Excel as DB](https://forum.uipath.com/t/unable-to-insert-parameter-while-using-excel-as-db/723585)
**Author:** [@ch460960](https://forum.uipath.com/u/ch460960)\ **Replies:** 4\ **Last updated:** [March 1, 2024, 6:43am UTC](https://forum.uipath.com/t/unable-to-insert-parameter-while-using-excel-as-db/723585 "2024-03-01T06:43:16Z")
Hi all, I’m trying to dynamically assign values while using excel as DB Error: Run query: ERROR \[07002\] \[Microsoft\]\[ODBC Excel Driver\] Too few parameters. Expected 2. Command I’m Giving "SELECT SUM(PEJAMT) AS SUMTOTA… --- ## [Connection to database Sqlite](https://forum.uipath.com/t/connection-to-database-sqlite/722804)
**Author:** [@Geoffroy\_Pantegnies](https://forum.uipath.com/u/Geoffroy_Pantegnies)\ **Replies:** 2\ **Last updated:** [February 28, 2024, 7:51am UTC](https://forum.uipath.com/t/connection-to-database-sqlite/722804 "2024-02-28T07:51:15Z")
Hello everyone, I’m trying to connect to a database, and as I did not succeed with the UiPath activity “Connect to database”, I tried with another method, but I’m not doing better. If you find what’s wrong please let m… --- ## [SQL Server Standard vs Enterprise Edition](https://forum.uipath.com/t/sql-server-standard-vs-enterprise-edition/715199)
**Author:** [@haythem.huiji](https://forum.uipath.com/u/haythem.huiji)\ **Replies:** 1\ **Last updated:** [January 26, 2024, 10:00am UTC](https://forum.uipath.com/t/sql-server-standard-vs-enterprise-edition/715199 "2024-01-26T10:00:27Z")
Hello fellow UiPathers, I have a question regarding SQL Server EE & Standard in an on premises deployment, I know that the documentation states that you can use either, but how can we justify using EE over standard edi… --- ## [Orchestrator データベースのディスク使用量レポートの取得手順](https://forum.uipath.com/t/orchestrator/711999)
**Author:** [@system](https://forum.uipath.com/u/system)\ **Replies:** 0\ **Last updated:** [January 12, 2024, 7:59am UTC](https://forum.uipath.com/t/orchestrator/711999 "2024-01-12T07:59:31Z")
:light\_bulb: Answer Orchestrator データベースのディスク使用量レポートの取得手順は以下の通りです。 Windows のスタートメニューから「Microsoft SQL Server Tool」をクリックして展開し「Microsoft SQL Server Management Studio」をクリックします。 表示された「Microsoft SQL Server Management Stud… --- ## [Sql query excel](https://forum.uipath.com/t/sql-query-excel/706183)
**Author:** [@sereganator](https://forum.uipath.com/u/sereganator)\ **Replies:** 0\ **Last updated:** [December 13, 2023, 12:41pm UTC](https://forum.uipath.com/t/sql-query-excel/706183 "2023-12-13T12:41:04Z")
Hi all! Please tell me if there is a sql query: SELECT t.Train, t.Dest, r.MaxTime FROM ( SELECT Train, MAX(Time) as MaxTime FROM TrainTable GROUP BY Train ) r INNER JOIN TrainTable t ON t.Train = r.Tr… --- ## [UIPATH mariaDB Insert 오류](https://forum.uipath.com/t/uipath-mariadb-insert/701468)
**Author:** [@Ilgu\_Yong](https://forum.uipath.com/u/Ilgu_Yong)\ **Replies:** 8\ **Last updated:** [November 22, 2023, 4:20am UTC](https://forum.uipath.com/t/uipath-mariadb-insert/701468 "2023-11-22T04:20:27Z")
UiPath 지침에 따라 mariadb를 잘 설치하고 connect to database 까지 성공적으로 마쳤습니다. 그러나 data를 넣으려는 insert 구문에서 오류가 발생하였습니다. 오류의 내용은 아래와 같습니다. Insert: ERROR \[42000\] \[ma-3.1.19\]\[10.11.2-MariaDB\]You have an error in your SQL syntax; check… --- ## [How to add a queue item in orchestrator whenever a new item is added to sql database table](https://forum.uipath.com/t/how-to-add-a-queue-item-in-orchestrator-whenever-a-new-item-is-added-to-sql-database-table/701267)
**Author:** [@Palaniyappan](https://forum.uipath.com/u/Palaniyappan)\ **Replies:** 1\ **Last updated:** [November 21, 2023, 9:06am UTC](https://forum.uipath.com/t/how-to-add-a-queue-item-in-orchestrator-whenever-a-new-item-is-added-to-sql-database-table/701267 "2023-11-21T09:06:51Z")
Hi I m looking for a solution with which I can trigger a bot instantly in orchestrator whenever there is an update in sql database table Say for example if any record is added to a sql table I want that record to be ad… --- ## [How to configure SQL connection strings when you bring your own databases](https://forum.uipath.com/t/how-to-configure-sql-connection-strings-when-you-bring-your-own-databases/604242)
**Author:** [@Minoh\_Kang](https://forum.uipath.com/u/Minoh_Kang)\ **Replies:** 0\ **Last updated:** [September 24, 2023, 7:30am UTC](https://forum.uipath.com/t/how-to-configure-sql-connection-strings-when-you-bring-your-own-databases/604242 "2023-09-24T07:30:28Z")
When you install Automation Suite 2023.4 in your own environment, you can either let the installer create SQL databases for you or, alternatively, you can bring your own databases. In case the installer creates database… --- ## [Database activities - Insert datatable](https://forum.uipath.com/t/database-activities-insert-datatable/575127)
**Author:** [@LucasBelo](https://forum.uipath.com/u/LucasBelo)\ **Replies:** 12\ **Last updated:** [August 23, 2023, 2:12pm UTC](https://forum.uipath.com/t/database-activities-insert-datatable/575127 "2023-08-23T14:12:24Z")
Using the package UiPath.Database.Activities, I am connecting to a database with an account that is only able to insert data, but does not have SELECT permission. I am using the ‘DatabaseConnect’ activitie to configure … --- ## [Insert vs Bulk insert](https://forum.uipath.com/t/insert-vs-bulk-insert/571701)
**Author:** [@Povilas\_Jonikas](https://forum.uipath.com/u/Povilas_Jonikas)\ **Replies:** 2\ **Last updated:** [August 10, 2023, 8:09am UTC](https://forum.uipath.com/t/insert-vs-bulk-insert/571701 "2023-08-10T08:09:13Z")
Hello guys. Im facing a problem and can’t seem to figure out how to solve it. Im trying to insert a datatable to SQL table. While using insert, it works perfectly, but using bulk insert i get an error, that the columns f… --- ## [Connect to MS SQL server database, value for key 'Encrypt' Error](https://forum.uipath.com/t/connect-to-ms-sql-server-database-value-for-key-encrypt-error/571377)
**Author:** [@Povilas\_Jonikas](https://forum.uipath.com/u/Povilas_Jonikas)\ **Replies:** 0\ **Last updated:** [August 9, 2023, 8:20am UTC](https://forum.uipath.com/t/connect-to-ms-sql-server-database-value-for-key-encrypt-error/571377 "2023-08-09T08:20:26Z")
Hello guys. So i’ve been stuck with this problem for quite a while now. Basically I am testing my grounds with different connections. So far I’ve established ODBC and Ole DB connections to my SQL server, but none of thes… --- ## [D drive in DB server has exceeded 80% capacity. How to reduce it](https://forum.uipath.com/t/d-drive-in-db-server-has-exceeded-80-capacity-how-to-reduce-it/569716)
**Author:** [@TUSHAR\_DIWASE](https://forum.uipath.com/u/TUSHAR_DIWASE)\ **Replies:** 1\ **Last updated:** [August 4, 2023, 9:53am UTC](https://forum.uipath.com/t/d-drive-in-db-server-has-exceeded-80-capacity-how-to-reduce-it/569716 "2023-08-04T09:53:39Z")
In Database server , D Drive is exceeded to 80% , how can i reduce it. Previously it is below 80% but now it is increased. Does it happen because of large amount of logs stored in sql server. How we can check or re… --- ## [How to supply Parameter's in PostgreSQL](https://forum.uipath.com/t/how-to-supply-parameters-in-postgresql/563106)
**Author:** [@ManjunathReddy](https://forum.uipath.com/u/ManjunathReddy)\ **Replies:** 17\ **Last updated:** [July 14, 2023, 2:15pm UTC](https://forum.uipath.com/t/how-to-supply-parameters-in-postgresql/563106 "2023-07-14T14:15:41Z")
How to changes values dynamically in sql query, Nee supply values through parameters. "SELECT WIID, Description,Type,Status FROM work\_Items WHERE Type = 'WI2'; " sql sql-database --- ## [Gmsa account issue IIS application pool identity](https://forum.uipath.com/t/gmsa-account-issue-iis-application-pool-identity/562823)
**Author:** [@Vetrivel\_G](https://forum.uipath.com/u/Vetrivel_G)\ **Replies:** 1\ **Last updated:** [July 13, 2023, 10:59am UTC](https://forum.uipath.com/t/gmsa-account-issue-iis-application-pool-identity/562823 "2023-07-13T10:59:30Z")
After updating the gmsa account(domainname\\username$) in application pool identity in IIS. Facing http 500 error code Orchestrator application couldn’t access the login page. --- ## [Parsing xml files to SQL tables](https://forum.uipath.com/t/parsing-xml-files-to-sql-tables/553308)
**Author:** [@jan.kovac](https://forum.uipath.com/u/jan.kovac)\ **Replies:** 3\ **Last updated:** [June 14, 2023, 8:15am UTC](https://forum.uipath.com/t/parsing-xml-files-to-sql-tables/553308 "2023-06-14T08:15:54Z")
Hi, can you please help me with parsing xml files into tables? I have thousands of XML files in a folder like this: And I would like to parse them into separate tables in MS SQL database. XML samples: 3I6LAKPVSLXSK… --- ## [SQL Run Querry error](https://forum.uipath.com/t/sql-run-querry-error/553194)
**Author:** [@Povilas\_Jonikas](https://forum.uipath.com/u/Povilas_Jonikas)\ **Replies:** 4\ **Last updated:** [June 12, 2023, 7:48am UTC](https://forum.uipath.com/t/sql-run-querry-error/553194 "2023-06-12T07:48:26Z")
Hello guys, could you please give me a hand? :smiley: I am trying to write an Expression to the “Run querry” command, but I keep getting errors like this: The querry is simple: Select KatalogoKodas, PrekesPavadinim… --- ## [UiPath execute query | Display results instead of messages](https://forum.uipath.com/t/uipath-execute-query-display-results-instead-of-messages/549590)
**Author:** [@Hithashree8](https://forum.uipath.com/u/Hithashree8)\ **Replies:** 2\ **Last updated:** [May 30, 2023, 11:43am UTC](https://forum.uipath.com/t/uipath-execute-query-display-results-instead-of-messages/549590 "2023-05-30T11:43:48Z")
I need to extract the data from results no matter what the message is, but in UiPath, when I execute query, I am getting the same error as in sql. Try catch for the query didn’t work. --- ## [How can I send data from one database to another database in uipath?](https://forum.uipath.com/t/how-can-i-send-data-from-one-database-to-another-database-in-uipath/532465)
**Author:** [@burak](https://forum.uipath.com/u/burak)\ **Replies:** 1\ **Last updated:** [April 4, 2023, 3:44pm UTC](https://forum.uipath.com/t/how-can-i-send-data-from-one-database-to-another-database-in-uipath/532465 "2023-04-04T15:44:46Z")
I want to extract data from one database and send it to another database. How can I do that. --- ## [How to convert Excel to Database and execute an sql query](https://forum.uipath.com/t/how-to-convert-excel-to-database-and-execute-an-sql-query/525635)
**Author:** [@adarsh\_kotagiri](https://forum.uipath.com/u/adarsh_kotagiri)\ **Replies:** 2\ **Last updated:** [March 13, 2023, 6:36pm UTC](https://forum.uipath.com/t/how-to-convert-excel-to-database-and-execute-an-sql-query/525635 "2023-03-13T18:36:22Z")
Hi Team, can anyone help me how to convert a excel data to database and execute a query. Here my scenario is to identify the duplicate rows and write it in to different sheet, with SQL query. Input: Expected output… [Next page](https://forum.uipath.com/tag/sql-database/2493.md?match_all_tags=true&page=1&tags%5B%5D=sql-database)