1. Administering and Working with Oracle Enterprise Data Management Cloud
  2. Administration
  3. Understanding Data Sources
  4. Creating, Editing, and Deleting Data Sources

Creating, Editing, and Deleting Data Sources

Considerations

  • You must have Owner or Metadata Manager permission on an application in order to create, modify, or delete a data source for that application.
  • You must have Owner or Metadata Manager permission on at least one application in order to create, modify, or delete an unregistered data source.

Creating a Data Source

Considerations

  1. From the home page, click Tools, and then click Data Sources.
  2. Click Create.
  3. Enter the following information:
    Field Description
    Name Name (must be unique) for the data source.
    Description Optional: Description for the data source
    Code Unique code that identifies this data source when a request file is processed.

    Note:

    If the Code field is left blank, the name of the data source is used to identify it when a request file is processed. However, because the data source name can change over time it is a best practice to use the Code field to identify the data source instead of the name.
    Registered Specify the type of data source:
    • Enabled: Data source represents another Oracle Enterprise Data Management Cloud application
    • Disabled: Data source represents an external system whose data is not being managed in Oracle Enterprise Data Management Cloud

    Note:

    Because data sources are created automatically for every registered application, in general you will create unregistered data sources only. You would only create a registered data source when the default registered data source for an application has been deleted.
    Application (Registered data sources only) Select the application to use as a data source.

    Note:

    You can register an application to one data source only.
  4. Click Create.

    The data source is displayed in the inspector.

Registered Data Source Default Values

Registered data sources are created automatically when you register an application. The data source that is created has the following default values:

Field Value
Name The name of the application
Description "Data source for application (application name)"
Code (blank)

Note:

For registered data sources, the name of the data source is used to identify it when a request file is processed. It is a best practice to edit the data source and add a Code to identify the data source instead of the name.
Registered True
Application (application name)
Enabled True

Editing a Data Source

After you create a data source, you can edit it in the inspector to enable or disable it or to change any general details.

  1. From Data Sources, click the name of a data source to open it in the inspector, and then click Edit.
  2. Optional: Edit any of the summary fields for the data source listed in Creating a Data Source.

    Note:

    If the data source is already registered, you cannot edit the Registered or Application fields.
  3. In Enabled, click to enable or disable the data source. Data sources must be enabled in order to reference them in matching rules.

    Note:

    You cannot disable a data source if it is being referenced by a matching rule.

Deleting a Data Source

To delete a data source, in the Action column for the data source that you want to delete, click Actions action button, and then select Delete.

Note:

You cannot delete a data source if it meets any of the following conditions: