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
Leading retailer transforms sales data into actionable insights to boost revenues with OpenText VerticaPy
To maximize sales, retailers need to distribute the right volumes of stock to the right locations to satisfy consumer demand. This represents a hugely complex challenge. Often flawed inventory management processes lead companies to overstock some stores with products that subsequently go unsold, while other locations run out of supplies, missing out on potential sales.
This is where Pabis Retail aims to make a difference. The platform enables companies to capture and monitor sales and inventory transactions and use sophisticated analytics to determine the ideal stock levels for stores to optimize profitability. Launched over 15 years ago, Pabis Retail initially supported the platform with a traditional relational database architecture. However, as client numbers increased, challenges soon emerged.
Carlos Urguelles, managing director at Pabis Retail, explained, “Transaction volumes were rising rapidly, and response times were growing longer, especially in peak periods when hundreds of clients ran queries simultaneously. Data was difficult to consolidate and analyze, while maintaining the environment was a time-consuming task. To scale our business and continue to deliver high-quality services, we needed to change our approach.”
Our latest project with VerticaPy demonstrates the innovative AI-driven functionality Vertica is developing. Going from a query response time of hours to mere seconds makes an incredible and tangible difference to our clients. It gives us the confidence that the next stage of our collaboration with Vertica will be just as successful.
Pabis Retail selected Vertica to support thousands of users running complex queries. Vertica in Eon Mode provided scalability to meet clients’ changing requirements, while VerticaPy facilitated an AI-driven effective price simulator.
Vertica in Eon Mode is a scalable, high-performance analytics platform that separates compute and storage for flexible, efficient data processing
Seamlessly integrated with Vertica Database, it offers a comprehensive library for powerful predictive modeling
The market-leading analytical database, delivering the best value for the highest performance
Realizing that it needed much greater query performance than a traditional row-based database could offer, Pabis Retail searched for an advanced columnar storage solution. Impressed by a customer reference for Vertica, the company selected the Vertica Analytics Platform as its new data warehouse.
Paulo Rios, IT manager at Pabis Retail, commented, “Of the data warehouse solutions we reviewed, Vertica stood out for its exceptional performance and parallel processing capabilities, which would enable upwards of 1,000 users to run complex queries concurrently. Also, we noted the Vertica platform would require minimal maintenance, saving us valuable time.”
Deploying Vertica in Eon Mode running on Amazon Web Services is ideal with Pabis Retail’s high transaction volumes. It provides the highest levels of scalability to tackle the most demanding client workloads. The architecture combines a central data repository with separate storage nodes, making it quicker and easier to add extra processing resources when demand grows, as Rios confirmed, “Eon Mode has been a gamechanger. Several major clients run massive queries at the same time each month, and the elastic scalability of Vertica in Eon Mode ensures we have the resources to meet their requirements.”
As the team familiarized themselves with the AI-driven opportunities presented by Vertica, more use cases emerged to support Pabis Retail clients. Many clients want to understand how price changes can affect sales and overall revenue. To receive detailed insight, they would need to create interactive what-if dashboards where price changes are plotted against demand with a fine level of detailed elasticity analysis. However, to analyze this effectively for each product in each store, a two-year history of daily sales and price data needs to be searched. This is represented by millions of local data models that must be aggregated by week, filtered for extreme values, and pre-processed.
With the data volumes involved, even Vertica struggled to meet the requirements associated with creating a price simulator based on elastic demand. The data was batch-processed and published into Vertica, but the team found the execution times to be prohibitively long.
VerticaPy is the perfect blend of the scalability of Vertica and the flexibility of Python, bringing a unique and indispensable set of data science tools. It contains a Python library that is used for machine learning and data science tasks in conjunction with the Vertica database. It provides a Pythonic interface to interact with and leverage the power of Vertica for analytical and predictive modelling tasks.
Leveraging VerticaPy, the team could effortlessly build models to perform the complex calculations. These are optimized for efficiency and performance using many of the InDatabase scalable machine learning algorithms. Python scripts call SQL queries, and the results are directly published in Vertica.
Carenne Ludeňa, director data science for Pabis Retail, commented, “We started using VerticaPy to solve our massive elasticity model generation for retail pricing, a process that previously took hours to complete. Using VerticaPy, powered by machine learning and AI-driven, we now receive results in almost real-time without any delay. We are very excited about the results and the huge possibilities Vertica provides.”
With Vertica in Eon Mode, we have achieved a quantum leap in performance and dramatically reduced query response times. Our clients are much happier and have the critical data at their fingertips needed to optimize their sales revenues.
Vertica, leveraging Eon Mode and VerticaPy, boosted customer satisfaction with dramatically improved query response performance, enabling clients to adopt true data-driven decision-making. Pabis Retail can now support sustained company growth.
By embracing the Vertica Analytics Platform, Pabis Retail has significantly improved its client services. Currently, more than 2,000 users run as many as 15,000 daily queries and enjoy much faster response times. With rapid access to information and analytics, clients can identify emerging trends sooner, and make more effective data-driven decisions about their sales, inventory, and distribution strategies.
Urguelles recalled, “Previously, we received inquiries from major clients about why queries were queued or took up to 40 seconds. With Vertica in Eon Mode, we have achieved a quantum leap in performance and dramatically reduced query response times. Our clients are much happier and have the critical data at their fingertips needed to optimize their sales revenues.”
With the ultra-scalable and robust Vertica solution underpinning its analytics platform, Pabis Retail has been able to grow its client base without facing performance issues. In total, the platform stores seven billion client transactions, with more than 20 million new records added daily.
Rios added, “The COVID-19 pandemic has radically changed consumer buying habits, and we have seen a huge demand from retailers looking to adapt by building smarter, data-driven strategies. Thanks to the Vertica platform, and the power of VerticaPy, we have accommodated their requests and achieved sustainable growth.”
He concluded, “The Vertica solution has removed the technical headaches we faced, and whenever we need support, Vertica provides a swift and effective response. Our latest project with VerticaPy demonstrates the innovative AI-driven functionality Vertica is developing. Going from a query response time of hours to mere seconds makes an incredible and tangible difference to our clients. It gives us the confidence that the next stage of our collaboration with Vertica will be just as successful.”