From SQL To Ano

Overview

Different database service providers use different database dialects.

Therefore, to start writitng ANO Tasks and Rules, it is a necessary step to describe the database definition in the ANO Language, that is database agnostic.

The ANO Language

The ANO Language is a Domain Specific Language created for the purpose of anonymization. It uses its own ANO types.

Translating from SQL to ANO

• Use DBano to translate DDL statements in SQL to ANO

When this is done, you may freely write ANO Tasks and ANO Rules according to the ANO Language.

Writing code in ANO

Since ANO has its own syntax it is recommended to write ANO using Visual Studio Code, which is a free code editor available for Windows, Mac, and Linux:

• Install Visual Studio Code to read and write .ano files
• Install and use our ANO extension for Visual Studio Code
  • It provides error checking, syntax highlighting, syntax completion, hover information, and on-save formatting