Quick reference
In this section we present a quick reference to the objects covered in this chapter.
Object |
Usage |
Creation |
---|---|---|
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... |