Connecting to oracle database

How can we connect from pega workflow to oracle database-?

**Moderation Team has archived post**

This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.


Keep up to date on this post and subscribe to comments

September 28, 2009 - 1:12pm

Hi Satish,

Follow the steps to Connect to Oracle Database from Pega Workflow:
1). Add a Integrator shape to your workflow.
2). Use Connector and MetaData accelarator to generate the required rules to connect to Oracle Database.
3). with Connect as the Activity Type) that call connector rules (Rule-Connect- rule types) from Integrator shape you can connect to the database.

hope it helps.


September 28, 2009 - 7:01pm

Hi Jaswal,

For the Pega workflow I am getting the Input from oracle database,

I think this is in the middle of the flow,

Can you please confirm me-?,


September 29, 2009 - 5:02am

Hi Satish,

Just use the integrator shape in the pega workflow wherever you want to get the details from the database.
Alternatively, if you have already connected with the database and have the information with you, you can store the information in some page and use at different stages of your flow.

Parveen Jaswal

September 1, 2015 - 3:20am

Can any one tell the procedure to connect external database through prpc.

September 8, 2015 - 11:48am

Have a look at creating a database table class mapping

September 9, 2015 - 2:27am


    Thanks for Reply, I am using pega cloud directly without installation,can i you please tell me how to connect to external database.



September 9, 2015 - 2:28am


    Thanks for Reply, I am using pega cloud directly without installation,can  you please tell me how to connect to external database.



September 9, 2015 - 9:50am

Create a new Database instance from Designer studio .

Records Explorer -> SysAdmin -> Database

September 10, 2015 - 5:41am

Thanks for Reply,

                       I tried this befor but i am confusion in that  will i specify the url means driver name or dbinstalled location because its shows error can u please share the screen sheet with data.