Test Data Manager

  • 1.  CA TDM - Self Service Portal for Multiple Datasources

    Posted Jun 12, 2018 08:05 PM

     

    Background :- 

    We are performing a POC on CA TDM - Tester Self Service ( Data reservation Portal) for one of the largest banks in Australia. From the documentation available on web i can see that test data engineer had to create data mart as

    pre-requisite from various data sources and then only testers can reserve the data. 

     

    Question :-

    We have data scattered across IMS , DB2 and Oracle Data sources ( Multiple Oracle DB's on different hosts) in the bank.To create a data mart for Data reservation portal do we need to extract the data from these multiple data sources and store a copy in data mart and define relationships or does the tool directly connects to multiple DB's ( including multiple Oracle DB's hosted on different hosts and IMS and DB2 on Mainframes)  and pull the data dynamically based on predefined relationships ?   Can you also please let me know if the data mart tables had to be created in any specific format ?



  • 2.  Re: CA TDM - Self Service Portal for Multiple Datasources
    Best Answer

    Posted Jun 14, 2018 06:27 AM

    Hi,

     

    Data reservation allows portal to access different databases and establish relationships across these databases.

    Link : https://docops.ca.com/ca-test-data-manager/4-5/en/provisioning-test-data/configure-test-data-reservation-service/configure-dynamic-test-data-reservation-service#ConfigureDynamicTestDataReservationService-Considerations 

    Supported DBs: Supported Data Sources - CA Test Data Manager - 4.5 - CA Technologies Documentation  (IMS and DB2 on mainframe not supported)

    Hope this helps.

     

    Regards,

    Aditi