Accessing database APIs (newbie)

[Michael McAuliffe]

I'm converting a SQL Server Data Transformation Service (DTS) package to a Java program.

It required to call multiple database APIs (there are also web APIs) to update the database. The APIs are from a purchase vendor package.

What is the best way of doing this? It has been suggested that I use WSDL.

I'm new to Java and have read some on WSDL.

[Vinod K Singh]

With so little information, I don't think anyone can help you out. Also by your post it is not clear if it is related to JDBC or web services.

[Michael McAuliffe]

I hope that I'm able to explain.

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?

[Bear Bibeault]

You're still being way too vague:

To perform the update, it needs to execute APIs.

What APIs?

[Michael McAuliffe]

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'm new to Java, WSDL, XML.

[Ulf Dittmer]

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.