Running custom SQL scripts on Engrafo Database

It can be useful to extract data from the Engrafo Database that holds all the metadata in a very structed and relational database.

Some task that could be useful to do is:

  • Run a SQL Script that creates metadato of the differences between data catalogs and database registration

  • Run a SQL script that exports data catalogs to a webpage for integrated documentation in a HTML page

  • Run a SQL script that creates foundation for a PowerBI report showing documentation status

If you have a SQL task that should be accessible to run, it must be placed in a wwwroot\SQL

Â