Defining a connection to XML within ODI

In this section, we will look into how to create a new connection to an existing XML file technology. The connection will be created as a new data server with the XML technology. Technologies are defined in the Topology navigator, so all you need to do to get started is to make sure that this navigator has been selected.

In this recipe, we will create a new data server based on the XML file that is delivered with the ODI demonstration environment. This XML file is named GEO_DIM.xml and is located on the ODI Companion CD and zipped in the oracledi-demo.zip file within the [demo home] \oracledi\demo\xml directory. ODI has an XML JDBC driver, which will be used to connect to the XML file. The XML driver can ...

Get Oracle Data Integrator 11g Cookbook now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.