nd.gov - The Official Portal for North Dakota State Government
North Dakota: Legendary. Follow the trail of legends

DHS FRAME Production Data Warehouse Upgrade and ETL change

June 21, 2013 - 10:00pm - June 23, 2013 - 11:49am

At 10 PM Friday, the current FRAME ETL will run to load the Oracle 10g Data Warehouse(DW) with DB2 as the data source and at the same time the new FRAME ETL will run to load the new Oracle 11g Data Warehouse(DW) with the CDC as the data source. The current ETL will be done in 5-6 hours and the new ETL will be complete in 30 minutes.
Cognos reports will be run against the old DW and the new DW and compared for differences.
The NYTD and NCANDS reports will be changed to point to the new Oracle 11g DW in order to run comparisons between the 10g Data Warehouse and the 11g Data Warehouse.
The Cognos DW reports and NCANDS and NYTD reports will continue to point to the new 11g Data Warehouse if the comparisons are good.

Who's Affected

FRAME Users running Reports from the Data Warehouse


What Our Customers Are Saying

Thanks for completing this so quickly!

Bank of North Dakota
September 11, 2014