Configuring External Databases

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.

Adding External Database

  1. From the side menu select Toolbox, select System Setup then External Databases.

  2. Click New and enter the following details:

    1. Code: Enter a code for the external database. The code is displayed in profile subscriptions. This code is also seen when configuring Business Events for special External Databases.

    2. Description: Enter full name to explain the location and use.

    3. Interface Type: Select an interface type from the list.

    4. Outbound Code: Select outbound code to link with external database code

    5. Copy Subscription: Select checkbox to copy default business events configuration for the database code created for an external system.

    6. Available > Selected: Select applicable properties in the Available panel and click > to move selection to the Selected panel.

  3. Click Save and Continue.

Editing an External Database

  1. From the side menu select Toolbox, select System Setup then External Databases.

  2. Enter search criteria and click Search.

    Note:

    Click Vertical Ellipse and select Show Inactive to include inactive records

  3. Select an external database in the result, click Vertical Ellipse and select Edit.

  4. Update details.

  5. Inactive: Click to mark the external database inactive.

  6. Click Save.

Deleting an External Database

  1. From the side menu select Toolbox, select System Setup then External Databases.

  2. Enter search criteria and click Search.

  3. Select an external database in the result, click Vertical Ellipse and select Delete.

  4. Click Delete to confirm.

Parent topic: System Setup