There are two general types of integration: Outbound and Inbound. Outbound integration is when an app initiates the connection to another system. Inbound integration is when another system initiates the connection in order to pass data to PerfectApps.
This topic covers outbound integration only. See the PerfectApps API topics in this guide for more information on inbound integration.
Listed below are several common outbound integration scenarios.
Background Lookup |
If a user selects a specific item from a list, for example, you may want the app to retrieve data from a database and populate a field elsewhere in the app.
|
Popup Lookups |
You may require your app to be able to extract data from a database or LDAP system. For example, a parts catalog is stored in an Oracle or SQL database and you want to allow the user to search that catalog and return the official part name, unit price and code back into the app.
|
Writing to Database Tables |
PerfectApps can add, modify or delete information in a database table.
|
Calling Stored Procedures |
PerfectApps can send information to a stored procedure.
|
Directory Services (LDAP) |
PerfectApps treats LDAP like a database and can perform background and pop-up lookups.
|
Web Services |
PerfectApps can pass data from the app to a web service. This suits developers, and it is the standard SOA-type interface for products such as Salesforce, SAP, and others.
|
Google Spreadsheets
|
PerfectApps has a connection type that allows data to be imported from a Google Spreadsheet. Note that this feature requires an additional purchase.
|
Text/CSV |
PerfectApps has a connection type that allows a text (ASCII, delimited) file to be treated as a database.
|
See also: Creating PerfectApps Connections
Return to: PerfectApps Connections, Integration
