Custom ETL functions

Unknown

There are a wealth of etl functions available in the ETL Function Reference, but I would like the ability to write additional custom functions which I can reference in layouts and dataflows. 

 

As as an example, I would like to define variations on the lending calculations (PMT, IPMT, FV, NPV) that use our custom business logic. 

 

To accomplish this, I would need and editor and debugging tools to validate and verify custom calculations. 

 

I understand and there will be limitations of the code acceptable to ensure all custom calculations are executable as set theory expressions. 

 

I also understand custom functions may be not allowed for performance and security reasons. If that’s the case, please let me know.