Import to a Static Data Collection

In the Reliability Data Warehouse, a custom connection provides a live link to an external database or XFRACAS report, while a static data collection stores data that was extracted at a particular point in time.

A static data collection can contain data extracted directly from XFRACAS. If desired, you can also create a static data collection by importing data from a custom connection. To do this:

1. Right-click the custom connection in the data source manager and choose Import.
2. In the Import Data from Custom Connection window:
   1. The Map Data Source Fields to Columns section specifies which field from the custom connection will be mapped to a column that’s available in a data collection.
   2. The Define Values as Failures/Suspensions section displays all of the unique values from the field that is currently mapped to the State FS column. Specify whether each value should be considered a failure or a suspension.
   3. The Preview tab allows you to see what the data collection will look like based on your selections.
3. Click OK to create the static data collection.