Project Description
The company is the world’s leading specialty distributor of advanced network technology solutions. Through their business units around the world, they are a significant sales channel for Cisco, Nortel Networks, Avaya and close to 100 other industry-leading manufacturers.
The primary challenge of this project was that the availability of these customized catalogs, a key component of their vision, was not natively supported by the company’s ERP. For the solution to be successful, their customers must have the ability to download complete pricelists, and obtain single product pricing in real-time via the API. Given the required flexibility of this pricing system, achieving the desired performance proved to be particularly complex.
A significant factor in the process of selecting a telecommunications distributor is how quickly and easily the retailer can conduct business transactions with them. The ability to utilize API’s and integrate purchasing functionality within the customer’s own system would present a level of efficiency that is not typically offered by competing distributors. With such a solution in place, they would display a distinct competitive advantage within their market.
In order to implement this process, Chateaux conducted extensive interviews to aggregate the in-depth rules and regulations that existed for the company’s pricing structure. One of the major obstacles that hindered the execution of this technology in the past was the complexity of the logic for the pricing packages. Several different permutations for product pricing exist based on factors such as volume of the products purchased, and individual customer agreements. Chateaux’s primary focus in this effort was to ensure that the accuracy of the data would save time, money, and resources in the future.
The technological execution of the project required a solid understanding of data warehousing methodology and architecture. Though this was not a true data mart since it was not used for Business Intelligence, the requirements for performance, real time loading, and data quality were the same. SQL Server was employed as the database server. Principles of database security, management and performance were all important aspects of this project.
One of the outstanding features of this solution is enabled through the Web Service API; the company can now provide the ability for select customers to program the purchasing of products through their own inventory systems. This feature eliminates the need for their customers to spend valuable time placing an order on either the company website, or over the phone. The company now has a significant competitive advantage over other distributors in the marketplace.