Question Re: SAP metadata export in Technology Q&A

SAP metadata export

WaqasQadri — Fri, 30 Aug 2024 12:44:01 GMT

Hi,

I have to export the metadata of BO into an excel file. I read that we can use SAP BO SDK to export the metadata using java or VBA (BusinessObjects SDK for Microsoft Office).

I need details of how to do this. What are the prerequisites and other things to do this. I am unable to find much details regarding this.

I am more interested in doing this using VBA and exporting the metadata directly into excel file. Any code example would also be helpful.

Re: SAP metadata export

ayman_salem — Fri, 30 Aug 2024 13:02:47 GMT

Use BI RESTful API to retrieve the metadata.
You can call RESTful from your VBA or Java code.

Re: SAP metadata export

WaqasQadri — Fri, 30 Aug 2024 13:09:12 GMT

Thank you for your response. Could you please share some details regarding the VBA, or if you can point me to some code example or documentation.

Re: SAP metadata export

ayman_salem — Fri, 30 Aug 2024 13:16:36 GMT

Read the help guide for using the BI RESTful SDK
https://help.sap.com/doc/2534ba1cbc6f433595e8582045503bcb/4.3.4/en-US/sbo43sp2_webi_restful_web_service_sdk_en.pdf

to call RESTfull from VBA. If you search the internet you will find many examples
here is one of them

Option Explicit

Sub Test_LateBinding()

    Dim objRequest As Object
    Dim strUrl As String
    Dim blnAsync As Boolean
    Dim strResponse As String

    Set objRequest = CreateObject("MSXML2.XMLHTTP")
    strUrl = "https://<server>:<port>/<1>"
    blnAsync = True

    With objRequest
        .Open "GET", strUrl, blnAsync
        .SetRequestHeader "Content-Type", "application/json"
        .Send
        'spin wheels whilst waiting for response
        While objRequest.readyState <> 4
            DoEvents
        Wend
        strResponse = .ResponseText
    End With

    Debug.Print strResponse

End Sub

Re: SAP metadata export

WaqasQadri — Tue, 03 Sep 2024 04:41:28 GMT

Thank you, we are actually running a migration project for SAP BO. We need these metadata for that purpose. I am new to this so do you suggest any other better approach for this project?