TDM: Need best practice for creating database connection profiles

Products

• CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

What is the best practice for creating database connection profiles for FDM, DataMaker and Portal so the connections show up in each components without having to add connection profiles in each manually.

We do not have passwords to any of our databases, so each time we create a connection profile we need a admin to enter the password for us.

Is there a way to share connection profiles between all three components?

Environment

Release : 4.9 and later

Component : CA Test Data Manager - TDM Web Portal

Cause

N/A

Resolution

As per our documentation:

https://techdocs.broadcom.com/us/en/ca-enterprise-software/devops/test-data-management/4-9/provisioning-test-data/defining-test-data/defining-test-data-using-the-ca-tdm-portal/create-and-edit-connection-profiles.html

Use the CA TDM Portal to create connection profiles for Microsoft SQL Server, DB2, MySQL, MariaDB, Oracle, Sybase, PostgreSQL, and Teradata databases. CA TDM Portal does not support connection profiles using DSN type that were created in CA TDM DataMaker. Profiles created in the CA TDM Portal are compatible with both TDM Portal and DataMaker. You can also share a connection profile with a group. When a connection profile is shared with a group, all users associated to that group can then access the shared connection profile.

Currently there is not a way to share FDM with DM or Portal.