we are using WM 6.01 on Windows 2000. The majority of our data is stored in SQL 2000 which we access via a SQL JDBC driver in WM.
I am trying to work out if there is a way to automatically create an adapter service by passing it a jdbc connection string and stored procedure name. A perfect solution would be a process in WM that could accept a stored procedure name and JDBC connection strig, determine the input and output variables and their data types and create them as parameters in a new adapter service of the stored procedure’s name.
I have written a stored procedure that will return this sort of information from a database for a given SP object but am not sure where to go from here. I briefly looked at some of the ndf xml files that get created but they look tricky to replicate.
Has anyone had any similar experience where they have been able to shorten the process of manually entering in the parameters for a database procedures?