How to connect yout self data base?

[PabloSarabia]

Hi community!!


I have started working on a different idea of an asset that could be useful for the community.

The problem is that it pulls data from Blue Prism's own database. I would like to make the component without the user having to specifically specify the credentials for it.

Is there any way to connect to blue prism's own DDBB?


Thanks for helping

Bye 🙂

------------------------------
Pablo Sarabia
Architect
Altamira Assets Management
Madrid
634726270
------------------------------

[TobiasArnold]

Hi Pablo,

great idea, but you have to consider two situations:
1. If it would be possible to access the BP database directly from an VBO it would be a security risk. So a digital worker should not be able to manipulate the database. In an enterprise szenario there is an application server the man in the middle and deals with the DB connection. The client should only know the connection to the application server.
2. If you are dealing with an application server it might be possible that there is no (network) route from the client to the database (or a proxy server denies tcp traffic on port 1433).

------------------------------
Tobias Arnold
RPA Developer
ITERGO GmbH
Europe/Duesseldorf
------------------------------

[Asilarow]

Saying it's not possible, unsecure, dangerous, etc. is a very antiquated way of thinking.

Yes it is possible, Yes it is safe, and secure. - via AutomateAppCore.dll
You will find it in your Blue Prism Installation directory.
To find out the list of available methods, simply add as a new com reference to a new project in visual studio, and use the built in help.
Obviously you won't be able to use methods that infringe on your assigned user privileges, but otherwise the sky is the limit!
Enjoy!

------------------------------
Andrzej Silarow
Principal Consultant
Ignite IPA
Europe/London
------------------------------