Blueprism and SQL Server

[VinodV]

Hi, Can someone explain , how is blue prism related to SQL Server? We know SQL server is used to store the code (process and objects). While we run RTR , blueprism brings code to RTR machine and start executing the code? after that for every stage does it goes to SQL server? basicall, i would like to know how at run time BP execution is related to SQL server Regards Vinod V    

[Denis__Dennehy]

Hello Vinodjv, The SQL database is the central repository - storing all global configuration, processes/objects/environment variables, work queue data, session log data, etc, etc. At run time when a session is started the local resource pc will load all the components it needs to run the process into memory.  Your capability should have a trained technical lead/architect that has gone through our technical training - that person will know about the database and all the network communications that occur in the platform.  If your team does not have someone that has taken that training available to ask questions like this it is probably worth escalating that to your manager.  

[John__Carter]

Everything, apart from some local config, lives in the DB - processes, objects, queues, schedules, users etc. When a resource PC is instructed to run a process, it downloads the process definition from the DB via the app server. As the process runs, it communicates with the DB (again via app server) to request the data it needs (queue data, credentials etc) and to send updates (logs, queue item updates etc).

[John__Carter]

Denis beat me to it!