Prerequisite
- Establish a connection to a target VantageCloud Lake system with your credentials and an authentication token. You typically receive this information from your system administrator.
- The DBA needs to grant users the necessary privileges to create UDFs in VantageCloud Lake.
- GRANT CREATE FUNCTION, DROP FUNCTION ON database_name TO username;
- GRANT LOGON ON ALL TO username WITH NULL PASSWORD;
- The routine tdextroutine must be installed on your local system. See Installing the External Routine Installation Tool.
- XRMigrationTool installed on your local system. See Installing the External Routine Migration Tool.
- Create the UDF config.yml file and put the file in the input directory. See UDF Config File.
- Place the SQL script containing the CREATE/REPLACE FUNCTION statements for creating the UDFs in the input directory. For example, a .bteq file.
- Back up the input directory. Running XRMigrationTool modifies the SQL script you placed in the input directory.
- Place your UDF source files in the source directory.
- Run XRMigrationTool:
XRMigrationTool -d input_directory -o output_directory -s UDF_source_directory
XRMigrationTool creates a directory named SQLToPayload in the output directory and places the generated UDF manifest files there. - After XRMigrationTool completes converting the SQL script, run the updated SQL script to create the UDFs in VantageCloud Lake.For details about all the options of XRMigrationTool, see External Routine Migration Tool. For an example of using XRMigrationTool, see Example: Migrating Existing UDF SQL Scripts to VantageCloud Lake.