Key Challenges
• Reduce expenses associated with on-premise equipment and maintenance.
• Allow scaling as the database grows.
• Ensure easy access to current policies from any location, on any device.
Business Case
In the past, the company relied on compliance officers and legal departments that spent hours researching the policy landscape of each country. But even the most diligent compliance research is not useful unless up-to-date information is easily accessible to employees worldwide.
MAQ Software worked with government affairs officials to create a policy database that is current and accessible company-wide.
Solution
MAQ Software helped design a cloud-based solution where authenticated users can view all the consolidated policies in real-time.Key Highlights
• Used Azure App Service to pull data from diverse APIs and servers at scheduled intervals.
• Used Azure Application Insights to track usage metrics.
 |
| Figure 1: Policy database architecture |
MAQ Software used Azure App Service to register multiple APIs including Graph and Azure Active Directory. We used Azure WebJobs to run programs that pull the policy data from the APIs and servers at scheduled intervals. Users are authenticated through Azure Active Directory. Connection strings and credentials are encrypted and stored in the Azure Key Vault.
The policy database—which includes policies, events, and internal messages—is hosted on an Azure SQL database. User file attachments associated with policies and events are stored in Blob storage. Azure Application Insights provides usage data including page views, unique user counts, and visits from external links.
We used Azure Cognitive Services to add Bing news functionality to the final product. Based on keywords, Cognitive Services pulls relevant news from Bing, which is updated daily..
The policy database—which includes policies, events, and internal messages—is hosted on an Azure SQL database. User file attachments associated with policies and events are stored in Blob storage. Azure Application Insights provides usage data including page views, unique user counts, and visits from external links.
We used Azure Cognitive Services to add Bing news functionality to the final product. Based on keywords, Cognitive Services pulls relevant news from Bing, which is updated daily..
Business Outcome
The cloud-based policy solution provides a central location for compliance officers to view up-to-date policies from any country where the company conducts business. The database minimizes the risk of policy violations, which could cost the company millions of dollars.Outcome Highlights
• Saved time by creating a searchable central repository for all current policy documents.
• Reduced the risk of costly legal proceedings in countries with different business policies.
• Added security with Azure Key Vault.
• Provided usage metrics with Azure Application Insights. This data is being used for usage reporting.
Click here to learn more about our Collaboration & Content expertise.