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 19, 2013 - 7:00pm - June 20, 2013 - 11:59am

On June 19 @ 7 PM the current FRAME ETL will run to load the Oracle 10g Data Warehouse 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 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.

On June 20th, the NYTD and NCANDS reports will be changed to point to the new Oracle 11g Data Warehouse in order to run comparisons between the 10g Data Warehouse and the 11g Data Warehouse. The comparisons will be completed by noon.

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

Thank you for the speedy resolution

Traill County Social Services
January 8, 2015