Test Data Manager

Expand all | Collapse all

CA - Data generation using PostgreSQL

Jump to Best Answer
  • 1.  CA - Data generation using PostgreSQL

    Posted 06-04-2018 02:38 AM
      |   view attached

    CA PAM says that there is no support for PostgreSQL - Data generation. I was able to create generation rules and preview data. When published the data to target, got the following error:

     

     

    ----

    Log for Data Pool: dp 4.4.0.23 (S11) 3.2K

    Publish to Data Target (Profile - Cancel) schema postgres
    Start date and time: 6/4/2018 11:43:37

    Default values used for Variables

    Publish to Data Target (Profile - Cancel) schema postgres
    Start date and time: 6/4/2018 11:43:37
    Initialising datastores: 6/4/2018 11:43:37

    Status Table Table Location Seq Rows Comments
    Exclude CUSTOMER_BASIC_TDM POSTGRES 2 1 0 table missing from POSTGRES

    Finishing: 6/4/2018 11:43:37

    End date and time: 6/4/2018 11:43:37
    Total Elapsed time: 0 seconds

    Publish errors occurred - See below


    Publish errors

    No tables to publish - STOPPING

    ---



  • 2.  Re: CA - Data generation using PostgreSQL
    Best Answer

    Posted 06-08-2018 12:48 AM

    Hi Swathy,

     

    As per the documentation (link given below), PostgreSQL is not a supported Databse for generation. 

     

    Supported Data Sources - CA Test Data Manager - 4.5 - CA Technologies Documentation 

     

    The reason that you were able to make a connection to it and create rules is to do with the fact that 

    "As long as you have a valid driver for any Database, Datamaker can make a connection to it". 

     

    I hope you find this useful.

     

    Regards,

    Aditi

    Sr. Support Enigneer

    TDM/ARD