Coffing Data Warehousing Software

Ultimate Advantage: Cross-System Joins

Tera-Tom here!  What weapon was deemed so powerful by the experts of the day that it was thought to end all war because it gave such an advantage to whomever possessed it?  It was the crossbow!  What weapon of today is thought to be so powerful that it will give an unfair advantage to any company who uses it?  Forget the crossbow, think cross systems.  Companies of today are interested in enterprise desktop software that seamlessly joins tables from different systems together by simply aiming and pulling the trigger.


Cross systems joins are about the equivalent to landing a human on Mars.  Some say neither can be done, but I know that cross system joins will work.  I am putting together the last piece of the puzzle, and it will be one giant leap for man and womankind.


To make cross joins happen, software vendors are going to need to do 5 outrageously difficult things.  Number one, they need to be able to load the ERwin model or find another way to define the relationships between objects, and we do that.  They will need to present tables visually, so users can point and click on the columns they want on the report.  With each click, the SQL needs to be built automatically.  We do that.  They will need to be able to convert the table structures between systems, and that takes years to develop.  We do that.  They will need to make sure that their tool works with every database, and we do that.  Lastly, they will need to be able to move the data between systems, and we’re doing that right now.


The next release of Nexus will have a Teradata TPT Script Builder, and a SQL Server Bulk Copy Script Builder.  With a few clicks of the mouse, users can build complicated scripts that will move data at top speeds.  We are going to take it even further with what we call BOB ETL, where BOB stands for the Big Orange Button.  Press the Big Orange Button, and we’ll write the script, then we’ll move the data seamlessly for you.


The cross-systems joining capability also fits brilliantly into our Garden of Analysis strategy.  Once a user brings back a large amount of data, the Garden of Analysis allows them to run countless queries against the answer set without leaving the PC.  All queries on answer sets are calculated by the genius of Nexus.  Imagine if 50% of the world immediately started working from home, the traffic would drop so dramatically that there would be no congestion on the roads.  Now imagine that 50% of the queries were performed on the answer sets and not by re-querying the system.  It’d be like everybody in your enterprise is suddenly working from home.  It is the perfect environment for all enterprise users.  We think the Garden of Analysis will provide users twice the insight at half the costs.  How much will your company save if half the queries were done locally on the PC?


I’ve been chasing the impossible dream for 15 years, and its success is a foregone conclusion.  Imagine the ability to visually see a table on SQL Server and another on Teradata, and with the push of a button, the ability to join those tables together.  The brilliance is that the user sees none of the complexity, and yet, two incompatible systems can become one.  This is a journey that every major software vendor has set their sights on, but it’s so complicated few will pull it off.


Contact me or so that we can personally show you why Nexus is your competitive weapon.






Tom Coffing

CEO, Coffing Data Warehousing

Direct: 513 300-0341