Ability to Delete Database Integration Configurati
Comments
-
It seems that the feature I initially mentioned is present only in the 5.0 version of Decisions.
Here is how you would delete a database integration configuration.
First, you must delete all queries or tables set up for that particular database connection. That should be easy enough because queries and tables do have the delete option in their context menu.
Then run the following SQL queries, which can be done directly in SQL Management Studio:
select * from entity_folder where full_path like %System/Integrations/Databases/YourConnectionName%
select * from database_data where extension_id like (select extension_id from entity_folder where full_path like %System/Integrations/Databases/YourConnectionName%)delete from entity_folder where full_path like %System/Integrations/Databases/YourConnectionName%
delete from database_data where extension_id like (select extension_id from entity_folder where full_path like %System/Integrations/Databases/YourConnectionName%)%System/Integrations/Databases/YourConnectionName% is the full path as it appears in the Decisions navigation tree. So if I had an empty database that I wanted to get rid of called MY_EXTERNAL_DB, then the full path name is %System/Integrations/Databases/MY_EXTERNAL_DB%
You may need to do a browser refresh to see the effect in Decisions (i.e. See that the database is no longer in your database list)
I hope this helps.
Howdy, Stranger!
Categories
- 4.4K All Categories
- 84 General
- 13 Training
- 212 Installation / Setup
- 1.2K Flows
- 111 Rules
- 275 Administration
- 214 Portal
- 498 General Q & A
- 716 Forms
- 349 Reports
- 3 Designer Extensions
- 48 Example Flows
- 58 CSS Examples
- 1 Diagram Tile
- 8 Javascript Controls
- 188 Pages
- 5 Process Mining
- New Features
- 187 Datastructures
- 70 Repository
- 231 Integrations
- 30 Multi-Tenant
- 27 SDK
- 81 Modules
- 60 Settings
- 27 Active Directory
- 12 Version 7
- 36 Version 8
- 143 Lunch And Learn Questions