Retrieve data from database to folder

[Yogita_Gaikwad]

how to retrieve data from sql database using uipath

[Gokul001 (Gokul Balaji)]

Hi @Yogita_Gaikwad

Configuration

Integrating PostgreSQL With Uipath

Hello Guys, 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 [image] Create new activity and search for connect to data base and drag drop the activity. [image] Then click configure connection button [image] Edit connection setting will open, then click connection wizard C…

Integrating with ODBC to PostgreSQL

Hello Guys, I would like to present this tutorial who are looking for integrating ODBC to PostgreSQL Following steps are required Download step for PostgreSQL Initial Step to download PostgreSQL app on our machine. Go to Postgre website URL: Download PostgreSQL Then Click download, the Version 13.6 in column of Windows x86-64 [image] Then follow the installation procedure at postgre website: Install PostgreSQL During set up it will ask for a password, in which enter the password “ro…

Instead of Postgresql → Use Sql database

Have a look on the thread

How to query data from a SQL database

[Aakash_Singh_Rawat]

Hi,

Use connect activity to connect with sql client.
If you can’t find the connect activity, you can install it from manage packages by searching UiPath.Database.Activities.DatabaseConnect.

[Yogita_Gaikwad]

can you tell after db connection which query write in run command for select all data & store in particular folder

[Aakash_Singh_Rawat]

Hi,

Can you add breakpoint to output datatable and run in debug mode and check what your datatable(output for Run command) returning?

[Gokul001 (Gokul Balaji)]

Hi @Yogita_Gaikwad

Just use the Run Query activity and create an output variable

Run Query activity variable type → DataTable

Regards
Gokul

[Yogita_Gaikwad]

extract sql data in particular folder using uipath

[Gokul001 (Gokul Balaji)]

Duplicate : Retrieve data from database to folder

[Veera_Raj (Veeraraj Sethuraman)]

can you explain more bit ?

[Yogita_Gaikwad]

 Colum1    Colum2     Colum3

1. Akshay Yogita Akash
   2.Yamini Yojna Akshu

suppose I want to store data of Names which is start from A store in one folder and other is starting from Y store in other folder from sql database using uipath how i do it can you send workflow

[Veera_Raj (Veeraraj Sethuraman)]

once you retreive the data from data table try to iterate using for each row , i hope you will store the data in excel.
next you can use switch case for 26 alphapet formats for switch case input will be row(“columnname”).tostring.substring(0,1).tolower
inside each case do like create folder but before creating check once path already exist or not if exist use append range or directly write

[THIRU_NANI (NaNi)]

Hey!

Please answer the following questions…

1. From where we are getting the Names?
2. Are we trying to insert the data to the particular database whose name starts with A and Y?

Regards,
NaNi