cancel
Showing results for 
Search instead for 
Did you mean: 

Can Design Studio connect via SOAP or OData?

Former Member
0 Kudos

Hi

Looking at the documentation and the few posts in this forum, it does not seem like Design Studio can consume data through SOAP or OData. If this is true, does any of you know if this is planned for the future releases?

Best regards,

Martin

Accepted Solutions (1)

Accepted Solutions (1)

IngoH
Active Contributor
0 Kudos

HI Martin,

there is no out of the box data connectivity to OData for Design Studio.

Design Studio 1.6 connects out of the box to BW, HANA, and BI 4.1 Universes.

regards

Ingo Hilgefort, Visual BI

Answers (1)

Answers (1)

TammyPowlas
Active Contributor
0 Kudos

For OData, you can use a BI4x universe to consume the OData Source

See

Design Studio can use the BI4x universe as a datasource  - I have not tried this but this is an idea you can try today.

former_member185603
Active Contributor
0 Kudos

Tammy,

Can you please confirm if Design Studio 1.6 connect via odata?

TammyPowlas
Active Contributor
0 Kudos

OData to Universe - to Design Studio - I should think that would work assuming it's a relational universe

IngoH
Active Contributor
0 Kudos

HI Jawahar,

there is no out of the box data connectivity to OData for Design Studio.

Design Studio 1.6 connects out of the box to BW, HANA, and BI 4.1 Universes.

regards

Ingo Hilgefort, Visual BI

former_member185603
Active Contributor
0 Kudos

Is there any work around like using Design Studio SDK or something?

Karol-K
Advisor
Advisor
0 Kudos

Hi Jawahar.

we have a component in scn community package - . You can check if this will fit into your scenario.

what is it doing? basically AJAX request against any other server (here you need to fix CORS topic in configuration and authentication) - then you can parse the result in BIAL script (using eg. JSON OBJECT component).

Karol

former_member114166
Discoverer
0 Kudos

Hi Karol,

I am trying to access a OData service (HANA) using the 'PostResponseParser' component and I have been getting the following error:

XMLHttpRequest cannot load http://myhost:8000/xxxx/xxxxx/xxxxx.xsodata/xxxx. Response to preflight request doesn't pass access control check: No 'Access-Control-Allow-Origin' header is present on the requested resource. Origin 'http://myIP:55555' is therefore not allowed access.


And this is how I have defined .xsaccess file (I dont have access to XSADMIN rights on HANA).


{

     "exposed" : true, 

     "authentication" : {"method": "basic"},

     "cors":{"enabled":true, "allowMethods":["GET","POST","HEAD","OPTIONS"],"allowOrigin": ["*"],

    "allowHeaders": [

            "Accept",

            "Authorization",

            "Content-Type",

            "X-CSRF-Token"

        ],

        "exposeHeaders": [

            "x-csrf-token"

        ] }

}

What settings do I tweak to make it work?