Format

This describes a flat file for use with BODS

The Formats tab, right-click, and click on New.

Define the file format, location, field types, and names.

Formats can be either source or target in data flows.

Datastore

This defines a link to a database

The Datastore tab, right-click, and click on New.

Choose datastore type, database type, and enter connection information.

Use a datastore as either source or target in data flow.

Use existing tables as a source, use template tables or existing tables as targets. Template tables will be created, then take the structure of input data.

Transformation

This describes a modification to make to data as it is transferred

In a data flow, add a transformation of appropriate type according to business needs between source and target. Several transformations can be linked in series in a data flow.

Function

This allows...