RPA - connecting to DWH

Help Studio
1

Hello.
I need information about connecting to DWH. How can I use DWH information using query and get it in form of excel, for example?

2

@okalinic

Which DWH you want to connect to?

depending on that we can either use connectors or use database activities

cheers

3

What do you mean by “which dwh”? I am connecting manualy to DWH using SQL Developer, but I need to connect through UiPath Studio using user’s credentials.
Is that possible?

4

@okalinic

Yes it is possible

Get the connection string and use database activities

Cheers

5

Do you have some simple example on how to do that? :slight_smile:

6

@okalinic

Here is the activity

It has a wizard where you can select your db and give the credentials ports etc

Here is a brief video

Cheers