Performs queries on an ArcSDE spatial database. The queries can have both a spatial and a nonspatial component.
One query is issued to the ArcSDE database for each feature that enters the transformer. The results of the query are then output to the output port that matches the table name, if it exists; otherwise, results are output to the OTHER port.
If the Mode parameter is set to Delete, the results of the query are deleted from ArcSDE before they are output from the transformer. If the Mode parameter is set to Update, the features in ArcSDE matching the query feature will be updated with that feature's complete set of attributes.
The query feature defines the geometry which will be used to define the spatial component of the query, unless the search method is SDE_NONE. In that case, only an attribute query as defined by the WHERE clause will be executed.
An attribute named _table_name will be added to each result feature, specifying which table the result feature came from.
An attribute named _matched_records will be added to each query feature, specifying how many database rows the query matched.
The ArcSDE server name.
The instance to which FME is to connect. The instance can also be of the form port:<port-number>, which is usually port:5151 (you may have to confirm this with your System Administrator).
This field identifies the SDE database from which features are retrieved. In SDE, the dataset is referred to as the Database. This field is required regardless of the underlying RDBMS of the SDE. Some RDBMSes, such as Oracle, do not require a value, whereas others, such SQLServer, do. For databases that do not require the value, the field will be ignored.
The username and password to access the database. This overrides the ODBC DSN settings.
The SDE version to which FME connects. The version must already exist and the current user must have privileges set so that it can access the version. If the VERSION_NAME directive is not used, then FME attempts to connect to SDE.DEFAULT. If there is no SDE schema, FME then attempts to connect to dbo.DEFAULT. If the name is not prefixed by the owner of the version, then it is assumed that the owner is the current user. This setting is only applicable when dealing with versioned tables.
If the Remove Table Qualifier parameter is set to Yes, then user names will not be included in table names when they are not required.
If the Table Name in Attribute parameter is blank, the set of tables to query is defined by the Tables parameter, which is set in the "Select Tables" panel. Alternatively, if the Table Name in Attribute parameter is not blank, the tables to query are read from the specified attribute in the input features. In this case, the tables to query should be specified as a colon-separated list.
The Search Order parameter controls the manner in which the search is performed. If Optimize is specified, then the SDE engine decides how to perform the search. If Attribute First is specified, then the attribute portion of the search is performed first and then the spatial component is performed on the set resulting from the attribute set. If Spatial First is specified, then the spatial search is performed first and then the attribute search is performed on the resulting set. This is useful if the Optimize setting makes the wrong choice and you want to force the search to be performed in a different order.
- Result Attributes Only: result feature attributes are based solely on the query results.
- Keep Query Attributes if Conflict: result feature attributes are a combination of both the query results and the query feature's attributes. If there is a conflict, attribute values are taken from the query feature.
- Keep Result Attributes if Conflict: result feature attributes are a combination of both the query results and query feature's attributes. If there is a conflict, attribute values are taken from the query results.
- Result Geometry Only: result feature geometry is taken from the query results.
- Query Geometry Only: result feature geometry is taken from the query feature.
- Aggregate Query and Result Geometry: result feature geometry is an aggregate of the geometry from the query feature followed by the geometry from the query results.
Specifies whether or not duplicate features will be output from the transformer. If the Mode parameter is set to Update, this parameter also specifies whether duplicate updates will be performed.
Specifies whether or not the relationships between the query and result geometries should be computed. Refer to the SDE30QueryFactory factory documentation for more information.
A persistent connection is useful for workspaces that are published using FME Server.
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.
FME Licensing Level
FME Professional Edition and above
Search FME Knowledge Center
Search for samples and information about this transformer on the FME Knowledge Center.