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.

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.