Oracle database

Oracle database is a database from Oracle Corporation.

Integrations and Connectors

AgilePoint NX integrates in these ways with Oracle database:

  • Activities in Process Builder
  • Lookups in eForm Builder
  • Automated Actions Based on Database Events (Event Service)
  • Access tokens

Activities in Process Builder

You can use Oracle database with the out-of-the-box Database activities to execute actions in process-based apps.

An activity is a functional unit, or task, in a process-based app. Activities that integrate with a third-party system provide access to the API functionality for that system in a simple, point-and-click, form-entry format. This means that you can easily leverage APIs without writing code.

Figure: Process Activities for Database

Process Activities for Database

The following activities are available for databases:

  • Batch Insert
  • Delete Record
  • Insert Record
  • Query Multiple
  • Query Record
  • Stored Procedure
  • Update Record

For more information, refer to the process activities for database in Process Builder.

Lookups in eForm Builder

You can create lookups for Oracle databases in eForm Builder and form-based apps.

A lookup is an automated procedure that retrieves data from an external data source, such as a database or third-party service, to display runtime. For example, you can use a lookup to populate the options in a list on an eForm.

For more information, refer to Database Auto-Lookup configuration.

Figure: A drop-down list populated from a lookup

A drop-down list populated from a lookup
Figure: Sample lookup configuration screen

Configure Lookup Screen

This image is only one example configuration screen from the Auto-Lookup form control. It does not show all the configuration options, and lookups can be configured and executed in multiple ways. The Auto-Lookup control can perform a lookup for eForms or other controls. However, many other form controls have built-in lookup capabilities — for example, the Drop-Down List form control. For information about how to configure lookups, refer to eForm Controls.

Automated Actions Based on Database Events (Event Service)

AgilePoint NX apps can take automated actions when data is added to an Oracle database. For example, a process-based app can start based a new row added to the specific database table. These actions use the Database Insert event service

For more information, refer to Add New Event Service Screen > Database Insert Screen.

Access Tokens

You can create access tokens for Oracle database.

An access token is a secure object that stores an endpoint (usually a URL) and authentication credentials to connect to a service or technology. Often this is an external or third-party service, like Salesforce or SharePoint, but access tokens can also connect to an AgilePoint NX enviornment, local database, or other types of technologies. Once an access token is created, app designers can simply select and reuse it, rather than entering the credentials each time they are needed.

For more information, refer to Access Token for Database.

Figure: Database Access Token Configuration screen

Database Access Token Configuration screen

Related Topics

Examples

Some information about third-party integrations is outside the scope of the AgilePoint NX Product Documentation. It is the responsibility of the vendors who create and maintain these technologies to provide this information. This includes specific business use cases and examples; explanations for third-party concepts; details about the data models and input and output data formats for third-party technologies; and various types of IDs, URL patterns, connection string formats, or other technical information that is specific to the third-party technologies. For more information, refer to Where Can I Find Information and Examples for Third-Party Integrations?

Video: Show Data from a Database on an eForm

Oracle database Documentation

Use these links to find third-party vendor documentation for Oracle database:

About This Page

This page is a navigational feature that can help you find the most important information about this topic from one location. It centralizes access to information about the concept that may be found in different parts of the documentation, provides any videos that may be available for this topic, and facilitates search using synonyms or related terms. Use the links on this page to find the information that is the most relevant to your needs.

Keywords

database, Oracle, MySql, SqlServer, Sql Server, storage, data store, table, column, workflow database, workflow db, reports database