Relational Database Support
Streamlined Development and Deployment
When building XML data integration applications, the Data Integration Suite provides highly-functional development support for all major relational databases. Data Integration Suite also supports programmatic, bi-directional access to virtually any non-XML file including EDI standards, flat files, and other legacy formats.
When it comes to relational database integration at runtime, the Data Integration Suite is an easily embeddable component, requiring no other product or application server. It has no server of its own, and is not tied to a specific vendor database or database version. Supported relational databases include:
In fact, Data Integration Suite generates one easy-to-maintain application regardless of the databases and versions in use. This component application is then insulated from frequent changes to the database and database vendor tools.
Data Integration Suite translates relational data query into SQL, executes the SQL, and returns the results in the specified format. This means that Data Integration Suite queries very large databases in a highly efficient manner, using the indexes and query optimization of the database. Lazy result retrieval also ensures that large results are efficiently handled by the Data Integration Suite application.
XQuery API for Java (XQJ)
The XQuery API for Java (XQJ), currently under development under the Java Community Process as JSR 225, lets programmers use XQuery for XML programming and data integration, with full access to the J2SE and J2EE platforms. XQJ allows a Java program to connect to XML data sources, prepare and issue XQueries, and process the results as XML. This functionality is similar to that of JDBC Java API for SQL, but the query language for XQJ is XQuery. Progress DataDirect Data Integration Suite implements XQJ, which allows developers to dramatically simplify Java programs that work with XML and relational data. It supports Early Draft Review 1 of JSR 225.
- XQJ Tutorial – an extensive and accessible tutorial on XQJ. Includes source code for four complete programs.