DVAASUSERAPIKEY stored procedure

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). 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')