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: 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. Process namespace – Set this value to 0 if you do not want namespace specification to be considered during parsing. The default value is 1. Preserve Element whitespace – Set this value to true (1) to allows the whitespace in the XML element value to be preserved. If set to false (0), any whitespace surrounding XML element values is trimmed, or if the XML element value includes only whitespace, it is interpreted as an empty element value.
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. The DB Schema options are as follows: Attribute name case – formats the attribute names generated from the xml. "upper" and "lower" will convert the attributes names accordingly. "mixed" leaves the names as they appear in the xml document. The default value is mixed. Attribute name prefix – prefix to be used for every generated attribute name. Create indexes – If set to1, indexes on the primary keys of the tables are automatically generated. The default value is 1. Create flat views – If set to1, a view called V_XML_CONTENT is automatically generated. This view joins all tables and returns all xml data in a broad table. The default value is 1. If the database schema result in more than 32 tables, this view does not work and the option has to be switched off. Foreign key prefix – prefix to be used for attributes which are foreign keys. Ignore Empty Leaf Element Values – Set this value to true (1) if you do not want the database to include column entries for specific XML leaf elements that contain no data. If set to false (0), the database created from the XML document will include column entries for all XML leaf elements whether empty or not. Primary key name – Attribute name to be used for primary keys. Table name case– formats the table names generated from the xml. "upper" and "lower" will convert the table names accordingly. "mixed" leaves the names as they appear in the xml. document Table name prefix – prefix to be used for generated table 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.