Table of Contents

Search

  1. Preface
  2. Workflow Manager
  3. Workflows and Worklets
  4. Sessions
  5. Session Configuration Object
  6. Tasks
  7. Sources
  8. Targets
  9. Connection Objects
  10. Validation
  11. Scheduling and Running Workflows
  12. Sending Email
  13. Workflow Monitor
  14. Workflow Monitor Details
  15. Session and Workflow Logs
  16. Appendix A: Session Properties Reference
  17. Appendix B: Workflow Properties Reference

Workflow Basics Guide

Workflow Basics Guide

Working with XML Sources

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.

0 COMMENTS

We’d like to hear from you!