We sell a Commercial Parser for the Teradata SQL language
A ready-to-go solution!

Why buy a commercial parser? In some cases, open-source parsers are available, so why consider buying a commercial parser?

Depending on your situation, you may need a parser that has been thoroughly tested and documented and has someone to call in case you encounter any problems.
We create and distribute a commercial off-the-shelf Teradata SQL parser.
You may want to buy a commercial parser to have a parser ready for the integration, without any technical complexity and easy to integrate. A ready-to-go Teradata SQL parser. 

Three reasons to buy:

Strumenta Playground

Strumenta Playground” allows you to try the parser and discover all its features before you decide to buy it. Just register with your email and try it.

Yearly License

We provide a commercial license, which gives you access to the full documentation. You can choose a Standard, Distribution, or Service License, and our support is included with it.

Easy integration and Guarantee

We cover all technical aspects. Your license includes our support and access to professional documentation. Once bought, we offer a one-year guarantee that you can extend at your convenience.

Teradata SQL is a language that has been used extensively for decades.
Nowadays, billions of lines composing extremely valuable software are defined in Teradata.

You may want to perform several operations on your Teradata SQL code, which our Teradata SQL parser might help you with. Let’s discover them:

  • Database Migration and SQL Dialect Conversions: Sometimes, teams migrate from Oracle PL/SQL to other SQL dialects (e.g., PostgreSQL procedural language PL/pgSQL). A robust parser can assist in partial or full automation of such migrations.
    Even within Oracle, specific features can evolve between releases; a parser helps detect outdated syntax and automate the transition.

  • Automated Documentation Generation with a PL/SQL Parser: the parser can be leveraged to analyze code and extract metadata for automated documentation generation. This includes:

    1. Listing all procedures along with their parameters.
    2. Generating diagrams, such as Entity-Relationship Diagrams, to visualize the database structure and dependencies.

    This automated information extraction is valuable in several scenarios:

    1. Documenting an existing system to improve maintainability.
    2. Supporting refactoring efforts, providing a clear structure of the codebase.
    3. Preparing for migration, allowing teams to gain a better understanding of the system before transitioning to a new platform.

  • Refactoring and Modernization: As PL/SQL codebases grow, they can become unwieldy. A parser can enable automated or semi-automated refactoring (renaming variables or procedures, extracting subroutines, reorganizing packages).
    This saves developers from manual, error-prone tasks and helps in migrating older PL/SQL code to more modern patterns.

    It can even be used to support a migration to a very different language such as Java. For such advanced usage, we are available to support you through consulting services

  • Automated Code Analysis and Quality Assurance: PL/SQL is often used extensively in business-critical applications. A parser can help you analyze source code to ensure coding standards are met and detect potential performance issues or best-practice violations.
    Examples: checking for unreachable code in procedures, ensuring consistent variable naming conventions, or verifying performance hints.

  • Code Generation and Reverse Engineering: Tools that generate diagrams or documentation often rely on parsing the underlying PL/SQL code. This is particularly useful in large organizations for compliance and auditing.
    A parser helps build or regenerate entity-relationship models or procedural flow diagrams from existing PL/SQL code.

  • Integrated Development Tools: IDE plugins or specialized applications can leverage a PL/SQL parser to provide better auto-completion, syntax highlighting, and real-time error detection.
    A parser that fully supports the PL/SQL grammar ensures these tools offer reliable language-aware features.

  • Testing and Continuous Integration: Automated testing frameworks that include static checks rely on parsers to validate code against company or team rules before deployment.
    A PL/SQL parser is fundamental for hooking into CI/CD pipelines to run static analysis or code coverage metrics.

How to use a parser to build these applications?

We offer the parser in two different formats, allowing you to choose the best approach for your needs:

Service: Access the parser via a cloud-based API.

Library: Integrate it directly into your applications using Java, Python, C#, JavaScript, or Kotlin. This would work without any connection to our API, if not for validating a key (i.e., no code would be shared with our servers).

Once you acquire the parser, we will provide comprehensive documentation to facilitate onboarding.
An introductory meeting will be held to guide you through the setup and integration.

For those needing additional expertise, we also offer advanced training, coaching, and support to help implement more sophisticated language engineering solutions.


How can I learn more?
Do you have questions?

You can schedule a quick meeting with our experts!

We suggest you fill out the linked questionnaire; this will allow us to better understand your use case and arrive well-prepared.

What does it matter in a parser?

We have built tens of parsers for our clients, written books and created video courses, written hundreds of articles, and given presentations on multiple continents. We have learned some important things in a parser to support what our clients want to build with them.

Our parsers provide an Abstract Syntax Tree (AST), not a Parse Tree. This may sound like some academic term just thrown out to appear smart. It is not. The difference is that the output of our parsers is more high-level and easier to work with, and we think this could be relevant to you as well.

We provide AST libraries to process the output of our parsers. They permit you to work with the tree more easily to accomplish your goals. We know that as we have built interpreters, editors, compilers, transpilers, and other tools using those libraries, we built them as tools we needed to use in our work.

Error recovery: our parsers can deal with errors in code and recover them to build an AST. This is important for applications that need to process also incorrect code. This is always the case for editors, for example, as the user is constantly writing code, and until they are finished, the code is typically incorrect.


How can I learn more?
Do you have questions?

You can schedule a quick meeting with our experts!

We suggest you fill out the linked questionnaire; this will allow us to better understand your use case and arrive well-prepared.

Technical specifications, legal & license details

The PL/SQL parser extracts structured models from code, producing an Abstract Syntax Tree (AST). The Code Generation module, available as an optional extension, performs the reverse operation: It converts an AST back into PL/SQL code, allowing structured modifications and generation of new code.

This module is useful in several cases:

1. Generating new PL/SQL code from scratch.
2. Modifying existing PL/SQL code, making it particularly useful for automated refactoring.

By combining the parser and the Code Generation module, you can:

1. Analyze PL/SQL code to detect specific patterns or function calls that are obsolete or incorrect.
2. Modify the AST to introduce structured changes.
3. Regenerate the updated PL/SQL code, ensuring correctness and consistency.

This approach enables automated refactoring, enforcing coding policies, or even generating entirely new PL/SQL files based on predefined AST structures.

We provide a commercial license. You will get access to documentation about the AST and best practices for using the parser. You can choose a Standard, a Distribution, or a Service License. You will also get our support included with it.

Discover the Teradata SQL Parser documentation!

You can find the documentation for our Teradata SQL Ready-to-Go parser.

Strumenta Playground

Strumenta Playground is where you can evaluate the parser we build online. You can choose among several open-source examples source files and look at the output of the parser for that file – an AST (Abstract Syntax Tree) representing the logical structure of the input file (and not just the grammatical decomposition of the source into keywords, identifiers, punctuation, and other elements).


How can I learn more?
Do you have questions?

You can schedule a quick meeting with our experts!

We suggest you fill out the linked questionnaire; this will allow us to better understand your use case and arrive well-prepared.

Frequently Asked Questions

If I need more information?

When you book a meeting, we will provide several resources regarding our methodology, articles, webinars, and tutorials. If you want to learn more, don’t hesitate to book a meeting with our experts.

Anything else you could help me with?

We are specialists in Language Engineering and can offer all these supporting services to ensure you reach your goals. Typically, our clients buy a transpiler to use as part of larger systems. Sometimes, they have all the internal skills they need to integrate. Still, they often ask us for training courses, support with the architectural design, or the implementation of the entire system for them.

Where can I find references and testimonials of other clients?

You can have a look at our session “Testimonials” to read some customer’s experiences and opinions. You can also find some interviews in the section “Articles“: Interview with Rob Wunderlich or Interview with Campbell Pride.