Executing Remote Functions on Oracle


Executing Remote Functions on Oracle


I have standard Oracle User Defined Functions (UDF) where we mask sensitive data in the test systems. I am trying to reuse the same for Teradata warehouse, like I want to have some callable function / script in Teradata where I want to send the sensitive data to Oracle for masking and I want to update that return value in Teradata. I am not sure if we have any solution that will complement in Teradata. I trying to avoid recreating those functions for each of the database and want to use them centralized. It will be easy from on-going maintenance etc.

Any thoughts and suggestions would be greatly appreciated.