ValueEdge: Value Stream Management
Align corporate investments with business strategy
Continuous quality from requirements to delivery
Scale enterprise SCCM with security and compliance
Resilient AI-powered functional test automation
Enterprise-level requirements management
Deliver continuous application performance testing
Plan, track, orchestrate, and release applications
Govern quality and implement auditable processes
Automate deployments for continuous delivery
Build business applications using new tools & platforms
The leading solution for COBOL application modernization
Modernize mainframe applications for the Cloud
Modernize host application access
Discover the future of CORBA
Modern mainframe application delivery for IBM Z
Secure, zero-footprint access to host applications
Access host data and automate processes with RPA
Multi-factor Authentication for IBM z/OS endpoints
Build secure software fast
Augment human intelligence
Discover, analyze, and protect sensitive data
Drive IT ecosystem with identity-centric expertise
Deliver simplified, secure access to users
Scale to billions of identities with IGA platform
Gain control of privileged user activities
Track changes and activities in managed services
Get fast, accurate detection of threats
Analytics for text, audio, video, and image data
Reduce risk, cost, and maintenance, and T2M
AI and machine learning for data analysis
Enterprise backup/disaster recovery
Unified traditional and mobile device management
Meet regulatory & privacy retention requirements
Email, IM, and chat-based collaboration
Mobile workforce communication & collaboration
Secure critical file storage and print services
Manage IT & non-IT services with automation and AI
Discover, monitor, and remediate with AIOps
Monitor and optimize complex networks
Discover, manage, and map configurations & assets
Accelerate provisioning with governance in place
Automate and orchestrate processes end to end
Manage IT & software assets for better compliance
Automate server provisioning, patching, and compliance
Automate screen-based human actions with robots
All Micro Focus learning in one place
Build the skills to succeed
Streamline software delivery for faster value
ValueEdge: Value Stream Management
Align corporate investments with business strategy
Continuous quality from requirements to delivery
Scale enterprise SCCM with security and compliance
Resilient AI-powered functional test automation
Enterprise-level requirements management
Deliver continuous application performance testing
Plan, track, orchestrate, and release applications
Govern quality and implement auditable processes
Automate deployments for continuous delivery
Access all products in application delivery management
Modernize Core Business Systems to Drive Business Transformation
Build business applications using new tools & platforms
The leading solution for COBOL application modernization
Modernize mainframe applications for the Cloud
Modernize host application access
Discover the future of CORBA
Modern mainframe application delivery for IBM Z
Secure, zero-footprint access to host applications
Access host data and automate processes with RPA
Multi-factor Authentication for IBM z/OS endpoints
Access all products in Application Modernization & Connectivity
Security at the core to everything you do; Operations, Applications, Identity and Data
Build secure software fast
Augment human intelligence
Discover, analyze, and protect sensitive data
Drive IT ecosystem with identity-centric expertise
Deliver simplified, secure access to users
Scale to billions of identities with IGA platform
Gain control of privileged user activities
Track changes and activities in managed services
Get fast, accurate detection of threats
Access all products in CyberRes
Trusted, proven legal, compliance and privacy solutions
Analytics for text, audio, video, and image data
Reduce risk, cost, and maintenance, and T2M
AI and machine learning for data analysis
Enterprise backup/disaster recovery
Unified traditional and mobile device management
Meet regulatory & privacy retention requirements
Email, IM, and chat-based collaboration
Mobile workforce communication & collaboration
Secure critical file storage and print services
Access all products in Information Management and Governance
Simplify Your IT Transformation
Manage IT & non-IT services with automation and AI
Discover, monitor, and remediate with AIOps
Monitor and optimize complex networks
Discover, manage, and map configurations & assets
Accelerate provisioning with governance in place
Automate and orchestrate processes end to end
Manage IT & software assets for better compliance
Automate server provisioning, patching, and compliance
Automate screen-based human actions with robots
Access all products in IT Operations Management
Give your team the power to make your business perform to its fullest
Following a DMSII upgrade, UW discovered that long replication times were negatively affecting data quality and productivity, which required changes in data replication configuration and set-up.
UW relies on its Unisys mainframe and DMSII database for key applications, such as financial systems and student information systems. An in-house developed DMSII extraction component was introduced in the mid-1990s to enable more effective operational data access by easily replicating large volumes of mainframe-based data to relational databases, such as SQL Server, Sybase, and Informix. Eliminating customized mainframe reporting, data extraction and file transfer routines saves times, improves the flexibility and quality of the data being made available, and reduces the burden on processing resources. The data is vital for budget setting and analysis, as well as course planning.
After many years of successful operation, when UW upgraded its DMSII system, it ran into unexpected problems. Elizabeth Runkle, Technology Manager for the university, explains the problems: “We were suddenly experiencing issues with replicating compact data sets on the relational database side. Records were dropped and we had a real integrity problem. We also noticed that replication was taking about seven hours after the upgrade. This was unacceptable for us and we suspected some rigorous data reorganization was needed.”
A test of the replication after adding the Micro Focus Databridge relational database client demonstrated a solution to the data replication integrity issue, and Runkle and the team embarked on a project to introduce Databridge across the board.
About University of Washington
The University of Washington (UW) is one of the world’s preeminent public universities. Ranked number 13 in the world on the 2017 Academic Ranking of World Universities, UW educates more than 54,000 students annually
Supported by Micro Focus Professional Services, Databridge was implemented on most key systems. Student records are held on the mainframe, and replicated into both an Enterprise Data Warehouse, and a Web Services database where the data can be accessed and provided to campus-consuming applications. The data is strictly regulated and private data is not passed to downstream systems, or it is masked. Transferring the data to more modern systems allows departments to massage, report, and use the data more constructively with Tableau-driven or custom reporting.
Runkle comments: “This flexibility is especially important to us as we need to provide census information at the start of each quarter as part of a federal requirement. During our training with Micro Focus Professional Services we learned that the newest components of Databridge would not only solve our data integrity issues, but it also had the potential to really improve our system performance.”
The team discovered that the new multithreading processes, in conjunction with optimizations of updates provided by customizable filter generation, contributed significantly to increased system throughput. Different stakeholders within the university have different data requirements and the Databridge filter generation capability enables the team to customize the results based on specific requirements to make data interpretation and analysis as easy as possible. Runkle:
Elizabeth Runkle – TECHNOLOGY MANAGER
University of Washington
“By being more intelligent about the data and how it is replicated, we moved from a seven-hour data replication to just 90 minutes for the University of Washington Student Database.”
Over 50 Databridge-managed replications are executed to a variety of SQL Server target databases and continuous audit log tracking is in place. Multiple staff were involved in the Databridge client implementation. Collaborative workshops were held weekly to migrate all applications in a phased manner allowing the team to meet the delivery schedule and budget. Spreading implementation expertise among more employees helps reduce operational risk and the team established great partnerships.
The increased processing performance was clear immediately, and one team was particularly pleased, as Runkle comments:
Elizabeth Runkle – TECHNOLOGY MANAGER
University of Washington
“This meant the data was available for all campus users in the Enterprise Data Warehouse much sooner than before and all the heavy load data activities were processed seamlessly through the end-user databases.”
She concludes: “The speed and reliability of data processing is just amazing. Our stakeholders need their data quickly, especially for federal and college reporting purposes. We are in a continuous audit cycle and need near real-time data which is exactly what Databridge delivers. The team responsible for the Databridge client implementation received a well-deserved ACE award in recognition of their Achievement, Collaboration, and Excellence. We could not have done this project without the excellent support from Micro Focus as they helped improve our data quality and replication processes, as well as updated our technology.”