GetMbDefs

Syntax

MbDefsResult GetMbDefs(GetMbDefsArg tArg)

Parameters

tArg. Operation execution parameters.

Description

The GetMbDefs operation gets the list of repositories descriptions created on BI server.

Comments

The operations gets the list of repositories descriptions, to which the connection will be available. To execute the operation, in the tArg.pattern field set the pattern that will be used to get descriptions list.

The operation results in the list of repositories descriptions. Use the OpenMetabase operation for repository connection.

Example

Below is the example of getting repository description. The description identifier is sent in the query and all settings specified for repository description will be received in the response.

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">
<GetMbDefs xmlns="http://www.fsight.ru/PP.SOM.Som">
<tArg xmlns="">
<pattern>
  <mbDefs>Get</mbDefs>
  <logonData>true</logonData>
<filter>
  <id>WAREHOUSE</id>
  </filter>
  </pattern>
  </tArg>
  </GetMbDefs>
  </s:Body>
  </s:Envelope>

SOAP response:

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/">
<soapenv:Body>
<GetMbDefsResult 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">
<meta xmlns="">
<its>
<it>
  <id>WAREHOUSE</id>
  <n>Warehouse</n>
  <k>4294967290</k>
  <scope>LocalMachine</scope>
<logonData>
  <driver>MSSQL2012</driver>
  <server>v-nrspo-mssql.dev.fs.fsight.world</server>
  <database>Warehouse</database>
  <schema>dbo</schema>
  <unicode>1</unicode>
  <authentication>Password</authentication>
  <locale>65536</locale>
  <debugMode>0</debugMode>
  <deferredLoading>0</deferredLoading>
  <caseSensitive>0</caseSensitive>
  <fileGroup>PRIMARY</fileGroup>
  </logonData>
  </it>
  </its>
  </meta>
  </GetMbDefsResult>
  </soapenv:Body>
  </soapenv:Envelope>

JSON request:

{
"GetMbDefs" :
{
"tArg" :
{
"pattern" :
{
"mbDefs" : "Get",
"logonData" : "true",
"filter" :
{
"id" : "WAREHOUSE"
}
}
}
}
}

JSON response:

{
"GetMbDefsResult" :
{
"meta" :
{
"its" :
{
"it" :
[
{
"id" : "WAREHOUSE",
"n" : "Warehouse",
"k" : "4294967290",
"scope" : "LocalMachine",
"logonData" :
{
"driver" : "MSSQL2012",
"server" : "v-nrspo-mssql.dev.fs.fsight.world",
"database" : "Warehouse",
"schema" : "dbo",
"unicode" : "1",
"authentication" : "Password",
"locale" : "65536",
"debugMode" : "0",
"deferredLoading" : "0",
"caseSensitive" : "0",
"fileGroup" : "PRIMARY"
}
}
]
}
}
}
}
public static MbDefsResult GetDefinition(string defId)
{
var somClient = new SomPortTypeClient(); //Proxy object for operation execution
//Operation execution parameters
var tGet = new GetMbDefs()
{
tArg = new GetMbDefsArg()
{
pattern = new MbDefsPattern()
{
mbDefs = ListOperation.Get,
logonData = true,
filter = new MbDefsFilter()
{
id = defId
}
}
}
};
// Get information about repository description
var result = somClient.GetMbDefs(tGet);
return result;
}

See also:

Working with a Repository