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
Provide advanced analytics to a growing user base while supporting a corporate move to cloud deployment, and controlling costs.
As a data consolidation offering, REDPHARMA’s REDDATA service gathers and enriches transactional data from across 4000+ pharmacies, capturing all prescription and over-the-counter ticket sales. This measures the return and uplift of targeted end-customer marketing campaigns and offers. The data is processed, cleansed, and extrapolated for consumption by pharmaceutical producers, such a laboratories. The REDDATA analysis platform contains secure and anonymized data that is used for market and trend analysis. Various reporting options help customers understand their marketing environment, align campaigns, and develop seamless promotions. Using this wealth of data, REDDATA also produces national and localized statistics to identify product sales trends, and support fast decision-making.
David Nicholson-Jones, Analytics Architect with REDDATA, explains further: “Collating all the data with only a small data science team is a challenge. To attract new pharmacies to our model we need to showcase the benefits of analytics. One way to do this is by providing easy-to-use dashboards, giving a detailed overview of a pharmacy’s position within a competitive landscape. We have been using Tableau to present our data in a meaningful way. Although this is great as a Business Intelligence (BI) solution, we found that as soon as our data volumes started to grow, performance went down.”
At the same time, REDDATA made a strategic move towards the cloud, and chose Amazon Web Services (AWS) as its platform. Nicholson-Jones looked for a way to split BI from data processing, while minimizing infrastructure costs.
REDPHARMA offers independent pharmacies and pharma brands effective integrated marketing tools to help them meet today’s challenges in the pharmacy industry. REDPHARMA specializes in pharmaceutical product promotion and makes that expertise available to its partners.
After exploring various options in the market, the team liked the concept of columnar storage versus row-based storage, and Vertica’s approach in particular, according to Nicholson-Jones: “We were very impressed with Vertica’s detailed data optimization capabilities, actually working on the data ‘atoms’. In a demo, the Vertica team showed us how fast optimized columnar data stores can be, and how well they integrate with Tableau, which was a key selling point for us. We needed to automate our processes as soon as possible and could not afford full-time dedicated database administration, so it needed to be easy-to-use and intuitive. The Vertica team gave us a real feel for the value of the entire architectural design and data compression; a ‘penny-drop’ moment for us.”
Already convinced Vertica was the right solution, REDDATA was delighted to discover Vertica in Eon Mode. Eon Mode delivers a cloud-optimized architecture to easily scale resources up and down, isolate workloads, and optimize infrastructure costs without risk, restrictions, and added expense. The Vertica cloud-based deployment tools helped with a fast implementation schedule. The more he found out about Vertica in Eon Mode, the more excited Nicholson-Jones was about it:
David Nicholson-Jones – ANALYTICS ARCHITECT
REDPHARMA
Vertica was soon introduced as the single data warehouse for all customer and partner dashboards and data science analytics. A collection of simple flattened tables with ‘feeder dimensions’ has replaced the need to manage multiple star-schema databases of varying granularity with external tools. The team only manages a core set of sources for data quality and populates the flattened tables with views using the chosen granularity—the result is full consistency across the board, with little extra effort. Nicholson-Jones: “We design it once, and can then focus on the data quality of our transactions and dimensions. We have a range of different granularity BI views for our pharmacies and laboratory partners, so each user only sees what’s relevant for them. This would be so much more time consuming to manage without the flattened table structure.”
During REDDATA’s development phase, running Vertica in Eon Mode on AWS was very helpful. The team could spin nodes up as required and shut them down again just as easily when the work was done. This helped keep AWS infrastructure costs as low as possible in the early stages.
REDDATA can now focus on the deployment of in-depth dashboards for its pharmacy and laboratory partners. Tableau and Vertica are closely integrated, and the team is exploring Vertica’s machine learning capabilities to provide additional insight to its partners by data mining more variables into the models.
Nicholson-Jones is pleased with the benefits gained so far: “When we looked at other options, the pricing model was often CPU-based. Because we are still a young company it was hard to predict what we would need. Vertica’s flexible pricing model worked much better for us. Ease of management is very important to us, and we love the user-friendly Eon Mode GUI on AWS.”
He concludes: “With Vertica in Eon Mode all data warehouse management activities are automated, leaving our small team to focus on more advanced analytics that support our business goals.”
David Nicholson-Jones – ANALYTICS ARCHITECT
REDPHARMA
