search cancel

TDM Portal generate CSV data and DB data concurrently

book

Article ID: 216385

calendar_today

Updated On:

Products

CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

How to configure a generator in the TDM Portal that generates records in a CSV file and at the same time generates records in a database.

Environment

Release : 4.9, 4.10

Component : CA Test Data Manager - TDM Web Portal

Resolution

It is only possible to publish either to a CSV file or to a table. Not at the same time.
As a workaround it may be possible to publish to a CSV. Then as part of the same generator a 'Post Publish Action' can be configured. 
This action could then run a SQL script that loads the CSV into the database table.