External Database Configurations

The External Database Setup feature in the Toolbox menu is essential for external systems configuration in OPERA Cloud and for integration with the correct chain/property. Its purpose is to link each property in the multi-tenant cloud to its respective external system and external database ID.

The feature enables you to create new external database configurations based on existing Interface Types. You create a unique External Database Code with a description to identify each new configuration. The description should include the External Database Code and a full external database name to explain its system type and use. OPERA Cloud will provide a list of properties that use the Interface Type you specify in your search. From the list, you can highlight and select one or more properties to move into your new configuration. You can save and continue the process of creating the external database.

You can also edit external database setups to update database descriptions and to add or remove linked properties. The search function provides a list of databases, each identified by a code, a description, and an interface type. You can expand each database listed in your search results to reveal the properties attached to the database. You can also elect to show inactive database/interface types or to hide inactive database/interface types using. Database/interface types remain configured even if shown as inactive.

Use the following search criteria to locate an interface type for your property.
  • Interface Type: Select an interface type from the list of values (LOV). The LOV filters the search results by an interface types already configured. You can then edit the interface type. The same interface type might be associated with multiple databases, so the LOV shows all of the available databases when referencing the interface type.

  • Property: Enter the external database name to filter search results based on a specific property database. The property database can include multiple properties, depending on its current configuration and name.

  • Code: Search by entering a known External Database full or partial code.