REDPHARMA

Solution

After exploring various options in the market, the team liked the concept of columnar storage versus row-based storage, and the OpenText (formerly Vertica) approach in particular, according to Nicholson-Jones: “We were very impressed with Vertica’s (now OpenText) detailed data optimization capabilities, actually working on the data ‘atoms’. In a demo, the Vertica (now OpenText) 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 (now OpenText) 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 OpenText (formerly Vertica) was the right solution, REDDATA was delighted to discover OpenText (formerly 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 OpenText (formerly Vertica) cloud-based deployment tools helped with a fast implementation schedule. The more he found out about OpenText (formerly Vertica) in Eon Mode, the more excited Nicholson-Jones was about it: “Using Vertica (now OpenText) in Eon Mode on AWS allows us to separate compute and storage, which helps with maintenance. Backups are easier, and we like the constant data synchronization. The flexibility to spin up nodes at a minute’s notice gives us an operational resilience that makes me sleep better at night.”

OpenText (formerly 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 OpenText (formerly 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.

Using Vertica (now OpenText) in Eon Mode on AWS allows us to separate compute and storage, which helps with maintenance. Backups are easier and we like the constant data synchronization. The flexibility to spin up nodes at a minute’s notice gives us an operational resilience that makes me sleep better at night.

Results

REDDATA can now focus on the deployment of in­-depth dashboards for its pharmacy and laboratory partners. Tableau and OpenText (formerly Vertica) are closely integrated, and the team is exploring OpenText’s (formerly Vertica) 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 (now OpenText) 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 (now OpenText) 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. I love the product quality of Vertica (now OpenText), and the use of it is nearly always intuitive, which is impressive, given the complexity hidden underneath. Vertica (now OpenText) has been great for getting us started with minimal resources and effort. It’s like getting a Ferrari to drive.”

I love the product quality of Vertica (now OpenText), and the use of it is nearly always intuitive, which is impressive, given the complexity hidden underneath. Vertica (now OpenText) has been great for getting us started with minimal resources and effort.