Which is more difficult, landing on the Moon or joining tables across database platforms? It is probably more difficult to land on the Moon.

However, everybody knows databases are proprietary and don’t talk with others. Over 20 years, we made it our business to integrate all database systems completely.

Can we join data across database platforms in a single query? Not only can we do it, but we have also made it so anyone and everyone can do it.

Why do we use thousands of techniques inside the engine to do federated queries? Because data is complicated, the size of data matters and system resources are scarce, so we allow users to join data in any way they want.

The video below will show a wide variety of techniques to join data across 20 database platforms, all of which you probably have in your enterprise.

I will start the video by showing simple techniques to combine data from different platforms. At first glance, you might even say this is not sophisticated, but as the video progresses, you will soon understand that we can join data across any combination of systems in any way you want.

You will begin to believe when I join 20 tables from 20 different systems in a single query. You will know we are serious when I join a production table with 19 Excel spreadsheets.

And all you have to do is point-and-click your mouse!

Nexus has been in production at many of the largest financial, insurance, PC manufacturers, and package delivery sites for 20 years.

If you had to choose only to have one query, migration, and federated tool in your entire enterprise, Nexus would be the only solution you would need.

Here is a video showing the many techniques Nexus uses to join data across systems.

You can also visit our website at the link below to see 60-second videos of the Nexus in action. Ten videos will show the many brilliant techniques Nexus uses to thrill users.

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,

Tom


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

Posted in Blog