Generating the configuration for the Data Virtualization Remote Agent

Generate the Configuration Hash and Instance ID that is used to deploy the Data Virtualization Remote Agent.

1. Navigate to the Run SQL page.
2. Enter the following SQL command and enter the value for each parameter listed in the following table.

   call dvsys.generateconfighash('<Agent name>','<Agent description>', <Data port>, <Management port>, 'peerAuthentication', null, -1, -1,'DV_EXTERNAL_NODE_HOSTNAME_PORT=<Exposed Cloud hostname:port>‘, ?, ?, ?);
   Copy to clipboardCopied to clipboard

   Table 1. Parameter, parameter descriptions, and default values used in generating the configuration for the Remote Agent.

   Parameter	Description	Default value
   Agent name	Enter the name of the Remote Agent. You can only use uppercase or lowercase letters, numbers, and the underscore symbol ( _ ).	Defaults to the hostname where the agent runs.
   Agent description	Enter an optional textual description of the Remote Agent. Do not include new lines or single quotation marks.	–
   Data port	Enter the Data communications port. See table in step 3.	6414
   Management port	Enter the Management port. See table in step 3.	7777
   Satellite connector endpoint address	Enter the endpoint address, which includes the host name and port for accessing the Remote Agent. If you use this parameter, you must specify it as: DV_EXTERNAL_NODE_HOSTNAME_PORT=Satellite connector endpoint address	–

3. Select Run All.
4. Expand the Results output and export it.
   In the Output values column, take a note of the Instance ID and Configuration hash.

   • Instance ID is listed in the first row.
   • Configuration Hash is listed in the second row.