Twenty Years, 30,000 Users and Counting

“Today I consider myself the luckiest man on the face of the earth.”

– Lou Gehrig, 1939

Lou Gehrig played 2,130 consecutive games and earned the name the Iron Horse. One of the largest PC and server manufacturers in the world has a streak of its own: 20 straight years on Nexus Query Chameleon. Nexus has been in the starting lineup every day, and it has never been benched.

Today, 30,000 people at the company use Nexus. When a company that builds the world’s computers picks one query tool to run on them, that’s an endorsement with real hardware behind it.

One Price. Unlimited Users. Twenty Years.

“You miss 100 percent of the shots you don’t take.”

– Wayne Gretzky, 1983

This company never misses a shot, because every user gets one. Its Nexus Universal License covers an unlimited number of users for one price. No seat counting and no waiting for a license to free up. Every employee gets a stick and a spot on the ice.

For 20 years, the company has paid one price for unlimited Nexus for all users. A new hire in any department can install Nexus on day one. That’s a power play that scores every single shift.

Stop settling for query tools that just skate by. One price, unlimited users and 20 years: that’s a Nexus hat trick.

Around the World, Including India

“Strength does not come from physical capacity. It comes from an indomitable will.”

– Mahatma Gandhi, 1920

Nexus users at this company work around the world, including India. They work in different countries and different time zones, but they all query with the same tool. That’s strength in numbers, 30,000 strong.

Gandhi said strength comes from an indomitable will. For 20 years, these users have had the will, and Nexus has given them the way. Nexus is the change they wished to see in their world.

Twenty Years of Never Giving In

“Never give in, never give in, never, never, never, never…”

– Winston Churchill, 1941

Twenty years is an eternity in technology. Databases have come and gone, the cloud arrived, and query tools have risen and fallen. Through it all, this company never gave up on Nexus. That’s a finest hour that has lasted two decades.

Loyalty like that is earned. Our team answers their questions and keeps improving Nexus year after year. When a customer stands with you for 20 years, you stand right back with them, and we shall never surrender.

Nexus Kept Moving

“Life is like riding a bicycle. To keep your balance you must keep moving.”

– Albert Einstein, letter to his son Eduard, 1930

Nexus has kept its balance for 20 years by never standing still. Today it queries cloud databases, migrates data between every system, builds dashboards on its own and drops results into the cloud. It’s been pedal to the metal the whole ride.

With one license covering the whole company, everyone rides together. Nobody gets left behind with a flat tire. Nexus proves a theory of user relativity: E = mc², where the masses get Energy at the speed of light.

Never Stop Questioning

“The unexamined life is not worth living.”

– Socrates, in Plato’s Apology

Socrates built a philosophy on asking questions, and a query is just a question asked of a database. At a company this size, data lives on many systems, and Nexus asks questions of all of them from one window: Teradata, Oracle, SQL Server, Snowflake, BigQuery, Databricks, and more. With Nexus, no database goes unexamined.

The Cache Tree searches every connected system at once for a table or column name, so users stop wondering where the data lives and start getting answers. It’s the Socratic method, with SQL delivered on a silver Plato.

Here is what keeps 30,000 users asking questions.

Migrate Between All Systems

“A journey of a thousand miles begins with a single step.”

– Lao Tzu, Tao Te Ching

With Nexus, every data migration begins with a single click. Check the tables, pick a target and click Execute. Nexus builds the target tables, pairs the source vendor’s export utility with the target vendor’s load utility, and moves the data at full speed. The thousand miles go by in a hurry.

Teradata to Snowflake, Oracle to BigQuery, SQL Server to Databricks: Nexus migrates between every system it connects to. Your data takes the journey, and your team never has to pack a bag. With Nexus, a migration of a thousand tables ends with a single click.

Super Join Builder: Federation Across All Systems

“If I have seen further it is by standing on the shoulders of Giants.”

– Isaac Newton, 1675

The Super Join Builder stands on the shoulders of giants like Teradata, Snowflake, BigQuery and Databricks. Check the columns you want from tables on different systems, and Nexus writes the SQL, moves the data to a hub and joins it there. Users see further without writing a line of SQL, and the view is gravity-defying.

Want a different hub? Pick your PC or a Nexus Server, and Nexus rewrites the SQL for you. What goes up must come down, and with Nexus, it comes down joined.

The Nexus Server

“Be water, my friend.”

– Bruce Lee, 1971

Data should flow like water, straight from source to target. When a migration runs from a desktop, every row squeezes through the user’s PC like water through a straw. The Nexus Server moves the data directly from source to target while the PC only sends the instructions. Your data finally goes with the flow. Enter the Dragon, and exit the bottleneck.

The Nexus Server also speeds up federated queries, and it stores flat files cheaply so users can query them like tables. For a company that builds servers, this is one server with real kung fu.

Cloud Drop

“The future ain’t what it used to be.”

– Yogi Berra

Neither is where data lives. Cloud Drop lets users drag any query result into AWS, Azure, Google Cloud or local storage as a CSV, JSON, Parquet, Excel or text file. The forecast calls for clear skies.

Nexus shows cloud buckets like databases and files like tables, so users can query a file in the cloud and join it to a table on any system. The future has arrived, and it’s partly cloudy. You can drag files to the cloud faster than a fastball and know that Nexus will catcher.

GitHub Integration

“Life can only be understood backwards; but it must be lived forwards.”

– Søren Kierkegaard, 1843

With 30,000 users, someone has probably already written the query you need. Nexus and GitHub make sure you can find it. Push, pull and manage SQL files directly between Nexus and GitHub, and every version is saved. Now every query can be understood backwards, one commit at a time.

Click a .sql file in the repo, and it opens as a query, ready to run on any system. Your team learns from yesterday’s SQL and moves forward with today’s. That’s a philosophy anyone can commit to.

Federated Notebooks

“The Analytical Engine weaves algebraical patterns just as the Jacquard-loom weaves flowers and leaves.”

– Ada Lovelace, 1843

Ada Lovelace wrote what is often called the first computer program in her famous Notes. Federated Notebooks let you write yours in SQL, Python, Markdown and more, woven into one connected workflow. One cell queries Teradata, the next queries Oracle, and Python brings the results together. It’s a pattern worth weaving.

Analysts write down their thinking right next to their code, so the next person understands the why as well as the what. That’s one notebook nobody will want to close the book on.

BIcandy: Instant Dashboards and Beautiful Maps

“Design is not just what it looks like and feels like. Design is how it works.”

– Steve Jobs, 2003

BIcandy looks good, and it works even better. Run a query that returns a date and an amount, and Nexus builds the dashboard for you: sales by year, month, weekday and hour, plus maps where the size of each circle shows the sales in that city. It’s the sweetest design in data.

There’s no dragging, no dropping and no separate BI tool. For a company that knows hardware inside and out, BIcandy is software that will be the Apple of your eye.

More Than 100 Themes

“If you want the rainbow, you gotta put up with the rain.”

– Dolly Parton

With Nexus, you get the rainbow without the rain. More than 100 themes let users pick the look they love, from Coffee and Northern Lights to Ann Arbor Maize and Blue, Columbus Scarlet and Gray, and Pittsburgh Black and Gold. With 30,000 users, that’s a lot of colorful personalities.

Nexus is also the only query tool that lets you schedule your themes. Change them by the clock, rotate through your favorites, or go light by day and dark at night. Working 9 to 5 has never looked so good, because Nexus gives every workday a coat of many colors.

Why the Builders of Computers Choose Nexus

“Do what you can, with what you have, where you are.”

– Theodore Roosevelt, Autobiography, 1913

Most vendor query tools only work where they live: Snowsight on Snowflake, BigQuery Studio on BigQuery, the Databricks SQL Editor on Databricks, and Teradata Studio on Teradata. Nexus works with what you have, wherever you are. Teddy Roosevelt would have called that bully.

Nexus works equally well on every system it connects to. Microsoft saw it early: from 2009 to 2012, Microsoft OEM’d Nexus and gave it to its customers. One of the world’s largest PC and server manufacturers has seen it for 20 years. When the companies that build the computers choose Nexus, that’s an endorsement that carries a big stick.

Start Your Own Streak

“Life is either a daring adventure or nothing.”

– Helen Keller, 1957

Your adventure can start this week. Ask for a 30-minute demo, and we’ll run Nexus on your own systems with the queries your team runs every day. If you’d rather explore on your own, ask for a free trial. It’s a daring adventure with no risk attached.

If your company has thousands of users, ask about a Universal License: one price, unlimited users. Everyone gets a seat, and nobody is left standing.

Email Tom Coffing at Tom.Coffing@CoffingDW.com and put “Nexus demo” or “Nexus trial” in the subject line.

Nexus Query Chameleon: The Intersection of All Data.

Posted in Blog