Coffing Data Warehousing Software

Analytics: There is No ‘I’ In Team

Nexus Query Chameleon and NexusCore Servers Make Data Movement Easy

Tera-Tom here! My career started as a programmer, and I did that for 10 years. I then became a teacher of big data, and for the next 25 years I taught more than 1,000 classes and wrote more than 75 books on Teradata, Aster Data, Hadoop, Oracle, SQL Server, DB2, Greenplum, Netezza, Azure SQL Data Warehouse, Amazon Redshift, Matrix, Kognitio, and Python.

But then I took on my biggest challenge and spent 20 years on a quest to build the best software the computer industry has ever seen.  

That software is called the Nexus Query Chameleon, and it is used on the desktop for advanced querying capabilities. We have combined this with NexusCore Server software to manage data movement between all vendor platforms.

What’s your data movement style?

There is no ‘I’ in Team, but there is no sense in not placing everyone in an enterprise on the same team.

Many companies use a team strategy as a business model. For example, one large financial company teams up an IT person with a business user and that team is assigned to specific accounts. The IT person is there to support the business analyst by querying data and building analytics and the business user uses that information to make business decisions that penetrate the account and make money for the company.  

Some vendors create servers designed to move this data between systems or create query tools where developers write SQL. Some vendors create tools for Python users or tools that will build the SQL for the user. Other vendors create tools that take answer sets from systems so users can easily manipulate the data and enhance analytics. And finally, some vendors create tools so business users can use point-and-click menus to easily get information.  

Only the combination of the Nexus Query Chameleon at the desktop and the NexusCore Server will do it all!      

When you give your IT personnel and your business users a Nexus Query Chameleon on their desktop and laptop and then place multiple NexusCore Servers strategically inside your enterprise, you have succeeded in putting everyone on the same team.  

The benefits of getting everyone on the same page

So what does all this accomplish?

First of all, you have just put the most lethal and effective data tool in the hands of everyone’s desktop and laptop, while simultaneously placing the most advanced data movement and cross-system join server(s) between your many database platforms. You have also placed everyone on the same team and given them all the ability to use Excel, Tableau, the Super Join Builder, the Single-Table Mover, the Database Mover, the Garden of Analysis, and the BizStar.

Every user can now text and send information to one another through Nexus.  Every user can perform cross-system joins, which with Nexus is as easy to use as it gets. Any user can move data between systems into their own sandbox without any network saturation on the local PC or local network. And the complicated analytics needed are all done by simply using the Nexus point-and-click strategy.  

The concept behind Nexus and the NexusCore Server is that everyone can use the best tools and work exactly how they like. Even more importantly, it allows the business user community and the IT staff to completely work hand-and-hand as one cohesive team.

This strategy is effective for an infinite number of reasons. The biggest gain is that everyone can access data from anywhere in the enterprise that they have been given security to access. Everyone can perform cross-system joins or move data to and from systems without saturating the networks or the database platforms.    

The next biggest priority is that IT and business users can share answer sets, plus queries can be developed and saved in each user’s Nexus BizStar section so all users have to do is point-and-click on menus to get information. Now, IT can truly build an environment that makes the business user a business star (BizStar).

Putting NexusCore Servers to work

One of the most relieving priorities is that management and the DBA teams can control the data movement and the networks that users use to move data and perform cross-system joins. This is where the NexusCore Servers come in. These servers allow users to schedule long-running queries, move data between systems, and perform cross-system joins by impersonating the user’s credentials and running the jobs from the servers.  

With this strategy, companies no longer have to restrain the IT professional or the business user, and they no longer have to break their necks to move source data to the many target systems needed for each department. This opens up companies to use a lot more vendor platforms instead of trying to have a single data warehouse.

The NexusCore strategy also opens companies up to utilizing on-premises systems in conjunction with their cloud systems. This puts the power of data control in your management’s hands and takes away control from any single vendor. It’s now a buyers’ market, so big money is saved while simultaneously giving users more freedom and power than they have ever had before.

Want to learn more? Book a demo with Tom Coffing and find out how NexusCore Servers can help you move data easily and more efficiently.