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

[PhaniD]

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

[Palaniyappan (Forum Leader)]

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

How to query data from a SQL database

Cheers

[kommijeevan (Jeevan Kommi)]

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.