Informed business decisions often rely on information residing in corporate databases. But integrating data from Unisys MCP-based DMSII databases is tricky. DMSII databases are non-relational, while most business intelligence tools support only relational databases. Micro Focus solves the problem with a true Extract, Transform, Load (ETL) solution.
Put ETL to work
Give decision makers up-to-the-minute information on demand. The ETL solution mirrors DMSII and non-DMSII data in a secondary working database, keeping it updated in real time.Video: Maximize the Business Value of Your Unisys Mainframe
Generate business intelligence with DMSII
Pull data from your Unisys MCP DMSII database into relational databases running on Windows, UNIX, and Linux systems. Combine data from multiple sources, perform trend analyses, and generate relevant reports designed for decision makers. Changed Data Capture technology keeps the DMSII data in your relational database current.
Cut MIPS costs
Ensure that rising numbers of data queries don’t consume higher quantities of costly MIPS resources in your metered or non-metered Unisys MCP environments. Offload DMSII queries to a secondary database, and replicate only changed data after the initial extraction.
Produce meaningful reports
Allow users to easily view and manipulate data sourced directly from DMSII databases (which can’t be formatted via SQL the way data from a relational database can). Generate reports in the format they need, without costly COBOL or ALGOL coding.
"Databridge was a strategic investment that is enabling us to meet our long term objectives of improving efficiency and decreasing costs—by reducing our resource requirements and minimising usage costs on the Unisys platform."