Transition to Database Server

CCMDB will eventually outgrow Microsoft Access as a storage format for our Centralized_data.mdb. We are investigating storing the data with Decision Support Services.

Technical considerations

WRHA Department "Analytics & Business Intelligence" has given us access to a database on their database server where we would be able to store our data. The technical groundwork is in place: we can add/edit/remove tables and access them via an MS Access front end through ODBC.

Things that would need to work to get started

One question that remains is:

• Template:Discussion Julie, can you confirm that SAS would be able to connect to an MS SQL Server via ODBC? Ttenbergen 22:02, 2018 March 14 (CDT)

Future Dreams

• would we be allowed to run MS Reporting Services reports through this? Kym's group uses these with their Accuro data, it's a decent way to get data to a controlled group of users almost real-time

Administrative and governance considerations

We now need to work out the following:

Administrative and governance considerations Discussed at Steering, Allan will book meeting with Phil Jarman to discuss. Ttenbergen 14:07, 2018 April 9 (CDT)

• SMW

• Cargo

• Categories

• What would be the terms and conditions of us using this repository
  • who owns the data?
  • how will this be funded?
  • how do we navigate giving additional people access to the data?
    • will we be able to give partial access to data to people? Technically this is obviously possible, but would we be allowed to do this, and if so, would we be allowed to manage this ourselves?