The Ides of March is best known as the date on which Julius Caesar was assassinated at the Theatre of Pompey by members of the Senate in 44 BC. The stabbing is famously dramatized in William Shakespeare’s play Julius Caesar, to which the soothsayer’s warning to Caesar was “Beware the ides of March.”
Just before the assassination, Caesar passed the seer and joked, “The Ides of March have come”, suggesting that there was no fulfillment of the prophecy, to which the seer replies, “Aye, Caesar; but not gone.”
I think that 2020 is the year that we make the Ides of March a good thing.
During March, I am going to allow you to migrate and move any amount of data to Snowflake for FREE. You can even move your data to and from any system you desire for FREE.
What do you have to lose? Depending on how much data you need to move, this could save you up to $500,000.00. With that potential savings, you might be muttering, “Behold the Ides of Nexus!”
I have no partnership with Snowflake, but I am one of their biggest fans. I believe that Snowflake is the next big thing in big data. You can create a Snowflake system (on the cloud only) in minutes. Snowflake separates storage and compute so you can save money. Snowflake only charges you for computing when you are running queries. You can scale up the compute from one node to hundreds of nodes in minutes to load data, or during critical times, and you can scale it back down to one node in seconds. What a concept!
I can save you money as well. If you decide to bring up a Snowflake system, I will allow you to migrate your data for Free during March 2020. What systems will you be able to move to Snowflake?
- SQL Server
- Amazon Redshift
- Azure SQL Data Warehouse
- SAP Hana
How difficult is the process of moving data between systems? You can set it up faster than two shakes of a lamb’s tail because all you have to do is point-click and move. Let me put it in Shakespearean terms, “Your data movement chariot awaits.”
Check out how easy it is with the screenshots below.
First of all, you have two choices. If the tables are smaller (i.e., < 500,000 rows), you can move the data via your Nexus Universal Desktop. However, if the tables are huge (i.e., Millions/Billions of rows), you can move the data through the NexusCore Server.
The first screenshot shows you how to begin the data movement through your Nexus Universal Desktop. Just right-click on any database from any system in your systems tree, and choose “Move data to…”.
The second option is to move data through the NexusCore Server. The screenshot below shows you how to initiate data movement through the NexusCore Server. You set up a NexusCore Server job via your Nexus Universal Desktop.
If you choose to move the data through your Nexus Universal Desktop or NexusCore Server, you will see the screen below. Choose the system you want to move from, which is your source system (on the left). Then, choose the system you want to move data to, which is your target system. In the example below, we have chosen Teradata as the source system, and Snowflake as the target system.
You feel free to choose any source or target in which you want to move data.
Take a look at the picture below. Place a checkmark on the source tables in which you want to move. Notice that I used the search bar to type “Claims or Table.” Only tables with the letters “Claims” or “Table” appear. I can then place a checkmark on all of them by placing a checkmark on the Tables checkbox, or I can individually select or deselect any checkmark.
Once you hit the blue arrow, the source tables with a checkmark move to the target tables. Based on which two systems you have chosen as your source and target, Nexus will choose from over 80 different load utility methods. Nexus uses the vendor’s load utilities to load the data as fast as the vendor does. You don’t have to set up or write any load utilities. My development team has spent the last ten years automating the process. Nexus writes the load utility scripts automatically.
Press SAVE, and you will have multiple options. You can schedule the job to run immediately, or schedule it to run at a particular time. Nexus allows you to schedule federated queries or load jobs once, daily, weekly, monthly, yearly, or custom.
Here is what you will see when the job finishes. Each table move will show SUCCESS or ERROR. IF you see a green checkmark, then all of the tables were successful. If you see a red checkmark, then one or more tables had an issue. You can then hit the MORE button to see the individual log for each table.
We have spent the last 20-years building all-in-one enterprise software for all database platforms. We start at the desktop with the Nexus, which has 1000 features that work on 1000 different database systems. The Nexus even has a Super Join Builder that builds the SQL automatically. You can even do federated queries, which are cross-system joins, and Nexus’ 10,000,000 lines of code handle everything seamlessly.
For larger federated queries, or for moving large amounts of data, the user can choose to have the NexusCore Server move the data for them, as them. The Nexus Universal Desktop passes to the server the user’s credentials. That is the future of big data.
In March, you can have five Nexus Universal Desktop licenses and one NexusCore Server license for FREE. My team will send you the documentation you need to set everything up yourself, or we will be happy to help you with the installation and training you want. It is so easy; you will be able to do it.
I promise you that this will be an easy process, and you will be amazed at how efficiently and fast the data moves.
CEO, Coffing Data Warehousing
Direct: 513 300-0341
YouTube channel: CoffingDW
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.