edison365projects DataStore Technical Product Description

Overview, Product Features, Architecture Diagram, Prerequisites and a List of Captured Data

Table of Contents

1. Overview

2. Product Features

3. Architecture - Event Receiver Service

4. Architecture - Datastore

5. Pre-requisite Requirements

5. Data Captured - Project

6. Data Captured - SharePoint

Overview

edison365projects DataStore is a SaaS solution hosted in Microsoft’s Azure. The application is built and fully maintained by the edison365 team with updates regularly being rolled out that include new features / service improvements.

DataStore enables your organisation to have a SQL Reporting database that contains your key Project Online data including Project Site data. Having the data in a SQL database gives
great flexibility for enhanced reporting and system integrations.

Data gets updated in the SQL database in near real time but is a queue based system so it is not instant.

Back to Top

Product Features at a Glance

• SaaS based product in hosted in Azure
• Queue based sync system
• Driven from Project Online PWA events
• Key Project Online data
• SharePoint List data from Project Sites
• Snapshot / history tables
• Bulk / on demand Sync
• Scheduled Sync
• Email alerts
• SQL database maintenance
• Sync History via the UI
• Configured via an intuitive UI
• 1 Database per PWA instance

Back to Top

Architecture - Event Receiver Service

Architecture - DataStore

Prerequisite Requirements

• Azure SQL Cloud database - https://docs.microsoft.com/en-us/azure/sql-database/sql-database-get-started
  • At least S2 tier or equivalent tier
  • Blank Database
  • We recommend restricting the IPs and whitelisting the application IPs, please find these here.
    • Alternatively it is possible to enabling the 'Allow Access to Azure Services' option within the Azure SQL firewall.
  • SQL username and password with full control over the target database:
  • • Ideally the Azure SQL Server Admin account or an account with at least db_manager role for the initial deployment
    • Post deployment, the account requires db_owner access to the database
  • Ensure the backup / restore options are understood: https://docs.microsoft.com/en-us/azure/sql-database/sql-database-business-continuity
  • Enable auto tuning: https://docs.microsoft.com/en-us/azure/sql-database/sql-database-automatic-tuning
  • Consider enabling Auditing: https://docs.microsoft.com/en-gb/azure/sql-database/sql-database-auditing-portal
  • Consider enabling Threat Detection: https://docs.microsoft.com/en-gb/azure/sql-database/sql-database-threat-detection-portal
• Project Online PWA instance
  • PWA user account with site collection Admin access and full PWA Admin access
• Access to Project Online SharePoint App Catalogue site
• The DataStore .app files from edison365 / your edison365 partner
• Ensure that custom app authentication is enabled on the SharePoint Online tenant, to enable it run the following SharePoint PowerShell command:
  • set-spotenant -DisableCustomAppAuthentication $false
  • Details on the set-SpoTenant cmdlets here: https://docs.microsoft.com/en-us/powershell/module/sharepoint-online/set-spotenant?view=sharepoint-ps 

Back to Top

Data Captured - Project

Data Captured - SharePoint

SharePoint lists can be synchronised to the DataStore database. Lists from the root PWA site collection and from Project Sites for Projects in PWA or other site collections on the tenant. The following SharePoint events are used:

Back to Top