A federated query joins tables across database systems, and today, you will see 19 tables joined across 19 systems and a wide variety of techniques to federate humongous amounts of data quickly and efficiently.

Federating data should be compared to driving a car in rush hour traffic because it’s complicated, and a million things could go wrong. To successfully drive a car, you must be able to do whatever is required for the situation that arises.

We give users every possible option to process federated queries any way they see fit and automate everything so anyone can do it.

Data is complicated because it comes in all sizes, and system resources are sometimes busy or expensive. However, we allow users to process federated joins anywhere a CPU and memory exist, convert table structures and data instantly between all systems, build over 250 load utilities depending on the source and target systems in which you want to move data, automatically write the SQL perfectly on all systems, and give users the option to do everything from their PC or schedule the jobs on a Server physically located anywhere in the world you choose. And finally, we only move and join the data necessary to complete the query, so no data moves unless needed to satisfy the query.

Have we thought of every technique possible for joining data across systems? Absolutely and positively, yes. Do we have any competitors even close to doing what we are doing? As you will see in the video, absolutely and positively, nobody else is even close.

Watch the video below to understand everything important about federated queries.

You can also visit our website at the link below to see 60-second videos of the Nexus in action where you will see ten different videos showing 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,

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