Say goodbye to Teradata and Oracle forever.

Migrate Teradata to Snowflake

Move to the #1 rated cloud data platform.

FREE CODE ANALYSIS TOOL​

Save time and money.
Move to the cloud seamlessly with Mobilize.Net.

Mobilize.Net's automated migration tools and services move your Teradata scripts and stored procedures to the cloud for more bang with less buck. You can stop paying exorbitant fees and get into the 21st century with your data warehouse. 

Mobilize.Net's Teradata
to Snowflake migration tool

Convert all of your Teradata scripts with the automation products from Mobilize.Net. Our flagship tool has converted more than 190 million lines of tables, views, stored procedures, macros, and BTEQ scripts.

See the demo and learn more about how you can get an assessment for your migration workload by clicking the link below.

Teradata to Snowflake

Just over the past 6 months, this tool has been used to accelerate numerous migration projects to the tune of:

  • >193 million lines of code converted
  • >4.1 million objects converted (Tables, Views, Procedures, Macros, BTEQ [Teradata])
  • Average level of automation for initial workloads is 95.45%.
  • Median level of automation for initial workloads is 99.1%.

Target Conversion Architecture

Migrate from Teradata to Snowflake | Mobilize.Net

The migration experts at Mobilize.Net are here to transfer your Teradata SQL and proprietary scripts over to Snowflake. Specifically:

  1. Teradata SQL (*.sql) statements converted to Snowflake SQL
  2. Stored procedures (*.sql) converted to JavaScript
  3. BTEQ files (*.bteq) converted to Python
  4. Other supported extensions: Fastload (*.fl, *.fload) and Multiload(*.ml, *.mload)

The following diagram illustrates the conversion architecture:

Architecture Diagram Teradata to Snowflake

This is just an example of one complete translation from one source data warehouse to a target data warehouse. We are also close to releasing an Oracle to Snowflake automated product with a similar design to the Teradata tool you see described on this page. Who knows what our next source to target pair will be. Let us know if you have any requests at info@mobilize.net.

More than just SQL Translation

While SQL translation can pose challenges to your average migration company, it's really the stored procedures and scripts written in outdated scripting languages (such as BTEQ for Teradata) that get them stalled. Mobilize.Net automates the conversion of PL/SQL and BTEQ as efficiently as with DDL written in SQL. We do not create glorified Regex or find-and-replace tools. A complete understanding of each workload is created with a full symbol table and a comprehensive abstract syntax tree (AST).  

Here's a quick conversion example of a stored procedure written in Teradata:

-- Teradata Stored Procedure

REPLACE PROCEDURE MY_DATABASE.DYNAMIC_RESULT_SETS()
DYNAMIC RESULT SETS 2
BEGIN
DECLARE SQL_CMD_0, SQL CMD_1 VARCHAR(20000) DEFAULT ' ';
DECLARE RESULT_SET_0 CURSOR WITH RETURN ONLY FOR FIRST_STATEMENT_0;
DECLARE RESULT_SET_1 CURSOR WITH RETURN ONLY FOR FIRST_STATEMENT_1;

--- MAIN ---
SET SQL_CMD_0 = 'SEL * FROM MY_DATABASE.EMPLOYEE';
SET SQL_CMD_1 = 'SEL * FROM MY_DATABASE.EMPLOYEE_PHONE_INFO';

--- CURSORS ---
PREPARE FIRST_STATEMENT_0 FROM SQL_CMD_0;
OPEN RESULT_SET_0;

PREPARE FIRST_STATEMENT_1 FROM SQL_CMD_1;
OPEN RESULT_SET_1;
END;
 

And the output in Snowflake is done in embedded JavaScript inside of Snowflake's SQL:

-- Snowflake Stored Procedure as JavaScript

CREATE OR REPLACE PROCEDURE
MY_DATABASE.PUBLIC.DYNAMIC_RESULT_SETS()

 RETURNS STRING
LANGUAGE JAVASCRIPT
EXECUTE AS CALLER
AS
$$
var SQL_CMD_0 = ' ';
var SQL_CMD_1 = ' ';
var resultSetCounter = 0;
var tablelist = new Array;
var procname = 'PUBLIC.DYNAMIC_RESULT_SETS
var sql_command = 'select current session() || '_' || to_varchar(current_timestamp, 'yyymmddhh24missss')';
var stmt = snowflake.createStatement({
sqlText : sql_command
});
var res = stmt.execute();
res.next();
var sessionid = procname + res.getColumnValue(1);
//--- MAIN ---
SQL_CMD_0 = 'SELECT * FROM MY_DATABASE.PUBLIC.EMPLOYEE';
SQL_CMD_1 = 'SELECT * FROM MY_DATABASE.PUBLIC.EMPLOYEE_PHONE_INFO';
//--- CURSORS ---
var setname = SQL_CMD_0;
var tablename = sessionid + '_' + resultSetCounter++;
var sql_stmt = 'CREATE TEMPORARY TABLE ${tablename} AS ${setname}';
tablelist.push(tablename);
var RESULT_SET_1 = snowflake.createStatement({
sqlText : sql_stmt
}).execute();
return tablelist;

$$;

This is just one example of the how Mobilize.Net automates the "hard problems" of sProcs and proprietary script conversions in a database migration. You can learn more about how Mobilize.Net fits code conversions into a complete strategy for migrating legacy data warehouses to Snowflake by visiting our database migration services page.

Upgrade your data warehouse today.

Migrate to the Cloud

Performance
goes up

SnowConvert_ToTheCloud_Graphic
Time to Mobilize
Modernization Solutions

Maintenance and cost go down

Time to Mobilize

“NTCNA Chassis Dynamics chose Mobilize.Net VBUC because the automated migration technology greatly sped up our move off VB6.”

- Aaron Bickel, Senior Manager, Nissan NA

“Mobilize.Net has a strong track record of building products that successfully automate challenging source code migrations, and this [product] will empower our customers to get up and running on Snowflake sooner.”

- Chris Degnan, CRO at Snowflake

“Mobilize tools create readable, maintainable, quality code,” said. “Mobilize uses familiar architecture and patterns which made it easy to immediately step into the code.”

- Matt Gropel, Director of Technology at AgWorks Software

“I am very pleased with the tool and your responsiveness. I have had at least 3 other aborted efforts to convert and hundreds of man-hours wasted. To get a clean compile after only 2 days is thrilling. I suspect that with about a week of effort, I can have a working .NET equivalent app.”

- Scott Lee, President, Superior Labels

We ran a proof of concept comparing the Visual Basic Upgrade Companion (VBUC) with other VB6 migration tools and we definitely preferred the way VBUC handled the conversion.

- James Lewis Stevenson II – Software Design Engineer, GT Software

Talk To An Engineer

Trusted by 80% of the Global 2000

logo-IRS
microsoft
nissan
CFM-materials
logo-AgWorks