DVAASUSERAPIKEY stored procedure

Last updated: Mar 17, 2025
DVAASUSERAPIKEY stored procedure in Data Virtualization

Add the API key onto the Data Virtualization catalog table so that it can be used when personal credentials is enabled. This stored procedure is a prerequisite step needed for you to access a datasource that is enabled with personal credentials using your own API key.

Input parameters

USER_API_KEY
The type of this required parameter is VARCHAR(32672). The User API key generated from the IAM access.

Syntax

Use the following syntax and replace the parameter for this stored procedure:
CALL DVSYS.SETDVAASUSERAPIKEY('<USER_API_KEY>')

Example

CALL DVSYS.SETDVAASUSERAPIKEY('0f0c50b5767b4b5ab4c3456dd8190d82')