Business Challenge
- Two separate source systems in different technology platform
- Both the source system to be merged as one and should be moved to MS Azure
- All SQL databases should be converted as MS Azure SQL Storage
- Integration platform Mule and BizLink should be replaced a single integration platform
- To develop reports and dashboard using PBI
- To integrate the whole operations with the intranet portal hosted in SharePoint Online / Office 365.
How Avasoft helped?
- An extensive inventory of existing application and environment was conducted.
- Sunset the old ERP application and moved all clients to a single ERP platform.
- Leveraged MS Logic Apps for all EDI transaction, thereby old integrations platforms were made to sunset
- MS Azure SQL data storage was set up for Data Warehouse and other DB operations and leveraged the use of MDM for master data reducing the redundancy of same data at multiple DB’s
- Helped in decision making process by leveraging Azure big data analytics services on the data collected from each customer location.
- Leveraged the MS Power BI capabilities for developing reports and dashboards and integrated the reports with SharePoint Online intranet portal
- All applications are integrated to intranet portal hosted in SharePoint online and SSO is achieved through the user of Azure AD service.
Tech Stack
- Office 365
- SharePoint Online
- Power BI
- Dynamics CRM
- Azure SQL Database
- Azure Active Directory
- Azure Big Data
- Azure Logic Apps
- Azure VM
Value Addition to Customer
- Reduction in Overall Infrastructure cost
- High availability of applications
- Single place to monitor the happenings of each warehouse
- Improved decision making based on data analysis
