Workflow Basics Guide

10.5.6
- 10.5
- 10.4.0

Back Next

Working with XML Sources

When you create a session to read data from an XML source, you can configure source properties for that session. For example, you might want to override the source file name and location in the session properties.

The following table describes the properties you can override for XML readers in a session:

XML Source Option	Description
Treat Empty Content as Null	Treat empty XML components as Null. By default, the Integration Service does not output element tags for Null values. The Integration Service outputs tags for empty content.
Source File Directory	Location of the Source XML file. By default, the Integration Service looks in the service process variable directory, $PMSourceFileDir. You can enter the full path and file name. If you specify both the directory and file name in the Source Filename field, clear the Source File Directory. The Integration Service concatenates this field with the Source Filename field. You can also use the $InputFileName session parameter to specify the file directory.
Source Filename	Enter the file name or file name and path. Optionally, use the $InputFileName session parameter for the file name. If you specify both the directory and file name in the Source File Directory field, clear this field. The Integration Service concatenates this field with the Source File Directory field when it runs the session. For example, if you have “C:\XMLdata\” in the Source File Directory field, then enter “filename.xml” in the Source Filename field. When the Integration Service begins the session, it looks for “C:\data\filename.xml”.
Source Filetype	Use to configure multiple file sources with a file list. Choose Direct or Indirect. The option indicates whether the source file contains the source data, or whether the source file contains a list of files with the same file properties. Choose Direct if the source file contains the source data. Choose Indirect if the source file contains a list of files. When you select Indirect, the Integration Service finds the file list and reads each listed file when it runs the session.

The following table describes the properties you can override for an XML Source Qualifier in a session:

XML Source Option	Description
Validate XML Source	Provides flexibility for validating an XML source against a schema or DTD file. Select Do Not Validate to skip validation, even if the instance document has an associated DTD or schema reference. Select Validate Only if DTD is Present to validate when the XML source has a corresponding DTD or schema file. The session fails if the instance document specifies a DTD or schema and one is not present. Select Always Validate to always validate the XML file. The session fails if the DTD or schema does not exist or the data is invalid.
Partitionable	You can create multiple partitions for the source pipeline.

XML Source Option

Description

Validate XML Source

Provides flexibility for validating an XML source against a schema or DTD file. Select Do Not Validate to skip validation, even if the instance document has an associated DTD or schema reference. Select Validate Only if DTD is Present to validate when the XML source has a corresponding DTD or schema file. The session fails if the instance document specifies a DTD or schema and one is not present. Select Always Validate to always validate the XML file. The session fails if the DTD or schema does not exist or the data is invalid.

Partitionable

You can create multiple partitions for the source pipeline.

Sources

Server Handling for XML Sources

Download Guide

Watch

Comments

Communities

Knowledge Base

Success Portal