Quick Start: DataDirect Data Integration Suite

The products included in the DataDirect Data Integration Suite – Stylus Studio 2008 XML Enterprise Suite, DataDirect XQuery, and DataDirect XML Converters – allow you to easily build applications to manage today’s data integration challenges. From querying relational data, converting data in numerous non-XML formats to XML, to transforming that data to PDF and HTML, to updating databases and generating code for Java and .NET, DataDirect Data Integration Suite has the power and flexibility you need.

This quick start identifies resources that will give you some ideas about how to use the tools of the DataDirect Data Integration Suite in your enterprise. For specific information about using a particular tool or API, see the product documentation for that component.

What Do You Want to Do?

Getting started with the DataDirect Data Integration Suite is easy – it’s just a matter of understanding the problem you need to tackle. We’ve compiled a short list of common scenarios our users have encountered, and how DataDirect Data Integration Suite products were able to help.

Create and Integrate Web Services

XQueryWebService is a framework that allows you to expose an XQuery as a Web service. In this example, you'll see how you can use tools in the DataDirect Data Integration Suite to build powerful data services that query, aggregate, and update multiple data sources.

http://www.xquery.com/examples/web-service-example/

DataDirect Data Integration Suite can help you design, test, and implement Web services, leveraging the power of XQuery to query an incoming request as XML, and query relational databases or XML configuration files that are available to the implementation running on the middle tier, producing the XML needed for a response.

http://www.xquery.com/web_services/

With the DataDirect Data Integration Suite, you can consume and join Web Services by joining XML documents and results from Web Service invocations, and exposing and testing XQuery(ies) as Web Services on Apache Tomcat server

http://www.xquery.com/developers/webinars/data-integration/

Join XML and Relational Data

One of the main challenges facing many IT organizations today is managing data from disparate sources and in different formats. XML has emerged as a technology that is helping to bridge the divide between legacy systems and current technologies. See how you can use the tools in the DataDirect Data Integration Suite to join XML and relational data.

http://www.xml-connection.com/2008/03/joining-xml-with-rdbms-how-and-what-are.html

Aggregate different data sources with the DataDirect Data Integration Suite by joining XML and relational data to create an XML document containing information from multiple data sources as the result.

http://www.xquery.com/developers/webinars/data-integration/

Integrate XML Data from Your Database

Increasingly, XML is stored in relational databases as structured XML. Some applications will continue to shred XML into a relational format or store XML as CLOB values. Other applications can now take advantage of relational databases that support a native XML data type to represent an XML document or XML document fragment. See how you can use DataDirect Data Integration Suite tools to query XML stored as character data and query XML stored as XML here:

Convert EDI Messages to XML

Conversion modules in the DataDirect Data Integration Suite are able to handle many EDI dialects easily – X12, HL7, and others – managing and converting transaction sets, segments, elements, and code lists to XML. XML Converters, one of the products in the Data Integration Suite, use their embedded EDI dictionary to help you create syntactically pure and semantically accurate EDI, converting to/from XML or diagnosing problems with incoming and outgoing EDI data.

X12 – Example

http://xmlconverters.com/tutorials/translate-x12-to-xml.html

HL7 – Supported Standards

http://www.xmlconverters.com/standards/hl7/

Custom EDI Formats – Example

http://xmlconverters.com/tutorials/custom-edi-message-
types.html

Convert Proprietary Files to XML

Companies still frequently use proprietary flat file formats to exchange or circulate information, so relying on standards like EDI is not always an option. But you can rely on tools in the DataDirect Data Integration Suite to help you manage conversion of proprietary file formats to XML.

Convert Tab-Delimited Files to EDI

The DataDirect Data Integration Suite has numerous tools to help you convert all sorts of file formats to XML. But what about converting one file format (say, tab-delimited) to another (in this case, EDI)?

Integrate and Transform Office Documents

Office documents have always been a rich source of data, but their proprietary binary formats have made them all but unusable to businesses seeking to integrate them in their processes. New office document standards like the OpenDocument Format (ODF) and Office Open XML (OOXML) are allowing tools like those in the DataDirect Data Integration Suite to unlock office documents’ enormous potential.

Additional Resources

In addition to this quick start, consider visiting the following pages to learn about the many additional resources – video demonstrations, user forums, product documentation, developer blogs, and more – for the products in the DataDirect Data Integration Suite.