You are here: Workflows > SQLExecutor

SQLExecutor

Performs SQL queries against a database.

One query is issued to the database for each feature that enters the transformer. The results of the query are then output through the Result port.

Input Ports

Output Ports

Parameters

Usage Notes

Features that enter this transformer are not outputted until the SQL query completes. This behavior ensures that additional SQLExecutor transformers, if present, do not execute their queries until the previous query completes.

Relationship to FeatureMerger

The FeatureMerger joins two datasets and uses a simple, single attribute key to match features. The FeatureMerger is also able to perform certain geometric operations on incoming features using its Merge Type parameter.

Relationship to InlineQuerier

The InlineQuerier can be thought of as the crafty cousin of the SQLCreator/SQLExecutor transformers, in that it allows the power of SQL to be applied to datasets originating from non-SQL capable data sources or disjoint SQL-capable sources.

If all the data to be queried already exists in a SQL-capable data source, it is always more efficient to use the SQLCreator or SQLExecutor, because this allows the queries and filtering of the data to be executed directly by the database before it enters the FME environment.

Relationship to DatabaseJoiner

The DatabaseJoiner is very useful and efficient when there exists a one-to-one or one-to-many relationship between data flowing through FME and data held within a database. If it can be used, the DatabaseJoiner can be more efficient than using either the InlineQuerier or SQLCreator/SQLExecutor, provided that the DatabaseJoiner key fields have indexes in the source database. The DatabaseJoiner is simple to use and does not require any knowledge of SQL.

Example

Editing Transformer Parameters

Using a set of menu options, transformer parameters can be assigned by referencing other elements in the workspace. More advanced functions, such as an advanced editor and an arithmetic editor, are also available in some transformers. To access a menu of these options, click beside the applicable parameter. For more information, see Transformer Parameter Menu Options.

Transformer Categories

Workflows

 

Search FME Knowledge Center

Search for samples and information about this transformer on the FME Knowledge Center.