This tool is based on Database Access but with more features.

What's included:

- App List > It's now possible to register apps or add from the assets list;

- This allows the system to automatically map entities to their respective apps. Manual mapping is also possible.

Note: The Key must correspond to the app ID, which can be seen in the URL on the ODC Portal when accessing the app details.

-Table/Entity Status > It's possible to manage the status of tables and entities so that exports only return information with values.

- Metamodel Export > It's now possible to export an Excel file with the app's data model information. The export includes only active tables/entities and attributes;

- Synchronization of tables/entities and attributes > It's now possible to synchronize (snapshot style) the data model information to ensure that everything added, changed, or removed is reflected in the interface. Entities and attributes that have been "deleted" are marked as "(Deleted)" and become inactive.

- Sample Export > It's possible to export a sample CSV of a table/entity with 50 records (includes only active columns);

- Shared Services > It's is possible to consume shared service actions that allow obtaining the metamodel, table info (size and number of rows) and table data in JSON and CSV.

What is needed to make it work (Assets List)?
Setup a new API Client "Database Info" in the ODC Portal > API Clients [Permission: Asset management > open]

Copy the client id and client secret to the Database info settings in the ODC Portal > Database Info > Configurations > Settings;

Adjust the url of consumed rest endpoints in the ODC Portal > Database Info > Configurations > Consumed REST APIs;

Note: If you encounter 401 unauthorized errors while retrieving the token, enable the "EncodeSecret" setting or generate a new client secret. Some characters, such as +, may undergo transformations.

What is needed to make it work (Query Screen)?

The JS files have been moved to the app's resources but still depend on directives such as:

font-src: fonts.googleapis.com

script-src: 'unsafe-inline'

style-src: 'unsafe-inline'