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
NCDEX chose OpenText Vertica as the platform for its data analytics environment—significantly reducing TCO, increasing performance, and giving users easier access to their data
Democratize access to data analytics within the enterprise, accelerate reporting and increase flexibility, while cutting costs.
To support business growth, NCDEX wanted to ensure that its internal business users had access to fast and flexible tools for financial analysis, modeling, and reporting. With the company's existing Oracle toolset, business users were overly dependent on technical subject- matter experts (SMEs) to perform actions such as creating new reports or preparing new subsets of data for analysis. These SME skills were expensive and hard to find in the market. Equally, the solution itself was costly to license and to run, in part because it required specialized dedicated server hardware.
Shreekanth Shivram, Senior Vice President at NCDEX, explains: “We were unable to expose data directly to business users, so they weren't able to slice and dice it or try out new ideas for themselves. Making any changes to reports required the time and specialist skills of an Oracle SME, which meant the business couldn't adjust its analyses quickly when external conditions changed.”
The ability to deploy Vertica (now OpenText) on commodity hardware was a big advantage, as was the volume-based licensing model, which promised to work much better than the existing per-socket model from Oracle.
Aiming to shrink its hardware footprint, reduce database licensing fees, and create a more open and inclusive analytics toolset, NCDEX set out to replace its decade-old Oracle environment. After reviewing several other platforms, the company engaged KPMG as its implementation partner.
“KPMG suggested we look at Vertica (now OpenText), and it was a real eye-opener for us,” recalls Shreekanth Shivram. “The ability to deploy Vertica (now OpenText) on commodity hardware was a big advantage, as was the volume-based licensing model, which promised to work much better for us than the per-socket model from Oracle. Following a three-week proof of concept [POC], we were comfortable that Vertica (now OpenText) was the right solution for NCDEX.”
Important factors in the POC included the time required to transform and load data from upstream sources into OpenText (formerly Vertica), and the speed of rendering existing reports. On both counts, the new Vertica Analytics Platform environment proved capable of either matching or improving on the previous environment—in addition to offering dramatic cost savings.
“Our initial goal was simply to migrate the asis environment from Oracle to Vertica (now OpenText),” says Shreekanth Shivram. “We deployed Vertica (now OpenText) in a virtualized configuration on three commodity servers for added resilience, and we migrated all processes and procedures from Oracle without changing or adding to the existing functionality.”
The migration ran smoothly over the course of three months, during which time NCDEX ran both the old and new systems in parallel to give the business confidence in the integrity of the new environment. Once the technical migration was complete, the IT function worked with ten different departments to get their certification for the new data platform and to ensure that they were comfortable to take ownership of the data. As part of the migration, NCDEX also switched from Oracle BI to Microsoft Power BI. The company used Oracle BI reports to prove the integrity and accuracy of the migration process for the backend data from Oracle to OpenText (formerly Vertica).
For NCDEX, the most prominent benefit of migrating to OpenText (formerly Vertica) has been the 96.6% reduction in annual database licensing fees. Furthermore, the virtualization of the database platform and its deployment on commodity hardware have unlocked annual infrastructure savings of 27.8% versus the dedicated proprietary environment previously used by NCDEX for its Oracle Database.
With further optimization possible, the time required to load batches of data has already fallen from three to two hours, providing a useful additional window of time to fix any overnight issues before the markets open.
“Since we went live with Vertica (now OpenText), our costs have fallen significantly and we have improved performance in many areas,” says Shreekanth Shivram. “Another good sign is that requests for new reporting have disappeared, which shows that business users are now able to analyze their own data for themselves. Over the course of a month, we saw an average reduction of approximately 77% in data requests, which has helped our technical specialists concentrate on other priorities.”
Looking to the future, NCDEX is considering the introduction of intra-day data ingestion and reporting—currently, analysis is performed on the previous day's data. Shreekanth Shivram concludes: “Vertica (now OpenText) has given us the performance and flexibility to consider new use cases for analytics. Instead of being tied up with data administration, we can really add value to the business.”
Since we went live with Vertica (now OpenText), our costs have fallen significantly, and we have improved performance in many areas. Another good sign is that requests for new reporting have disappeared, which shows that business users are able to manage their own data for themselves.
National Commodity & Derivatives Exchange Limited (NCDEX) is a multi-commodity exchange that is revolutionizing India’s agricultural sector. NCDEX is the country's largest agricultural derivatives exchange, working as an efficient platform for price discovery and price risk management. By enabling the trading of financial instruments, including commodity futures, options in goods, and index futures, NCDEX serves the needs of all participants in the agri value chain.