Flat file
You can use the flat file connector to convert documents into and from flat file formats. To set up the conversion, you create the definition and structure of the Flat File connector, which is called a flat file schema. The schema also provides instructions for parsing or generating the flat file, outlining how to identify individual records and specifying the data that is contained within each record.
What is a flat file definition and structure?
The definition and structure of a flat file connector contains the instructions for parsing or creating a flat file. It details the structure of the document, including delimiters, records, and repeated record structures. It also acts as the model against which you can validate an inbound flat file. A flat file structure consists of hierarchical elements that represent each record, field, and subfield in a flat file.
What are the different approaches to create a flat file connector?
- Create manually: In this approach, you define the definition and structure of a flat file connector and then manually add the elements or properties.
- Use a sample file: In this approach, you use a sample file to define the definition and structure of a flat file connector. Here, you use the automated wizards to create the structure of the flat file.
What are the high-level steps to create a flat file connector?
- Define the connector details: In this stage, you define the connector details and the approach. You can create the flat file connector either manually or by using a sample file.
- Define the record parser and specify a record identifier: This step links a record parser to the flat file connector, enabling it to process incoming flat files in webMethods Integration. You also specify how you want the record to be identified after it is parsed.
- Define the flat file structure: When creating the flat file connector manually, this step involves defining the flat file's hierarchical structure by creating and nesting record definitions.