How to import external file to database through TDM portal

book

Article ID: 141159

calendar_today

Updated On:

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