Schneider Electric has more than 100 product lines, more than 500 categories and over 50 000 items, information about them is stored in 7 different systems scattered around the world.
The main problems faced by partners of Schneider Electric, trying to find information on products:
Schneider Electric appealed to us for help in creating a single database that would contain information about all 50 000 names of products:
And to develop a mechanism for access by partners and suppliers.
Going deep in process, decompose into small parts. A single database that combines multiple sources of data we call OPS. API provides a machine interface, using it to interact with database servers.
Prepare the interaction with the information donors:
Such projects are very interesting for our programmers:
The main task of the service - providing full information to partners. Developing API to interact with our system. Give partners a choice: implement two methods for XML and JSON.
Facing with non-trivial problems:
Developing the following solutions:
All the information in the API OPS must be not only complete, but also up-to-date. This customizable periodic updates from existing sources. When checking analyze the existing data - compare by date and completeness of the content.
Database services must withstand enormous loads when thousands of connections and uploads. The administrator debugs the system:
For such services, focused on the use for partners, it is important to provide detailed and clear documentation.
To do this, we are describing in each command query examples:
We don't just write detailed documentation, but went further and developed a clear how-to for a quick start of work with our service. After reading this document, even an inexperienced programmer can quickly integrate the power of the Schneider Electric service to your online store or online catalog. Examples for the most common tasks such as :
Developing web service for the data downoad.
Using the database API OPS Schneider Electric partners can easily fill their services, such as online stores, catalogs, applications for designers, updated and extended information on products Schneider Electric. But not all partners are striving to fill their services. Some need information on specific rereferences (articles).
For their convenience, we have developed a web service, where the partner, having the key, can easily obtain information on required products and virtual them in any convenient format such as PDF, XLS, XML.
Information is the key of business. Summary.
This service does not have competitors Schneider Electric. It gives a significant business advantage. Partners can easily get information and integrates API OPS in their portals, online stores, catalogs. With this approach it is easier to provide equipment that is easier to sell, easier to use.