The External Routine Installation Tool (tdextroutine) is used to create and manage C/C++ and Java user-defined functions and external stored procedures in VantageCloud Lake. For details on how to use tdextroutine, see:
User Authentication for Using the External Routine Installation Tool
DBC user cannot be used for creating UDFs and external stored procedures. Create a different user for this purpose.
To install the tdextroutine tool on your local system, see Install the External Routine Installation Tool.
To use this tool to create and manage your UDFs and external stored procedures, do the following:
- Before using tdextroutine, make sure you have a PAT generated and the private key saved. See Create a Personal Access Token to have a PAT created for your database user.
- To run a tdextroutine command, you must pass the PAT and the path of the private key used to generate it. These can be specified in the config YAML file for tdextroutine or set as environment variables.