Every user should be able to move data between systems. It takes additional time and experience to move the data appropriately by using the correct load utility. The best data scientists in the world can take months to convert table structures and data types between systems. The user can execute the query directly from their PC (pink arrow) or any NexusCore Server (red arrow). The hub can be any system, the user’s PC, or any NexusCore Server. Focus next on the blue arrow, and notice it is a hub of SQL Server, which means all tables move to SQL Server temporarily to perform the join. Focus first on the green arrows and see that this join involves tables from Teradata, Oracle, SQL Server, DB2, and Greenplum. This feature alone has taken us over a decade, and that is why we are the world leaders. The greatest asset a desktop tool can bring is to make cross-system joins (Federated queries) easy and efficient.

It only makes sense to have one tool to query and combine data sets from multiple systems. Nexus is designed to query over 20 different systems simultaneously. The SQL Server Management Studio design is for SQL Server systems. Teradata Studio is tuned to query a Teradata system.

You can buy a separate Toad query tool for SQL Server or DB2, but Toad works on one system at a time. The NexusCore Server provides the flexibility to run jobs for the user, as the user.

Sometimes it makes sense to run queries, federated joins, build analytic reports, and move data from your desktop, but it also makes sense when the data is huge to do it through a server. NexusCore Servers are to Nexus desktops what cell phone towers are to cell phones. You can even build analytic reports inside your desktop, and move data to and from different systems with the click of a button. With the Nexus Desktop, you’ll be able to use one tool to query all systems and join data across platforms (Federated queries). Do you want to access any data, at any time, anywhere?Ĭoffing Data Warehousing is proud to announce that the latest update to the Nexus as well as the NexusCore Server will be coming out in October.

Toad for db2 freeware