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 specify the pattern that will be used to get the list of descriptions.

The operation results in the list of repositories descriptions. To connect to the repository, use the OpenMetabase operation.

Example

Below is the example of getting repository description settings. The request contains repository description identifier. The response contains all settings obtained for this description.

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="">
  <accessMode>1</accessMode>
<its>
<it>
  <id>WAREHOUSE</id>
  <n>Warehouse</n>
  <k>4294967293</k>
  <scope>LocalMachine</scope>
<logonData>
  <driver>MSSQL2012</driver>
  <server>TestServer</server>
  <database>TestRepository</database>
  <schema>dbo</schema>
  <unicode>1</unicode>
  <authentication>Password</authentication>
  <locale>0</locale>
  <deferredLoading>0</deferredLoading>
  <caseSensitive>0</caseSensitive>
  <fileGroup>PRIMARY</fileGroup>
  <ODBCParams />
  </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" :
{
"accessMode" : "1",
"its" :
{
"it" :
[
{
"id" : "WAREHOUSE",
"n" : "Warehouse",
"k" : "4294967293",
"scope" : "LocalMachine",
"logonData" :
{
"driver" : "MSSQL2012",
"server" : "TestServer",
"database" : "TestRepository",
"schema" : "dbo",
"unicode" : "1",
"authentication" : "Password",
"locale" : "0",
"deferredLoading" : "0",
"caseSensitive" : "0",
"fileGroup" : "PRIMARY",
"ODBCParams" : ""
}
}
]
}
}
}
}
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 Repository