Using multiple engines to reduce job execution time

The grid architecture reduces job execution time by using parallel execution of projects on multiple distributed engines.

To leverage this scalability, you must:

NoteThe terms grid engine and ETL Server are used interchangeably in this guide.

Registering grid engines

After you install grid engines, you can register them for a special repository. When executing a multiengine job from that repository, all projects are executed on those engines.

To register grid engines, select Tools | Engine Manager. If connections to multiple repositories are open, select one of them. The Engine Manager window displays a list of engines that are already registered for the selected repository.

The properties of a registered engine are:

You can register individual or multiple ETL servers manually.

StepsManually registering a grid engine

  1. Select Engine | New, or click the New Insert icon.

  2. Enter the desired values.

  3. Click OK.

StepsRegistering multiple engines

  1. Select Engine | New network search. The New Engines window appears, displaying registration and additional information, as well as the online state of the engine.

  2. Select the engine to register.

  3. Click Add.

NoteClick the Refresh icon on the toolbar or press the F5 key, to update and reload the list of grid engines at any point.

StepsModifying an engine registration

  1. Select the engine in the list and choose Engine | Edit, or click the Edit selected engine icon. Alternatively, double-click the engine in the list.

  2. Rewrite the current values with new values.

  3. Click OK.

StepsDeleting an engine registration

  1. Select the engine you want to delete.

  2. Select Engine | Delete, or click the Delete selected engine icon on the toolbar.