Hello evry one
I was going thru the wmDB users guide,wmusers search and wasn’t able to find the reason as to why we specifically need WmDB package as opposed to using the regular JDBC Adapter.
One reason i know(from my developing experience) is that WmDB and services written around it are normally used to load huge data i.e. table replications having thousands and millions of records etc . But the basic question i am having is do we really need to use webMethods WmDB services to do such things as opposed to using some other ETL tools ?
The reason why i came accross it now is we got a requirement to replicate few tables that are having like 5 million rows alltogether.And one of our team member wrote some java services(around WmDB package) that basically copies,moves the data over.I may end up using those(as per company’s policy) but before that i just want to know whether doing so is the right approach?