Re-platforming: Difference between revisions

(30 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]].

~~{{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 ==

* ~~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.~~

* [[Requirements for Re-Platforming]]

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

== Administrative and governance considerations ==

Line 18:

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)

== Log ==

=== 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

* [[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]]

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

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

** ~~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.~~

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

[[Category:Re-platforming | *]]

[[Category: eHealth]]

[[Category:eHealth]]

[[Category: Warehouse]]

[[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]].
-{{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 ==
-* 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.
+* [[Requirements for Re-Platforming]]
-* Who will be allowed to program and implement changes on this system?
 == Administrative and governance considerations ==
@@ Line 18: / 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)
-== Log ==
+=== 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
+* [[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]]
-* 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
+* 2023-03 - [[Re-platforming to SalesForce (failed)]]
-** 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.
+* 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:eHealth]]
-[[Category: Warehouse]]
+[[Category:Warehouse]]
+[[Category:Data Repository]]