GetDatabaseDrivers

SOAP-запрос:

<s:Envelope xmlns:s="http://schemas.xmlsoap.org/soap/envelope/">

<s:Body xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">

<GetDatabaseDrivers xmlns="http://www.fsight.ru/PP.SOM.Som">

<tMbSec xmlns="">

  <id>CKOMIMIKOGEIGOAEFGMLHGEBDJBOLCHEKJDLDLHCBDIDJGIM!M</id>

  </tMbSec>

<tArg xmlns="">

  <isPublic>false</isPublic>

  </tArg>

  </GetDatabaseDrivers>

  </s:Body>

  </s:Envelope>

SOAP-ответ:

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/">

<soapenv:Body>

<GetDatabaseDriversResult xmlns="http://www.fsight.ru/PP.SOM.Som" xmlns:q1="http://www.fsight.ru/PP.SOM.Som" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">

<drivers xmlns="">

<Item>

  <name>Oracle</name>

  <id>ORCL8</id>

  <tech>1</tech>

  <version>8</version>

  </Item>

<Item>

  <name>Microsoft SQL Server</name>

  <id>MSSQL2012</id>

  <tech>2</tech>

  <version>3</version>

  </Item>

<Item>

  <name>Microsoft SQL Server (ODBC)</name>

  <id>MSSQL2012ODBC</id>

  <tech>2</tech>

  <version>4</version>

  </Item>

<Item>

  <name>ClickHouse (ODBC)</name>

  <id>ODBC(CLICKHOUSE)</id>

  <tech>16</tech>

  <version>0</version>

  </Item>

<Item>

  <name>Generic ODBC</name>

  <id>ODBC</id>

  <tech>15</tech>

  <version>0</version>

  </Item>

<Item>

  <name>OLE DB(ODBC HIVE)</name>

  <id>OLEDB(ODBC HIVE)</id>

  <tech>12</tech>

  <version>0</version>

  </Item>

<Item>

  <name>OLE DB(ODBC)</name>

  <id>OLEDB(ODBC)</id>

  <tech>5</tech>

  <version>0</version>

  </Item>

<Item>

  <name>OLE DB</name>

  <id>OLEDB</id>

  <tech>0</tech>

  <version>0</version>

  </Item>

<Item>

  <name>Greenplum/Pivotal HD Hawq</name>

  <id>POSTGRES(NO_LO)</id>

  <tech>8</tech>

  <version>1</version>

  </Item>

<Item>

  <name>PostgreSQL</name>

  <id>POSTGRES</id>

  <tech>8</tech>

  <version>0</version>

  </Item>

<Item>

  <name>ClickHouse</name>

  <id>CLICKHOUSE</id>

  <tech>16</tech>

  <version>0</version>

  </Item>

<Item>

  <name>SQLite</name>

  <id>SQLITE</id>

  <tech>11</tech>

  <version>0</version>

  </Item>

<Item>

  <name>WEB Service</name>

  <id>WSF</id>

  <tech>13</tech>

  <version>0</version>

  </Item>

  </drivers>

  </GetDatabaseDriversResult>

  </soapenv:Body>

  </soapenv:Envelope>

JSON-запрос:

{
 "GetDatabaseDrivers" : 
  {
   "tMbSec" : 
    {
     "id" : "CKOMIMIKOGEIGOAEFGMLHGEBDJBOLCHEKJDLDLHCBDIDJGIM!M"
    },
   "tArg" : 
    {
     "isPublic" : "false"
    }
  }
}

JSON-ответ:

{
 "GetDatabaseDriversResult" : 
  {
   "drivers" : 
    {
     "Item" : 
      [
        {
         "name" : "Oracle",
         "id" : "ORCL8",
         "tech" : "1",
         "version" : "8"
        },
        {
         "name" : "Microsoft SQL Server",
         "id" : "MSSQL2012",
         "tech" : "2",
         "version" : "3"
        },
        {
         "name" : "Microsoft SQL Server (ODBC)",
         "id" : "MSSQL2012ODBC",
         "tech" : "2",
         "version" : "4"
        },
        {
         "name" : "ClickHouse (ODBC)",
         "id" : "ODBC(CLICKHOUSE)",
         "tech" : "16",
         "version" : "0"
        },
        {
         "name" : "Generic ODBC",
         "id" : "ODBC",
         "tech" : "15",
         "version" : "0"
        },
        {
         "name" : "OLE DB(ODBC HIVE)",
         "id" : "OLEDB(ODBC HIVE)",
         "tech" : "12",
         "version" : "0"
        },
        {
         "name" : "OLE DB(ODBC)",
         "id" : "OLEDB(ODBC)",
         "tech" : "5",
         "version" : "0"
        },
        {
         "name" : "OLE DB",
         "id" : "OLEDB",
         "tech" : "0",
         "version" : "0"
        },
        {
         "name" : "Greenplum/Pivotal HD Hawq",
         "id" : "POSTGRES(NO_LO)",
         "tech" : "8",
         "version" : "1"
        },
        {
         "name" : "PostgreSQL",
         "id" : "POSTGRES",
         "tech" : "8",
         "version" : "0"
        },
        {
         "name" : "ClickHouse",
         "id" : "CLICKHOUSE",
         "tech" : "16",
         "version" : "0"
        },
        {
         "name" : "SQLite",
         "id" : "SQLITE",
         "tech" : "11",
         "version" : "0"
        },
        {
         "name" : "WEB Service",
         "id" : "WSF",
         "tech" : "13",
         "version" : "0"
        }
      ]
    }
  }
}

public static MbDalDriversResult GetDatabaseDrivers(string moniker)
{
    var somClient = new SomPortTypeClient(); // Прокси-объект для выполнения операций
    // Параметры выполнения операции
    var tGet = new GetDatabaseDrivers()
    {
        tArg = new MbDalDriversArg()
        {
            isPublic = false
        },
        tMbSec = new MbId() { id = moniker }
    };
    // Получение списка драйверов
    var result = somClient.GetDatabaseDrivers(tGet);
    return result;
}