Skip to main content

User Functions

User Functions Overview​

User Functions in DPL Studio allow you to extend the transformation function library by creating custom functions. These functions are defined and stored within a DPL Package and can be authored, tested, and executed directly inside the DPL environment.

Purpose of User Functions​

User Functions are used to:

a. Create custom transformation logic b. Extend existing transformation capabilities c. Reuse custom business logic across queries and transformations d. Simplify complex data processing operations

Supported Parameter Types​

User Functions can accept and return three general types of parameters:

  1. Scalar Types: Scalar values are standard value types such as:

    a. int b. double c. string d. Other primitive data types

These values are used directly within the function.

  1. IVector: IVector is an interface used for vector-based data operations.
  2. IDataCachedTable: IDataCachedTable is an interface used for working with cached table data within DPL.

Namespace Requirement​

Both IVector and IDataCachedTable interfaces are defined in the following namespace: DPL.Connectors.ConnectorInterfaces

If your User Function uses these interfaces, include the namespace in your code: using DPL.Connectors.ConnectorInterfaces;