XML via SQL Data Provider properties list

XML via SQL Data Provider Properties List sets processing options for the XML source file. The properties that are mandatory appear in bold text.

Required properties

Property	Description
XML Source	Identifies the data source. You can select the XML data source when you add a component to a project, or select the file from the Properties window. To select a data source from the Properties window, click XML Source, then select the file.
Data Output	Click the Data Output icon to open XML port manager. XML port manager is a management console where you can query the XML source. See “Working with XML Port Manager” for more information.

Property

Description

XML Source

Identifies the data source.

You can select the XML data source when you add a component to a project, or select the file from the Properties window. To select a data source from the Properties window, click XML Source, then select the file.

Data Output

Click the Data Output icon to open XML port manager. XML port manager is a management console where you can query the XML source.

See “Working with XML Port Manager” for more information.

Optional properties

Property	Description
Document Schema	Click the Document Schema icon to identify an external schema (.xsd) or DTD that you can use to validate the XML source.
Namespace Schema	Points to the location of an external namespace schema. An XML schema consists of components such as type definitions and element declarations that can be used to assess the validity of well-formed element and attribute information items.
Validate Schema	Select this option if you want to enable schema and DTD validation.
XML Options	Click XML Options to open a window where you can set these XML processing options: Process namespace - Set this value to 0 if you do not want namespace specification to be considered during parsing. The default value is 1. Full schema check - Set this item to 1 to check for items that may be time-consuming or memory intensive. The particle unique attribution constraint checking and particle derivation restriction checking are controlled by this option. The default value is 0. Ignore external DTD - Set this value to 1 to ignore an external DTD referenced within the document. The default value is 0.
DB Schema	Click the DB Schema icon to select the database schema setup (create tables) script. Use this option to enforce a fixed data model.
DB Schema Options	Click the DB Schema Options icon to open a window where you can customize the settings for tables and attributes generated from the XML structure, including the prefixes for table and attribute names.
Database Options	Click the Database Options icon to open a window where you can set options that override performance defaults and control the behavior of some transactions. See “Database connection settings”.
Read Block Size	Determines the number of records retrieved by the component in a single step. If the component has more than one output port, the read block size is ignored and the component provides data at all ports, in a single step.