Integrator ETL Designer provides an easy-to-use interface you can use to create graphs for loading and updating your data quickly.
A graph is essentially a pipeline of components that processes the data. The simplest graph has one Reader component to read in the source data and one of the Information Discovery components to write (send) the data to the Endeca data domain. More complex graphs will use additional components, such as Transformer and Joiner components.
Integrator ETL, with its powerful graphical interface, provides an easy way to graphically lay out even complex graphs. You drag and drop the components from the Palette and then configure them by clicking the component icon.
The Integrator ETL perspective consists of four panes and the Palette tool, as shown in this example:
- The Navigator pane lists your projects, their folders (including the graph folders), and files.
- The Outline pane lists all the components of the selected graph.
- The Tab pane consists of a series of tabs (such as the Properties tab and the Console tab) that provide information about the components and the results of graph executions. The illustration shows the Log tab listing the output of a successful record loading operation.
- The Graph Editor pane allows you to create a graph and configure its components.
- The Palette allows you to select a component and drag it to the Graph Editor.
For more information on the Integrator ETL user interface, see the Oracle Endeca Information Discovery Integrator ETL Designer Guide.
