process complex data natively and in-flight


Bookmark and Share

problem: unstructured data, relational tools

Many of today’s ETL and data integration software solutions were designed in the ‘90s to handle operational and legacy data stored in highly-structured data formats including relational databases and flat files.  Structured data remains a critical element for business analytics, but experts estimate that more than half the information generated by organizations today is unstructured or semi-structured “complex” data – stored in legacy systems, spreadsheets, word processing files or XML-based industry-standard or proprietary formats.

Most ETL and data integration tools need to “flatten” complex data and read each data record separately and/or require developers to manually reestablish these relationships with custom code – a tedious and error-prone data mapping process that also creates performance bottlenecks.

expressor solution: process complex data natively and in-flight

The expressor semantic data integration system was built from the ground up to process complex data “natively” and “in-flight,”  which means expressor maintains the structure and hierarchy of complex data as it is extracted from one or multiple information sources, transformed and loaded into the target data formats.  By preserving the physical structures of complex data such as XML documents as it passes through expressor’s parallel data processing engine, expressor eliminates the need to deconstruct complex data for processing and reconstruct it for storage.

In addition, expressor’s high-performance engine is capable of processing terabytes of data per hour, in batch or real-time mode.  The expressor processor offers flexible deployment across Windows, Linux, and UNIX computers and provides connectors to a wide range of data sources, including:

  • CDISC
  • flat files
  • FTP
  • HL7 v3.x
  • LDAP
  • messaging queues
  • ODBC
  • rdbms
  • SAP IDOC
  • SAS files
  • XML documents

benefits: true next-generation complex data processing

By choosing the expressor semantic data integration system for complex data processing, you can benefit from:

  • business intelligence applications that encompass all your organization’s structured and unstructured data
  • faster and more efficient processing of complex data
  • eliminating the need for custom code, thereby reducing the room for error and improving data quality
  • leveraging expressor’s smart semantics capabilities for business rule reuse and better communication between business and IT
  • greatly reducing the time and effort to develop these kinds of data processing applications
  • reducing your hardware costs and taking full advantage of expressor’s highly affordable, usage-based pricing model


   
    smart semantics cut development cost
    breakthrough scalability delivers ultimate performance in batch and real-time
    role-based development improves lifecycle management
    usage-based pricing reduces software licensing costs up to 80%