Table of Contents

Search

  1. Preface
  2. Introduction to TDM Administration
  3. User and Role Administration
  4. Security Administration
  5. System Preferences
  6. TDM Server Administration
  7. Connections
  8. Pass Phrases
  9. Dictionaries
  10. User-Defined Datatypes

Creating a Connection

Creating a Connection

You can create a source or target connection in Test Data Manager.
Before you can test a Teradata or a Teradata Parallel Transporter connection, you must add the Teradata JDBC JAR files
tdgssconfig.jar
and
terajdbc4.jar
to the following location:
<Informatica installation directory>\TDM\lib\thirdparty
. Restart the Test Data Manager Service after you add the files.
If you reuse the name of a connection previously created and deleted in Test Data Manager, a workflow that you use the connection in might fail. The workflow might fail because a connection object with the same name and different properties exists in the domain repository.
  1. In the
    Administrator | Connections
    view, select
    New Connection
    from the
    Actions
    menu.
    A tab opens to display the new connection properties.
  2. Select the connection type and define the connection name, description, and user information.
    The connection name must begin with an alphabetic character. If you enter a connection name that begins with a numeric character, a workflow that includes the connection might fail.
  3. Optional. Click
    Change Owner
    and select a different user as the connection owner.
  4. Click
    Next
    .
  5. Enter the connection properties.
  6. Click
    Test Connection
    to test the connection.
  7. Click
    Finish
    to save the connection.
    The connection is visible in the
    Administrator | Connections
    view.
  8. Optional. Select the connection in the
    Administrator | Connections
    view, and click
    Actions
    Test Connection
    to validate the connection.