An XML Data Server corresponds to one XML file that is accessible through your local network.

XML files are accessed through the Oracle Data Integrator Driver for XML. This JDBC driver loads the XML file hierarchical structure in a relational structure in a schema stored in memory to enable SQL queries through JDBC. It is also able to unload the relational structure back in the XML File.

You must have following information:

· The location of the DTD file associated with your XML file

· The location of the XML file

· The name of the Root element of your XML file

Creation of the Data Server

Step: 1) Select XML from the Technology list view. Right click and select New Data Server.

Step: 2) Fill in the following fields in the Definition tab:

· Name: Name of the Data Server as it will appear in Oracle Data Integrator.
· User/Password: Not used here.

Step: 3) Fill in the following fields in the JDBC tab:

JDBC Driver: com.sunopsis.jdbc.driver.xml.SnpsXmlDriver

JDBC URL: jdbc:snps:xml?[property=value&property=value...]

JDBC Driver Properties:

Example:

jdbc:snps:xml?f=../xml/department.xml&re=Department_DIM&ro=false&case_sens=true&s=Depart

Step: 4) Click test Connection button it will ask you for saving it press ‘ok’ then it will ask again for creating physical schema press ‘ok’

Creating a Physical Schema for XML

The Physical Schema will be a storage location for the tables associated with the XML file.

Step: 1) Select the appropriate XML Data Server then right-click and select New Physical Schema. The Physical Schema window will appear.

Step: 2) Name the Schema and Work Schema. Note that if you have named the schemawith the s=<schema name> property of the JDBC URL of the XML Data Server, you must use the same schema name here.