the nexus chameleon: your secret to mastering all data

Open Systems Services/Coffing Data Warehousing

Patent Pending

Addresses T Add Join

Select *

Street Varchar(30)City Varchar(20)

State Char(2)

+

Zip Integer

AreaCode Smallint

Phone Integer

Subscribers O Add Join

Select *

Last_Name Varchar(20)First_Name Varchar(20)

Gender Char(1)

+

SSN Integer

Member_No Smallint

Subscriber_No Integer

Teradata Table


Claims

Add Join

Select *

Claim_Id IntegerClaim_Date DATE

+

Phone IntegerSubscriber_No Integer

Subscriber_No IntegerMember_No Smallint

SQL Server

Claim_Amt Decimal(12,2)

SQL Server Table

Join data across different on-premises and cloud systems by merely pointing-and-clicking

Oracle Table

It took over a decade of development to produce the Nexus Chameleon, but now it is the most sophisticated and powerful software in the world. The Nexus puts the business user on the same playing field as the most advanced data scientist because with the click of the mouse or a simple touch to the screen all systems become one! Nexus is the secret weapon to mastering all data.

• See your tables and views visually• A menu shows you what else is joinable• Click on the columns you want on your report• Nexus builds the SQL for you automatically• Perform cross-system joins among many systems• Choose the system you want to process the queries• You get the report with Nexus handling everything

• Move databases between systems instantly• Compare and synchronize databases across platforms• Save answer sets as tables on any system• Re-query answer sets inside your own PC• Join or move data across on-premises and cloud systems• Graph and chart answer sets instantly• Query and join Excel worksheets with production data

Nexus Queries On-Premises and Cloud Systems Simultaneously

Nexus is designed to work with every on-premises and cloud system in your enterprise. Nexus works with traditional systems such as DB2, Oracle, SQL Server and Teradata, but Nexus also works with newer systems such as Hadoop, Vertica, Netezza, Greenplum, Redshift, Kognitio, SAP Hana, Matrix, Aster Data and Microsoft Azure SQL Data Warehouse.

Nexus Chameleon

SystemsAster DataAzure CloudDB2ExcelGreenplumHadoopKognitioNetezzaOracleMatrixRedshiftSQL ServerSybaseTeradataVertica

File Edit View Query Tools Help Web Windows History Sandbox

System: Database:

+++++++++++++++

SQL ClassOracle

Query 1 Query 2 Query 3

SELECT *FROM Employee_tableWhere Dept_No = 400 ;

Messages Garden of Analysis Result 1

Employee_No Dept_No Last_Name First_Name Salary125634911213342341218

400400400

Harrison Strickling Reilly

HerbertCletusWilliam

54500.0054500.0036000.00

123

EXECUTE

New Query ?

Nexus is designed to work with every system in your enterprise,

whether on-premises or in the cloud

And you can query them all simultaneously

Nexus Shows Tables Visually and Automatically Builds the SQL For You

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 ChameleonFile Edit View Query Tools Help Web Windows History Sandbox

System: Database: SQL ClassTeradata EXECUTE

New Query ?

Execute Create Table Preview SQL in Nexus Join Hub System Teradata

Objects Columns Sorting Joins WHERE SQL Metadata Analytics

Customer_Table T Add Join

Select *Customer_Number IntegerCustomer_Name Varchar(20)Phone_Number Char(8)

Order_Table T Add Join

Select *Order_Number IntegerCustomer_Number IntegerOrder_Date DateOrder_Total Decimal (10,2)

Nexus Allows Users to Even Perform Cross-System Joins

Did you ever even imagine that you would be able 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.



New Query ?



ADDRESSES T Add Join

Select *Street Varchar(30)City Varchar(20)State Char(2)Zip IntegerAreaCode SmallintPhone Char(15)Subscriber_No Integer

SUBSCRIBERS O Add Join

Select *Last_Name Varchar(20)First_Name Varchar(20)Gender Char(1)SSN IntegerMember_No SmallintSubscriber_No Integer

CLAIMS SQL Server Add Join

Select *Claim_Id IntegerClaim_Date DateSubscriber_No IntegerMember_No SmallintClaim_Amt Decimal(12,2)Provider_No IntegerClaim_Service Integer

Users Can Choose on Which System to Process the Query

People who see this next feature can't believe their eyes. Nexus allows the user to select which system they want to process the query. In our last example, the Hub was Teradata. We just changed the Hub to SQL Server (above). Now, the tables from the three systems will be converted, moved and joined on the SQL Server system. Nexus allows you to join tables from any system in your enterprise (both on-premises and cloud), but then tops it off by allowing you to process the joins on any system in your enterprise. Need extra processing power? Spin up a server on the cloud and make it the hub. Simply amazing!



New Query ?

Execute Create Table Preview SQL in Nexus Join Hub System SQL Server






CLAIMS Sql Add Join


Simply Amazing - Change the Hub to the Garden of Analysis

Nexus allows you to determine on which system the processing will take place. We call this the Hub. Above, we have changed the Join Hub System to the Garden of Analysis. This should be done when the joining tables are not huge. Now, all of the tables will be queried separately, and then joined transparently inside the user's PC. It is as fast as lightning! Brilliant! You now have the smartest and most powerful PC on the planet.

Nexus Chameleon

Systems

File Edit View Query Tools Help Web Windows

Query 1Execute Create Table Preview SQL in Nexus Join Hub System


Query 1 Super Join Builder

Teradata

Oracle

+

- SQL_Class

System Tables

+ dbo.Addresses+ dbo.Claims+ dbo.Customer_Table

+

dbo.Department_Table+

dbo.Employee_Table

+ dbo.Order_Table

+ dbo.Providers+ dbo.Services+ dbo.Subscribers

- Addresses T Add Join

Select *

Street Varchar(30)City Varchar(20)

State Char(2)

+

Zip Integer

AreaCode Smallint

Phone Integer

Subscribers O Add Join

Select *


Gender Char(1)

+

SSN Integer

Member_No Smallint



+SQL Server-

Claims

Add Join

Select *


+

Phone IntegerSubscriber_No Integer


SQL

Claim_Amt Decimal(12,2)

From the Join Hub Systemdrop down menu

choose Garden of Analysis

Garden of A

Nexus Shows You What Tables Are Joinable in a Menu

The Add Join menu drop down shows that the Addresses table joins to the Subscribers table. Keep cascading down the menu and you see that the Subscribers table joins to the Claims table. Keep cascading all the way until you get to the final table, which is the Services table. Left click on the Services table and all five tables will be in the Super Join Builder.



New Query ?




Select *Street Varchar(30)City Varchar(20)State Char(2)

+

Zip IntegerAreaCode SmallintPhone IntegerSubscriber_No Integer

T

ClaimsT

Subscribers

ProvidersT

ServicesT

Left Click on thefinal table (Services)

The Menus Placed All Five Tables In the Super Join Builder

Now that all five tables are present in the Super Join Builder, all you have to do is checkmark the columns you want on the report. The SQL is built automatically with each mouse click. When you are done selecting the columns, just hit Execute.

Nexus ChameleonExecute Create Table Preview SQL in Nexus Join Hub System Teradata



Select *Street Varchar(30)City Varchar(20)

State Char(2)

+

Zip Integer

AreaCode Smallint

Phone Integer


Subscribers T Add Join

Select *


Gender Char(1)

+

SSN Integer

Member_No Smallint


Claims T Add Join

Select *


+

Claim_Amt Decimal(9,2)Phone IntegerSubscriber_No Integer


Services T Add Join

Select *Service_Code Integer

Service_Pay Decimal(7,2)

+

Service_Desc Varchar(20)

Providers T Add Join

Select *Provider_Code Integer

Error_Rate Decimal(4,2)

+

Prov_Name Varchar(20)

Save Answer Sets as Tables

Nexus allows you to run a query in the Super Join Builder and save the answer set as a table on any system in your enterprise (on-premises or cloud). This is a fantastic way to create a data mart or to save data to your own sandbox. It is also great for building a test system. And Nexus makes it so easy. Just click on the "Create Table" button and tell Nexus the system and the table name you desire, and that new table and its data will be there when the query is finished.



New Query ?

Execute Create Table Preview SQL in Nexus Join Hub System SQL Server






CLAIMS Sql Add Join


Move a Single-Table or an Entire Database Across Systems

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.

Database Movement

Execute

Table Movement Options Log

System DatabaseTeradata V15 SQL_Class

Source Tables

SQL_ClassTables

AddressesClaimsCourse_TableCustomer_TableEmployee_TableOrder_TableProvidersSales_Table

X

System DatabaseOracle Cloud SQL_Sandbox

Target Tables

SQL_SandboxTables

Addresses OKClaims OKCourse_Table OKCustomer_TableEmployee_TableOrder_TableProvidersSales_Table

Nexus Moves Data Across Platforms Without a Landing Zone

Whenever Nexus converts and moves data from one system to another the data never lands in a landing zone. When Nexus performs cross-system joins between systems, only the columns and rows needed to satisfy the query are moved, and the data moves directly from server to server. Whether you install Nexus on your desktop, laptop, Citrix server or access Nexus via a remote desktop on the cloud, there is no data passing through the Nexus. All data movement, conversions and cross-system joins are done directly between the big systems. And Nexus moves data in a wide variety of ways depending on the size!

Teradata

Oracle

SQL Server

Redshift

Hadoop

The Garden of Analysis Allows Your PC to act like a Database

Nexus can query all systems in your enterprise and each answer set is automatically placed 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. 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. All you have to do is press on a table and drag columns in the answer set to the templates and you immediately see the new reports.

Result 1

Product_ID Sale_Date Daily_Sales

Result 2 Result 3 Result 4

300010003000100030001000

09/28/200009/28/200009/29/200009/29/200009/30/200009/30/2000

61301.7748850.4034509.1354500.2243868.8636000.07

Welcome Aggregate OLAP Rank Grouping Sets Quantiles Top Sort Join Charts/Graphs Dynamic Charts Dashboard

A Garden of Analysis Example - Grouping Sets

We instantly received three more answer sets (in yellow and pink) for Grouping Sets, Group by Cube and Group by Rollup. What is truly intelligent is that we re-queried Result 4 to get the three new reports and did so inside Nexus. The data warehouse was not re-queried, but instead the Nexus used the processor and memory inside the PC to calculate the analytics. All answer sets are saved to the Garden of Analysis so users can get additional reports by merely clicking on the appropriate tab and selecting the columns they want in the varying templates. Why not have your own data warehouse inside Nexus?

Result 1

Product_ID MTH YR Sum_Daily_Sales

Result 2 Result 3 Result 4

300020001000 ? ? ?

???

109?

224587.82306611.81331204.72443634.99418769.36862404.35

Grouping sets Cube Rollup

?????

2000

Aggregate OLAP Rank Grouping Sets Quantiles Top Sort Join Charts/Graphs Dynamic Charts Dashboard

3 new reportswere

createdwith the PC

doing all the work

This report depictsthe actual results

of the Grouping Sets

Nexus Instantly Graphs and Charts Your Answer Sets

Welcome Aggregate OLAP Rank Grouping Sets Quantiles Top Sort Join Charts/Graphs Dynamic Charts Dashboard

Slideshow

Scroll

Thumbnails

Compare

Send Selected Graphs to Garden TabsCompare Selected Graphs Delete Selected Graphs

Take any answer set in the Garden of Analysis and get over 35 different graphs in seconds. Then see your graphs in thumbnails (above), slide show presentations, scroll them across your screen or compare two different charts.

Compress Your Teradata Systems by 35%

Just right click on any Teradata database and choose "Hound Dog Compression". Pick the tables you want to compress 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 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.

Hound dog Compress - Database

Execute

Table Compression Log

System DatabaseTeradata V15 SQL_Class

Available Tables

SQL_ClassTables

AddressesClaimsCourse_TableCustomer_TableEmployee_TableOrder_TableProvidersSales_Table

X

Target Tables

SQL_SandboxTables

Addresses Done Claims Done Course_Table Done Customer_Table Done Employee_TableOrder_TableProvidersSales_Table

Dashboard When the job is finished the dashboard shows the

table sizes before and after

Nexus is so Easy-to-Use

The important buttons and function keys you need to know about are listed above.

Nexus Chameleon

SystemsTeradata

File Edit View Query Tools Help Web Windows History Sandbox

System: Database: SQL ClassTeradata

EXECUTE

New Query ?

+Query 1

System your connected to

Your currentdatabase

Runs a Query,

or press F5

ClearsTheSQL

from your

screen

Providesthe

EXPLAIN Plan,or hit

F6

OpensUp

anotherQuery

Windowfor any

systemyou

have in your systems

tree

Click onthe plus signand see all

the databasesand objects

for this particular

systemHit F2 to see SQL Syntax

You query history

the nexus chameleon: your secret to mastering all data

Data & Analytics