How to connect to SQL Server Database which is on Citrix for an SQL call

Using UiPath Studio, how to connect to SQL Server Database which is on Citrix to execute an SQL query adn extract data to Excel?

1 Like

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

Cheers

Hi @PhaniD

Go to manage package and search uipath.database.activities install this package and use data base activities.

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.

Regards,
Kommi Jeevan.

1 Like