topic Re: How Blue Prism connects with Redshift DB ??? in University Forum

How Blue Prism connects with Redshift DB ???

Vijay.A — Wed, 29 Jun 2022 10:03:59 GMT

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

Re: How Blue Prism connects with Redshift DB ???

Denis__Dennehy — Wed, 29 Jun 2022 11:45:47 GMT

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

Re: How Blue Prism connects with Redshift DB ???

Neel1 — Tue, 20 Sep 2022 11:22:55 GMT

@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_MFBQ2KFZ1L*MTY1NjA3MTcyOC41NDMuMS4xNjU2MDczMTIwLjA

Re: How Blue Prism connects with Redshift DB ???

ewilson — Tue, 20 Sep 2022 11:47:48 GMT

Hello @Neeraj Kumar,

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

Cheers,

Re: How Blue Prism connects with Redshift DB ???

Neel1 — Tue, 20 Sep 2022 11:59:02 GMT

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