I'm writing a program that needs to update a SQL Server database. The program reads in a CSV file, write it to a SQL Server table. It then retrieves the rows from the table and edits the data. The next step is to retrieve the rows that are not in error and update the SQL Server tables with the data. To perform the update, it needs to execute APIs. The APIs are installed on both the database server and web server. They are the same.
The software package that was purchase has the same APIs executing on the database server and the web server.
I had asked some people that I know are more knowledgeable than I am and they suggested using WSDL.
Is there another way of calling an APIs other that using WSDL?
Whichever is easier to call for a beginner. I don't know XML. The current version of the program is using the database APIs, but it is written in a subset of vbscript, that is used by SQL Server.
Is it easier to use the database or web apis? Or is the coding the same?
I doubt that Java code can call any VBScript-type API that SQLServer offers. So the web service APIs are probably your only choice.
WSDL is a way to describe a web service API. You'll need it to create Java client code that can access those services. Most web services toolkits (like Apache Axis2) include tools that can take a WSDL and create that code for you.
There is no beard big enough to make me comfortable enough with my masculinity to wear pink. Tiny ad:
Free, earth friendly heat - from the CodeRanch trailboss