Creating an XML Data Server

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.

Pre-requisites

JDBC Configuration

XML files are accessed through the Oracle Data Integrator Driver for XML. The driver is installed with Oracle Data Integrator.

Connection Information

You must ask the system administrator for the following information:

Creation of the Data Server

To create an XML Data Server:
  1. Connect to Topology Manager

  2. Select Topology > Physical Architecture > Technologies > XML in the tree

  3. Right click and select Insert Data Server

  4. Fill in the following fields in the Definition tab:

  5. Fill in the following fields in the JDBC tab:

JDBC Driver Properties:

Parameter

Value

Notes

f

<XML File location>

XML File location (relative or absolute) in UNC format. Use slash “/” in the path name and not backslash “\” in the file path.

d

<DTD File location>

 

DTD File location (relative of absolute) in UNC format. Use slash “/” in the path name and not backslash “\” in the file path. If this parameter is missing, the driver will build the name of the DTD file from the XML file, replacing the ".xml" extension with “.dtd”.

re

<Root element>

Name of the element to take as the root table of the schema. This value is case sensitive. This parameter can be used for reverse-engineering a specific message definition from a WSDL file, or when several possible root elements exist in a XSD file.

ro

true | false

If true, the XML file is opened in read only mode.

s

<schema name>

Name of the relational schema where the XML file will be loaded. If this parameter is missing, a schema name is automatically generated from the file name.

cs

true | false

Load the XML file in case sensitive or insensitive mode. For case insensitive mode, all element names in the DTD file should be distinct (Ex: Abc and abc in the same file are banned). The case sensitive parameter is a permanent parameter for the schema. It CANNOT be changed after schema creation. Please note that when opening the XML file in insensitive mode, case will be preserved for the XML file.

Example:

jdbc:snps:xml?f=../demo/xml/GEO_DIM.xml&re=GEOGRAPHY_DIM&ro=false&case_sens=true&s=GEO

      Warning ! To access an XML file, you must first ensure that the file is not locked. To check if a file is locked, look for a .lck file in the directory of your XML file.

  1. Click Test.

  2. Click Test in the Test Connection window.

  3. A windows indicating a Successful Connection should appear. Click OK. If the connection is not successful, then refer to the Common Errors with XML.

  4. Click OK to validate the creation of the data server

The creation window for the data server's first Physical Schema appears.
See Creating an XML Physical Schema