Fifteen Years, Delivered on Time

“Eighty percent of success is showing up.”

– Woody Allen

One of the world’s largest shipping companies, the one that taught us some things absolutely, positively have to be there overnight, has shown up with Nexus every business day for 15 years. Its analysts started using Nexus Query Chameleon in 2011, and they have never missed a delivery window.

Fifteen years is a long time in technology and an eternity in shipping, where yesterday’s news is already this morning’s delivery. In all that time, Nexus has never once been returned to sender.

Every Minute Counts

“Lost time is never found again.”

– Benjamin Franklin, Poor Richard’s Almanack

In shipping, time is the product. Nexus saves time on every query by putting every system in one window: Teradata, Oracle, SQL Server, Snowflake, BigQuery, Databricks, and more. Users stop switching tools and start shipping answers.

The Cache Tree searches every connected system at once for a table or column name, so nobody wastes an afternoon hunting for data. With Nexus, lost time may never be found again, but lost tables always are.

Here is what Nexus delivers every day.

Migrate Between All Systems

“Plans are worthless, but planning is everything.”

– Dwight D. Eisenhower, 1957

Moving data is a logistics problem, and Nexus plans the whole route. 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 ships the data at full speed.

Teradata to Snowflake, Oracle to BigQuery, SQL Server to Databricks: Nexus migrates between every system it connects to. It’s overnight delivery for data, and nothing gets lost in the sort. With Nexus, every day is D-Day: Delivery Day.

Super Join Builder: Federation Across All Systems

“Alone we can do so little; together we can do so much.”

– Helen Keller

Few companies understand a hub better than this one. Packages fly in from everywhere, get sorted at the hub, and fly back out. The Super Join Builder works the same way: pick tables from Teradata, Snowflake, BigQuery, Databricks, and more, and Nexus moves the data to a hub and joins it there.

Check the columns you want, and Nexus writes the SQL. Want a different hub? Pick your PC or a Nexus Server, and Nexus reroutes the SQL for you. Hub-and-spoke works for packages, and Nexus proves it works for joins.

The Nexus Server: The Express Lane

“If everything seems under control, you’re just not going fast enough.”

– Mario Andretti

When a migration runs from a desktop, every row squeezes through the user’s PC. That’s like routing every package in the country through one person’s front porch. The Nexus Server moves data straight from source to target while the PC only sends the instructions.

It also speeds up federated queries, and it stores flat files cheaply so users can query them like tables. The Nexus Server puts your data in the express lane. In the race to move data, the Nexus Server is your Formula One, and the PC stays in the pits.

Cloud Drop: Air Freight for Data

“Adventure is worthwhile in itself.”

– Amelia Earhart

Air freight changed shipping forever, and Cloud Drop changes how data travels. Drag any query result into AWS, Azure, Google Cloud, or local storage, and it lands as a CSV, JSON, Parquet, Excel, or text file.

Nexus shows cloud buckets like databases and files like tables, so users can query a file in the cloud and join it to any system. Your data now flies first class, and it never pays for checked bags. Cloud Drop lets every user fly solo because storage costs will be so low.

GitHub Integration

“It ain’t over till it’s over.”

– Yogi Berra

In shipping, nothing is over until it’s delivered. In SQL, nothing is over until it’s committed. Push, pull, and manage SQL files directly between Nexus and GitHub, and save every version.

Click a .sql file in the repo, and it opens as a query, ready to run on any system. Every query now comes with tracking, and you always know who signed for it.

Yogi Berra won 10 World Series championships as a player, more than anyone else in Major League Baseball history. He won them by playing for the team. With GitHub, every query is shared, and everybody gets a ring.

Federated Notebooks

“Nothing in life is to be feared, it is only to be understood.”

– Marie Curie

Federated Notebooks help analysts understand their data instead of fearing it. Mix SQL, Python, Markdown, and more into one connected workflow. One cell queries Teradata, the next queries Oracle, and Python brings the results together.

Analysts write down their reasoning right next to their code, so the next person understands the why as well as the what. It’s a shipping manifest for your thinking, and every step is accounted for.

In 1903, Marie Curie became the first woman to win a Nobel Prize, sharing the Nobel Prize in Physics, and in 1911, she won the Nobel Prize in Chemistry, becoming the first person ever to receive two Nobel Prizes. Federated Notebooks allow your users to research, share, and combine SQL, Markdown, and Python across all systems. Now that’s elements coming together!

BIcandy: Instant Dashboards and Beautiful Maps

“Every child is an artist. The problem is how to remain an artist once we grow up.”

– Pablo Picasso

BIcandy turns every analyst back into an artist. Run a query that returns a date and an amount, and Nexus paints the dashboard for you: totals by year, month, weekday, and hour, plus maps where the size of each circle shows the amount in each city.

There’s no dragging, no dropping, and no separate BI tool. For a company that lives by its maps, BIcandy is a masterpiece that arrives already framed. With BIcandy, like Pablo Picasso, you could become a legend merely sitting in your cubism.

More Than 100 Themes

“I found I could say things with color and shapes that I couldn’t say any other way.”

– Georgia O’Keeffe

Some companies are known by their colors, and this one wears its colors on every truck and plane. Nexus has more than 100 themes, from Coffee and Northern Lights to Pittsburgh Black and Gold and Minnesota Purple and Gold, and users can create their own in any colors they like.

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. Picture your favorite theme arriving at 10:30 a.m. sharp, right on schedule.

Why Nexus Delivers Everywhere

“Float like a butterfly, sting like a bee.”

– Muhammad Ali, 1964

Most vendor query tools deliver to only one address. Snowsight delivers to Snowflake, BigQuery Studio delivers to BigQuery, and the Databricks SQL Editor delivers to Databricks. Nexus floats across every system and stings on all of them.

Microsoft OEM’d Nexus from 2009 to 2012 and gave it to its customers. One of the world’s largest shipping companies has relied on it for 15 years. When the world’s experts on delivery keep choosing Nexus, you know it delivers.

Nexus doesn’t just float like a butterfly. It makes every database The Greatest.

Seize the Demo

“Carpe diem.”

– Horace, 23 BC

Seize the day, or better yet, seize the demo. 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, your Nexus arrives absolutely, positively on time, and no signature is required.

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.