Back Forward About Connect SQL rules
 

Integration-Connectors category
  1. About 
  2. New 
  3. Open 
  4. Delete 
  5. Save 
  6. Browse 
  7. History
  8. More... 

Purpose

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.

TipAlternative: 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 to list the Connect SQL rules in your application. Use the Records Explorer to list all Connect SQL rules that are available to you.

Development

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

Where referenced

Connect SQL rules can be referenced in an Integrator shape (Integrator) of a flow rule, or on the Definition tab of a Data Page rule, as the source of data for the contents of the data page.

Category

Connect SQL rules are instances of the Rule-Connect-SQL class. They belong to the Integration-Connectors category.

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

Integration-Connectors category
Help System home pageHelp Home