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.

Note:

External databases are auto-configured for an external system when the Auto Configure External Databases checkbox is selected in Configure External System.

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.

1. Interface Type : Select an interface type from the list to search interface types already configured. You can then edit the interface type. The same interface type might be associated with multiple databases, so the list shows all of the available databases when referencing the interface type.

2. 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.

3. Code: Enter an external database code or partial code.

Adding External Databases

1. From the Toolbox menu, 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. External System: Select an external system from the list. For more information, see Configuring External Systems

   4. Outbound Code: Select outbound code to link with external database code. For more information, see Configuring Outbound Systems

   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 External Databases

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

2. Enter search criteria and click Search.

   Note:

   Click Vertical Ellipsis and select Show Inactive to include inactive records

3. Select an external database in the result, click the vertical ellipsis Actions menu and select Edit.

4. Update the details.

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

5. Click Save.

Deleting External Databases

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

2. Enter search criteria and click Search.

3. Select an external database in the result, click the vertical ellipsis Actions menu and select Delete.

4. Click Delete to confirm.