Create xml from WSDL url and Web Service functions

dataservices realtime
1

I have some problem with WSDL and Web Service datastore.

I created Web service datastore (for MS ERP Web service). Imported functions (insert/update/delete) and can see metadata (entity and attributes). Now I want to create target schema and insert/update few records. Here I have following questions:

  • How to create XML from WSDL url? WSDL is very large file…
  • How to link target XML schema with ERP external web service?
  • How to use external web service functions? is there any configuration required in management console. I tried with different ways but no luck.

It is for batch job and DS version: Designer - 12.2.2.3 and JS 12.2.3.0.
I am new to bods.
Thanks in Advance,
Ahmed

Ahmed19 (BOB member since 2011-10-21)

2

if you have imported the function in the datastore, then the input and output schema of the function is imported in DS webservice datastore

to send XML message to the webservice and receive the xml response you will have to create a Dataflow and in a Query transform call this function and pass the XML input (for this you will have to build the nested input)

you can build the nested input from a XML or from a table, refer to following link to working with nested schema

https://wiki.sdn.sap.com/wiki/display/BOBJ/The+Nested+Relational+Data+Model+NRDM

manoj_d (BOB member since 2009-01-02)

3

Thanks Manoj, Now I can consume web services.

Now I am facing other problems:
The metadata for Web Service function is very big (around 200 entities). I created 2 queries in a DF. In QueryPre_1 I copied metadata (SOAP Header, entity). In QueryFunc_2 I called web service function and mapped SOAP header and entity. When I tried to save it, BODS crashed with “unknown error” message. I am interested only in one entity out of 200 entities. I delete all entities except one required entity from “entity node”. I can save job, when I run the job I got following error:

(12.2) 10-23-11 15:57:27 (E) (8323132:2571) XML-240210: |Data flow A2_DF_TEST_401|Transform Query_Function-Function5
XML target: Generating XML failed, the column in an incoming row not found for element in the target DTD or Schema.

Is this ok to manually delete unwanted entities from Web service functions (datastore metadata)? What are the required columns like columnsetxml?

In SOAP header also there are 100 columns, Is this ok to delete datastore meta data to make it light? What are required columns for SOAP header?

This post also helped me:

Thanks,
Ahmed

Ahmed19 (BOB member since 2011-10-21)

4

deleting metadata after importing table in DataStoe is fine, but it doesn’t work for function schema imported from WSDL, you can try modifying the WSDL after saving to disk, but then the job will fail at run time if the element that you deleted shows up in the response

the designer might be crashing because of large schema, what the application that has this big request and response ?

manoj_d (BOB member since 2009-01-02)

5

Thank you! Manoj.

I will try. Is there any other optimal solution?

The application is MS CRM.

Thanks,
Ahmed

Ahmed19 (BOB member since 2011-10-21)

6

there was some fix done for importing large nested schema, I need to check the FP version

since its MS CRM, does it requires NTLM authentication ?

manoj_d (BOB member since 2009-01-02)

7

Thank you ! Manoj.

No! Kerberos authentication, according to tech team NTLM is an option.

I copied WSDL file in local disk and updated WSDL file to create web service datastore. Datastore is throwing pursing error. I tried with different sets of metadata.
Our DS version is: Designer - 12.2.2.3 and JS 12.2.3.0.
Could you please confirm if there is a fix in new version or ay know issues for importing large nested schemas?

Ahmed19 (BOB member since 2011-10-21)

8

from where can I access the MS CRM 4.0 WSDL ?
is it possible for you to mail me the WSDL file along with dependent files (any other WSDL or xsd that are included in the main WSDL)

you can email me at mdhyani at hotmail com

manoj_d (BOB member since 2009-01-02)

9

ok, got the WSDL from the SAP Message, Designer is still running out of memory in the latest 12.2 Fix Pack

let me see if it works fine in DS 4.0 which has 64bit Designer, in 32-bit OS a process can’t go beyond 2 GB so that limit is preventing Designer to process the large XML schema

manoj_d (BOB member since 2009-01-02)

10

Hi Manoj,
What are your recommendations to process these type of files?
Thanks,
Ahmed

Ahmed19 (BOB member since 2011-10-21)

11

the main problem with this WSDL is it’s using abstract type and there are quite a good number of different implementation for that abstract type

The way DS imports the abstract type is it creats a schema which includes all the possibilties, in this case the response has abstract type at multiple levels so while building the response schema with all those possibilities its running out of memory

the Request Schema for all the operations seems to be small

do you know what kind of input will produce which output ? if yes then this WSDL can be split into number of WSDL and rsponse schema can be changed to have only the response that is expected for that kind of input

manoj_d (BOB member since 2009-01-02)

12

Hi Manoj,
If I clearly understand your question, then yes. For example the input is Oracle table and out put is; class “account” (Represents the account entity) and column1, column2, n columns (for insert and update).

The classes are described in wsdl file, following is the link for list of crmService classes.

I am concerned about 5 classes. If we can modify wsdl file based on required classes then it will be the great news.

Thank you Manoj,
Ahmed

Ahmed19 (BOB member since 2011-10-21)