Attachmate is now
a part of Micro Focus

     

 Product flyer

 Download PDF

Integrating DMSII Database Information: How Databridge Makes It Less Costly and More Practical


Most organizations using a Unisys ClearPath MCP Server lack an efficient, secure way to access the mission-critical information stored in its DMSII database. That’s because traditional business-intelligence tools support only relational databases; the DMSII database is non-relational. Data queries involving the ClearPath MCP Server are costly—both in money and IT resources. Other drawbacks include a limited range of available information, one-direction-only navigation, and restricted ability to manipulate the data for customized reporting.


DMSII challenges

Trying to access DMSII data has some predictable—and unfavorable—outcomes:

  • You lose control of spending and resource allocation due to frequent data queries on the Unisys platform.
  • You cannot provide adequate business-decision support because real-time data analysis is not available.
  • You are less productive because the inflexible data format requires manual analysis and processing.

But these results are unavoidable in a Unisys/DMSII environment, and you just need to minimize the damage, right? Not necessarily.

What if you could…

Some IT managers are overcoming the challenges outlined above. A typical solution path begins with questioning the status quo. So let’s ask: What if you could…

  • Eliminate DMSII data queries and let users access data via your existing relational database server?
  • Provide access to the DMSII data in real time?
  • Present DMSII information in a flexible format?

With Databridge software you can do all that and more. The only out-of-the-box product of its kind, Databridge is a comprehensive solution for integrating DMSII data into your modern business-analysis systems, in real time.

Customer success

Let’s look at a real-life example of Databridge in action. Irish Life & Permanent, a Dublin-based financial services company, needed to simplify data access and let analysts see business objects, web intelligence, and desktop intelligence that resided on a Unisys platform. With more than one million customers, Irish Life needed a solution that would be seamless and accurate.

The company used Databridge to replicate data residing on the mainframe into a relational database that could be easily accessed by analysts via SQL. The offloading of MIS reporting functions to a Windows server gave Irish Life better control over their Unisys-related expenses and resource requirements. The Databridge implementation was invisible to customers, and the data replication provided real-time updates for analysts.

Since implementing Databridge, Irish Life has saved five to ten MIPS per month and improved the runtime on existing MIS reporting. “Databridge made the process much more efficient, cutting replication time from days to a matter of hours,” said Paul Coakley, who leads the company’s Unisys operations and technical support teams.

The SQL environment now serves as the bank’s primary data store for all MIS/BIS reporting. “We expect savings of between €190K and €250K over the life of the Unisys metered license contract,” Coakley said.

In this financial environment, where Unisys resources need to be kept to a minimum, Databridge is key. “We built many automated processes around our implementation, and the product pretty much looks after itself at this stage,” said Coakley. “We turned everything around in two weeks—it was just unbelievable.” That’s how Databridge helped one company. But what about you?

If you need to…

  • Reduce costs and unnecessary usage of your Unisys platform ✔
  • Provide the ability to make decisions based on accurate, up-to-the-minute information ✔
  • Present data in the way users need it, so they won’t have to rekey, reload, or reformat ✔

Then…

You need Databridge.

Rather than writing new applications to query DMSII data, you can use Databridge to replicate that data to a relational database. Then you can use existing business intelligence tools to make information readily accessible. The result: you conserve host resources while providing economical, real-time, flexible data access for the best business decision making possible.

What have you got to lose?

With the Databridge solution there’s a lot to gain, and there’s also a lot to lose:

  • No more expensive queries overloading your mainframe.
  • No more guesstimating or unpleasant surprises due to lack of real-time data.
  • No more restricted views and one-way navigation.
  • No more waiting for overnight downloads and reloads.
  • No more manual analysis.

Those “losses” would be welcome news for any DMSII-centric business today.

A decision-making breakthrough

Databridge sets a new standard for comprehensive data integration. By moving selected data from the host to a relational database (or multiple databases), organizations can combine information from several external sources, perform trend analysis, and generate a wide variety of reports for improved decision support.

With Databridge, you can also store large amounts of historical data on a UNIX or Windows system. And thanks to its native architecture, Databridge is ideal for high-volume environments. Unlike other ETL products, Databridge simultaneously accommodates thousands of transactions and subsequent updates.