top of page
  • tomcoffing

Federate as You Migrate and Excel Mate

Twenty years ago, it became obvious to me that companies would one day be so overwhelmed with data that no single data warehouse could hold it all. This problem became even more disturbing because I witnessed how many database companies try to lock in a customer for life. I was equally shocked to learn that the two most popular databases are Microsoft Access and Excel and that some companies use them to hold and process their data. I felt that these facts were a hole in the data universe. So, I built a world-class development team, and we have gone to work for 20 years. Our mission is a project named Nexus, which unites all database platforms automatically, including Microsoft Access and Excel. Today, I will show you three videos from this blog on my website. The first will perform a federated query of a 20-table join spanning 20 different systems in a single query. The second video will show a 20-table join that uses a production table and 19 Excel worksheets. In a single query, you can join Microsoft Access and Excel with any combination of cloud and legacy database tables. And the third video will show you how anyone using Nexus can migrate 20 different systems to any system with no technical knowledge required. People often ask me who our competitors are. And I tell them we have none. Nexus is the only software product to query, migrate automatically, and join data across over 25 relational database systems. Personally, I thought we would get there before twenty years of work, but it is nearly impossible to get all databases to play nice together. However, Nexus does now change the way the world processes data. If you are preparing for the future of data, check the video below and watch Nexus join 20 tables across 20 different systems in a single federated query.

Watch Nexus join 19 Excel worksheets with a production table below.

You have data in about 18,000 places, and if you could integrate the right data, you are minutes away from world domination.

You are two minutes away from understanding that migration across all systems is now automated.

It took almost 20 years to make the Nexus software act like a Rosetta stone because of the countless data conversion and load script options, but after testing for almost two decades, we have delivered.

Watch and understand and then migrate and command domination over your database vendors because you can pack up and move instantly.

You are about to see a video of how easy it is to use Nexus as your migration tool.

Please contact me directly to learn more about bringing Nexus into your company.

Tom Coffing, CEO of Coffing Data Warehousing

Call: 513 300-0341 YouTube Channel:

208 views0 comments


bottom of page