CompilerWorks' Transpiler Solutions

Transpiling from one SQL dialect to another frees the enterprise from lock-in by database and data-warehouse vendors. CompilerWorks’ Transpiler Solution is designed from the ground up to facilitate SQL migration in the real world.

Our Transpiler produces pure output code for the target platform(s) of choice, with no ongoing dependencies on the CompilerWorks' products or technologies. This is designed to leave users in full control of their infrastructure with no additional risks to mission-critical systems and services, and with access to the full feature set and performance of the target platform(s).

When enterprises are contemplating a "lift and shift" project the transpiler turns estimating the project into a science. Rather than estimating the work required and discovering the reality during the project, the transpiler de-risks the estimates. It converts all the code provided in the first step. The transpiler will identify everything from code missed when defining the project, to functionality that cannot be emulated on the target platform.

SQL Languages and associated procedural languages supported include:

The transpiler is precise and accurate. It understands all the nuances of each SQL dialect. Unlike human conversion, the compiler does not make any assumptions. The compiler implements the exact semantics of each SQL dialect. It preserves these exact semantics when it converts the SQL code. Transpiled code from one dialect to another will produce the same results across both platforms.

The compiler is designed to be “fault tolerant.”

  • It does NOT need the actual execution environment the query executes in.
  • It does NOT fail when there is a missing relation definition or finds a construct it cannot convert.
  • If the compiler has an issue it will convert what it can and place explanatory errors in the code.

The errors will explain assumptions the compiler made and/or the construct it is having problems with. A mature CompilerWorks compiler will handle 99%+ of the conversion automatically.

Request Transpiler Paper

Migration to Cloud

Reduce risk and cost, and do it fast

The business pressure to migrate to the cloud continues to grow, while at the same time the business must continue to operate without a hiccup.

CompilerWorks mitigates the risk of migrating to the cloud. CompilerWorks will instantly convert the code for execution in the cloud and generate custom test queries that will test the data migration and compare the results of execution on both legacy and target platforms.

  • Recompile legacy on-premises code to target cloud vendors.
  • Complex rewrites of unsupported features.
  • Unparalleled accuracy and speed.

The result is that the migration project become predictable and reliable.

transpile/to_cloud.png

Migration between Vendors

Escape vendor-specific lock-in

The Transpiler breaks the shackles that database and data warehouse vendors have created to lock customers in to their products. CompilerWorks' Transpiler Solution overcomes the limitations of ANSI SQL compatibility and automates the move from one platform to another.

Additionally, many SQL deployments incorporate imperative code (PL) with the declarative SQL. The Transpiler is not limited to SQL - it also handles the associated procedural language.

transpile/btwn_vendors.png

Why is CompilerWorks different?

When CompilerWorks transpiles the input is code and the output is also just code. There is no footprint left behind, and no dependency on anything other than the source code.

Data Warehouse Modernization

The decision to switch to a modern datawarehouse is made for a host of reasons, not least of which are increased functionality and reduced cost.

CompilerWorks generates a clean, modern, standalone codebase in the target language. There are no ongoing dependencies on CompilerWorks' components or runtime libraries. Users are in the perfect position to take full advantage of the optimalities of the new platform and infrastructure.

transpile/modernize.gif

Platform Specific Optimization

Take advantage of modern features.

CompilerWorks' Transpiler will automatically re-write queries to take advantage of the new database platform's strengths. The transpiler implements the most efficient patterns for each target language.

The Transpiler has an advantage over the database itself: it has visibility beyond a single query. It can see the full lineage including all uses of the data. CompilerWorks Transpiler will optimize a series of queries if asked to. The result is faster (and cheaper) data processing.

If it makes sense to restructure the data model to take advantage of the new platform the Transpiler will do it. Simply apply a transformation (e.g. to de-normalize a table) and the Transpiler will re-write all the SQL to handle the new data model.

transpile/optimize.gif