Enable Integrated Security for CA TDM Portal

By default, you specify a user and credentials for each connection. Enable Integrated Security to instead allow the respective logged on user to connect to data sources and targets, and the application GT repository. If the currently logged on user has permissions to access the  repository, or a target or source database, follow these steps here to enable connection as this AD user.
tdm45
By default, you specify a user and credentials for each connection. Enable Integrated Security to instead allow the respective logged on user to connect to data sources and targets, and the application GT repository. If the currently logged on user has permissions to access the
Test Data Management
repository, or a target or source database, follow these steps here to enable connection as this AD user.
Enable Integrated Security Patch for TDM Portal
  1. Open the Windows
    Services
    control panel and stop the
    Test Data Management
    Portal service. Wait for the Portal service to stop.
  2. Right click the portal service and click
    Properties
    .
  3. Click the
    Log on
    tab in the
    Properties
    dialog.
  4. Select the
    This account
    option, and enter the domain account that you want to be used.
  5. Enter the password for this user, and confirm the password. Click
    OK
    .
  6. Open the Windows
    Services
    control panel and start the
    Test Data Management
    Portal service. Wait for the Portal service to restart.
  7. Verify that you can connect at one of these respective URLs, depending on whether you use HTTPS security:
    • http://localhost:8080
    • https://localhost:8443
Create a Connection Profile
  1. Launch CA Datamaker, and log in.
  2. Click
    Create new profile
    in the
    Profiles
    dialog.
  3. Select
    Other
    when asked "What type of database do you want to connect to?"
  4. Complete the profile dialog with your details.
  5. Enable the option
    No login required
    , and leave the username and password blank.
  6. Specify a default schema.
  7. Click
    Test
    and
    Save
    .
    The new profile is visible and usable from CA Datamaker and from CA TDM Portal.
When you enable integrated security on database screen for server type SQL server, the TDM Portal service does not start automatically. Log on with an account that has Windows authentication to the SQL Server, and start the service manually.
(Optional) Use Integrated Security to Connect to the GTREP Repository
After you have enabled Integrated Security, you can also configure CA TDM Portal to use Integrated Security when connecting to the GTREP application repository.
  1. Browse to the following directory In Windows
    C:\Program Files\CA\CA Test Data Manager Portal\conf
  2. Open the file
    application.properties
    in a text editor.
  3. Append
    integratedSecurity=true
    to the
    datasource.url
    property.
  4. Comment out or delete the
    datasource.username
    and
    datasource.password
    fields.
    # Database
    spring.datasource.url =jdbc:sqlserver://localhost:1433;database=gtrep;integratedSecurity=true;
    #spring.datasource.username=
    #spring.datasource.password=
  5. Open the Windows
    Services
    control panel.
  6. Restart the
    Test Data Management
    portal service.