Test Data Manager

  • 1.  TDM Assistance / Brainstorm / Ideas

    Broadcom Employee
    Posted Nov 24, 2017 04:09 AM

    Hi,

     

    I have a couple of projects, that I have been designing a solution, working out best way to do it. But with all the TDM brainpower out there I thought I would also ask for your suggestions idea, to see how close or not they match mine.

     

    One.

    The customer has 800+ databases, spread across various DB severs. We will need to connect to these as both target and source.

    How would you say is the best way to construct these connections?

    This is just for connection profiles etc.

     

    Two

    We have ARD, within which we will generate numerous data fields for injection into various systems. The challenge is that we need to keep track of these variables and contents in a temp area as they are used in the flows of ARD. The idea being that it is populated by all new / add functions, then values used and updated for modify actions, finally removed for delete options. The flows will be separated and not all in one flow. (Separate Add/change/delete).

     

    Also, each “record” would need to be flagged as a good or bad data (As required / used by the test case).

    So, we get correct responses from the application. And, so we can use values via DevTest to validate data in the end application database.

     

    Any ideas, suggestions please as I said I have come up with some ideas for solutions, but am only human.

     

    Ta

     

    Mark



  • 2.  Re: TDM Assistance / Brainstorm / Ideas

    Posted Nov 24, 2017 05:30 AM

    Hi Mark_Ireland

     

    For question 1, have you looked at the TDM Portal web-services API - there is an interface for creating new JDBC connection profiles.  The advantage of JDBC connections is that they are visible in both DataMaker and TDM Portal, whereas ODBC connections are not visible in TDM Portal.

     

    I have never done it in bulk but it should be possible to create a series of .json files for each connection and use cURL to post them to the TDM Portal web-service. 

     

    See https://docops.ca.com/ca-test-data-manager/4-3/en/reference/rest-api-reference

     

    And on your local TDM Portal server:

    https://<server>:<port>/TDMConnectionProfileService/swagger-ui.html

    https://<server>:<port>/TDMConnectionProfileService/swagger-ui.html#!/con45profile45controller/createAuthUserProfileUsingPOST

     

    Let me know, and we can find some time to test it out.

     

    Regards,

                  Adrian