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:
Right-click the custom connection in the data source manager and choose Import.
In the Import Data from Custom Connection window:
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.
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.
The Preview tab allows you to see what the data collection will look like based on your selections.
Click OK to create the static data collection.