OpenText brings decades of expertise to help you unlock data, connect people and processes, and fuel AI with trust
Unify data seamlessly across your enterprise to eliminate silos, improve collaboration, and reduce risks
Get AI-ready and transform your data into structured, accessible, optimized information
Meet regulatory and compliance requirements and protect your information throughout its lifecycle
OpenText helps people manage content, automate work, use AI, and collaborate to boost productivity
See how thousands of companies around the world are succeeding with innovative solutions from OpenText™
Our people are our greatest asset; they are the life of the OpenText brand and values
Learn how we aspire to advance societal goals and accelerate positive change
Find a highly skilled OpenText partner with the right solution to enable digital transformation
Explore scalable and flexible deployment options for global organizations of any size
Local control. Global scale. Trusted AI
Your cloud, your control
Free up resources, optimize performance and rapidly address issues
Run anywhere and scale globally in the public cloud of your choice
See information in new ways
AI that understands your business, your data, and your goals
Say hello to faster decisions. Your secure personal AI assistant is ready to get to work
Gain better insights with generative AI for supply chains
Power work with AI content management and an intelligent AI content assistant
Improve your security posture with AI cybersecurity and agile threat detection
Enable faster app delivery, development, and automated software testing
Elevate customer communications and experiences for customer success
Empower users, service agents, and IT staff to find the answers they need
See information in new ways
AI that understands your business, your data, and your goals
Say hello to faster decisions. Your secure personal AI assistant is ready to get to work
Gain better insights with generative AI for supply chains
Power work with AI content management and an intelligent AI content assistant
Improve your security posture with AI cybersecurity and agile threat detection
Enable faster app delivery, development, and automated software testing
Elevate customer communications and experiences for customer success
Empower users, service agents, and IT staff to find the answers they need
Predict, act, and win with real-time analytics on a smarter data platform
Give users access to the answers they need, faster and easier, with multi-repository AI-based search that lets you contextualize everything from clicks to conversations
Connect once, reach anything with a secure B2B integration platform
Reimagine knowledge with AI-ready content management solutions
Supercharge intelligent workspaces with AI to modernize work
Integrated cybersecurity solutions for enterprise protection
Purpose built data protection and security solutions
Reinvent threat hunting to improve security posture with the power of agile AI
Ship better software—faster—with AI-driven DevOps automation, testing, and quality
Reimagine conversations with unforgettable customer experiences
Get the clarity needed to cut the cost and complexity of IT operations
Redefine Tier 1 business support functions with self-service capabilities from private generative AI
Build custom applications using proven OpenText Information Management technology
Build it your way with OpenText Cloud APIs that create the real-time information flows that enable custom applications and workflows
Protect what matters, recover when it counts
Get greater visibility and sharper insights from AI-driven information management. Ready to see how?
Break free from silos, streamline processes, and improve customer experiences with secure information management for AI
Improve efficiency, security, and customer satisfaction with OpenText
Run processes faster and with less risk
Achieve digital transformation with guidance from certified experts
Modernize your information management with certified experts
Unlock the full potential of your information management solution
Turn support into your strategic advantage
Extend IT teams with certified OpenText application experts
Discover training options to help users of all skill levels effectively adopt and use OpenText products
Modernize your information management with certified experts
Unlock the full potential of your information management solution
Turn support into your strategic advantage
Extend IT teams with certified OpenText application experts
Discover training options to help users of all skill levels effectively adopt and use OpenText products
Information is the heartbeat of every organization. We build information management software so you can build the future
OpenText partners with leading cloud infrastructure providers to offer the flexibility to run OpenText solutions anywhere
OpenText partners with top enterprise app providers to unlock unstructured content for better business insights
Discover flexible and innovative offerings designed to add value to OpenText solutions
Discover the resources available to support and grow Partner capabilities
Get expert product and service support to accelerate issue resolution and keep business flows running efficiently
Explore detailed services and consulting presentations, briefs, documentation and other resources
OpenText scales to support exponential data growth and delivers phenomenal processing and storage efficiencies
Shorten data processing time for a fast-growing business and provide a next-day onboarding experience for pharmaceutical analytics.
Working for large pharmaceutical companies in a previous life, Mike da Gama, Co-founder and Director of NostraData, was frustrated with the delays in getting the data he needed to provide meaningful insight to drug manufacturers and help his pharmacy partners better serve their patients. “It sometimes took weeks or even months to get the data we needed,” he says. “By then, any insight we could offer would be useless and out-of-date. I decided to start NostraData to collect and analyze pharmacy data to help drug manufacturers research the use of their drugs in real-world scenarios and make more informed decisions. Our envisioned network would connect wholesalers with supply partners, reward pharmacies for supplier loyalty and give them the insights to operate more effectively.”
NostraData soon attracted brands such as Pfizer, AstraZeneca, Boehringer Ingelheim, and Novartis to its proposition. The team used SQL Server to safely and securely load, cleanse, process, and map the daily data it collected from its member pharmacies. However, as the company grew, data processing time was approaching a full day. Though a lot better than the weeks and months da Gama had experienced before, the user experience was deteriorating. The processes took up precious development time and he noticed that the team was sitting idle waiting for data processing to finish. With a view to the future, da Gama realized NostraData needed a scalable, innovative, and well-supported solution to help with data processing.
Vertica’s (now OpenText) data compression impressed us too. We have historic data that we need to keep for compliance reasons and the cloud storage for this was expensive. With Vertica’s (now OpenText) 77 percent data compression we were able to save 93 percent on data storage.
Da Gama comments: “Our business strength is fast onboarding. If we onboard a new customer today, we want to present them with meaningful insights tomorrow. The solution needed to easily scale as we are constantly re-indexing and correcting our databases. We also required simple maintenance and a predictable cost model as we grew. Finally, we needed the ability to upgrade the solution in situ without having to disrupt our business. SQL was not scalable enough for our analytics requirements, but it was a cost-effective transaction processing solution, so we looked for a dedicated analytics solution that would allow concurrent processing and data access for full efficiency.”
NostraData looked at data appliances but found them expensive to implement and difficult to scale. They also looked at Snowflake, but needed advanced analytical capabilities like time series analysis with conditional event and windowing functions, and the freedom to control partitions and add their own user defined functions. When the team came across the Analytics Platform, they liked what they saw. It had all the advanced analytics they required plus machine learning. In a benchmark test between OpenText (formerly Vertica) and SQL Server, a OpenText (formerly Vertica) solution looked very promising. “We loaded the same amount of data in SQL Server and Vertica (now OpenText), running the same queries against them. Vertica (now OpenText) processed the data 70% faster, and while it was processing we could query the data at the same time, all leading to a much faster response time for our customers,” comments Da Gama. “Vertica’s (now OpenText) data compression impressed us too. We have historic data that we need to keep for compliance reasons and the cloud storage for this was expensive. With Vertica’s (now OpenText) 77 percent data compression we were able to save 93 percent on data storage.”
Although NostraData had support from local OpenText (formerly Vertica) experts, they were pleased to see how engaged the online community is. OpenText (formerly Vertica) users are always keen to share their experience, with hints and tips for other users. When NostraData was hiring a database analyst, their preferred candidate was an active member of the OpenText (formerly Vertica) community, bringing exactly the expertise and innovation NostraData looked for.
NostraData is now several years past their initial decision for OpenText (formerly Vertica) and still convinced it was and is the right one for them. As Da Gama says: “We have grown from supporting 1,000 pharmacies to over 4,500. Throughout this exponential growth, Vertica (now OpenText) has stayed the course with us and given us the consistent next-day onboarding we pride ourselves on. We now manage 4TB of compressed data. We started this process with 4TB of uncompressed data, so I dread to imagine what this growth would look like in SQL Server without the benefit of effective data compression. Instead, we are thrilled to have one database which is easy to maintain and support while managing multiple processes, nodes, and development instances. Vertica (now OpenText) enables us to deliver an efficient and effective service to our customers.”
We have grown from supporting 1,000 pharmacies to over 4,500. Throughout this exponential growth, Vertica (now OpenText) has stayed the course with us and gave us the consistent next-day onboarding we pride ourselves on.
NostraData was founded to improve access to information across the pharmacy supply chain and is connected to more than 4,600 pharmacies and over 7,500 database sources across Australia. NostraData services help pharmacies identify opportunities in their dispensary and retail through reporting and analytics, as well as support rebate payments from suppliers and patient adherence programs.