Previous Topic

Next Topic

Book Contents

Book Index

Imported/Linked Data Pros and Cons

Consider the following when deciding whether to import or link to data from an External Database.

Linked Data Pros/Cons

Pros:

  • CSM always shows the External Database's most recent data (that is, databases are in sync).
  • CSM Users can directly update data in the External Database if the External Business Object is marked as updatable.

Cons:

  • CSM’s underlying SQL queries cannot cross the CSM/External Database boundary.

    Example 1: Create a One-Step to use a Linked External Business Object, but that One-Step cannot use a CSM Business Object. Likewise, create a One-Step to use a CSM Business Object, but that One-Step cannot use a Linked External Business Object.

    Example 2: Create a Search to use a Linked External Business Object, but that Search cannot use a CSM Business Object. Likewise, create a Search to use a CSM Business Object, but that Search cannot use a Linked External Business Object.

  • There is potential for reduced performance when retrieving data from an External Database. If the External Database goes offline, there can be a significant delay while CSM attempts to connect before timing out.
  • Unless done carefully, updates from CSM could possibly violate business rules of the External Database.
  • When data is changed outside of CSM, CSM Automation Processes are not initiated. If the data is changed within CSM, then the business logic is executed.

    Imported Data Pros/Cons

Pros:

  • The data is available for every single feature in CSM. The data is not limited by the CSM boundary or system boundary mentioned above.
  • Use additional CSM fields to augment the imported data.
  • Full-Text Search can be used for searching.
  • The imported Table/View can become part of a CSM Group (ex: it could be a Configuration Item Group member).

Cons:

  • The data is only as current as the last import. However, use the Cherwell Scheduler to import the data at regular intervals.
  • If data is deleted from the External Database, it still displays in CSM.

See Also

External Data and Databases

Table Views