https://community.blueprism.com/t5/Digital-Exchange/How-to-connect-yout-self-data-base/m-p/61041#M2117 Hi community!!<BR /><BR /><BR />I have started working on a different idea of an asset that could be useful for the community.<BR /><BR />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.<BR /><BR />Is there any way to connect to blue prism's own DDBB?<BR /><BR /><BR />Thanks for helping<BR /><BR />Bye <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span><BR /><BR />------------------------------<BR />Pablo Sarabia<BR />Architect<BR />Altamira Assets Management<BR />Madrid<BR />634726270<BR />------------------------------<BR /> Sun, 20 Feb 2022 15:42:00 GMT PabloSarabia 2022-02-20T15:42:00Z https://community.blueprism.com/t5/Digital-Exchange/How-to-connect-yout-self-data-base/m-p/61041#M2117 Hi community!!<BR /><BR /><BR />I have started working on a different idea of an asset that could be useful for the community.<BR /><BR />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.<BR /><BR />Is there any way to connect to blue prism's own DDBB?<BR /><BR /><BR />Thanks for helping<BR /><BR />Bye <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span><BR /><BR />------------------------------<BR />Pablo Sarabia<BR />Architect<BR />Altamira Assets Management<BR />Madrid<BR />634726270<BR />------------------------------<BR /> Sun, 20 Feb 2022 15:42:00 GMT https://community.blueprism.com/t5/Digital-Exchange/How-to-connect-yout-self-data-base/m-p/61041#M2117 PabloSarabia 2022-02-20T15:42:00Z https://community.blueprism.com/t5/Digital-Exchange/How-to-connect-yout-self-data-base/m-p/61042#M2118 Hi Pablo,<BR /><BR />great idea, but you have to consider two situations:<BR />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.<BR />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).<BR /><BR />------------------------------<BR />Tobias Arnold<BR />RPA Developer<BR />ITERGO GmbH<BR />Europe/Duesseldorf<BR />------------------------------<BR /> Mon, 21 Feb 2022 14:11:00 GMT https://community.blueprism.com/t5/Digital-Exchange/How-to-connect-yout-self-data-base/m-p/61042#M2118 TobiasArnold 2022-02-21T14:11:00Z https://community.blueprism.com/t5/Digital-Exchange/How-to-connect-yout-self-data-base/m-p/61043#M2119 Saying it's not possible, unsecure, dangerous, etc. is a very antiquated way of thinking.<BR /><BR />Yes it is possible, Yes it is safe, and secure. - via AutomateAppCore.dll<BR />You will find it in your Blue Prism Installation directory.<BR />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.<BR />Obviously you won't be able to use methods that infringe on your assigned user privileges, but otherwise the sky is the limit!<BR />Enjoy!<BR /><BR />------------------------------<BR />Andrzej Silarow<BR />Principal Consultant<BR />Ignite IPA<BR />Europe/London<BR />------------------------------<BR /> Mon, 21 Feb 2022 18:21:00 GMT https://community.blueprism.com/t5/Digital-Exchange/How-to-connect-yout-self-data-base/m-p/61043#M2119 asilarow 2022-02-21T18:21:00Z