ImpacDW

The current data warehouse, known as ImpacDW, is a Microsoft SQL Server database consisting of data from various source systems (such as ICLS, SBO, MOS, etc.) populated primarily through nightly SQL Server Integration Services (SSIS) jobs.  The current location is: ifcdw\instifcdw,2457

 

IMDW

The original data warehouse, known as IMDW, is an Oracle database primarily populated through nightly Business Objects Data Integrator (BODI) jobs.  This database was geared towards end-user adhoc querying/reporting.  This database along with the BODI jobs are only supported from a break/fix perspective, there is no new development taking place in this environment and end-users should be working towards migrating away from this server and moving onto the new ImpacDW SQL server data warehouse.

 

DW

Another data warehouse, known as DW, is an Oracle database primarily populated through nightly Business Objects Data Integrator (BODI) jobs.  This database was geared towards IT developed Business Objects reports and user reporting via the BO reporting tools.  This database along with the BODI jobs are only supported from a break/fix perspective, there is no new development taking place in this environment and end-users should be working towards migrating away from this server and moving onto the new ImpacDW SQL server data warehouse.