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>‘, ?, ?, ?);

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

   Parameter	Description	Default value
   Agent name	Replace <Agent name> with 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	Replace <Agent description> with an optional textual description of the Remote Agent. Do not include new lines or single quotation marks.	–
   Data port	Replace <Data port> with the Data communications port. See table in step 3.	6414
   Management port	Replace <Management port> with the Management port. See table in step 3.	7777
   Satellite connector endpoint address	Replace <Exposed Cloud hostname:port> with 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.