Here is a tutorial to show you how to use the Nexus Super Join Builder for federated queries. You will see all the amazing features the Nexus places at your fingertips.
Joining tables from separate systems in a single query is often considered an unattainable goal by most individuals and database companies. However, Nexus defies this belief by automating the process of joining tables and views across a wide range of platforms, including Excel, Access, and Athena.
What truly sets Nexus apart is its unique capability that allows users to select the specific database system for processing the join operation. This flexibility empowers users to choose their preferred processing environment, whether it’s their own PC or any available Nexus Server.
Recognizing that data and systems come in various formats and sizes, Nexus goes a step further by offering recommendations on where the join should be processed. This ensures optimal utilization of system resources. However, the user retains complete control and can decide which system they prefer to use for the join operation.
Moreover, Nexus handles the complexities of SQL, DDL, data type conversion, and load scripts, making the process of federating data across multiple systems nearly as straightforward as joining data on a single system. This streamlined approach eliminates the usual hurdles associated with data federation and simplifies the overall workflow. In summary, Nexus defies common skepticism by enabling the joining of tables and views from disparate systems within a single query. Its unique feature allows users to choose the processing system, provides recommendations to optimize performance, and automates the necessary conversions and scripts for smooth data federation.
Watch the video below, and you will be an expert at using the Nexus Super Join Builder for federated queries.
Tom Coffing, better known as Tera-Tom, founded Coffing Data Warehousing, where he has been CEO for the past 30 years. Tom has written over 90 books on Architecture, performance tuning, and SQL on all relevant systems. Tom has taught over 1,000 classes worldwide, and he is the designer of the Nexus, which celebrates 20 years of brilliantly integrating all databases.