Managing supply chain becomes very much difficult due to the interaction between various stakeholders. Hence, it is essential to make strategic decisions in time. From time to time, the status of in-progress performance of effective supply chain management is varying due to its nature of interrelated and interactive upstream and downstream flows. Thus, it is necessary to make a database from the point of suppliers to customers to integrate the process flow and also reduce the operational gap. The manufacturing processes involved, fluctuation in demand, costs related to transportation, costs related to inventory and costs related to decisions, are the significant operational aspects, but not limited to these alone. For carrying out this integration, it is necessary to update, consolidate and categorize the database for deriving feasible decisions. Data-based decision support plays a critical role in encompassing the routine production and triggers to meet the customer requirements. The decisions in time will be quite useful by considering the database and orienting towards the effective, smooth and successful supply chain management.