DVAASUSERAPIKEY stored procedure
Last updated: Mar 17, 2025
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')
Was the topic helpful?
0/1000