About Connectors

Connector is PRPC components that act as a interface between a PRPC acting as a client and an external system acting as a Server.

A connector is implemented by any of these ten rule types:

1. Rule-Connect-BPEL

2. Rule-Connect-dotNet

3. Rule-Connect-SOAP

4. Rule-Connect-EJB

5. Rule-Connect-HTTP

6. Rule-Connect-Java

7. Rule-Connect-JSM

8. Rule-Connect-JCA

9. Rule-Connect-MQ

10. Rule-Connect-SQL

Connect-SQL- is a connector rule which is used when any complex SQL queries such as joins or stored procedures to update or extract information from an external database.

To configure SQL connection to an external database—

In an activity use any of the RDB methods- RDB-List, RDB-Open, RDB-Save, RDB-Delete

RDB-Open- is used to retrieve a single record from the external DB and place the retrieved data in the clipboard page as a property name and values.

RDB-List-- is used to retrieve multiple records from the external DB and place the retrieved results as an embedded pages in a specified step page of class Code-Pega-List

RDB-Delete- is a method used to delete a row or multiple records from the external DB using SQL. Under Delete Tab of connect-SQL rule contains Delete, Truncate, or Drop sql

RDB-SAVE- is used to save the content of the clipboard page into a row of an external database from the external DB. The system saves the properties on the specified step page to the specified table in the database. This method operates in conjunction with a Connect SQL rule that contains SQL statements such as INSERT, UPDATE, and CREATE statements on the Save tab

Use the Connect-MQ method to invoke a connector to an external system that uses IBM Web Sphere MQ messaging services.

Connect-SOAP

Use the Connect-Java method to call a public method of an external Java class, using a Rule-Connect-Java rule

Connect-HTTP- Use the Connect-HTTP method to start an HTTP request/response interaction between Process Commander and the external system identified by a Connect HTTP rule (Rule-Connect-HTTP rule type).

Connect-JMS

Use the Connect-JMS method to send a JMS message to an external system using the Java Message Service application programmer interface.

Use the Connect-JCA method to communicate through a JCA resource adapter to an external System