Special Delivery: A Five-Year Contract

“Neither snow nor rain nor heat nor gloom of night stays these couriers from the swift completion of their appointed rounds.”

– Herodotus, 5th century BC

Some federal agencies are old. This one predates the Constitution, and it has been serving the country ever since. When an agency with that kind of track record puts its stamp of approval on a query tool, it’s first-class news.

The agency runs Teradata and Oracle, and it awarded Nexus Query Chameleon a five-year contract. Neither snow nor rain nor a mountain of SQL kept Nexus from its appointed rounds, and the contract arrived with no postage due.

Why Five Years Says Everything

“The best way to predict the future is to invent it.”

– Alan Kay, computer scientist, 1971

A federal agency doesn’t sign a five-year contract on a hunch. It signs one after it has looked into the future and decided which tool belongs there. Five years is a lifetime in technology, and the agency bet that Nexus would keep inventing its way forward.

Nexus has kept inventing ever since. Here is what the agency, and every Nexus customer, can put to work.

Teradata and Oracle Under One Roof

“A house divided against itself cannot stand.”

– Abraham Lincoln, 1858

Four score and seven years ago has just changed to five stars and a five year contract. Many agencies live in a house divided. Teradata lives in one room, Oracle lives in another, and each vendor’s tool is built for its own system. Users spend the day walking from room to room.

Nexus brings everyone under one roof. One window queries Teradata and Oracle side by side, the Cache Tree searches both systems at once for a table or column name, and the Super Join Builder joins them in a single query. A house united stands strong.

Migrate Between All Systems

“We choose to go to the Moon in this decade and do the other things, not because they are easy, but because they are hard.”

– John F. Kennedy, 1962

Ask not what your company can do for you. Ask what your query tool can do for your company. Moving data between systems used to be a moonshot. Nexus makes it easy. 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 launches the data at full speed.

Oracle to Teradata, Teradata to Snowflake, Teradata to BigQuery: Nexus migrates between every system it connects to. Mission control can relax, because every table lands safely.

Super Join Builder: Federation Across All Systems

“Individual commitment to a group effort – that is what makes a team work, a company work, a society work, a civilization work.”

– Vince Lombardi

The Super Join Builder is the quarterback of federation and the ultimate Starr. It calls the play across Teradata, Oracle, Snowflake, BigQuery, Databricks and more, and it joins them in one query. Check the columns you want, and Nexus writes the SQL, hands the data off to a hub and joins it there.

Want to run a different play? Pick your PC or a Nexus Server as the hub, and Nexus rewrites the SQL on the fly. No fumbles, no penalties, just a touchdown every time.

Cloud Drop

“It is possible to fly without motors, but not without knowledge and skill.”

– Wilbur Wright, 1900

Two wrongs don’t make a Wright, but one Nexus brings two clouds together like brothers. Cloud Drop gives your data wings. Drag any query result into AWS, Azure, Google Cloud, or local storage, and it lands as a CSV, JSON, Parquet, Excel, or text file. No motor required, just a mouse.

Nexus shows your cloud buckets like databases and your files like tables, so you can query a file in the cloud and join it to Teradata or Oracle. The flight plan is a drag and a drop, and every landing is smooth.

GitHub Integration

“Those who cannot remember the past are condemned to repeat it.”

– George Santayana, 1905

With Nexus and GitHub, nobody has to remember the past, because Git remembers it for you. Push, pull, and manage SQL files directly between Nexus and GitHub, and Git saves every version. Click a .sql file in your repo, and it opens as a query, ready to run on any system.

No more rewriting a query someone wrote last year. Your team stops repeating history and starts making it.

Federated Notebooks

“Genius is one percent inspiration and ninety-nine percent perspiration.”

– Thomas Edison

Thomas Edison filled thousands of notebooks. Imagine what he could have done with a Nexus notebook. Federated Notebooks combine SQL, Python, Markdown, and more in one connected workflow. One cell queries Teradata, the next queries Oracle, and Python brings the results together.

Nexus supplies the perspiration, and you supply the inspiration. That’s a bright idea, and you don’t need a light bulb to see it.

BIcandy: Instant Dashboards and Beautiful Maps

“A picture is worth a thousand words.”

– Advertising adage, 1920s

With BIcandy, one result set is worth a thousand pictures. Run a query that returns a date and an amount, and Nexus paints 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.

There’s no dragging, no dropping, and no separate BI tool. Every chart is picture perfect, and the dashboard is ready before you can say cheese.

More Than 100 Themes

“We don’t make mistakes, just happy little accidents.”

– Bob Ross, The Joy of Painting

Bob Ross could paint a whole world with a few colors. Nexus hands you a palette of more than 100 themes. None are accidents, but every one makes users happy. Paint your day in Coffee, Ann Arbor Maize and Blue, Columbus Scarlet and Gray, Green Bay Green and Gold, Northern Lights or Sedona Red Rock, or keep it light with Pastel Latte and Caribbean Aqua.

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. Your workday becomes a work of art.

Why Nexus Is the King of Query Tools

“In the land of the blind, the one-eyed man is king.”

– Desiderius Erasmus, 1500

Nexus works equally well on Teradata, Oracle, Snowflake, BigQuery, Databricks, SQL Server and every other system it connects to. Microsoft saw it early: from 2009 to 2012, Microsoft OEM’d Nexus and gave it to its customers. When a federal agency older than the Constitution looked at its options, it saw the same thing. Nexus is the king of query tools, and that’s plain to see.

See Nexus for Yourself

“Well done is better than well said.”

– Benjamin Franklin, Poor Richard’s Almanack, 1737

So we won’t just say it. We’ll show it. If your team runs Teradata, Oracle, or both, 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 try it yourself, ask for a free trial. Either way, it’s a delivery worth signing for. Ben Franklin caught lightning with a kite. Prepare to be shocked when you see the demo.

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.