
/*
   @(#)HP OpenView OvWebdata Registration

   $Revision: /main/PULSAR/7 $
   $Date: 1998/09/08 21:45 UTC $


   This file defines the Data Provider Registration for the ovdwquery
   process, which extracts data from the Data Warehouse

   See the Description block for this provider for details on how to
   invoke it.
*/

DataProvider ovdwquery
{
  Version "NNM Release B.06.01  Apr 09 1999";

  // The command invoked is simply ovdwquery, which resides in $OV_BIN
  // This commands executes and SQL query to retrieve data from the
  // data warehouse.  The query text is sent as standard input to the
  // command, as defined by the stdin variable.
  Command "$OV_BIN\\ovdwquery -q -u $username -password $passwd $options";
  
  // The StdIn simply substitutes in the sqlQuery variable
  StdIn "$sqlQuery;;"

  // The server-side selection rule passes everything
  Select ".*";

  // The server-side projection rule doesn't need to do anything,
  // Because the data generated by ovdwquery is already tab-separated.
  Project "";
  FieldDelimiter "\t";

  Description {
        "This data provider is for accesing the NNM Data Warehouse",
        "on the server system.  It takes as a parameter an SQL",
        "statement which it executes using the Data Warehouse query",
        "tool, ovdwquery.",
        "The SQL to be executed is passed using the $sqlQuery",
        "variable, as in the following example (the entire URL should",
        "be one continuous line):",
        "",
        "  http://nnmserver.here.com/OvCgi/ovwebdata.exe?name=ovdwquery&",
        "     var_sqlQuery=SELECT+ip_hostname+FROM+nnm_nodes"
  }

}

