Re-platforming: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
← Older edit
m moved content from my reminder task into here.
m Text replacement - "Requiremens for Re-Platforming" to "Requirements for Re-Platforming"
 
(38 intermediate revisions by 2 users not shown)
Line 1: Line 1:
CCMDB will eventually outgrow Microsoft Access as a storage format. 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]].  


*2016-10-12 sent follow-up email
== Technical considerations ==
*2016-10-03-- Meeting booked for.
* [[Requirements for Re-Platforming]]
*2016-09-22 emailed Trevor with likely structure.
*2016-09-22 sent email about how to get data to Trevor
*2016-09-19 made new structure; asked Trevor how to get it to him.
*2016-09-15 met w Dr Roberts and confirmed it’s ok to go ahead with preliminary testing
*2016-09-08 discussion with Trevor Strome
**ODBC connections should be possible
***Ability write and ? change tables
**Sticking point: auditing
**Terms and conditions changes – spongy answers
**Reporting: sql mgr, then anything that has ODBC connectivity SSRS MS reporting services
*Funding? …if there is a cost we want to keep it reasonable (can’t get better answer)
*Ownership of data? Will others look into our data
**Some should be accessible by all or many, to be discussed with owners
**Research by eg U of M special use of would go back to owners
*2016-08-04 Trevor emailed that things should start in Sept/Oct and we will need to discuss architecture. Asked for scope.
*2016-08-03 emailed for update
*2016-06-12 replied to let me know if I can help
Trevor: “We’ve made some very positive progress in bringing our SQL server on-line and accessing much of our other clinical datamarts (i.e., EDIS, ADT, etc) through direct queries. There are still a few governance/policy annoyances that we’re navigating, but overall things are looking good. If we connect in the next few weeks I should be able to provide you more information, and we can begin to sketch out how an architecture might look.”
*2016-06-02 emailed for follow-up
*2016-05-19 Trevor Strome (DSS) thinks there might be a way to get us a SQL server to store our data; waiting to hear back.


[[Category: eHealth]]
== 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 ===
* 2024-01-24 - [[Re-platforming to UM MedIT undetermined platform]]
* 2023-03 - [[Re-platforming to SalesForce (failed)]]
* 2019-08 - [[Re-platforming to CHI (failed)]]
* 2019-07-24 - [[Re-platforming to REDCap (failed)]]
* 201? - [[Re-platforming to DSS SQL Server (failed)]]
* 201? - [[Re-platforming to CCMDB Server (failed)]]
* 2008-ish: [[Re-platforming to Oracle Apex (failed)]]
 
 
 
== Related articles ==
{{Related Articles}}
 
[[Category:Re-platforming | *]]
[[Category:eHealth]]
[[Category:Warehouse]]
[[Category:Data Repository]]

Latest revision as of 10:54, 14 March 2025

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

Technical considerations

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


Related articles

Related articles:
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Re-platforming&oldid=163066"