-
1. Re: Creating a Web Service
nestordrod Nov 20, 2008 9:20 AM (in response to salvarez)Without looking through the models and transformations, its' hard to say what could be causing the error.
Have you tested the models in Designer? Create a VDB and execute it from the tool to make sure everything's in working order. -
2. Re: Creating a Web Service
salvarez Nov 24, 2008 6:46 AM (in response to salvarez)hello!
I`ve already tested the model with the execute option of the vdb and it works perfectly.
I´m trying other ways to generate the web service. I´m trying to generate the web service directly from the data source model. This has as result a web service that includes the operations to accede the tables of the source model, but when I want to add a new operation, I need to declare some variables and elements in the xsd input file. However, there is no way I can change the DataTypes from string (default) to another data type.
Any idea about this?
Thank you for your attention! -
3. Re: Creating a Web Service
nestordrod Nov 24, 2008 9:50 PM (in response to salvarez)Have you tried editing the xsd file directly (i.e., outside of Designer)?
-
4. Re: Creating a Web Service
salvarez Nov 26, 2008 5:03 AM (in response to salvarez)Yes, I tried, and metamatrix changes the Data Types automatically when I open the project again.
-
5. Re: Creating a Web Service
nestordrod Nov 26, 2008 8:57 AM (in response to salvarez)Hmm... You've pretty much exhausted my amount of experience with the Web Service feature in MetaMatrix.
I seriously suggest contacting your MetaMatrix rep. I've found them in my experience to be very responsive to questions and problems.
Good luck! -
6. Re: Creating a Web Service
jdoyle Nov 26, 2008 11:01 AM (in response to salvarez)What does the transformation code look like.
EXEC proc(column1, column2)
or
SELECT * FROM proc WHERE input1=column1 AND input2=column2.
If it looks like the first example, try the second syntax.
~jd -
7. Re: Creating a Web Service
jdoyle Nov 26, 2008 11:32 AM (in response to salvarez)I would also second ndrodri's suggestion on contacting Metamatrix support. Since the source isn't open yet you must have a support agreement in place, and they will be able to address your case directly.
~jd