Connecting to Repository Using Direct Transfer of Credentials: the OpenMetabase Operation

Below is the example of using the OpenMetabase operation to connect to the repository. The request contains the user's credentials and the identifier of the description that contains settings for the repository connection. The response contains the repository connection moniker.

SOAP request:

<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">

<id>WAREHOUSE</id>

</tDef>

<user>

</user>

<pass>Qwerty1</pass>

</tCreds>

</OpenMetabase>

</s:Body>

</s:Envelope>

SOAP response:

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

<soapenv:Body>

</OpenMetabaseResult>

</soapenv:Body>

</soapenv:Envelope>

JSON request:

{
 "OpenMetabase" : 
  {
   "tDef" : 
    {
     "id" : "WAREHOUSE"
    },
   "tCreds" : 
    {
     "user" : 
      {
       "id" : "sa"
      },
     "pass" : "Qwerty1"
    },
   "tArg" : ""
  }
}

JSON response:

{
 "OpenMetabaseResult" : 
  {
   "id" : "S1!M",
   "sessKey" : "139743",
   "sessCookie" : "C1",
   "version" : "163",
   "defLocale" : "1049"
  }
}

The parameters required for connection are sent as input parameters of the function. The result of the operation is the result of the function.

public static OpenMetabaseResult MetabaseConnect(string mbDefinitionId, string userName, string password)
{
    var somClient = new SomPortTypeClient(); //Proxy object for operation execution
    //Operation execution parameters
    var tOpen = new OpenMetabase()
    {
        tArg = new OpenMetabaseArg(),
        tCreds = new UserCreds() //Credentials used for connection
        {
            user = new UserId() //Repository user identifier
            {
                id = userName
            },
            pass = password
        },
        tDef = new MbDef() //Description of the repository, to which connection is established
        {
            id = mbDefinitionId
        }
    };
    //Repository connection
    var result = somClient.OpenMetabase(tOpen);
    return result;
}