Blog

Most people have never imagined writing a two-table join where tables reside on different database platforms, called a federated query. However, federated queries are so easy that Nexus writes them for you. There is so much data out there that no single system can hold it all, so joining across systems is the new standard.…

After programming for ten years, writing 85 books, and teaching over 1,000 classes on the architecture and SQL for all databases, I knew I could design the friendliest yet most powerful federated tool ever invented. Most people believe that Nexus is a query tool that works across all databases, and yes, it is true, but…

My dream to unite all database systems into one giant ecosystem began 20 years ago when I realized the value of data would create a data tsunami that no single system could hold. There was only one problem. Database vendors hate one another, and no database integrates with another. The solution took 20 years to…

Every single day at Coffing Data Warehousing is an electrifying adventure that pushes the boundaries of what’s possible in the realm of data. We are trailblazers, constantly shattering records and achieving feats that no one else on this planet has ever dared to dream of. And the exhilaration doesn’t stop there! Our latest triumph involves…

Nexus has no AI functionality like ChatGPT, yet, Nexus automates the integration and conversion functions across all database platforms. Nexus is the closest thing to AI without using any AI. My goal as a designer has always been to automate the most difficult and impossible tasks of working with big data. At the beginning of…

We have found a technique on all Postgres databases to move 20X faster, so our migrations and federated queries have blistering speeds. I put together a 2-minute video showing a 20-table join that spans 20 systems to show the speed, versatility, and impact this will have on everyone in the computer industry. Why put all…

Below the video are great date functions on Teradata. However, you can first witness a two-minute video that joins a Teradata table with tables from Databricks, Snowflake, Redshift, Google BiqQuery, Synapse, Vertica, MySQL, Oracle, SQL Server, DB2, Yellowbrick, Postgres, Microsoft Access, Excel in a single federated query. You can now download our books on Synapse,…

Below the video are great date functions on MySQL. However, you can first witness a two-minute video that joins a MySQL table with tables from Databricks, Snowflake, Redshift, Google BiqQuery, Synapse, Vertica, Teradata, Oracle, SQL Server, DB2, Yellowbrick, Postgres, Microsoft Access, Excel in a single federated query. You can now download our books on Synapse,…

Below the video are great date functions on Postgres. However, you can first witness a two-minute video that joins a Postgres table with tables from Databricks, Snowflake, Redshift, Google BiqQuery, Synapse, Vertica, Teradata, Oracle, SQL Server, DB2, Yellowbrick, MySQL, Microsoft Access, Excel in a single federated query. You can now download our books on Synapse,…

Below the video are great date functions on Greenplum. However, you can first witness a two-minute video that joins a Greenplum table with tables from Databricks, Snowflake, Redshift, Google BiqQuery, Synapse, Vertica, Teradata, Oracle, SQL Server, DB2, Yellowbrick, MySQL, Postgres, Microsoft Access, Excel in a single federated query. You can now download our books on…

Below the video are great date functions on Azure Synapse. However, you can first witness a two-minute video that joins a Synapse table with tables from Databricks, Snowflake, Redshift, Google BiqQuery, Vertica, Teradata, Oracle, SQL Server, DB2, Yellowbrick, MySQL, Postgres, Microsoft Access, Excel in a single federated query. You can now download our books on…

Below the video are great date functions on Google BiqQuery. However, you can first witness a two-minute video that joins a BigQuery table with tables from Databricks, Snowflake, Redshift, Azure Synapse, Vertica, Teradata, Oracle, SQL Server, DB2, Yellowbrick, MySQL, Postgres, Microsoft Access, and Excel in a single federated query. You can now download our books…

Below the video are great date functions on Amazon Redshift. However, you can first witness a two-minute video that joins a Redshift table with tables from Databricks, Snowflake, Yellowbrick, Vertica, Azure Synapse, BigQuery, Teradata, Oracle, SQL Server, DB2, MySQL, Postgres, Microsoft Access, and Excel in a single federated query. You can now download our books…

Below the video are incredible date functions on Vertica. However, you can first witness a two-minute video that joins a Vertica table with tables from Databricks, Snowflake, Redshift, Azure Synapse, BigQuery, Teradata, Oracle, SQL Server, DB2, Yellowbrick, MySQL, Postgres, Microsoft Access, and Excel in a single federated query. You can now download our books on…

You are about to witness a two-minute video showing Nexus join tables from Databricks, Snowflake, Redshift, Azure Synapse, BigQuery, Teradata, Oracle, SQL Server, DB2, Yellowbrick, Vertica, MySQL, Postgres, Microsoft Access, and Excel in a single federated query. The first amazing feat is that a user with no technical expertise can build and run it, and…

Nexus is a query tool with an ETL engine that could federate. Analytics on data is the gold that runs every successful business, and business is good because today’s companies grab as much data as possible to analyze later. The key is to store it somewhere cheap until it’s time to analyze. Nexus queries all…

I love a good database, but unfortunately, I revolutionized the industry, and they hate my guts because nobody saw it coming. There isn’t a database on planet Earth that talks to another database. Therefore, each table syntax, data type, SQL, and load utility differs. A database vendor’s business is retention, and business has been good,…

The LEAD function is incredible when you know the tips and tricks. Tom Coffing will demo the LEAD analytics on Postgres in a live demo. You will also see a federated query between Postgres, Snowflake, and Oracle across clouds! Below is your data, with a week of sales data for three products. Below is an…

The LEAD function is incredible when you know the tips and tricks. Tom Coffing will demo the LEAD analytics on Databricks in a live demo. You will also see a federated query between Databricks and Snowflake across two clouds! Below is your data, with a week of sales data for three products. Below is an…

The LEAD function is incredible when you know the tips and tricks. Tom Coffing will demo the LEAD analytics on Oracle in a live demo. You will also see a federated query between Oracle and Snowflake across two clouds! Below is your data, with a week of sales data for three products. Below is an…