How Blue Prism connects with Redshift DB ???

[Vijay_AnandThia]

How Blue Prism connects with Redshift DB ? existing VBO if any please suggest with required configuration setup requirement

[Denis__Dennehy]

Just google searched Redshift+odbc and it looks as though Redshift profices ODBC drivers for their database product.  That should help you to do everything you need,  there is a VBO on the Digital Exchange called ODBC Utility Blue Prism.

Install the ODBC Drivers for your Database
Install the VBO
Use the connect and query actions that are in the VBO (it is probably over 5 years since I used it so can't remember much about it)
If you need any help using the ODBC actions there should be lots of help in the internet about using ODBC

[Neel1]

@devneetmohanty07 @ewilson- Helo guys- please can you share expertise on whether we can use Oracle MDA VBO to connect to Redshift DB.

https://digitalexchange.blueprism.com/dx/entry/3439/solution/oracle-mda---utility?_ga=2.92491293.1600082727.1655103133-1052292321.1645100355&_gl=1*ikxtz7*_ga*MTA1MjI5MjMyMS4xNjQ1MTAwMzU1*_ga_MFBQ2KFZ1...

[ewilson]

Hello @Neeraj Kumar,

No, the Oracle MDA connector is strictly for traditional Oracle databases.

Cheers,
​

[Neel1]

Thanks @ewilson for your reply. i was trying to connect red shift from MDA vbo but was having issue.

I will go now for ODBC method highlighted by Denis