The largest companies in their industry don’t write SQL because the SQL is automatically written for them. Everyone merely points and clicks from a menu to see what tables join, and then they choose the columns they want on the report. The average query is a five-table join, ready to run in seconds. Once the query is built, it can be scheduled or instantly run repeatedly.

Even more amazing is that everyone can join tables across systems, referred to as federated queries, just as easily. Point, click, and select the columns you want on the report, and everything under the covers is built automatically to join tables, views, Excel spreadsheets, Microsoft Access tables, and external tables from any system.

Because I was one of the first Teradata teachers to travel the globe and train the largest companies in the world, we catered to the biggest and most successful companies in their industry. We built the Nexus for their complicated environment, which meant thousands of users accessing hundreds of databases, with users ranging from data scientists to non-technical business users needing to access any data at any time, anywhere.

Large companies realize that if users must figure out what joins to what and write the SQL by hand, they waste tens of thousands of hours yearly.

And who doesn’t need to move data to a sandbox or another system? So we made sure everyone can point, click, and migrate a single table or thousands with a push of a button?

If you want to see the secrets the world’s largest corporations have had for the past 20 years, check out the video of the Nexus Super Join Builder in action.

Thank you,

Tera-Tom

Tom Coffing
CEO, Coffing Data Warehousing
Phone: 513 300-0341
Email: Tom.Coffing@CoffingDW.com
Website: CoffingDW.com and NexusDataServer.com

Posted in Blog