Skip to Content
Author's profile photo Former Member

Nested data management – XML File to Dimension Table

In this tutorial, learn how to design a batch type of job for extracting data from a hierarchical XML file, transform and load them into a table MS SQL SERVER 2012.


  • Access to a type of MS SQL SERVER 2012 database or otherwise,
  • An XML file containing the raw data
  • Version: 4.2 SAP Data Services
  • Application: Data Services Designer

/wp-content/uploads/2015/09/2015_09_10_17h37_53_787649.pngThe steps that constitute this tutorial are:

  • Added “MtrlDim” job, work and dataflows
  • Import a DTD (definition of an XML schema format)
  • Definition of the data stream “DF_MtrlDim”
  • Validation of the data stream
  • Running the job

Adding components “Work” and “Data” flows in the Job design space


  • Create New Job entitled “JOB_MtrlDim” In the project area,
  • Right-click and “New batch job”

/wp-content/uploads/2015/09/2015_09_10_17h42_14_787650.pngCreate a “workflow”

In the project area, click the created job.

Select the “Workflow” icon in the tool palette.

Place the “workflow” in the job Workspace and named the “WF_MtrlDim”.


Assigned Tags

      Be the first to leave a comment
      You must be Logged on to comment or reply to a post.