Connect Datamaker to Test Data Source and Target Databases

You can add new connections at any time, and you can also specify which is the source and which is the target before you connect.
Test Data Manager
 allows for three simultaneous database connections:
  • Repository
  • Data source
  • Data target
The data source and target are data sources that you can use to store and publish test data. The source is typically the source of the original data, and the target is where you publish the transformed data. The distinction between source and target does not have to be this clear. If it is not, simply configure the database connections you need and define them as source and target at a later time.
Test Data Manager
 provides several sample data sources that you can use to familiarize yourself with the product or to serve as real data sources. For them to be available as source and target data sources, you must first install them using the instructions in Install the Repository. Alternatively, you can use existing databases or databases you have created yourself.
You can connect to data sources using Datamaker or the CA TDM Portal. The CA TDM Portal uses JDBC to connect to databases. Datamaker uses ODBC by default. JDBC connections are visible across both interfaces, while ODBC connections are only visible in Datamaker. If you are defining connections in Datamaker, establish a DSN-less connection to be able to work with the connection in the CA TDM Portal.
Follow these steps:
  1. Log in to Datamaker.
  2. From the main connection screen, ensure that 
     is selected under '
    Get profiles from
     We recommend that you store connection profiles in the repository, not in the registry. 
  3. Click the 
    Create New Profile
     button (yellow folder icon).
    Create Connection Profile for Data Target
     dialog opens.
  4. Select the Database Type to which you want to connect. Click the 
     button (blue arrows).
    Create New Profile in Test Data Repository
     dialog opens.
  5. Enter a name for the profile in the 
    Profile Name
     field has a 30 character limit.
  6. Select the type of driver you want to use to connect to this database, from the 
     dropdown list.
    Different options appear, depending on what type of DBMS connection you choose.
  7. (
    DSN-Less ODBC
     only) These options vary further, depending on which ODBC driver you select.
    Other Parameters
     field is for additional database connection properties. These properties are specific to your database type. See your specific database documentation for a comprehensive list of available properties.
  8. When all fields are complete, the 
    Test Connection
     button ('cog' icon) and 
    Create New Profile
     (tick icon) become available.
    When complete, the new connection profile appears on the main connection screen.
  9. Click the green 
     button to connect to Datamaker using the selected data sources.
You can add new connections at any time, and you can also specify which is the source and which is the target before you connect.
You can edit or delete connection profiles at any time by right-clicking a profile. You can also copy an existing profile so that it can serve as a template for a new profile.