Read Excel Data into DataStage

Check out the video associated with this blog! In version 9.1 of DataStage, you can read Excel sheet data (.XLS and .XLSX) directly into DataStage using a new stage called the Unstructured Data stage. Let’s take a closer look at how to do this. First, we’ll create a simple parallel job which connects three stages: an Unstructured Data stage, a Transformer stage, and a Data Set stage. This job will read the data from the Excel… read more →