Integration Cloud 7.0.0 | Reference Data | Overview
 
Overview
Reference data is data that defines the set of permissible values to be used by other data fields. It is a collection of key-value pairs, which can be used to determine the value of a data field based on the value of another data field. For example, the value of a status field in an Application can be “Canceled” and that needs to be interpreted as “CN” in another Application. If you have the required project permissions under Settings > Project Permissions, you can create, update, or delete a Reference Data.
Integration Cloud allows you to upload Reference Data from a text file containing tabular data separated by a character, for example, a comma, semicolon, and so on. The uploaded file should not have an empty column heading or space in the first row, and the first row cannot be empty.
Note:
See this video on how to upload Reference Data, access the uploaded Reference Data in an Orchestrated Integration, and view the input and output parameters.
The Reference Data block appears under Services in the Orchestrated Integration workspace, only after you have created a Reference Data. See Reference Data Signature for information on the Input and Output parameters. The Reference Data is also available in Point-to-Point Integrations while transforming data. You can access the uploaded Reference Data in Orchestrated Integrations as a list of documents by using the Reference Data block and providing an appropriate name. You can filter the documents returned into the pipeline by the Reference Data block.
You can create a Reference Data only in the Development stage but can view, edit, delete, and download the Reference Data in all stages. The Status column in the Reference Data table displays Configured if the Reference Data is available in the current stage (Stage in view) and displays Not Configured if the Reference Data is not available in the current stage but available in any other stage. You can Delete or Download a Reference Data if the Reference Data is available in the current stage. You can Edit a Reference Data in all stages. The Download option allows you to download the previously uploaded Reference Data, edit it, and then upload the modified file. In this way you can upload different sets of data in different stages.
You can pull an Integration only if the Integration is consistent in the source stage, that is, all references of the Integration are present in the source stage. While pulling an Integration from the source stage to the target stage, if the same Reference Data is not available in the target stage, then you must configure the Reference Data in the target stage. If the same Reference Data is available in the target stage with a signature mismatch, for example, the number of columns or the column names are not the same, then you can either reconfigure the Reference Data or skip the reconfiguration. If the Reference Data is already available in the target stage and the signature is same as in the source stage, then it will not be copied from the source stage to the target stage while pulling the Integration.
Note:
If a Reference Data is in the Development stage, the Reference Data can be deleted even it is referenced or used in an Integration. Integrations using the deleted Reference Data will be in an inconsistent state.
If a Reference Data is in a stage other than the Development stage, the Reference Data can be deleted only if it is configured in that stage and not used in any Integration.