Teradata’s QueryGrid product is a brilliant concept that connects Teradata systems to multiple data sources for cross-system functionality. However, QueryGrid does not compare with CoffingDW’s high-speed Nexus Server.
Teradata is a proprietary database, but Nexus combines all database platforms.
Teradata broke barriers within the database world by allowing users to join data across several systems. But Teradata’s desktop tool Teradata Studio forces users to write SQL to receive an answer set. QueryGrid has intelligence, but the user’s desktop has none.
The Nexus Pro Desktop is the most intelligent user desktop on the market. Nexus Desktops can standalone or connect to any Nexus Server. The Nexus Super Join Builder allows users to point-and-click to automatically write the SQL for a single system or across multiple systems. A Nexus user said, “Nexus puts the business user on the same playing field as a data scientist.” I would state that this doesn’t seem right because Nexus puts the most straightforward business user on a higher level than the best data scientist. What a business user using Nexus can do in seconds takes a data scientist weeks to months to accomplish.
Nexus users can also transfer tables between any two systems and can migrate thousands of tables at high-speeds. Nexus is so intelligent that users can drag an answer set to their systems tree, and Nexus creates a table and moves the data.
Teradata Studio is the query tool for Teradata, but Nexus is an analytic workbench combining all systems into one.
You can have only one Teradata QueryGrid, and it requires a Teradata system. You can still have hundreds of Nexus Servers working across all systems, including Teradata only if you want.
Todd Wilson, co-CTO at CoffingDW, says, “We have customers who have multiple Teradata systems with QueryGrid connections. They have asked us to include a QueryGrid option in our Nexus Server to migrate tables between two Teradata Systems. That option is available, but customers have discovered that the Nexus Server’s TPT options are magnitudes of order faster than using the Nexus QueryGrid option.”
Dave Cook, co-CTO at CoffingDW, says, “QueryGrid connects Teradata with several database systems using a couple of load strategies. The Nexus Server connects all systems and uses over 150 different load utility combinations that intelligently and automatically initiate depending on the source and target databases.”
In a recent press release, Teradata says, “To extend the company’s reach to the most requested technologies, Teradata has partnered with Starburst Data to integrate a new Presto connector that allows Teradata Vantage users to leverage Starburst Enterprise Presto as part of QueryGrid.”
Teradata connects to:
Databricks Delta Lake
Hive (for Cloudera Distribution of Hadoop and Hortonworks Data Platform)
Oracle (only as a target connector)
The Nexus Server connects and also migrates between any combination of the systems below:
Tom Coffing, CEO of CoffingDW, says, “Customers want their business users to join data across any combination of systems easily. They also want users to transfer tables with no technical knowledge required. They also want their ETL teams to migrate entire databases to and from a wide variety of systems quickly and at low costs. The Nexus desktops working in conjunction with Nexus Servers are the perfect combination.”
Leslie Nolander, COO at CoffingDW, says, “We invite everyone, including Teradata, to run a POC with a Nexus Server. We have a Nexus Server connected to multiple sources on the cloud so users can log in today and see how powerful but easy Nexus is to join data across platforms or migrate between any two systems. You can call us and begin a POC in five minutes.”
It defeats the point if you combine systems but don’t give the users the functionality at the desktop to join tables automatically, move data with a click of the mouse, or allow entire databases to migrate.
The only architecture on the market today with it all are Nexus Desktops connecting to Nexus Servers, thus uniting all users by automating joining and data transfers across all systems.
Tom Coffing, better known as Tera-Tom, is the founder of Coffing Data Warehousing where he has been CEO for the past 25 years. Tom has written over 75 books on all aspects of Teradata, Netezza, Yellowbrick, Snowflake, Redshift, Aurora, Vertica, SQL Server, and Greenplum. Tom has taught over 1,000 classes worldwide, and he is the designer of the Nexus Product Line.