Consuming Web Service (Non-QaWS)

other Xcelsius - Crystal Dashboard Design
1

Hi,

I’m desperately trying to have Xcelsius consume a web service that is built using Visual Studio 2008. But whenever I try to add the web service connection to the data manager it fails returning an error “Unable to load URL” … --However, I am able to consume the web service in other applications succesfuly.

After researching the BO case forums it seems the issue is due the Web Service not being of a “Single Schema” (see attached Case) and the recommended resolution is to use BO’s Query as a web service.

The problem I have is that I don’t own BO XI to use Qaaws, the only tools I have are Xcelsius and Visual Studio.

Has anyone out there know a work around ? or is under a similar situation ? Any help is appreciated. . .

Thanks. :shock:
Web_Serv_Case.txt (0.0 KB)

reyesfra (BOB member since 2008-02-18)

2

Hello reyesfra,

You can try exporting your data as XML instead of Webservice. Then connect it to the Xcelsius Model using the XML Data Source Component.

MyXcelsius :us: (BOB member since 2008-07-18)

3

I would, but there is too much data to export, so I was hoping to use parameters to only retrieve a filtered set of data by using an Interactive dashboard. This is why we need the Web Service working. .

In all my team and I were wondering if anyone out there is consuming Web Services built on Visual Studio .NET. . .

reyesfra (BOB member since 2008-02-18)

4

Hi,

Ive demoed flynet a few times, this creates .Net web service files (.aspx stuff) from a database connection and SQL query using a wizard. It`s packed with a few version of Xcelsius.

If you send me a mail, I`ll zipup one of the sample project folders it creates with the ASPX stuff in. Might be a source of sample code!

ABILtd :uk: (BOB member since 2006-02-08)

5

Yes, it would be a benefit to examine the flynet files, my e-mail is fjreyes1@hotmail.com

Also. I’m making some progress. It turns out that my web service was UnTyped and as soon as I switched it to a Typed Web Service I now can import it into Xcelsius. I don’t get the URL error, and I am able to then see my input parameters and I can see the output headers.

The only thing I’m stuck on is when I preview my dashboard it does not return any data. However, it works well in Excel.

I think I’m getting closer.

Thanks for your help.

reyesfra (BOB member since 2008-02-18)

6

Hi reyesfra,

I am doing something similar with Xcelsius using web service.

Can you explain the term Typed web service? And how you switched it from untyped to typed?

Cheers.

3160006 (BOB member since 2008-09-30)

7

Basically, instead of hard coding my oracle data adapter connections, I implement the use of a dataset and configure it to my backend Oracle database. By using the dataset and dataadapter, the Web Service becomes a Typed Dataset, so all elements will have their types declared in the xml, a string will be string, etc…

By issuing this change xcelsius was able to recognize my visual studio web service. However, I still can’t pipe data in… it does not retrieve it.

reyesfra (BOB member since 2008-02-18)

8

Im using SQL Server 2005 to generate my Web Services and i have the same problem with Xcelsius not being able to consume the URL.

I’ve been stuck on this for days now, has anyone figured out how to get data from teh Web Service into Xcelsius?

rbowie (BOB member since 2005-10-03)

9

Since posting this i found a SAP page which says it is not possible to consume Web Services created from SQL Server 2005

https://bobj-board.org/t/138022

rbowie (BOB member since 2005-10-03)