Writing Data to Excel Spreadsheet from Javelin in Batch Mode

Products

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

Issue/Introduction

 

 

Need guidance on how to write data from Javelin in batch mode from an MS SQL server to an excel spreadsheet.
The reason for this is that when we try to export 60K rows at one time the export fails.

Environment

Javelin v2.0.715.0
Datamaker 4.8.0.15
TDM Portal -4.8.173.0

Database - Microsoft SQL Server Developer v12.0.6329.1

Cause

NA

Resolution

Find attached an example flow that shows how you can import data from a SQL server into a DataTable in Javelin and then work through the records in batch mode to write to an excel spreadsheet.
this requires adding the following imports:

 

Additional Information

This was built and tested on Javelin 4.8.137