Using UiPath Studio, how to connect to SQL Server Database which is on Citrix to execute an SQL query adn extract data to Excel?
That doesn’t matter like where the database is
If we know the username password, server name and database name then we will be able to connect to that sql server with EXECUTE QUERY ACTIVITY
To get this activity go to design tab -> manage packages-> official tab and search as UiPath.Database and install that Package
For more details on how to connect
Use connect activity in properties connection string use below code:
“Data Source=ServerName;Initial Catalog=DBName;User ID=username;Password=password”
ServerName : your computer name.