How a Business User Migrates 20 Systems to Snowflake
Only one query tool is so sophisticated that a business user with no technical knowledge can migrate 20 different database platforms to Snowflake or between any two database systems.
You are about to see a video of how business users are migrating data to Snowflake with the click of a button in the blink of an eye.
You will also see how users can optionally schedule data movement jobs on the Nexus Server for high-speed transfers.
Every database vendor has been so laser-focused on the database that they all missed what today's users need.
Today's users need a query tool that works brilliantly on all systems.
Today's users need to be able to join data across two systems seamlessly.
Today's users need to move data from one system to another in a point-and-click fashion with no technical knowledge required.
Today's users need to write the SQL or have the SQL built automatically. Today's users need search capabilities to look where a column resides in all their systems. Today's users need to take answer sets and join them with other answer sets, share them with peers, graph, chart them, pivot, and slice and dice them a hundred different analytics.
Today's users need to have dark mode when looking at their screen all day and be able to adjust the colors they see in the background completely.
All database vendors provide tools to access their systems, but none of them have any of the above features, so they are diminishing the power and purpose of their databases. In addition, the database vendors have never learned that the database and end-user access go hand in hand.
After writing 85 books on all database platforms and teaching over 1,000 classes worldwide for 20 years, I knew that software would one day overtake the importance of any single database.
I spent the last 20 years building the Nexus corporate software, which migrates one or thousands of tables across all database systems.
Last week I did a ten-table join across ten different systems using the Nexus Super Join Builder, and Nexus wrote the SQL automatically. I also searched on the column customer_number and found where it resides in 20 different systems, and I did it all in dark mode while joining and performing analytics on all answer sets I received that day.
Let the database vendors fight it out, but in the end, it is inevitable that everyone will access data across dozens, if not hundreds, of database platforms.
Here is the video of ten tables joining across ten database systems in a single query. Warning: This video contains what many experts thought was impossible.
Tom Coffing has also led a team of developers for almost 20 years to create the Nexus, which queries, migrates, and joins data across all systems. Amazingly, Nexus migrates between all the databases below with the click of the mouse.
• Microsoft Access
• SQL Server
• SAP HANA
The picture above shows Nexus in dark mode migrating Oracle data to Snowflake. Some customers are migrating thousands of tables to Snowflake in a single job.
It is never too early to dream about the future of data.