Book Image

Implementing Oracle Integration Cloud Service

Book Image

Implementing Oracle Integration Cloud Service

Overview of this book

Discover how to use ICS to solve your integration needs with this Oracle Cloud book. Written by Oracle ACE Robert and ACE Associate Phil, you?ll learn how to deliver business value using ICS. ? The only guide to Integration Cloud Service on the market ? A comprehensive guide to building successful integrations on ICS ? Features practical examples and handy tools
Table of Contents (21 chapters)
Implementing Oracle Integration Cloud Service
Credits
Foreword
About the Authors
About the Reviewer
www.PacktPub.com
Customer Feedback
Preface

Calculated filenames


We can also configure the integration to name the file or target folder based on the integration payload. Within a mapping view, you will be able to see an entry called OutboundFTPHeaderType, within this are elements called fileName and directory. By manipulating these values, we can dynamically set the filename and location of the output.

For example, if we are going to set the filename to be the test Id followed by the actual Id element from the source and set to be a .txt file, we can get a result such as Id9001.txt for a file. To do this we need to concatenate the literal values with Id element from the source. Click on the value filename on the target side of the tree to access the Build Mappings screen. Once in the Mapping screen, we need to drop the concat function onto the statement side of the editor (concat can be found by navigating the left menu to Mapping Components | Functions | String).