Register and Manage Relational Schema

In the CA TDM Portal, you register objects so that you can perform various data manipulation operations (for example, data generation) on them. You register objects in context of a project and its version.
tdm42
In the CA TDM Portal, you register objects so that you can perform various data manipulation operations (for example, data generation) on them. You register objects in context of a project and its version.
The CA TDM Portal supports registering and managing the following object types:
The high-level process to register different object types remains the same; only a few options differ based on the type you select.
Follow these steps to register Relational Schema:
  1. Select an appropriate project and its corresponding version from the Project drop-down list in the top blue bar.
    This selection sets the required project and version context for all the related operations that you perform in the Portal.
    Note:
     If the project is not available, create a new project.
  2. Click the 
    Modeling
     options in the left pane to expand it.
    Note:
    If the left pane is hidden, click the icon (represented by three horizontal bars) in the top left corner to view the pane.
  3. Click the
    Objects
    option to view the available options.
  4. Click the
    Register New Object(s)
    button.
  5. The
    Register New Object(s)
    page opens.
  6. Enter information in the following fields:
    • Object Type
      Lets you select the type of the object that you want to register. Select Table from the drop-down list.
    • Connection Profile
      Specifies the connection profile that associates the database to register tables from.
    • Schemas
      Lets you specify the schema within the database that the selected connection profile points to. Select an appropriate schema.
    • Tables
      Lets you specify the tables included in the selected schema. Select all the tables that you want to register.
      Note:
       Registering tables from a Teradata database with special characters in table or column names fails. Ensure that all characters are UTF-8 encoded. 
  7. Click 
    Register.
    The Registered Objects page opens with the newly registered tables added to the list of registered objects.
    You have successfully registered the data tables.
    Note:
     To delete a registered object, click the cross icon (X) for the required object and confirm the deletion. You can also select multiple objects and delete all of them at once. A delete job is created and is added to the jobs queue. You can view the jobs queue in the Requests table by clicking the request ID in the message that is displayed. When the status of the job is shown as Completed, the registered object is deleted. You can also click the appropriate row to view the additional information about the job. The additional information is displayed in the 
    Additional Information
     dialog.
  8. You can now publish the data to relational tables. Review Publish Data Using the CA TDM Portal section, for detailed steps to publish data to target database schema.