Editing a data connection in InfoSphere Metadata Asset Manager

You can select an existing data connection when you import metadata by using a connector or by using the HDFS bridge. You might need to edit the connection if the credentials to connect to the data source have changed or you want to change any of the parameters.

Before you begin

You must have the role of Common Metadata Importer or Common Metadata Administrator. If you do not have the Common Metadata Administrator role, you must be the creator of the data connection.

About this task

In InfoSphere® Metadata Asset Manager, creating and editing data connections is tied to the import process and to the import area. You create or edit data connections while in the import wizard. Your ability to edit the data connection in a particular import area depends on whether you have shared an import from that area to the metadata repository.
  • When no import has been shared to the metadata repository from the import area that you are working in, you can select an existing data connection or create a new data connection. You can edit any of the properties of the data connection, even after running imports, as long as you do not share an import to the metadata repository.
  • After an import has been shared to the metadata repository from the import area that you are working in, you can change only the password of the data connection while working in that import area. However, you can select and edit the data connection if you create a new import area.

Procedure

  1. On the Import tab, click New Import Area or open an existing import area.
  2. Select the data connection to edit.
    Option Description
    Edit a data connection in a new import area
    1. Specify a unique name and description for the import area.
    2. Select a metadata interchange server.
    3. Select the connector or bridge that you want to use to import your data.
    4. Click Next.
    5. Click the browse icon in the Data connection field.
    6. Select the data connection that you want to edit and click OK.
    7. Click Edit next to the Data connection field.
    Edit a data connection in an existing import area
    1. Select a staged import and click Reimport.
    2. Click Edit next to the Data connection field.
  3. Update the parameters that you want to edit and click OK. If an import has already been shared from the import area, only the password is editable.
    If you change the password, you must save the password if you want to be able to use the data connection in InfoSphere Information Analyzer. By default, the Save password parameter is displayed when you create or edit a data connection. The Common Metadata Administrator can turn off the ability to save passwords by changing the import settings on the Administration tab of InfoSphere Metadata Asset Manager
  4. Complete the import.
    When you share the import to the metadata repository the data connection is also saved to the metadata repository.