on 09-12-2008 6:52 AM
Hi Guys,
We're contempating the purchase of Xcelsius - but the version without FlyNet - as it has no user restrictions. We've done some experimentation with the use of XML Data Sources, but prefer the idea of using a Web Servcies Data Source.
The problem being that we have little experience with this sort of thing.
So, does anyone have advice for us on the best way to create Web Services that will source data from an Oracle DB?
Does anyone have any example scripting to go along with it?
Any help is appreciated.
Regards
Mick
Hi,
I have actually created a .NET multi schema Web Service in Visual Studio 2008, I used ODP.NET as my provider and it's hitting an Oracle 10g backend. I took the WS example off the Oracle website and changed the code around. It works like a charm and I'm able to consume the web service in Excel and other applications. Send me your e-mails and I can attach the code.
The issue I'm having now is that the Web Service generated by VS does not conform to a "Single Schema" which is required by Xcelsius. On the other hand, Flynet and BO's Query as a Web Service do provide the Single Schema WS, but we don't have money in our budget to purchase these right now.
So I'm in the process of making our VS.NET Web Services compatible with Xcelsius single schema requirements, since we already own these 2 products.
Thanks.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hello
I have been trying to do as you described.. i can get a result from a .net web service returning a single value from the oracle db... to work in xcelcius but not with a returned dataset... .
This is not my strong point, web services, .. have you been able to make the web service readable by xcelcius? Also, i haven't been able to find much of any documentation on xcelcius and web service connections, do you know of any.????
thanks,
Peter
Peter,
As far as Web Services goes, the only thing we had any real luck with was Flynet (optional additional purchase from BO), and didn't get very far with other options - as it's not our strong point either.
We did have considerable luck using XML data sources - so you may wish to consider that as another option.
Regards
Mick
We found the same issue while experimenting with .Net web services. It seems Xcelcius cannot consume a Dataset.
However it can consume an array of strings. It interprets this as a table of information.
Below is an snippet of the C# .Net code to create the array. (It has two values: a company ID and a count of employees.) I did not write this code (a developer on our team did.)
EmployeeCount[] Counts = null;
int i = 0;
Counts = new EmployeeCount[dtOutput.Rows.Count];
foreach (DataRow row in dtOutput.Rows)
{
Counts<i>.Company = row["COMPANY"].ToString();
Counts<i>.eCount = row["EmpCount"].ToString();
i++;
}
return Counts;
Below is an example of how we structured our webservice output
HTTP/1.1 200 OK
Content-Type: text/xml; charset=utf-8
Content-Length: length
<?xml version="1.0" encoding="utf-8"?>
<ArrayOfEmployeeCount xmlns="http://tempuri.org/">
<EmployeeCount>
<Company>string</Company>
<eCount>string</eCount>
</EmployeeCount>
<EmployeeCount>
<Company>string</Company>
<eCount>string</eCount>
</EmployeeCount>
</ArrayOfEmployeeCount>
Hi Mike, I'm trying to do exactly the same. I have created a web service as a 'hello world' test and I hit a snag in Xcelsius Engage 2008 SP1. See my post below.
Maybe we can pool our minds to solving this?
Hiran
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.