GetMetabaseLink

Syntax

MetabaseLinkResult GetMetabaseLink(OdId tOb, GetMetabaseLinkArg tArg)

Parameters

tOb. Repository connection moniker.

tArg. Operation execution parameters.

Description

The GetMetabaseLink operation gets repository connection metadata.

Comments

The operation gets information about repository connection settings. To execute the operation, in the tOb field specify moniker of the repository object that is repository connection, and in the tArg field specify opening parameters. The moniker can be obtained on executing the OpenMetabaseLink operation. The operation results in the repository connection settings used by the connection.

Example

The example of getting information about the connection parameters that are determined for repository connection. The request contains moniker of opened repository connection instance that determines whether it is necessary to get this information. The response contains requested information.

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">
<GetMetabaseLink xmlns="http://www.fsight.ru/PP.SOM.Som">
<tOb xmlns="">
  <id>S1!M!S!ML7</id>
  </tOb>
<tArg xmlns="">
<metaGet>
  <obInst>true</obInst>
  <all>true</all>
  </metaGet>
  </tArg>
  </GetMetabaseLink>
  </s:Body>
  </s:Envelope>

SOAP response:

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/">
<soapenv:Body>
<GetMetabaseLinkResult 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">
<id xmlns="">
  <id>S1!M!S!ML7</id>
  </id>
<meta xmlns="">
<obInst>
<obDesc ds="" isShortcut="0" isLink="0" ver="6" hf="0">
  <i>MB_LINK</i>
  <n>Repository connection</n>
  <k>174241</k>
  <c>8193</c>
  <p>9050</p>
  <h>0</h>
  <hasPrv>0</hasPrv>
  <ic>0</ic>
  <isPermanent>1</isPermanent>
  <isTemp>0</isTemp>
  </obDesc>
  </obInst>
  <dirty>0</dirty>
<metabaseLinkParams>
  <user />
  <pass />
<logonDataExt>
  <driver>MSSQL2008</driver>
  <server>%METABASE_SERVER%</server>
  <database>Warehouse</database>
  <schema>dbo</schema>
  <unicode>0</unicode>
  <authentication>Password</authentication>
  <caseSensitive>0</caseSensitive>
  </logonDataExt>
  <useUnicode>0</useUnicode>
  <loginPrompt>1</loginPrompt>
  <useMetabaseCredentials>0</useMetabaseCredentials>
  <useDeferredLoading>0</useDeferredLoading>
  </metabaseLinkParams>
  </meta>
  </GetMetabaseLinkResult>
  </soapenv:Body>
  </soapenv:Envelope>

JSON request:

{
"GetMetabaseLink" :
{
"tOb" :
{
"id" : "S1!M!S!ML7"
},
"tArg" :
{
"metaGet" :
{
"obInst" : "true",
"all" : "true"
}
}
}
}

JSON response:

{
"GetMetabaseLinkResult" :
{
"id" :
{
"id" : "S1!M!S!ML7"
},
"meta" :
{
"obInst" :
{
"obDesc" :
{
"@ds" : "",
"@isShortcut" : "0",
"@isLink" : "0",
"@ver" : "6",
"@hf" : "0",
"i" : "MB_LINK",
"n" : "Repository connection",
"k" : "174241",
"c" : "8193",
"p" : "9050",
"h" : "0",
"hasPrv" : "0",
"ic" : "0",
"isPermanent" : "1",
"isTemp" : "0"
}
},
"dirty" : "0",
"metabaseLinkParams" :
{
"user" : "",
"pass" : "",
"logonDataExt" :
{
"driver" : "MSSQL2008",
"server" : "%METABASE_SERVER%",
"database" : "Warehouse",
"schema" : "dbo",
"unicode" : "0",
"authentication" : "Password",
"caseSensitive" : "0"
},
"useUnicode" : "0",
"loginPrompt" : "1",
"useMetabaseCredentials" : "0",
"useDeferredLoading" : "0"
}
}
}
}
public static MetabaseLinkResult GetMetabaseLinkMetadata(string moniker)
{
var somClient = new SomPortTypeClient(); //Proxy object for operation execution
//Operation execution parameters
var tGet = new GetMetabaseLink()
{
tArg = new GetMetabaseLinkArg()
{
metaGet = new MetabaseLinkMdPattern()
{
all = true
}
},
tOb = new OdId() { id = moniker }
};
//Get metadata
var tResult = somClient.GetMetabaseLink(tGet);
return tResult;
}

See also:

Working with Relational Objects of Repository