products

PowerCenter Unstructured Data Option

Dramatically Expanding Data Access

The Unstructured Data Option extends PowerCenter's enterprise data integration capabilities to provide access to unstructured data formats. With this option, IT organizations can seamlessly access, discover, and integrate data from virtually any business system, in any format, including data locked in documents and industry-specific data formats. The ability to access and process any data format creates a powerful tool for delivering a comprehensive view of enterprise data to the business.

Key Features

Unstructured Data Access
  • Provides access to Microsoft Word, Excel, PowerPoint, PDF, WordPerfect, Star Office, ASCII reports, HTML, undocumented binaries, RPG, ANSI
  • Provides access to AFP, PostScript, DJDE

Integrated, Codeless Environment

  • Extends the range of data formats supported by PowerCenter
  • Provides virtually unlimited access to all data formats—unstructured and proprietary
  • Automates batch or real-time transformation of unstructured data without costly and rigid custom programming
  • Leverages PowerCenter’s service-oriented architecture (SOA), which offers high-performance data access at any latency—accelerating development, increasing productivity, simplifying administration, and reducing maintenance costs

Custom and Automatic Data Parsing

  • Automatically processes data elements in unstructured documents
  • Eliminates the need for time-consuming hand coding, increasing IT organizations’ productivity

Benefits

Expand Visibility into All Enterprise Data, Increasing Its Business Value and Reducing Risk
It’s estimated that unstructured data—email, Word documents, Excel spreadsheets, presentations, and PDF documents—accounts for as much as 80 percent of the information that today’s businesses store. PowerCenter’s unique architecture makes it the only offering on the market that can integrate all enterprise data—structured and unstructured—in the same data integration mapping. With this option, IT organizations can leverage unstructured sources of data to enrich data pipelined from traditional structured data sources. This option helps IT organizations arm the business with a comprehensive view of the information needed to make key business decisions that directly influence the bottom line.

Increase IT Productivity and Save Costs by Eliminating the Need for Hand-Coding
With this option, IT organizations can tap into the wealth of data previously accessible only through time-consuming and expensive custom programming. This option increases IT organizations’ productivity with features that automatically process data elements in unstructured documents. Because this option is fully integrated into the PowerCenter platform, IT organizations can leverage built-in parallel execution, batch and real-time data processing, and metadata lineage and reporting to access and integrate unstructured data.

Improve  Business Responsiveness and Agility in Competitive Markets
Many companies are expanding their sales channels to regions where their partners can only send orders through in Word or PDF format via email. For these companies to automatically process orders, they need to translate the order from Word or PDF format into their internal formats. After processing the orders in their internal systems, they then have to then translate the order from their internal formats back into Word or PDF so their suppliers can receive the confirmed orders. With this option, orders that once would have been manually processed (and possibly delayed) can now be automatically processed in a fraction of the time. This option helps businesses reduce order processing costs and errors resulting from manual data entry. In turn, it helps them increase their speed and agility in responding to higher order volumes.

 “...Natexis has been an enthusiastic proponent of combining support for both unstructured and structured data in a single data integration product. With this functionality, PowerCenter helps us achieve greater productivity, drive down costs, minimize operational risks, and accelerate the time to market for new data integration-intensive enterprise applications.”

- Avram Kornberg
Senior Vice President and CIO
Natexis USA

read the full story

Product Literature

Unstructured Data Option Datasheet
PowerCenter Brochure
Complex Data Exchange datasheet