You have probably seen SQL for a 20-table join, but you have never seen a 20-table join where the tables are located across 20 different systems. You will see that happen today.

You might think that NASA would be the organization tech-savvy enough to crack the code to make all databases join, but the first to do it comes from Tom and Leona Coffing, married for 43 years, based out of Middletown, Ohio.

Leona Coffing said, “We have been on the trail of the Holy Grail to make all databases speak the same language for almost 20 years. Translation between systems takes automatic table conversions, perfecting load scripts, and writing the SQL automatically across all systems.”

Tom Coffing said, “Companies migrating to a different database normally takes companies a year because conversions, building load scripts, and converting SQL is difficult. We can now do in seconds what takes companies a year.”

Dave Cook, Coffing Data Warehousing CTO, said, “Most of our customers began performing federated queries between two systems last year, but we want to ensure that as their technology needs advance, they can join tables from an unlimited number of systems automatically.”

We named our software Nexus 19 years ago, which means the intersection between all databases. What we have done that nobody else can do is process the join on any database system, including a user’s PC.

You will see today a 20-table join from 20 different systems, including Snowflake, Databricks, Azure Synapse, Amazon Redshift, Google BigQuery, Teradata, Oracle, SQL Server, DB2, Netezza, Greenplum, MySQL, Postgres, Yellowbrick, Vertica, Microsoft Access, and an Excel worksheet.

But the most impressive thing you will see is that we will change where the join processes. We will start by processing the join on Snowflake, then change it to MySQL, and then change it to the user’s PC. You will amazingly see Nexus instantly change the SQL, conversions, load scripts, and the case of the SQL. You will then see how Nexus creates a table with the results on any system and runs the SQL from the command line.

The astounding piece is that you can process the join on any system in your enterprise!

Watch the 20-table join video below.

You can also visit our website at the link below to see 60-second videos of the Nexus in action.

https://coffingdw.com/sixty-second-feature-videos/

Video 1 – Getting Started
Video 2 – Searching Across Systems
Video 3 – Migrating Data
Video 4 – Join Builder Writes the SQL
Video 5 – Federated Queries
Video 6 – Customizing Your Result Set Viewing
Video 7 – Using Excel
Video 8 – Dragging Answer Sets to Create Tables
Video 9 – Build Analytics Automatically
Video 10 – Analytics From Result Sets

Call or write me for a demo, or download the latest Nexus from our website for free. Here is a license that will give you and everyone in your organization a free month to use Nexus.

30-day Universal License of Nexus

E3PK0-N0D00-G1E3F-H8J5M-1F14B-9YDBI-K9C8J4X


Thank you,

Tera-Tom

Tom Coffing
CEO, Coffing Data Warehousing
Phone: 513 300-0341
Email: Tom.Coffing@CoffingDW.com
Website: CoffingDW.com and NexusDataServer.com
YouTube: CoffingDW

Posted in Blog