Mumha
Member
Hi
The company I work for currently has E9.10 and is in the process of upgrading to E9.20.
An outside company created a web application to (currently) show orders/statuses etc for our customers. We've created DB2 stored procedures to extract the required data for that company to build into their web application. That works well, for what it provides.
As we are now moving to E9.20, we are looking to redesign this and not only outflow information, but also to take in everything from new item data to purchase orders to changing/deleting lines etc. For that, we have been looking at using Orchestrator, and not need to use Stored Procedures any longer.
My question is whether anyone else has been down this road, and what their experience is ? From the training we have received, we have been re-evaluating whether we can get rid of SPs after all. Maybe we should just use Orchestrator as the delivery vehicle, rather than the data extractor AND delivery vehicle. Also, on the inbound, I can see we could use standard BSFNs to do a lot of the work, but I'm wondering whether sending the data through the 47 tables would be a safer option ?
Thanks in advance.
The company I work for currently has E9.10 and is in the process of upgrading to E9.20.
An outside company created a web application to (currently) show orders/statuses etc for our customers. We've created DB2 stored procedures to extract the required data for that company to build into their web application. That works well, for what it provides.
As we are now moving to E9.20, we are looking to redesign this and not only outflow information, but also to take in everything from new item data to purchase orders to changing/deleting lines etc. For that, we have been looking at using Orchestrator, and not need to use Stored Procedures any longer.
My question is whether anyone else has been down this road, and what their experience is ? From the training we have received, we have been re-evaluating whether we can get rid of SPs after all. Maybe we should just use Orchestrator as the delivery vehicle, rather than the data extractor AND delivery vehicle. Also, on the inbound, I can see we could use standard BSFNs to do a lot of the work, but I'm wondering whether sending the data through the 47 tables would be a safer option ?
Thanks in advance.