Process for Setting Up Oracle Database for Cobalt Module
in TR Internal
I've been recently working on setting up a new module on the Cobalt platform that is backed by an Oracle database. The administrative process for defining the database through requesting its deployment has not been especially clear. Could someone list out the steps and CRs required to get this into place? Also how hand off works between development, CM and Ops. Does the process change if the module is already deployed in PROD and the addition of the database is release dependent?
Tagged:
0
Best Answer
-
Good question Ryan. The development teams have taken a couple of differet approaches for setting up schemas in Dev environments. Either working directly with DBAs or by setting the schemas up by themselves and taking DBA feedback. In anycase, we CM like to be involved early in the game to make sure we understand what it takes to bring the new module up in the higer environments. 1. **CI** : Engage the DBAs to create the schema for the new module. Loop in CM so we know that there is a DB dependency for the module setup in upper environments. (Invite CM to the meeting with DBA - we will engange other parties as needed). Developers own the CI schemas. Once the schemas are created the developers can make any schema changes as they see fit 2. **Demo**: CM created the schema setup tickets for DBAs using the schema setup scripts provided by the developers. Any schema changes in Demo after the setup have to be communicated to CM before 2:00 PM everyday. Use appropriate database change request workitem in TFS Central (online:
http://tfsnpt.int.thomson.com:8080/tfs/web/UI/Pages/WorkItems/
WorkItemEdit.aspx?pguid=a26dfa46-07f4-435a-9801-ecc5393f39e9&wit=Db+Change+Request-Online). Please note that 2:00 PM is a hard deadline DBAs set for CM to ensure the schema changes are out there before the next day's demo deploy. *CM hosts DB schema change review meetings two times in the iterations where the developers and the DBA's participate to review the schema changes. Contact CO_CM_TECH if you need an invite to this meeting/conf call* 3. **QED and Up** - all schema changes are identified by the release.iteration identified in the database change request workitem. CM runs a query before each release to identify the list of schema changes across all modules and submit tickets for respectibe DBA teams Hope this makes sense.3
Answers
-
Thanks Lavanya, that helps a lot.0
Categories
- All Categories
- 6 AHS
- 37 Alpha
- 161 App Studio
- 4 Block Chain
- 4 Bot Platform
- 16 Connected Risk APIs
- 47 Data Fusion
- 30 Data Model Discovery
- 608 Datastream
- 1.3K DSS
- 577 Eikon COM
- 4.9K Eikon Data APIs
- 7 Electronic Trading
- Generic FIX
- 7 Local Bank Node API
- Trading API
- 2.7K Elektron
- 1.3K EMA
- 236 ETA
- 519 WebSocket API
- 33 FX Venues
- 10 FX Market Data
- 1 FX Post Trade
- 1 FX Trading - Matching
- 12 FX Trading – RFQ Maker
- 5 Intelligent Tagging
- 2 Legal One
- 20 Messenger Bot
- 2 Messenger Side by Side
- 9 ONESOURCE
- 7 Indirect Tax
- 59 Open Calais
- 264 Open PermID
- 39 Entity Search
- 2 Org ID
- PAM
- PAM - Logging
- 8.4K Private Comments
- 6 Product Insight
- Project Tracking
- ProView
- ProView Internal
- 20 RDMS
- 1.4K Refinitiv Data Platform
- 367 Refinitiv Data Platform Libraries
- 3 Refinitiv Due Diligence
- LSEG Due Diligence Portal API
- 3 Refinitiv Due Dilligence Centre
- Rose's Space
- 1.1K Screening
- 18 Qual-ID API
- 13 Screening Deployed
- 23 Screening Online
- 10 World-Check Customer Risk Screener
- 990 World-Check One
- 44 World-Check One Zero Footprint
- 45 Side by Side Integration API
- Test Space
- 3 Thomson One Smart
- 1.2K TR Internal
- Global Hackathon 2015
- 2 Specialists Who Code
- 10 TR Knowledge Graph
- 150 Transactions
- 142 REDI API
- 1.7K TREP APIs
- 4 CAT
- 21 DACS Station
- 117 Open DACS
- 1.1K RFA
- 103 UPA
- 172 TREP Infrastructure
- 224 TRKD
- 886 TRTH
- 5 Velocity Analytics
- 5 Wealth Management Web Services
- 59 Workspace SDK
- 9 Element Framework
- 5 Grid
- 13 World-Check Data File
- Yield Book Analytics
- 46 中文论坛