This dialog box is part of Safe Software's Feature Manipulation Engine (FME). It is not available with FME Base Edition.
Database Connection
- Connection - OS Authentication provides the necessary information to connect to the SDE server, by validating the username and password through the operating system. If you choose Parameters you will have to fill in the username and password fields.
- Server - Enter the ArcSDE server name.
- Database - This field identifies the SDE database from which features are retrieved. In SDE, the dataset is referred to as the Database. The Source Dataset area of the Set Translation Parameters dialog box will default to sde, which is the dataset name you will use most often. This field is required no matter what 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.
- Username and Password - Enter the username and password to access the database, user account, or wherever authentication is required.
- Instance - The instance to which FME is to connect. The usual value for systems with a single SDE instance is esri_sde. 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).
- Version - 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.
Constraints
- Remove Schema Qualifier - When selected, the table name's prefix is dropped. The prefix includes the database name, where applicable (i.e. SQL Server), and the owner name if the owner name is the same as the currently connected user.
- Table List - Click the Browse button to select tables for export. You may only select this after you have completely specified the database connection.
After you click the Browse button, The ArcSDE Table List Extraction window appears while the system compiles a table list from the database. Once the table list appears, you can select one or more tables and then click OK to dismiss the window. The table name(s) will appear in the table list field in the Input Settings dialog.
- Where Clause - Enter any SQL where clause that constrains the attributes of the layers selected in the layer list (for example, NUMLANES=2).
Schema Attributes
- Additional Attributes to Expose - This parameter exposes Format Attributes in Workbench when you create a workspace:
In a dynamic scenario, it means these attributes can be passed to the output dataset at runtime.
In a non-dynamic scenario where you have multiple feature types, it is convenient to expose additional attributes from one parameter. For example, if you have ten feature types and want to expose the same attribute in each one, it is easier to define it once than it is to set each feature type individually in the workspace.
Search Envelope
- Use Search Envelope - Using the minimum and maximum x and y parameters, define a bounding box that will be used to filter the input features. Only features that interact with the bounding box are returned.
If all four coordinates of the search envelope are specified as 0, the search envelope will be disabled.
- Clip to Search Envelope - Check this box if you want to remove any portions of exported features outside the area of interest.
Defaults button
Click to save or reset default settings.
- Save as My Defaults - Edit a field, and then choose this option to save the parameter.
- Reset to FME Defaults - Changes the fields back to the standard (FME) defaults.
- Reset to My Defaults - If you manually edit a field, you can reset it back to your own defaults. Note that you cannot restore your own defaults after resetting to FME defaults.
OK
Closes the dialog box and applies your settings.