Transition to Database Server: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
← Older editNewer edit →
TOstryzniuk (talk | contribs)
CCMDB_legit, approved, Bureaucrats, Administrators
27,522 edits
mNo edit summary
mNo edit summary
Line 1: Line 1:
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]].  
CCMDB will eventually outgrow Microsoft Access as a storage format for our [[Centralized_data.mdb]].  


{{DA | You were going to follow up with the new CHI person to make sure they are aware. 2019-March-11 }}
{{DA | You were going meet with Dr. Renner to find out if he can help us make this a priority for either Digital Health or CHI. }}


== Technical considerations ==
== 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.  
* We need to be able to access this from collector laptops that might not be on the WRHA network at the time, since some locations where collectors work don't have wifi yet.  


=== Things that would need to work to get started ===
* Who will be allowed to program and implement changes on this system?
One question that remains is:
* {{Discuss | who = Julie | question = 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 ==
== Administrative and governance considerations ==
Line 22: Line 17:
*** 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?  
*** 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?  
** would we be able to access this and report from this via SQL reporting (a system Kym's group uses for real-time available reports for Accuro, which ties into the same type of database system)
** would we be able to access this and report from this via SQL reporting (a system Kym's group uses for real-time available reports for Accuro, which ties into the same type of database system)
== Log ==
* we asked CHI if they could store this for us, but they said storing external data like this is not currently a project they can take on
* we tried to work with Decision Support Services and had a test system set up when the arrangement fell through because a data agreement could not be reached
** 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.
== Related articles ==
{{Related Articles}}




[[Category: eHealth]]
[[Category: eHealth]]
[[Category: Warehouse]]
[[Category: Warehouse]]

Revision as of 09:26, 2019 July 31

CCMDB will eventually outgrow Microsoft Access as a storage format for our Centralized_data.mdb.


You were going meet with Dr. Renner to find out if he can help us make this a priority for either Digital Health or CHI.

  • SMW


  • Cargo


  • Categories

Technical considerations

  • We need to be able to access this from collector laptops that might not be on the WRHA network at the time, since some locations where collectors work don't have wifi yet.
  • Who will be allowed to program and implement changes on this system?

Administrative and governance considerations

We now need to work out the following:

  • 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?
    • would we be able to access this and report from this via SQL reporting (a system Kym's group uses for real-time available reports for Accuro, which ties into the same type of database system)

Log

  • we asked CHI if they could store this for us, but they said storing external data like this is not currently a project they can take on
  • we tried to work with Decision Support Services and had a test system set up when the arrangement fell through because a data agreement could not be reached
    • 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.

Related articles

Related articles:
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Transition_to_Database_Server&oldid=138512"