S
sderrico
Guest
Hello! We are using Progress 10.2B. The company where I work manage the inventory of some of their customers. Two major customers ask if we can set some query over the web so they can integrate this remote inventory to their ERP. We currently using IIS for other web site with ODBC OpenEdge drivers. So we could do some query like: http://website.com/inventory/get/bincustomer2 The architecture would look like: IIS - ODBC - Progress Database We are planning to implement other stuff like web order and heavier sales reports for the customers and the partners. Q1) I am concerned about the ODBC performance. Does someone one experience some performance issue with ODBC? We made some test and we get 100,000 records in 1 second. That seem good. But the performance seem to degrade when we did some joins table even if we respect the table index. Q2) Also, we hit sa show stopper like it is not possible to insert a value or update a field that his name contains a dash. In sum, the query with "Customer-No" will fail but "CustomerNo" will succeed. Is there are any other things like this? Q3) Is there are any tool available in Progress that can accomplish a better performance or will be more "Progress Compatible" like: Webspeed/Appserver - Progress Database? I am not sure to fully understand the difference between WebSpeed and Appserver. I read that some technologies need to generate Proxy DLL so you can distribute them to other programmer so their can call the request. If it is possible, we would like to rely on a technology that the programmers from our customer and partner will have more independance. In our ideal, we will give the documentation to them like all the URL with the parameters and the detailed result. The result of the query could be XML, Json, whatever. So on their side, their will use theirs tools: Java, C#, any others and their will be able to comsume the web service and feed their ERP. Is there are any progress tools that can do this? If yes, was there reliable? Did your project ended well? Q4) Do you have any tips or personals experiences that will allow us to jump over some pitfall? Thank you for your time. Really appreciated! Have a great day! Sebastien
Continue reading...
Continue reading...