Push data from an Excel spreadsheet to an Oracle database using Javelin

Products

• CA Test Data Manager (Data Finder / Grid Tools)
• Testing Tools

Issue/Introduction

Requirement: take the field names from an Excel spreadsheet, create a table in Oracle, and populate it with the data.

 

Environment

TDM 4.10+
Javelin 4.10.x

Resolution

Required Steps:

1. Read the Excel file into data reader
2. Collect the Column Names
3. Create Database table
4. Push data into Oracle

Please see attached Javelin Script as an example.