Introducing OCI ECS 7.3.3+ Datasource (replacing Deprecated ECS Datasource)

on

Contents

  • Introduction
  • Where Was Old ECS Data Found?
  • Changes That Are Required?

Introduction

EMC ECS object data (also Atmos and Centera) - prior to NetApp OnCommand Insight OCI 7.3.3 - was using the Cloud schema. EMC ECS for OCI 7.3.3+ uses the Inventory schema.

Image: ECS vs ECS for OCI 7.3.3+


Where Was Old ECS Data Found?

From a Recharge (Chargeback) Reporting perspective, most of our ‘Recharge Reports’ (for NAS, SAN, VMs) use the dwh_inventory schema.

For object pre 7.3.3 we had to use the following core set of tables, as illustrated in the MySQL query below:

SELECT *
FROM `dwh_capacity`.`chargeback_fact` AS cf
JOIN `dwh_capacity`.`business_entity_dimension` AS `bed` ON bed.`tk` = cf.`businessEntityTk`
JOIN `dwh_capacity`.`date_dimension` AS d ON d.`tk` = cf.`dateTk`
WHERE cf.`dateTk` = (SELECT MAX(`dateTk`) FROM `dwh_capacity`.`chargeback_fact`)

We also used custom tables too, mainly due to the lack of annotations on Cloud schema data. Annotations for things like:

  • Name, Identifier, Region, Country, Legacy, Tier, building
  • id, subtenant, costcode, service, bucket

Changes That Are Required?

When we change our ECS datasources to the ECS 7.3.3+ datasource:

  1. Any reports will need a UNION to add in dwh_inventory object data (old style data could be removed once all the old datasources have been demised.)

  2. Any annotation data (as provided by the tables mentioned above) can be inputted directly into the OCI WebUI (i.e. we’ll need to make sure the new data is annotated correctly.)

Future decommissioning (once all old Cloud schema Object datasources have been demised would be):

  1. Remove old Cognos report SQL queries that used dwh_capacity.chargeback_fact and dwh_capacity.business_entity_dimension.

  2. Remove obsolete dwh_custom object annotation tables.

That’s it!

Note: This will also bring new StorageGRID Object data (using OCI 7.3.3+ datasource) - that is already in dwh_inventory - into the Object Recharge report.

Comments

Post a Comment