Solutions for XML - DataDirect Connect

The DataDirect Connect family of database drivers for ODBC, JDBC, and ADO.NET supports the native XML capabilities provided by the database vendors. Individual support for Oracle, DB2, Microsoft SQL Server, and Sybase is critical because the level of support provided by each database vendor varies. The prompt support for these native capabilities is important since the database vendors are adding new XML features in each new release of their database products.

For applications that predominantly use relational data but have an occasional need for XML data, the Connect products provide developers the flexibility to access XML data however it is stored in the database. Where available, (for example, Oracle 9i R2 and above and IBM DB2 v9), the Connect products can process XML data that was created with the native XML data type. In other situations, character data types can be used to store and process XML data.

DataDirect's active role in the specification process will allow us to provide early support for any XML features that are adopted by the SQL ANSI, JDBC, ODBC, and ADO.NET specifications. For example, the JDBC 4.0 specification will include support for an XML data type that will be supported in the Connect for JDBC product.

Some of the advantages of using DataDirect for your XML initiatives include:

• Support for the native database XML capabilities. The DataDirect Connect drivers and providers support the native capabilities provided by each database. This is important because the level of support varies between database products and versions. Based on the design of the application and the capabilities provided by the database, developers can use the DataDirect drivers and providers to access data using the native XML data types, or use LOB data types to store and process data.
• Support for the very latest advances in database products. We apply the insight gained from our active role in standards bodies relating to database connectivity specifications. For that reason, DataDirect is well positioned to support advancements in XML capabilities in upcoming specification versions.
• High-level interoperation with DataDirect XQuery. DataDirect XQuery, our powerful XQuery engine for driving XML-intensive applications, is optimized to leverage DataDirect JDBC database drivers. This gives enterprise-class systems high-performance access to numerous and diverse databases with rock-solid reliability.

To speak with an expert about our products and licensing options call 1-800-876-3101 or submit a Request for Information form and an account executive will contact you.