About Connect SQL rules

New	Open	Delete	Save
Browse	History		More...

Purpose

C-501 Use Connect SQL rules when your application needs to run complex Structured Query Language statements such as joins or stored procedures to update or extract information from an external database.

Tip Alternative: If your application needs to perform a simple browse, open, delete, or update operation against an external database, use the Connector and Metadata Accelerator to configure external table access. When external table access is configured for an external table, you can use the Obj-Open, Obj-Browse, and other Obj- methods to interact with that table through a class that represents it and you do not need to create SQL connector rules. See About generating connector rules.

Access

Use the Application Explorer or the Integration Overview landing page to see Connect SQL rules in your application. Use the Rules Explorer to list all Connect SQL rules that are available to you. To access the Integration Overview landing page, select > Integration > Overview.

Development

To configure an SQL connection to an external database, use the following elements along with the Connect-SQL rule:

An activity that references one or more of four standard methods for operating on relational databases — RDB-Open, RDB-List, RDB-Delete, and RDB-Save. The names of the methods match the names of the tabs in the connector rule. An activity that uses RDB-Open to call a connector rule runs the SQL statement on that connectors Open tab, and so on.
A Database instance and one or more Database Table instances that provide access to the tables or views of the external database.
A JDBC library that provides access to the external database software.
Special data mapping syntax to associate properties with database columns.

	Connect SQL rules — Data mapping
	Atlas — Standard Connect SQL rules

About Connect SQL rules

Purpose

Access

Development

Category