Writing Data to Excel Spreadsheet from Javelin in Batch Mode

book

Article ID: 200926

calendar_today

Updated On:

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.

Cause

NA

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

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 

Attachments

1602016152322__ExportDataTableToExcelInBatches_final.vwf get_app