Create Project in Datamaker

If you have a simple application, you can work with just one project with one version. For complex applications, you can choose to work with multiple project versions. You can save your data definitions against an initial version of the project and then save (Register) any changes or new tables against a new project version. This method allows you to only identify changes from version to version, rather than having to save the definitions of all the tables. For more information, refer Datamaker User Guide.
tdm40
If you have a simple application, you can work with just one project with one version. For complex applications, you can choose to work with multiple project versions. You can save your data definitions against an initial version of the project and then save (Register) any changes or new tables against a new project version. This method allows you to only identify changes from version to version, rather than having to save the definitions of all the tables. For more information, refer Datamaker User Guide.
Follow these steps:
  1. Launch Datamaker and connect to the Profile which is mapped with the Test Data Repository.
  2. Provide login credentials in the logon dialog and click the Connect to user button.
  3. Select the required Data Target and click the Connect to Databases and Startup button.
  4. Go to Projects menu and click Project Manager.
  5. Right click the Projects and click New Project and Version.
  6. Specify the following in the Create New Project dialog and click the Save Details button:
    • Project Name
      Specifies the name of the project.
    • Project Description
      Specifies the description of the project. If left empty defaults to Project Name
    • Version
      Specifies the version number of the project.
    • Version Description
      Specifies the description of the version. If left empty defaults to Version.
    • Generic
      Specifies whether the project is Generic or not.
  7. Click OK on Project Settings and New Project dialogs.
Register Test Data Mart
You must register the data definitions to Datamaker to manage the data. You can register the data definition just once per version. Thereafter, you can re-register only the table or data definition, if you edit them.
Follow these steps:
  1. Expand the newly created project from the Projects tree view and locate the Version folder.
  2. Right click the Version folder and click Register.
  3. In the Select the type of object to register dialog, select Database Table and click the Next icon.
  4. In the Register Object Explorer window, select the test data mart table that you want to register with the project.
  5. Select Register Tables from Data Target from the dropdown list, and then click the Go icon.
  6. Click the Go icon, in the Reconcile Objects to Register window.
  7. Click Yes, in the Calculate Table Order dialog.
  8. Close the windows opened during the above steps.
Create a Test Match Data Pool
A data pool is a centralized data object, where the necessary information to perform business transactions is stored in a standardized way. When creating a data pool, you can specify the type based on the format of the data you wish to save. For performing test match, you can create the data pool of Test Match type.
Follow these steps:
  1. Expand the newly created project from the Projects tree view and locate the Version folder.
  2. Right click on the Version folder, and click New Data Group.
  3. Specify the following in the New Data Group dialog and click Save Details:
    • Name
      Specifies the name of the Data Group.
    • Description
      Specifies the description of the Data Group. If left empty defaults to Name.
    • On Demand?
      Specifies the option to access data and visual flows on demand using the Datamaker Service Layer. Select, if you want to run the test match also from Test Data on Demand (TDoD).
    • Type
      Specifies the type of Data Group. Following are the available options:
      • Normal
        Select this option to specify that the data group is of Normal type.
      • GTSubsets
        Select this option to specify that the data group is of GTSubsets type.
      • CA Agile Requirements Designer
        Select this option to specify that the data group is of
        CA Agile Requirements Designer
        type.
         
  4. Click OK in the confirmation dialog.
  5. Right click on the Data Group you created, and then click New Data Set.
  6. Specify the required details in the New Data Set window and click Save Details icon. Following are the additional fields to specify in this step:
    • Make Test Data available for external use
      Specifies whether the Test Data can be made available for external use.
  7. Click OK in the confirmation dialog.
  8. Right click on the Data Set you created, and then click New Data Pool.
  9. Specify the following in the New Data Pool window and click Save Details icon. Following are the additional fields to specify in this step:
    • Type
      Specifies the type of Data Pool. Select Test Match from the dropdown list. Following are the available options:
      • Data Only
      • Normal
      • Test Match
      • GTSubsets
      • CA Agile Requirements Designer
  10. Go to the Test Matching tab and do the following:
    • Click the Tables and Columns tab and specify the following:
      • Profile Name
      • Table Owner
      • Match data in table
      • Report match in column
      • Report user in column
      • Report locking in column
      • Expected Results in column
      • Report Job ID in column
      • Default Summary Table Publish
    • Click the Key Columns tab and specify the following:
      • Report Key Columns
        Set of columns that are uniquely identifiable. Locks one record, and blocks all the duplicate records found with same values in reporting key columns.
      • Primary Key Columns
        These are the surrogate key columns. The clauses of the query are formed based on this column.
      • Data Attribute Columns
        These are the reporting columns. This identifies the attribute columns to show in the reports.
  11. Click the Save Changes and Exit icon.
Connect to a Database Using a Non-EZconnect Connection String
When I run a test match in CA TDM Portal  and your
spring.datasource.url
 parameter is assigned with a complicated or non-standard jdbc connection string, and you try to connect to a database, you may get an error message similar to the following.
Exception occured while updating job start information
ORA-12154: TNS:could not resolve the connect identifier specified
In this case, define the connection string in your
application.properties
file in C# format.
  1. Navigate to the directory where you installed the CA TDM Portal, and open the conf subdirectory.
  2. Locate and open the application.properties file in a text editor.
  3. Define the connection string. Add or update the following parameter:
    tdmweb.TDMLegacyExecuterService.testmatch.connectionString
    Format: Enter the connection string in C# style.