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.
XML files are accessed through the Oracle Data Integrator Driver for XML. The driver is installed with Oracle Data Integrator.
You must ask the system administrator for the 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
Connect to Topology Manager
Select Topology > Physical Architecture > Technologies > XML in the tree
Right click and select Insert Data Server
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.
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...]
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. |
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.
Click Test.
Click Test in the Test Connection window.
A windows indicating a Successful Connection should appear. Click OK. If the connection is not successful, then refer to the Common Errors with XML.
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