create soapui/wsdl/webservices data sources and dataset in birt

Hi,
 
Can someone kindly provide a brief step by step guide on how to create a web services based data source and data set in birt. I am trying to create one but nothing is working for me. There is an example on web but it does not explain how the data source and dataset has been created
 
Shah

Find more posts tagged with

Comments

JFreeman

Which version of BIRT are you using?
 
Take a look a this DevShare on using the Web Service ODA: <a data-ipb='nomediaparse' href='http://developer.actuate.com/community/forum/index.php?/files/file/656-birt-web-service-oda-article/'>http://developer.actuate.com/community/forum/index.php?/files/file/656-birt-web-service-oda-article/</a>
 
Also, take a look at this documentation on using a Web Service Data Source with the commercial version of the designer: <a data-ipb='nomediaparse' href='http://developer.actuate.com/be/documentation/ihub31-dev/DAG/index.html#page/DAG/accessing-data-webservice.html'>http://developer.actuate.com/be/documentation/ihub31-dev/DAG/index.html#page/DAG/accessing-data-webservice.html</a>

Arif shah

Hi,
 
I am using open source eclipse birt 4.2
 
Arif

JFreeman

Read through the DevShare document I posted first. This has a good write up of using the Web Service ODA with instructions for creating one.
 
The commercial link should still be helpful as well. The majority of the information within that document should still pertain to OS 4.2.

Arif shah

Hi,
 
Many thanks for the help. It has helped me understand how to add web services data source. Here is a bit of a problem. The web services that I use, when I create the soap request in soapui, I get the list of columns for mapping. However in Birt, I do not get the list of columns.
 
Attached are the birt and soapui responses for the same request. My question is how can I get the columns list for mapping
 
Syed
 
 
<div> </div>

JFreeman

The first thing I would check is that the SOAP request that is being generated/sent from the designer matches the soap request generated/sent from SOAP UI.
 
I have seen situations where the auto generated SOAP request needs to be modified to properly align with a specific environment.

Arif shah

Hi,
 
I have again come across this requirement and again stuck at this point. The soap request is not generating the column list for me. If I use soapui, it gives me the list of columns but the birt is not generating the column list. I have also pasted the soap request from ui into birt as suggested above but that is also not working
 
I will appreciate if someone can please suggest me a solution.

Arif shah

This is a sample wsdl content
 
 <message name="listingQuestionIn"> 
 <part name="key" type="xsd:string"/> 
 <part name="qt_id" type="xsd:int"/> 
 <part name="qm_id" type="xsd:int"/> 
 <part name="gr_id" type="xsd:int"/> 
 <part name="dateStart" type="xsd:string"/> 
 <part name="dateEnd" type="xsd:string"/> 
 <part name="sg_id" type="xsd:string"/> 
 </message> 
 <message name="listingQuestionOut"> 
 <part name="return" type="soap-enc:Array"/> 
 </message> 

 
A soapui request, response as well as Birt column mapping window snapshot is attached here
 
I need to see proper column mappings here

Arif shah

Further update.
 
The birt returns an xml output. How to convert them into columns now?

JFreeman

You could use computed columns to parse the XML output into your desired columns. It's not ideal but it should work.

Arif shah

Hi,
 
Can you give me a short example on how could the xml be parsed into columns. Suppose I have the following xml retunred as a string
<pre class="_prettyXprint">
<?xml version="1.0" encoding="utf-8"?>
<response><items><item><nv_id>1</nv_id><nv_id_parent>0</nv_id_parent><nv_label>Satisfactory</nv_label></item><item><nv_id>2</nv_id><nv_id_parent>1</nv_id_parent><nv_label>Niveau admin</nv_label></item><item><nv_id>3</nv_id><nv_id_parent>2</nv_id_parent><nv_label>Enseigne</nv_label></item><item><nv_id>4</nv_id><nv_id_parent>3</nv_id_parent><nv_label>Magasin</nv_label></item></items></response></pre>
How can I parse this ino columns and values of columns?

Arif shah

I have used below code to parse the above xml and create a column.
<pre class="_prettyXprint">
importPackage(Packages.org.apache.xerces.parsers);
importPackage(Packages.org.xml.sax);
importPackage(Packages.java.io);

var parser = new DOMParser();
parser.parse(new InputSource(new StringReader(dataSetRow["return"])));
var nodelist = parser.getDocument().getElementsByTagName('nv_label');
var entry = nodelist.item(0).getFirstChild().getNodeValue();

entry;</pre>
Now the problem is that the xml is returned as a single row string. The xml string contains a lot of rows and I would like to fetch all those rows for the column. How can I do that?
 
Arif

JFreeman

Computed columns are not going to work if there are multiple rows of data within the single row that is returned.
 
I can think of a couple of options for going forward.
 
1. You could create a second data source/set that is scripted and configure the report so that the web service data source/set runs first then the scripted data source/set. When the web service data set runs, push the XML response into a persistent global variable(PGV). Then in the scripted data source/set, read the XML from the PGV and parse it into the desired columns/rows. Then you would use the scripted data source/set for your report content.
 
2. Instead of having 2 different data sources as I described above, you can do the entire thing with a scripted data source/set.

gangadhar15

Hi,
 
 I have started working on webservice integration , while taking the data single row is coming correctly, how to take multiple row. Say for example if i want to show all the cities that is coming in the xml tag , how can i achieve that?
<city>A</city>
<city>B</city>
How can i both A and B , please chare me if you have any example, I am trying with below service.
<a data-ipb='nomediaparse' href='http://www.webservicex.net/uszip.asmx?WSDL'>http://www.webservicex.net/uszip.asmx?WSDL</a>