Connect studioX to to database

Help StudioX
,
1

Hi team, Can StudioX be connected to the database, the aim is to query and read the output and write the same into a csv/data table.Thanks!

2

@Raghav_Dhawan

You can install UiPath.database.activities and use them…

https://docs.uipath.com/activities/docs/about-the-database-activities-pack

Cheers

3

Hi @Raghav_Dhawan

Yes, StudioX can be connected to a database to query data and read the output. Here’s how you can achieve this:

  1. Open UiPath StudioX and create a new project.
  2. Drag and drop the “Connect” action from the “Database” category onto the canvas.
  3. In the “Connect” action, choose the appropriate database provider (e.g., SQL Server, Oracle, MySQL) and provide the necessary connection details (server name, database name, credentials, etc.).
  4. After connecting to the database, you can use the “Query Database” action to execute SQL queries and retrieve the output.
  5. Drag and drop the “Query Database” action onto the canvas and configure it with the SQL query you want to execute. You can use placeholders for dynamic inputs by clicking on the “Insert Variables” button.
  6. The output of the query can be stored in a DataTable variable. Click on the “Create Variable” button to create a new variable to hold the query results.
  7. To write the output to a CSV file or a DataTable, you can use the “Write to File” or “Write Range” action respectively. Drag and drop the appropriate action onto the canvas and configure it accordingly. Provide the DataTable variable as the input, and specify the file path or Excel file where you want to write the data.

Thanks!!

4

Hi @Raghav_Dhawan

To connect your Studio X with database.

  1. Download UiPath.DataBase.Activities.
  2. Drag and drop the “Connect to dataBase” activity and in the Properties panel, click on the “Configure Connection” button next to the “Connection” field.
  3. In the Connection Wizard window, select the appropriate database provider from the list. UiPath StudioX supports various providers such as Microsoft SQL Server, Oracle Database, MySQL, etc. Choose the provider that corresponds to your database.
  4. Configure the connection details based on the selected provider. This includes specifying the server address, database name, authentication method (username/password or integrated security), and other relevant connection parameters.
  5. Test the connection by clicking on the “Test Connection” button. If the connection is successful, you should see a confirmation message.
  6. Click “OK” to close the Connection Wizard.
  7. Back in the Properties panel, you can optionally provide a name for the connection by entering a value in the “Connection” field.

Hope it helps!!
Regards,