Getting the Details of an SAP BW Connection

Returns the details of an SAP BW connection.

Request

GET <webiURL>/bwconnections/{bwConnectionId}

Where:

  • {bwConnectionId} is the connection identifier retrieved from the list of SAP BW connections
Response

Response type: application/xml or application/json

Response body: the details of an SAP BW connection that you have the authorization to access.

<path> is the connection path in the CMS repository.

Example

To get the details of an SAP BW connection of type query

GET <webiURL>/bwconnections/11489

<bwconnection type="Query">
    <id>11489</id>
    <cuid>AXRu2fNiQphAtF4O4lJ4OKg</cuid>
    <name>bex_simple</name>
    <folderId>11484</folderId>
    <path>Application Folder/Root Folder/Connections/</path>
    <bwnodes>
        <bwnode type="Query">
            <id>11489</id>
            <name>A simple Bex Query</name>
            <technicalName>QRY_SIMPLE</technicalName>
            <path>/QRY_SIMPLE</path>
        </bwnode>
    </bwnodes>
</bwconnection>

Example

To get the details of an incomplete BW connection of type System or Cube
Note For an incomplete BW connection, we have to browse the system/cube and find a bwnode of type Query (BEx query) which will complete the connection.

GET <webiURL>/bwconnections/11990

<bwconnection type="System">
    <id>11990</id>
    <cuid>Aaj0N_I.bSJElyDKk08sxTU</cuid>
    <name>raylight_BOF</name>
    <folderId>11484</folderId>
    <path>Application Folder/Root Folder/Connections/</path>
    <bwnodes>
        <bwnode type="Favorites">
            <name>Favorites</name>
            <technicalName>SystemFavoritesTopLevel</technicalName>
            <path>/SystemFavoritesTopLevel</path>
        </bwnode>
        <bwnode type="InfoArea">
            <name>InfoArea</name>
            <technicalName>SystemInfoareaTopLevel</technicalName>
            <path>/SystemInfoareaTopLevel</path>
        </bwnode>
    </bwnodes>
</bwconnection>