How to import external file to database through TDM portal

Article Id: 141159

Status: Published

Updated On: 03-12-2019 14:08

Products:

CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction:

Can i load data from a external file like (csv, excel, txt etc.) into database table trough CA TDM Portal?

I know this can be done through Datamaker.

My requirement is how to import a excel file from TDM Portal by Self Service Catalog on demand by user from local computer.

Environment:

TDM Portal Version: 4.7.118.0

Data Maker - Version: 4.7.0.9

Component : CA Test Data Manager - TDM Web Portal

Resolution:

You should be able to do the same thing in TDM Portal:

Your file needs to be in a csv format and file not an .xlsx format.

Modeling --> Objects --> Register New Objects(s) --> Object Type --> DELIM(CSV) --> File(s) to Upload (choose Import Data checkbox) --> REGISTER