Analytics

OpenText Analytics Database: The ELT Advantage

Understand how OpenText Analytics Database (Vertica) revolutionizes data management by enhancing the ELT process, offering superior speed, scalability, and analytical power.

August 9, 2024 3 minute read
Shortcut the paperwork shuffle with AI-augmented content capture

Shortcut the paperwork shuffle with AI-augmented content capture

Early in my career, when I was a freelance writer and market researcher, I spent a sizable chunk of my work week sending and receiving…

5 minute read

How to recognize strings containing nbsp

How to recognize strings containing nbsp

Word Processors and Web forms often use the non-breaking space character (nbsp) to prevent line breaks. This character looks the same as a normal space,…

2 minute read

Streaming Analytics with OpenText Magellan

Streaming Analytics with OpenText Magellan

Streaming Analytics is the ability to continuously process, manage, monitor, enrich and perform real-time analysis on live streaming data (typically from sensors and other components…

5 minute read

Choosing the right programming language for machine learning algorithms with Apache Spark

Choosing the right programming language for machine learning algorithms with Apache Spark

When it comes to writing machine learning algorithms leveraging the Apache Spark framework, the data science community is fairly divided as to which language is…

6 minute read

Better insights. Better decisions.

Better insights. Better decisions.

The OpenText™ team has spent the last year enriching the OpenText eDOCS user experience ꟷ giving users more choice and more flexibility in how they work….

2 minute read

Give the people what they want: Better financial product recommendations

Give the people what they want: Better financial product recommendations

One of the big advantages of doing business in a digital world is being able to make use of the data exhaust left by practically…

4 minute read

Query Tuning with Vertica: Dos and Don’ts

Query Tuning with Vertica: Dos and Don’ts

Query tuning in Vertica is not an exact science. Recommendations differ based on your database. This document assumes that all nodes in the cluster are…

8 minute read

What Should I do if the Database Performance is Slow?

What Should I do if the Database Performance is Slow?

Troubleshoot using the following checklist if your database performance is slow. Check if any of the following problems exist: Step Task Results 1 Is the…

6 minute read

What Should I do When the Database Node is Down?

What Should I do When the Database Node is Down?

When database node is DOWN, troubleshoot using the following checklist. Step Task Results 1 Check whether your database is UP. $ admintools -t db_status -s…

2 minute read

What Version of Vertica am I Running?

What Version of Vertica am I Running?

The built-in VERSION function returns a VARCHAR that contains your Vertica node’s version information. Example: dbadmin=> SELECT version(); version ———————————— Vertica Analytic Database v9.1.0-2 (1…

1 minute read

OpenText Magellan helps G7 hear the voice of the people

OpenText Magellan helps G7 hear the voice of the people

Enlightened leaders take the feelings and interests of their people into account. But how can you tell what they’re thinking, about myriads of subjects? Elections are yes/no…

5 minute read

With predictive maintenance, AI keeps the wheels rolling

With predictive maintenance, AI keeps the wheels rolling

Whether you’re talking about a fleet of city buses, a coffee chain’s espresso machines, an office’s networked laptops and printers, or even a natural gas…

4 minute read

Stay in the loop!

Get our most popular content delivered monthly to your inbox.

Sign up