The Universal Database Analytic Workstation for Relational and Cloud Platforms
Nexus Pro is the universal database analytic workstation for business users, IT professionals and the DBA and ETL teams. How can one tool support such a wide range of users? In its 15th year of development, Nexus queries 20 different platforms, perform cross-system joins, and moves a single-table or entire database between platforms with a few clicks of the mouse. Nexus also has two major components that no other tool possesses: The “Garden of Analysis” is designed so a user can query all answer sets using templates inside their PC. “BizStar” allows business users to become business stars using query menus with an ability to share reports and automate processes.
Nexus Pro Features
Our Nexus query tool is designed to work with every system in your enterprise, on-premises systems, and cloud systems. Nexus works with traditional systems, such as DB2, Oracle, SQL Server, and Teradata. Nexus also works with newer systems, such as Netezza, Greenplum, Kognitio, Hana, Matrix, Aster Data, and Vertica. Nexus also works with your top cloud systems, such as Amazon Redshift, Microsoft Azure SQL Data Warehouse and all flavors of Hadoop.
Right-click on any table or view in your Nexus system tree and choose "Super Join Builder". Your table, or view, will be shown visually, along with its columns and their data types. Press the "Add Join" drop-down menu and see what other tables or views can be joined. Click on the columns you want on your report and a checkmark appears. Nexus automatically writes the SQL for you. You now have the ability to develop much quicker because Nexus is doing the hard work for you.
Nexus allows users to join tables from different systems. Above, we are joining a Teradata table to an Oracle table to a SQL Server table. Just checkmark the columns you want on your report and Nexus handles everything behind the scenes. Nexus builds the SQL, converts the table structures and moves the tables to the Hub system. The report comes flying back with no intervention from the user. That is just another amazing feature of Nexus.
Nexus allows users to convert answer sets into Excel spreadsheets. This allows users can work and manipulate data in a format that they prefer. Users can also export data to Excel, import Excel worksheets into relational systems as tables, and even join Excel spreadsheets with table or views.
Most companies would love to allow their business and IT uses to be able to move data from one system to another. The problem is that when a user initiates a data movement job, the data must move from the source system to the user’s PC and then to the target system. There are many problems with this scenario. User’s can’s schedule data movement jobs unless their PC is turned on or have a global data movement calendar. Plus, moving large data through a local network and through the user’s PC can be extremely slow and a disaster on network resources. NexusCore has been designed to eliminate these problems. NexusCore is a server that you strategically place on your Wide Area Network (WAN) to act as your super communications highway. Users can move data between systems, but now the NexusCore Server impersonates the user’s credentials and moves the data as if the user was executing from the server. Now, the data moves from the source to the NexusCore Server to the target. The only data moving through the local network is the tiny message that the data movement job has been completed.
Do you know how long it normally takes to convert the table structures and move data between systems? Sometimes this is a month-long project, but not with Nexus. Just right-click on any database in your systems tree and choose "Move Data". Pick the target system in which you want the tables and data to move and then checkmark the tables you want to move. Press the blue arrow and the tables with a checkmark move to the Target system. Press Execute and watch the tables light up in green with every successful move. If there is a problem, the table(s) will light up in red. Nexus users can move data between different systems from their local Nexus or use the optional NexusCore Server for enhanced speed.
Allows for full or partial searches on names of objects for these systems: DB2, Oracle, SQL Server, Teradata, Postgres, and Netezza. All query tools display a tree that must poll the metadata each time a tree is opened, but Nexus allows the user to poll their systems once, and to then to store that metadata in memory. This enhances search speeds for metadata magnitudes of order. To poll a system a user merely right clicks on the system in the system's tree and chooses “Collect Cache Tree Hierarchy”. Once the system has been scanned then all metadata and search bar capabilities are instantaneous no matter how large your systems.
The search bar has been designed with auto-sense, so it doesn’t begin its search until typing is delayed. Once a system is polled, a user has instantaneous search capabilities across all platforms in their access rights universe. The visual display builds a systems tree with only the objects meeting the search criteria. Although the Cache Tree is stored in memory, it is an active tree capable of queries, joins, and data movement.
This new capability is designed for both sub-second speed of object metadata retrieval and to greatly reduce network traffic between the client for metadata lookup. The visual design for comparisons of duplicate names across systems is excellent for comparing tables, columns, and their data types. Plus, no matter how many systems a user has access to or how large each system is the user will have instant lookup capabilities as well as an excellent viewing device for comparing objects, as well as instantaneous retrieval for metadata.
Merely remove any text from the search bar and the normal Nexus tree is automatically restored.
Nexus can query all of the systems in your enterprise and each answer set is automatically present in the Garden of Analysis. This is a unique concept because any and all answer sets can be re-queried by Nexus inside your desktop. Users can even join answer sets together from different systems right inside the Garden. Above, we have four answer sets. We right-clicked on answer set 4 (Result 4 – in red). Now, we can click on any tab above and get Aggregates, OLAP, Rank, Grouping Sets, Quantiles, Top, Sort, Join, Charts/Graphs, Dynamic Charts or a Dashboard. Press on a table and drag columns in the answer set to the templates and you immediately see the new data.
Nexus has a section dedicated to making the business user a star. The BizStar on Nexus allows the business user community to share reports, automate processes, execute advanced queries and joins by merely clicking from menus. What is amazing is that IT experts can create advanced and cool processes, joins or queries that the business users can execute or schedule with a click of the mouse. The BizStar is designed for users to integrate with other users and the IT staff.
Nexus can now create and execute Python scripts. Just build your code and hit Execute and your results are returned. How many query tools have you seen designed for SQL that can also execute Python? Nexus!
Just right-click on any database and choose “Compare and Sync“ as your Source system. Then choose the system and database you want to compare and synchronize with as your Target system. The Nexus will attempt to line-up the tables based on their name. The user can drag and drop to align the tables perfectly if needed. Checkmark the tables you want to be compared and synched and hit Execute. The Nexus will show the results of the comparison and allow the user to synchronize the data.
Press on the Calendar icon in the main Nexus screen toolbar (circled above in red) and your scheduling options will appear. You will then see the Schedule Builder User Interface. Press on the dropdown menu and choose the Operation Type.
Just right-click on any Teradata database and choose "Hound Dog Compression". Pick the tables you want to be compressed and move them over by hitting the blue arrow. Hit Execute. Nexus evaluates Teradata tables and applies the perfect algorithm to attain the maximum compression savings. This feature alone has saved hundreds of companies millions of dollars over the past 10 years. Nexus usually gains about 35% space savings on average. There are even more savings on larger tables. There is no down side to Multi-Value compression because the tables are about 35% smaller, they don't need to be decompressed, they move faster into memory and they save about 35% of your entire system's space. Nexus auto-compresses tables when they move from other systems, for example when Oracle or SQL Server tables are moved to Teradata.