home > products > nexus > Nexus by Tera-Tom

login

TERA TOM'S TOP TEN NEXUS FEATURES

“No other tool queries every database, but even more amazing are the add-ons that allow you to manage all your different systems.”

Tom Coffing
CEO Coffing Data Warehousing

Select icon to view feature details

1 Query Teradata, Oracle, DB2, UDB, Netezza, DATAllegro, Greenplum, SQL Server, and any generic ODBC system at the same time!
2 With "Edit Data in Place" users can Update, Insert, or Delete tables without writing a line of SQL.
3 The SmartCompress Add-On will compress up to 30% of your warehouse!
4 Nexus provides a load utility wizard that builds your BTEQ, FASTLOAD, MULTILOAD, and TPump load scripts in seconds automatically.
5 SmartReplica allows you to create systems and move data between them.
6 Batch Schedule Queries, Replications, Compressions, Comparisons, and Scripts to run at your convenience.
7 Compare and move objects between systems.
8 Nexus performs smart DBA functions like creating tables and objects with the click of a button.
9 Manipulate an answer set after the query has returned.
For example, simply click and drag column headers to group results by desired columns
10 Nexus Query Templates allow a user to build queries with almost no typing!