Re-platforming: Difference between revisions

(35 intermediate revisions by 2 users not shown)

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.accdb]].

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

* [[Requirements for Re-Platforming]]

~~=== Things that would need to work to get started ===~~

~~One question that remains is:~~

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

~~{{DiscussSteering |~~

* Administrative and governance considerations

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

* What would be the terms and conditions of us using this repository

Line 24:

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

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

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

[[Category: eHealth]]

[[Category:Re-platforming | *]]

[[Category: Warehouse]]

[[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]]. We are investigating storing the data with [[Decision Support Services]].
+CCMDB will eventually outgrow Microsoft Access as a storage format for our [[Centralized_data.accdb]].
 == 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.
+* [[Requirements for Re-Platforming]]
-=== Things that would need to work to get started ===
-One question that remains is:
-* {{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:
-{{DiscussSteering |
-* Administrative and governance considerations
-** Discussed at Steering, Allan will book meeting with Phil Jarman to discuss. Ttenbergen 14:07, 2018 April 9 (CDT)}}
 * What would be the terms and conditions of us using this repository
@@ Line 24: / 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 ===
+* [[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]]
+* 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: eHealth]]
+[[Category:Re-platforming | *]]
-[[Category: Warehouse]]
+[[Category:eHealth]]
+[[Category:Warehouse]]
+[[Category:Data Repository]]