Create custom programs

For details on creating a custom program, see this video:

If a transformation or validation check is too complex to create in the user interface, you can use a custom program instead, for example:

• To perform data aggregation, case statements, or complex calculations.

• To call an API to set a flag on records that meet specified criteria see Sample PLSQL program that calls an API to set a flag.

• To use 1-to-many or many-to-many column mappings.

The custom program code must do everything the system does automatically in noncustom transformations and validation checks, including mapping source and target table columns and enabling data lineage tracing when possible; see Enable data lineage tracing in a custom program.

You must define a program in Oracle Life Sciences Data Hub (Oracle LSH). You can write a PL/SQL or SAS program and upload it to the Oracle LSH program. You can reuse custom programs.

Note:

• To create and use a SAS program, you must purchase SAS separately and integrate it with Oracle LSH. See the Oracle Life Sciences Data Hub Installation Guide and the Oracle Life Sciences Data Hub System Administrator's Guide for instructions.
• Do not modify an Oracle DMW work area directly in Oracle LSH. Oracle DMW work areas are those that are in the DMW_Domain/project or other study grouping domain/studydomain/data model application area. In particular, do not add either tables or programs to these work areas in Oracle LSH. Create custom programs in the DMW_UTILS domain.

This section contains:

• Create a custom program for a transformation
  
• Create a custom program for a validation check
  
• Enable data lineage tracing in a custom program
  
• Sample programs that populate auxiliary columns with the source surrogate key
  
• Use APIs
  
• Sample PLSQL program that calls an API to set a flag