Processing XML data within an RDBMS not in memory

By default, ODI will perform XML processing within the default in-memory database, HSQL. For out of the box JVM settings, small XML files, less than 2-3 megabytes, the in-memory database will perform as expected. However, for larger XML files, or when there is a large amount of files, it is easy to exceed the reserved amount of memory for processing within the JVM. When the JVM memory size is exceeded, the JVM will crash, and it is necessary to tune the JVM settings to allow for the large amount of memory the in-memory database will require. The XML JDBC Driver can also be set up to use a relational database for this processing. Similar to the in-memory database, a relational schema will be created in the RDBMS to match the logical schema. The physical schema in the relational database will be managed by ODI; the artifacts will be created, updated, and deleted as needed by the ODI XML JDBC Driver. The set up to use an RDBMS for XML processing...