span8
span4
span8
span4
How do I connect to my ArcSDE Geodatabase using Direct Connect?
Connecting to an ArcSDE Geodatabase using the Direct (or 2 Tier) method has become the default standard as of ArcGIS 10.1.See The Notes on FME and Esri Compatibilitypagefor more information on what software is required to support this method.For additional information please consult the Esri documentation onDirect Connecting.As of FME 2015 the Geodatabase (ArcSDE) format supports the use of the Esri connection .sde files only.So building and testing your connection in ArcCatalog prior to using FME is recommended.Then this connection file can be used by the Geodatabase (ArcSDE) formats.Older versions of FME also use the Esri connection files or you can setup the Geodatabase (ArcSDE) format connection using the information below.
TheEsri Legacy ArcSDEformat will continue to need the following information.FME 2015 adds an option to the Connection dropdown - "Populate from Connection File" that will pre-fill the connection parameters based on what you are using in your Esri geodatabase connection file (.sde).This makes it easier to ensure that you are using the right connection parameters for your various connections.
Notethat support for the ArcSDE SDK ended for ArcSDE 10.2,refer to theComparison of FME readers and writers for SDE and Geodatabase
If connecting to SDE on Oracle,use the following settings in the Esri Legacy ArcSDE reader or writer database connection dialog box.
Note: Oracle Client Values "oracle10g" if you are using an Oracle 10g client,"oracle11g" if you are using an Oracle 11g client or "oracle" for an Oracle 12c client.Our testing has shown that using "oracle" or "oracle11g" also works for the Oracle 12c client.
Connection: Parameters* Server:* Database: e.g.sde * Instance Name: sde:oracle: e.g.sde:oracle11g:MyOracleService
* User ID:e.g.scott* Password: e.g.tiger* Version: SDE.DEFAULT
Alternatively:
Connection: Parameters* Server:* Database: e.g.sde * Instance Name: sde: : / e.g.sde:oracle10g: /SID* User ID: e.g.scott* Password: e.g.tiger* Version: SDE.DEFAULT
Also readthis articleabout the Oracle client that is required.
If connecting to SDE on SQL Server,use the following settings in the Esri Legacy ArcSDE reader or writer database connection dialog box.
Connection: Parameters* Server:* Database: e.g.sde * Instance Name: sde:sqlserver: e.g.sde:sqlserver:myhost* User ID: e.g.scott* Password: e.g.tiger* Version: DBO.DEFAULT
If connecting to SDE on anamed SQL Server instance,use the following settings in the Esri Legacy ArcSDE reader or writer database connection dialog box.
Connection: Parameters* Server:* Database: e.g.sde * Instance Name: sde:sqlserver: \ e.g.sde:sqlserver:myhost\INST2* User ID: e.g.scott* Password: e.g.tiger* Version: DBO.DEFAULT
If connecting to a Personal SDE Geodatabase on aSQLExpress instance,use the following settings in the Esri Legacy ArcSDE reader or writer database connection dialog box.
Connection: OS Authentication* Server:* Database: e.g.CityData * Instance Name: sde:sqlserver: \ e.g.sde:sqlserver:myhost\SQLEXPRESS* User ID: * Password: * Version: DBO.DEFAULT
If connecting to SDE on PostGreSQL,use the following settings in the Esri Legacy ArcSDE reader or writer database connection dialog box.
Note: In order to connect to a PostGreSQL Geodatabase you must have the correct PostGreSQL client libraries provided by Esri in your ArcGIS bin directory.See this section in theEsri Help.
Connection: Parameters* Server:* Database: e.g.PostSDE * Instance Name: sde:postgresql: , e.g.sde:postgresql:myhost,5432* User ID: e.g.scott* Password: e.g.tiger* Version: SDE.DEFAULT
If connecting to SDE on DB2,use the following settings in the Esri Legacy ArcSDE reader or writer database connection dialog box.
Note:In order to connect to a DB2 Geodatabase you must have a DB2 client installed and have cataloged the database on the client machine.
Connection: Parameters* Server:* Database: e.g.sde * Instance Name: sde:db2* User ID: e.g.scott* Password: e.g.tiger* Version: SDE.DEFAULT
Comparison of FME readers and writers for SDE and Geodatabase
Performing spatial queries on database tables using the FeatureReader
Converting to PostGIS: Write to an Existing Table
Viewing and Inspecting PostGIS Data
What is an ESRI .mdf Geodatabase file or Esri Personal SDE Geodatabase?
Updating,Inserting and Deleting features in an unversioned Geodatabase
FME and Esri ArcGIS Troubleshooting Guide
Converting to PostGIS: Create,Drop or Truncate a Table
Unable to Connect to Database After Upgrading to ArcSDE 10.1 or Above
© 2019 亚搏在线Safe Software Inc |Legal