What's New in 20R2.1

The Nitro 20R2.1 release includes several new features.

Our release notes offer brief, high-level descriptions of enhancements and new features. Configuration is available by selecting the feature name.

Features

Platform

Data Quality Scorecard

Nitro’s data quality framework gives system administrators and data analysts the ability to easily configure complex data quality check rules without having to write SQL. Using the Nitro Admin Console, users instantiate quality checks that leverage templates delivered by Veeva. Once created, users can execute the rules and view or download the results.

Two data quality checks are available to detect data quality issues in loaded data, allowing admins to take corrective action to keep customer data accurate, complete, and reliable. Admins can now define a data quality check rule by adding a few parameters. Data quality check results are returned in real time. A context columns parameter allows admins to get more insight while previewing data quality check violations.

The following data quality checks are available:

  • Duplicate IDs - Identifies duplicate values in a table column selected by the Admin using a Quality Check Template. Admins use a Named Query to enter values for the table object and table key columns. This check uncovers duplicate violations in dimensions and facts, which is not covered in Nitro standard loading validation.
  • Referential Integrity - Finds records in the child table that have attribute values not present in the parent table. Admins use the Named Query template to enter values for the parent table object, parent table join column, child table object, and child table join column parameters.

Adding Extension Objects

Extension Objects allow users to extend the Nitro Data Model for FTP Industry Connectors. Nitro Industry Connectors are managed by Veeva. Users cannot change the Nitro data model, however by using extension tables, users can extend the following parameters:

  • Table enabled
  • Table loadPattern
  • Column colOrder
  • Column label
  • Column enabled
  • Column columnBehavior
  • Introduce new columns

Supporting Shapeshifting for FTP Intelligent Load

Changing file layouts for data being loaded into Nitro previously required that redshift tables be manually adjusted to match the new file layout. Users are now able to remove columns from a table and add columns to the end of existing redshift tables in FTP connectors without having to manually manipulate the redshift tables. The removed columns remain in the ODS, without new updates to these fields.

Analytics

Global ODS: Demographic Cross Reference

A new Demographic Cross Reference table (demographic_xref_gbl_ods_v) allows users to map multiple identifier fields to a single demographic dimension record. Data sources use multiple account identifier fields, for example, NPI and ME number. All key identifier fields from Network and CRM are then mapped to the Demographic Cross Reference table in the Global ODS.