Skip to content

Database objects

What is it for

In CCH TagetikDatabase Objects are used to:

  • Create non-standard database objects on the application database to implement particular customer requirements, such as:
  • custom views to perform import via ETL;
  • stored procedures and functions to implement specific data processes that cannot be accomplished otherwise;
  • customised queries to carry out, via Tagetik's query analyzer functionalities, direct queries on the database or for the creation of staging tables to be used in a stored procedure or for the creation of queries to be used as 'form queries';
  • Display the archive of all non-standard objects that can be transferred from one database to another, together with the rest of the parameterisation, when importing/exporting the database.

Operations performed on Database Objects are always recorded within the audit trail.

IMPORTANT: Since these functions can operate directly on the database, they are not available to all users by default. Only users with the 'Entity data processing: calculation logics etc.' module enabled in their role can display them

Deploy

Actions () > Deploy

Necessary to physically create a non-standard database object on the database. It is only visible if the body of the database object has been defined for the database type linked to the application. This operation creates the database object; if an object with the same name already exists, it is first deleted and then recreated.

If errors occur during deployment:

  • When using an MSSQL, PostgreSQL, or SAP HANA® database, the system detects errors and reports them to the user;
  • In the case of an ORACLE database, the system cannot detect them, so they are only reported to the user at the time the object is used.

IMPORTANT: Database objects of Query type can only be deployed. In this case, the system executes the query statements.

IMPORTANT: Database objects of Query type containing Select statements are not executed by the system. Failure to execute Select queries is tracked in the audit .

Execution

Utility > Run

If a database object of procedure or function type has already been deployed, Tagetik allows you to run it directly from the application.

In order for a procedure or function to be run directly from the application, it must have a name written in capital letters beginning with CPM_SP_. For the requirements that such an object must meet in order to be considered a Tagetik data processing and thus be executed directly by the application, see Stored procedure