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?
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.