In July 1799, Rosetta Stone, discovered during Napoleon Bonaparte’s campaign through Egypt, became one of the British Museum’s most famous objects. But what is it, and why is it important?
The Stone held a simple message that says that a temple’s priests in Memphis (in Egypt) supported the king. But the same message is written three times in three different languages:
- Ancient Greek
The importance of this to Egyptology is earth-shattering. When discovered, nobody knew how to read ancient Egyptian hieroglyphs. Because the inscriptions say the same thing in three different scripts, and scholars could still read Ancient Greek, the Rosetta Stone became a valuable key to deciphering hieroglyphs.
By the 4th century AD, hieroglyphs had gone out of use, the knowledge of how to read and write them disappeared. In the early years of the 19th century, scholars used the Greek inscription on this Stone as the key to deciphering them.
Rosetta Stone is now used to refer to the essential clue to a new field of knowledge.
What field of knowledge today requires more translation than the computer industry? Different database vendor platforms store tables in databases and schemas, but each vendor has a different table format and load utilities that move data on and off its platform.
It takes the best data scientists months to convert table structures between two different databases and even more time to write today’s computer hieroglyphs, which are load scripts that require significant expertise in each database’s language.
But in the year 2020, the Rosetta Stone of computing, which has the name of Nexus Server, was found with the same message written 15 times. The same table structures and load utilities for Yellowbrick, Snowflake, Redshift, Azure Synapse, Greenplum, Teradata, Oracle, SQL Server, SAP Hana, Postgres, Hadoop, Netezza, Athena, DB2, and MySQL.
Why is the Nexus Server necessary? Because it holds the knowledge to automatically convert each database into a common language, allowing anyone to move data between systems or join tables across different database platforms, which is the key to a hybrid-cloud strategy.
Where is the Nexus Server located? Any high-speed server loaded with a Windows VM can hold the Nexus Server software, no matter if it is on-premises or provisioned on the cloud.
What is the purpose of the Nexus Server? The objective is to manage the movement and conversions between all databases. Transformations happen in less than a second, and when the Nexus Server resides on a high-speed network, the movement of data is record-breaking.
Who does the Nexus Server serve? The Nexus Pro clients. Every company that wants users to access any data, at any time, anywhere can move data or join tables from different platforms with the Nexus Pro on their desktop or laptop. The Nexus Server executes the commands from the Nexus Pro clients to move or merge the data across the varying database platforms and then delivers the results to the Nexus Pro clients.
Why is that important today? Because users don’t always work inside the company firewall, and they need to access data across systems at high-speed. The user can now work anywhere because the Nexus Server does the user’s execution. The user appears to be sitting on the Nexus Server whenever moving or joining data across the database.
How do companies use the Nexus Server? Some use the Nexus Server to migrate their legacy databases to the cloud. Thousands of tables can move by merely using the Nexus Pro to choose your source system, database, and tables and then choose your target system, database, and schema. When you press “Schedule on Server,” the users’ credentials and the load scripts are sent to the Nexus Server, and the load utilities initiate.
Many companies use the Nexus Server to move single tables into the user’s sandbox, while many utilize the Nexus Super Join builder to join data across platforms. User’s point-and-click on the Nexus Pro system tree to join tables across any cloud or on-premises database, and the Nexus Server moves the data to a common platform where it performs the join.
Users need the Nexus Pro clients to query any database, move data between any database, join data across any number of database platforms, and do so through Nexus’s automation. Companies need the Nexus Server so each user’s requests can execute inside the company firewall at high-speeds.
Without the Rosetta Stone, the history of Egypt told through hieroglyphs would have been lost forever. Without the Nexus Server, databases can never talk between one another, and users could not join large data across database systems in seconds.
The easiest way to try the Nexus Pro and Nexus Server is to call or write and request a demo. We will then set you up a free Proof of Concept trial with the Nexus Server and Nexus Pro software.
I look forward to hearing from you soon.
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.