2. Manage an Application

2.1. Add an application

Use API_REDADM.ADD_APPLICATION to create a new application. Besides an optional description the parameter p_use_deps may come in handy if the application matches a complete schema (like an application mart) and p_app_name is identical with the schema name. In this case all objects depending on the views in the application schema are implicitly registered as application components - no additional discover rule needed.

Example: create the application ‘test_app’

EXECUTE SCRIPT API_REDADM.ADD_APPLICATION(
     'test_app'                     -- p_app_name
     ,'this is a test application'  -- p_description
     ,false                         -- p_use_deps
);

After successful creation of a new application, it can be found in the table RED_APPLICATIONS.

APP_NAME	DESCRIPTION	USE_DEPS
test_app	this is a test application	false

2.2. Modify an Application

For modification use API_REDADM.MODIFY_APPLICATION. Providing NULL leaves the parameters as is, while a blank (’ ‘) restores the default value.

Example: modify the description

EXECUTE SCRIPT API_REDADM.MODIFY_APPLICATION(
     'test_app'                    -- p_app_name
     ,'changing the description'   -- p_description
     ,null                         -- p_use_deps
);

After the command above has been issued, the entry in the table RED_APPLICATIONS will have changed as follows:

APP_NAME	DESCRIPTION	USE_DEPS
test_app	changing the description	false

Remove an application

To remove an application use API_REDADM.REMOVE_APPLICATION.

Example

EXECUTE SCRIPT API_REDADM.REMOVE_APPLICATION (
     'test_app'   -- p_app_name 
);

After the example above has been issued, the entry for the application with the name ‘test_app’ will be removed from the table RED_APPLICATIONS.