Get your data to the cloud! That’s the cry of every article and expert around the globe since the cloud became… well, the cloud. But that transition is much easier said (or… written about) than done. Getting from the stability and perceived security of on-prem servers to the freedom, flexibility, and downright usefulness of the cloud can be daunting. Mobilize.Net and Snowflake are here to make it simple, easy, and seamless. Learn more about this partnership by reading the press release or visiting our blog.
Finally, one of the best reasons to get off a legacy platform is the use of their outdated, proprietary scripting languages. These may have been necessary when data warehouses started being more relevant. However, the world of data has changed, and those scripts are not only outdated, they are a burden on your ability to modernize. Fortunately, as with stored procedures, Mobilize.Net is uniquely experienced to handle scripts like these. For over 25 years, we’ve been taking outdated code and modernizing it for the cloud or for a new architecture. These scripting languages… they require the same kind of conversion. We can convert these proprietary scripts to Python, a common and universally understood language. A language that people are being taught today and will have skilled developers for years to come. It’s also a language that Snowflake can understand. In testing with Teradata BTEQ, TPT, TPUMP, FastLoad, and MultiLoad scripts, Mobilize.Net has again achieved a high success rate with a functionally equivalent output.
While stored procedures and scripts are generally the hard problems in database migrations, the majority of the code that exists is SQL; DDL and DML. SQL is SQL... except when it’s one data warehouse’s SQL compared with another platform’s SQL. Snowflake SQL is not immediately up-loadable into Teradata. Redshift SQL is not immediately up-loadable into Snowflake. While all of the data platforms use ANSI SQL, they do not all implement it the same way, and there are additions from each data warehouse to the ANSI SQL that are designed to make the queries more efficient. Those additions make immediately translatable SQL files between data warehouses completely impossible. Translation is required. Mobilize.Net automates that process with over a 98% success rate of the tens of millions of lines of customer code used for beta testing.
There are a lot of companies out there with big promises and big claims about moving your data from one platform to another. All of them will promise to do the job better than the others. All of them will promise complete, seamless migration. So why choose Mobilize.Net? Mobilize is promising the same things. The difference is simple: our experience, our resources, and our approach.
If you’re familiar with Mobilize.Net, you already know that no other organization has the history of success that Mobilize does. Operating for 25+ years doing application migration, we’ve worked with 80% of the Fortune 1000. In fact, if you add up most of our competitors' years of experience with the number of substantial clients, it may not even equal our experience. We’ve turned to database migrations, and we have the experience to truly understand what complete, seamless migration really means. Snowflake clearly seems to think so, which is why they've come to us for creating a tool capable of migrating large customers' workloads.
Mobilize.Net has a team of software engineers that specialize in automating code migrations. We’ve built tools, and worked directly with clients to ensure their code has 100% functional equivalence. All of our engineers are near-shore, no wait times or odd hours with a team of in-experienced engineers in India. Our headquarters are in the pacific time zone (Bellevue, WA), and our engineering center is in the central time zone (San Jose, Costa Rica).
Instead of trying to do glorified regex find and replace with SQL Statements, we look at the problem more holistically. We apply recursive transforms on an Abstract Syntax Tree (AST) node data structure. This is difficult to do when doing many-to-many SQL conversions, but our methodology focuses on specific one-to-one transformations. Applying a dataflow analysis to each SQL file or proprietary script allows us to understand the syntax, pattern match, and recreate functional equivalence automatically. We go after the hard stuff that others don't even bother to convert.
The choice should be clear. Make the transition to Snowflake, and allow Mobilize.Net’s experience and resources guide you through it… seamlessly and completely.