ESRI遗留Arcsde读者参数
Database Connection
![关闭](http://www.baooytra.com/docs/fme/2017.0/html/FME_Desktop_Documentation/FME_ReadersWriters/Skins/Default/Stylesheets/Images/transparent.gif)
- OS Authentication通过通过操作系统验证用户名和密码,提供要连接到SDE服务器的必要信息。如果你选择Parameters, you will have to fill in the username and password fields.
- 从连接文件填充...将填写Database Connectionparameters with values extracted from an Esri Connection File. If selected, a file chooser dialog will open, and you can navigate to and select the desired connection file.
Once selected and confirmed, all theDatabase Connection除密码之外的参数将从连接文件中的数据填充。这个选项特别有用的是确保Instanceparameter is correct for direct connections.
Note that this option requires the installation of a compatible and licensed version of ArcGIS.
![关闭](http://www.baooytra.com/docs/fme/2017.0/html/FME_Desktop_Documentation/FME_ReadersWriters/Skins/Default/Stylesheets/Images/transparent.gif)
Enter the ArcSDE server name.
![关闭](http://www.baooytra.com/docs/fme/2017.0/html/FME_Desktop_Documentation/FME_ReadersWriters/Skins/Default/Stylesheets/Images/transparent.gif)
此字段标识从中检索的特征的SDE数据库。在SDE中,数据集被称为数据库。Set Translay参数对话框的源DataSet区域将默认为SDE,这是您最常使用的数据集名称。无论SDE的底层RDBMS,都需要该字段。一些RDBMSE(如Oracle)不需要值,而其他RDBMSES则不需要值。对于不需要该值的数据库,将忽略该字段。
![关闭](http://www.baooytra.com/docs/fme/2017.0/html/FME_Desktop_Documentation/FME_ReadersWriters/Skins/Default/Stylesheets/Images/transparent.gif)
输入用户名和密码以访问数据库,用户帐户或需要身份验证。
![关闭](http://www.baooytra.com/docs/fme/2017.0/html/FME_Desktop_Documentation/FME_ReadersWriters/Skins/Default/Stylesheets/Images/transparent.gif)
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:
![关闭](http://www.baooytra.com/docs/fme/2017.0/html/FME_Desktop_Documentation/FME_ReadersWriters/Skins/Default/Stylesheets/Images/transparent.gif)
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.
约束
![关闭](http://www.baooytra.com/docs/fme/2017.0/html/FME_Desktop_Documentation/FME_ReadersWriters/Skins/Default/Stylesheets/Images/transparent.gif)
Specifies whether to keep the table qualifier. The full name of a table in a database is of the format:
Depending on the database format, theprefix可
Selecting this parameter indicates that the reader should return the table name without any prefixes. This is useful, for example, when creating a workspace that will be passed on to another organization using the same table names, or performing a translation to another database format but with a different user name.
When this parameter is selected during workspace generation, the source feature types will be the table names without any prefix; otherwise, they will contain the owner name as a prefix. It is recommended that you do not change this parameter after generating the workspace, because it is possible for no features to be successfully passed onto the writer (since the writer is expecting feature types with different names).
Note:Even when this parameter is selected, if the table is owned by a user other than the current user, the prefix will not be dropped. This is to ensure that the reader will find the correct table.
![关闭](http://www.baooytra.com/docs/fme/2017.0/html/FME_Desktop_Documentation/FME_ReadersWriters/Skins/Default/Stylesheets/Images/transparent.gif)
Click the Browse button to select tables for export. You may only select this after you’ve 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.
![关闭](http://www.baooytra.com/docs/fme/2017.0/html/FME_Desktop_Documentation/FME_ReadersWriters/Skins/Default/Stylesheets/Images/transparent.gif)
输入任何SQL,其中约会在图层列表中选择的图层的属性(例如,numlanes = 2)。
架构属性
![关闭](http://www.baooytra.com/docs/fme/2017.0/html/FME_Desktop_Documentation/FME_ReadersWriters/Skins/Default/Stylesheets/Images/transparent.gif)
Use this parameter to expose Format Attributes in Workbench when you create a workspace:
- 在动态方案中,它意味着这些属性可以在运行时传递到输出数据集。
- In a non-dynamic scenario where you have multiple feature types, it is convenient to expose additional attributes using this 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.
![关闭](http://www.baooytra.com/docs/fme/2017.0/html/FME_Desktop_Documentation/FME_ReadersWriters/Skins/Default/Stylesheets/Images/transparent.gif)
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 intersect with the bounding box are returned.
If all four coordinates of the search envelope are specified as 0, the search envelope will be disabled.
![关闭](http://www.baooytra.com/docs/fme/2017.0/html/FME_Desktop_Documentation/FME_ReadersWriters/Skins/Default/Stylesheets/Images/transparent.gif)
选择后,此参数删除在搜索信封外部读取的导入功能的任何部分。
下面的示例说明了搜索信封的结果Clip to Search Envelopeis not selected (set to No) and when it is selected (set to Yes).
- No: Any features that cross the search envelope boundary will be read, including the portion that lies outside of the boundary.
- 是:跨越搜索信封边界的任何功能将在边界处剪切,只会读取边界内部的部分。潜在的功能Clip to Search Envelope功能是一个十字路口;但是,当Clip to Search Envelopeis selected, a clipping operation is also performed in addition to the intersection.