Orchestrator qeury

[Pushpendra_kowthavarapu]

Hi, If we done some sql automation like connecting to database and manipulating data over there. when we publish that bot to the orchestrator like sending it to the client environment. Do we need Sql in the runner machine as well.

[Dilli_Reddy]

@Pushpendra_kowthavarapu

-If your automation process involves connecting to a SQL Server database and manipulating data directly on the runner machine, you would typically need SQL Server or a SQL Server client installed on the runner machine.
-If your automation process connects to a remote SQL Server database, you do not necessarily need SQL Server on the runner machine.

-Database in Orchestrator: In this case, the runner machines do not need SQL Server installed because the database operations are handled by the Orchestrator.
-Depending on your specific use case, you might not even need a full SQL Server installation.

[neha.upase]

Hi,

1. Database Operations in Automation:
   If your automation involves interacting with a database, such as running SQL queries, updating, inserting, or retrieving data, the machine where your automation runs (runner machine) needs to have access to the database. This may require SQL client software (e.g., SQL Server Management Studio, MySQL Workbench) to be installed on the runner machine. You also need to configure database connection strings and credentials in your automation workflow.

2. UiPath SQL Activities:
   UiPath provides SQL-related activities, such as the “Execute Query” activity, which allows you to run SQL queries directly from your automation workflow without needing SQL client software on the runner machine. These activities interact with the database through the specified database connection in the UiPath Orchestrator. In this case, the runner machine doesn’t need SQL client software.

3. Running the Bot in Client Environment:
   When you publish a UiPath bot to the Orchestrator and deploy it to a client environment, it’s important to ensure that the client environment meets the automation’s prerequisites. This includes having the necessary database access and, if applicable, the required SQL client software installed. You’ll need to work with the client’s IT team to make sure the environment is properly set up for your automation.

4. Configuration Management:
   To simplify deployment and avoid the need to install SQL client software on each runner machine, you can centralize database connections and credentials. UiPath Orchestrator supports asset management, where you can securely store database connection strings, and your automation workflows can retrieve these assets when needed. This way, you don’t need to hardcode database connection details in your workflows, and you can update the connection information centrally.

[Pushpendra_kowthavarapu]

Thanks for the answer bro. Could you please elaborate me the 3 point.