Editing Interface Data Sources

You can edit any of the properties of an interface data source, including the name and description of the data source and the database name, server, and user name.

  To edit an interface data source:

  1. Select Navigate, Administer, Configure Interface Data Source.

  2. When the Interface Data Source tab is displayed, right-click the data source you want to edit, and select Edit.

  3. In the Interface Data Source Wizard, for Database Details, edit any of the following properties of the data source:

    1. Edit the name and/or port number of the server hosting the database. (The defaults display based on the database type.)

    2. Edit the Service Name/SID of the database. This is the name of the database on the server.

    3. Edit the database username and/or password.

    4. Edit the Connection URL for the database.

  4. If you want to test the connection to the database, click Test.

  5. For Data Source Details, edit the description of the data source.

    Note:

    While editing a data source, the name you gave to the data source when you created it is displayed in read only; you cannot edit the data source name.

  6. Select Create Tables, and click Finish to update the tables with your changes.

    Note:

    If you do not select the Create interface tables check box, no tables are created. If you select the check box to create the interface tables, both IM_ (internal) and HS_ (sample) tables will be created. If the tables already exist, you are prompted to delete the existing IM_ and HS_ tables. If you click Yes to delete the existing tables, the new tables are created. However, if you select No, the existing IM_ and HS_ tables are left unchanged.

Note:

You may review the configuration log (EPM_ORACLE_INSTANCE/diagnostics/logs/config), correct errors, and rerun the wizard.

After you finish the wizard, the properties of the edited data source (for example, its name, description database type, and database server) are displayed on the Interface Data Source tab.

After you complete the configuration, a set of sample tables is created in the database. For a complete list of the sample tables, see Defining Interface Tables.