Skip to Content (Press Enter)
Community › Forge › Assets list › Database Access
Login to follow
Database Access

Database Access (ODC)

Stable version 0.5.1 (Compatible with ODC)
Uploaded on 13 Feb (12 days ago) by CEES Online Tools B.V.
Database Access

Database Access (ODC)

Details
Detailed Description

On stages other than DEV it is often hard to troubleshoot or fix data inconsistencies because of the lack of database access in ODC.


This app offers a solution for this by enabling querying the database using the physical table names. No entities need to be made public for this app to function. Besides viewing and downloading data, data can also be updated or deleted when required.


Reads physical table names from the ODC database, and extracts their logical names and attributes


WARNING: Know what you are doing, you can break stuff on production with this, there is no roll-back. No warranties.



ODC Asset screenshot_0
Limitations

There are no roll-backs, commits are immediate.

Release notes 
  • Added sync of entity names and apps using ODC API, inspired by the Database Info App
  • Added disabling apps to skip entity synchronization and exclude from autocomplete
  • Added timer for periodic sync of all new and not disabled apps
  • When an entity already exists in a different app, the app-name is post-fixed _AppName to keep names unique
  • Added support to select cells by mouse or double click
  • Move query results to bottom of screen and using full width
  • Removed unused role(s) - app is now only protected by 1 role. Users with this role have full access.