I want to create SOAP Web service in adf application that I can call project server database using API called PSI.
Here is the architecture of Project server.
Can anyone please give me suggestions?
Just use New->Business Tier->Web Services and choose what you need :)
I am new in adf development.
Just use New->Business Tier->Web Services and choose what you need, I am not sure which option I need to select to connect to PSI API for Project Server Database from web service.
any one has any more suggestions?
You need to decide will you use "Web Service Data Control" or "Web Service Client and Proxy".
I recommend the first option because this will create Data Control so you can drag and drop operations from this WS to your pages(as buttons, parameter forms, etc).
I have created web service with data control by providing this WSDL
http://SERVER_NAME/PWA_INSTANCE/_vti_bin/psi/project.asmx?WSDL and some objects and service methods are genreated. Service method has parameters.
How I can use this parameters of service methods to read the data from sql server database and how I can write data back into databases.
When I am dropping this parameter as ADF Parameter form is just input text box without any values. Please give me some direction or links for code I can use to implement the application.
Please let me know if you have any questions.