Re-platforming: Difference between revisions

(22 intermediate revisions by the same user not shown)

Line 1:

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

CCMDB will eventually outgrow Microsoft Access as a storage format for our [[Centralized_data.accdb]].

== Technical considerations ==

* ~~We need to be able to access this from collector laptops; these might be accessing the network remotely~~

* [[Requirements for Re-Platforming]]

* Who will be allowed to program and implement changes on this system?

== Administrative and governance considerations ==

Line 16:

Line 14:

** 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)

~~== CHI ==~~

* Narmada Retnakaran (Manager, Data Coordinating Centre) is getting a handle on how they do stuff before she is prepared to discuss further with us

* 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

=== Log ===

* ~~2019~~-08-22 - ~~Allan reported that CHI will set up a group~~ to ~~work through~~ the ~~governance~~ of ~~such a server. Tina suggested to start the technical discussions in tandem with this~~, ~~and Allan agreed~~ to ~~make the connection to do this~~.

* [[Task Team Meeting - Rolling Agenda and Minutes 2025#ICU Database Task Group Meeting – June 18, 2025|2025-06-18]] - due to reorganization at the level of central University of Manitoba IT, our plan/hope for [[Re-platforming to UM MedIT undetermined platform]] is on hold for an unknown period.

* 2024-01-24 - [[Re-platforming to UM MedIT undetermined platform]]

~~== Shared Health ==~~

* 2023-03 - [[Re-platforming to SalesForce (failed)]]

* ~~2021~~-11-~~04 that incident was taken over by Kevin Soroka a while ago, Tina emailed him~~ to ~~follow up~~

* 2019-08 - [[Re-platforming to CHI (failed)]]

* ~~2021~~-~~08... was encouraged by MS Access upgrade team~~ to ~~start a new incident for this~~ (~~INC000004781738~~)

* 2019-07-24 - [[Re-platforming to REDCap (failed)]]

* ~~2021~~-02-12 - ~~Summary of the last few months: we put in a "Provincial Intake" request with the help of Alex Omsen; Shelley Irving Day agreed~~ to be the required executive level support; there is ongoing conversation at the leadership level how our database fits into ongoing needs and once that is decided we will hopefully move toward a solution.

* 201? - [[Re-platforming to DSS SQL Server (failed)]]

* 201? - [[Re-platforming to CCMDB Server (failed)]]

~~=== older history ===~~

* 2008-ish: [[Re-platforming to Oracle Apex (failed)]]

* ~~a long time ago we tried~~ to set up our own server within the Shared Health system; they initially offered to make this safe and doable within their network but then the price tag was to the moon, and they would not have allowed us to access this network from the rest of the network so no use

* ~~there was at least one meeting at some point~~ to ~~which Kym Morris was also invited~~

* ~~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 was in place: ~~we were able~~ to ~~add/edit/remove tables and access them via an MS Access front end through ODBC. Then some decision was made that made this not a feasible solution, might have been when Trevor Strom left~~

== Related articles ==

[[Category:Re-platforming | *]]

[[Category:eHealth]]

[[Category:Warehouse]]

[[Category:Data Repository]]

@@ Line 1: / Line 1: @@
-CCMDB will eventually outgrow Microsoft Access as a storage format for our [[Centralized_data.mdb]].
+CCMDB will eventually outgrow Microsoft Access as a storage format for our [[Centralized_data.accdb]].
 == Technical considerations ==
-* We need to be able to access this from collector laptops; these might be accessing the network remotely
+* [[Requirements for Re-Platforming]]
-* Who will be allowed to program and implement changes on this system?
 == Administrative and governance considerations ==
@@ Line 16: / Line 14: @@
 ** 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)
-== CHI ==
-* Narmada Retnakaran (Manager, Data Coordinating Centre) is getting a handle on how they do stuff before she is prepared to discuss further with us
-* 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
 === Log ===
-* 2019-08-22 - Allan reported that CHI will set up a group to work through the governance of such a server. Tina suggested to start the technical discussions in tandem with this, and Allan agreed to make the connection to do this.
+* [[Task Team Meeting - Rolling Agenda and Minutes 2025#ICU Database Task Group Meeting – June 18, 2025|2025-06-18]] - due to reorganization at the level of central University of Manitoba IT, our plan/hope for [[Re-platforming to UM MedIT undetermined platform]] is on hold for an unknown period.
+* 2024-01-24 - [[Re-platforming to UM MedIT undetermined platform]]
-== Shared Health ==
+* 2023-03 - [[Re-platforming to SalesForce (failed)]]
-* 2021-11-04 that incident was taken over by Kevin Soroka a while ago, Tina emailed him to follow up
+* 2019-08 - [[Re-platforming to CHI (failed)]]
-* 2021-08... was encouraged by MS Access upgrade team to start a new incident for this (INC000004781738)
+* 2019-07-24 - [[Re-platforming to REDCap (failed)]]
-* 2021-02-12 - Summary of the last few months: we put in a "Provincial Intake" request with the help of Alex Omsen; Shelley Irving Day agreed to be the required executive level support; there is ongoing conversation at the leadership level how our database fits into ongoing needs and once that is decided we will hopefully move toward a solution.
+* 201? - [[Re-platforming to DSS SQL Server (failed)]]
+* 201? - [[Re-platforming to CCMDB Server (failed)]]
-=== older history ===
+* 2008-ish: [[Re-platforming to Oracle Apex (failed)]]
-* a long time ago we tried to set up our own server within the Shared Health system; they initially offered to make this safe and doable within their network but then the price tag was to the moon, and they would not have allowed us to access this network from the rest of the network so no use
-* there was at least one meeting at some point to which Kym Morris was also invited
-* 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 was in place: we were able to add/edit/remove tables and access them via an MS Access front end through ODBC. Then some decision was made that made this not a feasible solution, might have been when Trevor Strom left
 == Related articles ==
 {{Related Articles}}
+[[Category:Re-platforming | *]]
 [[Category:eHealth]]
 [[Category:Warehouse]]
 [[Category:Data Repository]]