In good times and in bad, it is essential to save money. So many companies are using dozens of different tools to access data, and the penalty is millions of dollars per year. And the truth of the matter is most of these tools don’t share reports or queries with others. It is every man and woman for themselves.
It may sound too good to be true, but you can give everyone a much better toolset, and allow everyone to be on the same team. You also need your people to access data both on-premises or in the cloud. And unfortunately, in today’s climate, you need a tool where everyone can perform all of their duties from home, but execute the work from an internal Server.
Is it impossible to find a tool that can migrate and move data between systems automatically? Can this tool satisfy everyone, including the DBA and ETL teams, the IT staff, as well as the business users? Our Nexus product line has a design for everyone, but the most ingenious part of the product is the Nexus Server. Here are the two most prominent theories:
- The Nexus Pro Desktop allows each user to do everything imaginable, from their PC or laptop, and it is easy because we automate everything.
- Users can execute anything from their desktop or laptop, or they can choose to run it from any Nexus Server, located on-premises or on any cloud.
The entire future of software will automate difficult tasks to give every user the ability to do anything imaginable with a few clicks of the mouse. The future is brighter when the user can run everything from their PC or laptop for smaller amounts of data, or run them from a high-powered server on big data jobs.
There were two intricate pieces in building the Nexus product line. The first took 15 years and millions of lines of code to create a desktop tool that everyone loves. It took another three years to build a high-powered Server that recognizes the user and runs the job for the user.
I have two Proof of Concepts (POC) going on right now with significant customers. One is with a major insurance company that provisioned a Nexus Server on the cloud, and the other is an international provider of semiconductors that have set up a Nexus Server on-premises.
Both are using our Nexus Server in conjunction with the Nexus Pro desktop. The international semiconductor company is scheduling complex Teradata queries on the Nexus Server, but automatically saving the results as a table on MySQL for large resultsets. On resultsets less than 100,000 rows, they are querying Teradata from their desktop, receiving a resultset, and then dragging the result tab to their Nexus MySQL tree, where Nexus is automatically creating a table on MySQL with the data loaded.
Their business users are then able to query the MySQL table, receive a result set, and then perform business user functions. They can pivot the data, or use the Nexus spreadsheet with advanced formulas. They can graph and chart the data and place it on a dashboard. They can share their results across the enterprise with teammates. And they can even build analytic reports through easy to use templates where all calculations come from inside their desktop.
The insurance company is using the Nexus Server to migrate data from Teradata, Netezza, and Oracle to Amazon Redshift and Snowflake. They are also moving data from their Teradata production system to their development system. They are testing so they can consolidate their ETL tools with the Nexus product line.
And here is the most fantastic part. A developer using Nexus can write SQL and execute it on every database in their enterprise simultaneously. Still, Nexus has a Super Join Builder that shows tables and views graphically, and Nexus builds the SQL automatically. Users can edit or share these queries, where anyone can run or schedule them in the future from a menu.
And even better, the Super Join Builder joins tables across all platforms, including Excel. Did you ever imagine you would one day in a single query join a table from Teradata, Oracle, SQL Server, DB2, Greenplum, Hadoop, Redshift, Azure, MySQL, Postgres, Snowflake, Excel, and Yellowbrick? And then have the choice to execute it from either your PC or on the Server?
Why don’t you run a Proof of Concept (POC) this week with Nexus? Once you provision a Windows Server or Linux Server with a Windows VM, it will only take 30-minutes before you are moving data, querying data, performing federated queries, or allowing the business users to be in data heaven.
Save millions, and upgrade everyone’s tools with a single product line with a design that allows users to work from anywhere.
My contact information is below. I look forward to working together.
CEO, Coffing Data Warehousing
Direct: 513 300-0341
Tom Coffing, better known as Tera-Tom, is the founder of Coffing Data Warehousing where he has been CEO for the past 25 years. Tom has written over 75 books on all aspects of Teradata, Netezza, Yellowbrick, Snowflake, Redshift, Aurora, Vertica, SQL Server, and Greenplum. Tom has taught over 1,000 classes worldwide, and he is the designer of the Nexus Product Line.