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).
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.
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.
Why is CompilerWorks different?
The input is code and the output is also just 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 code base 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 power of the new platform and infrastructure.
Platform Specific Optimization
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.
Operational Efficiency Transformations
Transform code to increase operational efficiency
Code transformations can achieve many operational efficiency objectives. A few examples:
- Introduce (or remove) partitioning or normalization
- Changing the database layout (eg. from star to snowflake)
- Special use cases, eg. rewrite queries to –
- manage access to PII
- work with sampled data
Imagine “invisibly” rewriting analyst queries to work with sampled data during development. The result is an agile development cycle (cycle time reduced by orders of magnitude) with a positive impact on SLAs and operating costs.
The core technology is extensible, allowing customers to develop transformations to meet their own business objectives. With that said, CompilerWorks is continually adding valuable operational efficiency transformations driven by customer request.