/
Running custom SQL scripts on Engrafo Database

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