Accessing information from Oracle tables using db connection from BluePrism

[SandeepKutwal]

Hi All, Need suggestions and help on defining below business architecture solution : We expect to connect to the remote oracle db of BPM tool from Blue Prism with read only access and pull relevant records from oracle table for creating work queue in Blueprism database . In certain end to end workflow , there will be number of "steps" in a sequence in which some of them must be worked upon using RPA automation and marked for so , by querying oracle database where all information is kept for each will "step" execution . Once the steps before automation are found to be completed when we query relevant tables in oracle , we will start RPA process to complete its automation activities for marked step to be automated . For e.g , below are mix of steps for certain E2E workflow. Step --> Manual /Automatic 1 --> Manual 2 --> Manual 3 --> Automatic 1 --> Manual 3 --> Manual RPA has to pull data from oracle table to get know on if step 2 is completed so that it can start step 3 as automated using bots and it will provide feedback of completion of activity. So , below are some of queries 1. what is best approach to develop this integration to run supposed automated steps at RPA end . 2. Is it more prudent to write C# code at Blue Prism to query oracle db where we can find out steps to be automated and by when automated step to be started at RPA (for .e.g only after completion of step 2 , we can start automated step 3 using RPA) 3. Is queue in Blueprism database is ultimately record in some of table - pls name that table if anyone know it . I guess using insert in that table creates queue for certain process . 4. Provide list of dlls / references/namespace imports to add in business objects 5. Is any OLEDB drivers/ oracle client installation is needed at BluePrism VM ? Please share connection string for oracle db to use in c# code if anyone having it handy 6. Any workaround / alternate solution to resolve this business integration problem Thanks in advance for suggestions and help. Regards Sandeep Kutwal

[Denis__Dennehy]

Hello, This is a complex design question, Ideally you will have an experienced Mentor (either a Trusted Advisor or Delivery Enablement Manager from Blue Prism, or otherwise a Lead Developer from one of our Partners) available to you to discuss and sign off your solution designs. If you do not have such a person available to you it should be raised as a risk with your head of RPA. There is an OLEDB VBO distributed with the Blue Prism product. It is up to you to find and install the correct OLEDB drivers for your Oracle database (it will depend upon db version and OS version - search the internet for it). Do not EVER insert direct into any Blue Prism database table. You should be querying your oracle databse table, and have a process flow that loads the items into the Blue Prism Work Queue. You could also have a check for duplicates logic if you are unable to update the oracle db to record when an item has been loaded. You may want to store the last loaded datetime information in a work queue table in some way as part of your design. I recommend the Process Examples (distributed with the process templates - for examples of loading the Work Queue and checking for duplicates).

[SandeepKutwal]

Hi Denis , Thanks lot for your information..a much help. We will surely connect BluePrism team for final design decisions out of some of the options that we are evaluating now for integration of IBM BPM & BluePrism . Thanks , Sandeep Kutwal