search cancel

Update Synthetically Generated data When Publishing to an existing Table


Article ID: 187925


Updated On:


CA Test Data Manager (Data Finder / Grid Tools)


We have a need while using generators to publish data to update non-key fields. For example consider a table that has SSN as part of a primary index. When we insert more records to this table via Generator Publish, we want a. to update existing fields for some rows and b. insert new rows.

Can you please advise if we can do that and if so is there an option we need to select? 



Release : 4.8

Component : CA Test Data Manager


Reviewing the TDM documentation. If you are using TDM Portal for the Data Generation and Publishing, then please look over the Data Generation Rules (, and the Publishing Options (

When publishing from TDM Portal, you should find under 'Publishing Options (optional)' an Update setting, which allows the publishing job to update duplicate records found in the target database.