Running Custom SQL-Scripts
- Elias Helgren Dahl
It can be useful to extract data from the Engrafo Database that holds all the metadata in a very structed and relational database. As a configurator you can easily do this using the feature Execute SQL Scripts.
Some task that could be useful are:
Run an SQL Script that creates metadata of the differences between data catalogs and database registration.
Run an SQL script that exports data catalogs to a webpage for integrated documentation in a HTML page.
Run an SQL script that creates foundation for a PowerBI report showing documentation status.
To do this, navigate to the section under the “System” menu item called “Execute SQL Scripts”.
From here, simply choose the file containing the script and click upload. You also have the option to schedule running the script in cron-format (e.g. 15 14 * * * - That being everyday at 2:15 pm).