Load data using Webservices
Posted: Fri Nov 14, 2014 4:37 pm
Hi Folks,
Requirement:
Load the DB table in MDM EBX(This Database is a propietary database format), only way to load this Table would be to call Webservice they provide.
Here is the approach i am planning to take:
Oracle------>TFM---->XML FILE---->WebServices Client
PS: Webservices WSDL when imported has the operation called multiinsert(inserting multi records in the same table)
Q: How do i configure between XML file and Wservice?
Q:how each record will go into the target table? i dont see any col to col mapping?
PS: let me know if you have more questions.
Requirement:
Load the DB table in MDM EBX(This Database is a propietary database format), only way to load this Table would be to call Webservice they provide.
Here is the approach i am planning to take:
Oracle------>TFM---->XML FILE---->WebServices Client
PS: Webservices WSDL when imported has the operation called multiinsert(inserting multi records in the same table)
Q: How do i configure between XML file and Wservice?
Q:how each record will go into the target table? i dont see any col to col mapping?
PS: let me know if you have more questions.