+ Reply to Thread
Results 1 to 36 of 36

Thread: Why would I install ArcSDE with 10.1?

  1. #1
    Alan Toms
    Join Date
    Apr 2010
    Posts
    82
    Points
    8
    Answers Provided
    2


    2

    Question Why would I install ArcSDE with 10.1?

    Hello all,
    Why would I install ArcSDE with 10.1? It seems I can us ArcCatalog to create an enterprise geodatabase without SDE then have all my users use direct connections. What am I missing?

    Thank you
    Alan

  2. #2
    Jake Skinner

    Join Date
    May 2010
    Posts
    1,118
    Points
    629
    Answers Provided
    98


    5

    Default Re: Why would I install ArcSDE with 10.1?

    Hi Alan,

    With ArcGIS 10.1 you can connect to an enterprise database that does not have an SDE geodatabase repository and create feature classes with a native spatial type. For example, you could connect to a SQL Server database and import/create feature classes with the GEOMETRY or GEOGRAPHY spatial type. However, you can only view this feature class. You cannot perform any edits, or have the feature class participate in any geodatabase functionality (such as replication, topology, geometric networks, relationship classes, network datasets, etc). Essentially, you are getting a 'view' only feature class w/o SDE.
    Last edited by JSkinn3; 05-11-2012 at 07:25 AM.

  3. #3
    Russell Brennan
    Join Date
    Oct 2009
    Posts
    149
    Points
    51
    Answers Provided
    8


    16
    This post is marked as the answer

    Default Re: Why would I install ArcSDE with 10.1?

    Alan,

    To further add on to what Jake said...

    Prior to 10.1 (10.0, 9.x, 8.x) if you wanted to use a Geodatabase with all of the cool Geodatabase functionality (versioning, archiving, topology, relationship classes, terrains, geometric networks, etc) on a DBMS (Oracle, SQL Server, Postgresql, Informix, DB2) you had to perform a few steps.

    First, you needed to install ArcSDE onto your machine, usually this was your DBMS server. This install included the files needed to run ArcSDE command line utilities, the application server, as well as the ArcSDE post installer.

    After installing this onto your machine you would need to run the ArcSDE post installer. The main purpose of this post install was to install the Geodatabase into your enterprise database. This includes all the stored procedures, functions, privileges, and schema needed to provide the functionality I mentioned earlier. The post install could also be used to set up your application server.

    The application server can be used to connect from a client machine to the DBMS/Geodatabase. It is used more or less to manage the connection requests coming in from clients and provide a way for the clients to 'talk' to the DBMS. For a while this was the only way to connect to a Geodatabase. At some point (I think 9.0) we added the ability to make direct connections (2-tier: client-DBMS) to the DBMS. This made the use of the application server (3-tier: client-app server-dbms) optional. For some people this meant they stopped setting up the application server and started using direct connections. Others continued using the application server.

    The ArcSDE command line utilities are a method for the Geodatabase administrator to manage data, users, the application server service.

    Fast forward to 10.1 - We have tried to allow you to manage your Geodatabase completely within ArcGIS applications (ArcCatalog, ArcMap, ArcGIS Server, etc). This is done through the use of dialogues in ArcMap/Catalog and the use of geoprocessing. The first thing we did was to break out the installation of the geodatabase schema tasks into geoprocessing tools. If you want to create an enterprise geodatabase there are now two options. Option 1, you can use the 'Create Enterprise Geodatabase' geoprocessing tool. This tool will create a new empty geodatabase in an existing instance. The second option is to use the 'Enable Enterprise Geodatabase' tool will allow you to install the Geodatabase schema in an already existing instance. The new functionality that Jake mentioned that allows you to now connect to a enterprise database (not a geodatabase) is what allow ArcGIS to then enable geodatabase behavior in your enterprise geodatabase. This second option would be used where you have already set up a database, have user permissions assigned and maybe have loaded some data (essentially converting your database to a geodatabase). The first option would be used if you are starting from nothing.

    Esri recommends using direct connections for making connections to your geodatabase, it is not mandatory that you install the application server.

    Much of the commonly used functionality found in the ArcSDE command line utilities is now available either through ArcGIS applications mentioned earlier or through geoprocessing (disconnecting users, identifying locks, loading data, investigating data, etc). For most users the install of these utilities should not be necessary.

    If you determine that you really need the application server or the command line utilities they are available as a separate install.

    So, this has been a pretty long winded answer to a pretty straightforward question. Answer is, it's not mandatory to install the application server or command line utilities. If you want to take advantage of Geodatabase behavior you do need to run one of the geoprocessing tools to install the Geodatabase.
    Last edited by russellb; 10-18-2012 at 08:34 AM.
    Russell
    esri

  4. #4
    Alan Toms
    Join Date
    Apr 2010
    Posts
    82
    Points
    8
    Answers Provided
    2


    0

    Default Re: Why would I install ArcSDE with 10.1?

    Thank you very much for the education.

    Alan

  5. #5
    Shannon S.
    Join Date
    Oct 2009
    Posts
    52
    Points
    54
    Answers Provided
    8


    6

    Default Re: Why would I install ArcSDE with 10.1?

    Hi Alan,

    at 10.1 there is no need to install the ArcSDE software unless you need to run an ArcSDE service. If all of your users are making Direct Connections to the geodatabase then the ArcSDE installation is not necessary. As well, most of the functionality offered by ArcSDE commands is now available in ArcGIS Desktop & through GP tools.

    -Shannon

  6. #6
    Luca Simone
    Join Date
    Apr 2010
    Posts
    6
    Points
    1
    Answers Provided
    0


    0

    Default Re: Why would I install ArcSDE with 10.1?

    the answer from russellb is really clear, but I have another little question:

    what about editing?

    I have some services that I can edit on the web with ArcGIS Server 10.1, should I still use the SDE connection or it is ok to use a direct Connection?
    Is the new ArcGIS Server able to 'replace' or acts as the SDE layer?

  7. #7
    Vince Angelo

    Join Date
    Feb 2010
    Posts
    2,033
    Points
    479
    Answers Provided
    71


    2

    Default Re: Why would I install ArcSDE with 10.1?

    Direct Connect *is* an ArcSDE connection. This thread is about application server install,
    but the ArcSDE functionality still exists -- It's ArcSDE that provides the basis for versioned
    geodatabases. With Direct Connect, it's just a multi-threaded solution in the ArcGIS client
    instead of a multi-processing solution on the database server.

    - V

  8. #8
    Alaa Kutbi
    Join Date
    Feb 2012
    Posts
    4
    Points
    0
    Answers Provided
    0


    0

    Default Re: Why would I install ArcSDE with 10.1?

    You cannot perform any edits, or have the feature class participate in any geodatabase functionality (such as replication, topology, geometric networks, relationship classes, network datasets, etc). Essentially, you are getting a 'view' only feature class w/o SDE.
    Is the qouted text true if I don't install ArcSDE 10.1?

  9. #9
    Marco Boeringa
    Join Date
    Aug 2010
    Posts
    299
    Points
    183
    Answers Provided
    18


    4

    Default Re: Why would I install ArcSDE with 10.1?

    Quote Originally Posted by 61179 View Post
    Is the qouted text true if I don't install ArcSDE 10.1?
    No, it's true, like Russell Brennan wrote, if you don't Create or Enable Enterprise Geodatabase functionality on your database using the new geoprocessing tools in ArcGIS 10.1.

    It has nothing to do with whether or not ArcSDE is installed on your database server. As Vince says, even if you don't use or install it on your database server, ArcSDE is still part of your client ArcGIS application, there are by default DLLs installed on your own computer with ArcGIS that handle the geodatabase SQL logic ---> That is essentially what ArcSDE is!

    E.g., have a look at your "C:\Program Files (x86)\ArcGIS\Desktop10.X\Bin" folder on your local computer. You will see DLLs like "sde.dll" and "sdesqlsrvr100.dll" etc.

    As soon as you attempt to connect to an ESRI Enterprise Geodatabase, these DLLs will be in use by your client ArcGIS application. There is no way around this when connecting to an ESRI geodatabase - at least for full functionality including editing - ArcSDE is just the component ESRI devised to handle the connection to the database and SQL stuff needed to allow advanced geodatabase functionality like versioning.

    There is nothing special about ArcSDE or these DLLs in this respect, other vendors like Bentley or Autodesk have similar software components in their software to handle connections and SQL stuff related to geospatial databases, they just call it differently.
    Last edited by mboeringa2010; 11-18-2012 at 04:58 AM.

  10. #10
    Alaa Kutbi
    Join Date
    Feb 2012
    Posts
    4
    Points
    0
    Answers Provided
    0


    0

    Default Re: Why would I install ArcSDE with 10.1?

    Just to make sure that I understood you correctly.
    What you are saying is I do not need to install ArcSDE on the database server because the client contains the SDE functionality.

  11. #11
    Alaa Kutbi
    Join Date
    Feb 2012
    Posts
    4
    Points
    0
    Answers Provided
    0


    0

    Default Re: Why would I install ArcSDE with 10.1?

    Another way of sying it:

    - I could use direct connection without ArcSDE installed for two-tier topology.
    - I could use ArcSDE to hide or conceal the database in a three-tier topology.

    am I right?

  12. #12
    Marco Boeringa
    Join Date
    Aug 2010
    Posts
    299
    Points
    183
    Answers Provided
    18


    2

    Default Re: Why would I install ArcSDE with 10.1?

    Quote Originally Posted by 61179 View Post
    Just to make sure that I understood you correctly.
    What you are saying is I do not need to install ArcSDE on the database server because the client contains the SDE functionality.
    Yes, this is true, but in a 2-tier Direct Connect situation, be aware you may need to install other additional software like Oracle Client on the client ArcGIS computer, to get the connection to your database up and running. This is not necessary with a separate server side 3-tier installation of ArcSDE.

    Quote Originally Posted by 61179 View Post
    Another way of saying it:

    - I could use direct connection without ArcSDE installed for two-tier topology.
    - I could use ArcSDE to hide or conceal the database in a three-tier topology.

    am I right?
    Yes, that is about the story, although "hide" is probably a bit overstated, you will always have some database related stuff, like database login with username and password, that is there on the client side. And again be aware that for Oracle, you need to install Oracle Client in a two-tier topology, and that it needs to be a 32-bit version, as ArcGIS is still 32-bit.

    Also, rephrasing the first sentence to:

    - I could use direct connection without ArcSDE installed on a server for two-tier topology.

    is probably a bit more accurate, as, as you now understand, ArcSDE is always installed on the client side as part of the ArcGIS installation.

    ArcSDE is the engine of the "car" called "geodatabase"... Take away the engine entirely, and you will grind to a halt.
    Last edited by mboeringa2010; 11-18-2012 at 09:01 AM.

  13. #13
    Fiona Hatfield
    Join Date
    Mar 2010
    Posts
    5
    Points
    0
    Answers Provided
    0


    0

    Default Re: Why would I install ArcSDE with 10.1?

    Hi,
    I'm trying to wrap my head around this, as I setup my test server for our upgrade.

    I have set up my server with Windows Server 2008 R2 sp1 and SQL Server 2012 standard edition.
    I have installed ArcGIS desktop 10.1 + sp1
    I ran through the ArcGIS for Server 10.1 sp1 installer but did not create a ArcGIS Server site. (essentially I needed the authorization file for the create enterprise geodatabase tool )

    I then ran the tool > 'Create Enterprise Geodatabase'
    I loaded some data into the geodatabase, registered as versioned.
    When exploring the schema all the SDE and GDB tables are present.

    Am I missing something? Do I need to install ArcSDE 10.1 to get the multi user/versioning/history capabilties of ArcSDE, or as this discussion indicates this is now inherent in the desktop.

    I still am not 100% clear why I would need to install the ArcSDE application server or command line tools.
    If I am managing data via desktop (ArcMap & ArcCatalog) I do not need to install anything further
    If I am managing data via web editing tools I do need to install the ArcSDE application server.

    Thank you for any clarification you can provide.
    Fiona

  14. #14
    Alan Toms
    Join Date
    Apr 2010
    Posts
    82
    Points
    8
    Answers Provided
    2


    0

    Default Re: Why would I install ArcSDE with 10.1?

    Yeah it took me a bit to get it as well. The ArcSDE Command Line tools do not need to be installed unless you want to run stuff with a command line or need to do some major troubleshoot.

    Quote Originally Posted by fleith View Post
    Hi,
    I'm trying to wrap my head around this, as I setup my test server for our upgrade.

    I have set up my server with Windows Server 2008 R2 sp1 and SQL Server 2012 standard edition.
    I have installed ArcGIS desktop 10.1 + sp1
    I ran through the ArcGIS for Server 10.1 sp1 installer but did not create a ArcGIS Server site. (essentially I needed the authorization file for the create enterprise geodatabase tool )

    I then ran the tool > 'Create Enterprise Geodatabase'
    I loaded some data into the geodatabase, registered as versioned.
    When exploring the schema all the SDE and GDB tables are present.

    Am I missing something? Do I need to install ArcSDE 10.1 to get the multi user/versioning/history capabilties of ArcSDE, or as this discussion indicates this is now inherent in the desktop.

    I still am not 100% clear why I would need to install the ArcSDE application server or command line tools.
    If I am managing data via desktop (ArcMap & ArcCatalog) I do not need to install anything further
    If I am managing data via web editing tools I do need to install the ArcSDE application server.

    Thank you for any clarification you can provide.
    Fiona

  15. #15
    Marco Boeringa
    Join Date
    Aug 2010
    Posts
    299
    Points
    183
    Answers Provided
    18


    2

    Default Re: Why would I install ArcSDE with 10.1?

    Quote Originally Posted by fleith View Post
    I then ran the tool > 'Create Enterprise Geodatabase'
    I loaded some data into the geodatabase, registered as versioned.
    When exploring the schema all the SDE and GDB tables are present.
    Hi Fiona,

    Good, this means you are most likely "up-and-running", and can start using ArcGIS to fill and use your ESRI geodatabase

    Quote Originally Posted by fleith View Post
    Am I missing something? Do I need to install ArcSDE 10.1 to get the multi user/versioning/history capabilities of ArcSDE, or as this discussion indicates this is now inherent in the desktop.
    Quote Originally Posted by fleith View Post
    I still am not 100% clear why I would need to install the ArcSDE application server or command line tools.
    No, you do not need to install an ArcSDE 10.1 application server to get full geodatabase functionality, including multi user/versioning/history.

    As I and others have attempted to explain in this thread, ArcSDE's software components in the form of DLLs (Dynamic Link Libraries) form an inherent - and VITAL - part of any "client" ArcGIS application, most prominently "ArcGIS for Desktop" and "ArcGIS for Server" (Server is after all a "client" of the DBMS too, e.g. Oracle, Microsoft SQL Server). They are installed by default as part of the respective software's installation.

    You can't access or run an ESRI geodatabase without these DLLs that incorporate all the functionality and logic of ArcSDE to handle ESRI geodatabases (at least not by re-doing years long software development by ESRI and at great risk of corrupting the database in case you want to edit something).

    Like I wrote in my last post:

    *************************************
    ArcSDE is the "engine" of the "car" called "geodatabase"... Take away the engine entirely, and you will grind to a halt.
    *************************************

    However, if this sentence still leaves you confused, think of the ArcSDE application server running on a remote server being "public transport", and the ArcSDE DLLs on your local computer as part of "ArcGIS for Desktop" as your "private car". Both share an "engine" (THIS IS ARCSDE!), but they are independent and both get you from A to B (allow you to access an ESRI geodatabase with all of it's functionality).

    It is up to you to decide if you want to travel by "public transport" or use your "private car". One mode of transport may be faster than the other (or the other way around), depending on the conditions in your local "area"...

    To also recap some of the very good comments by the ESRI staff in this thread (Russell Brennan in this case):

    "Fast forward to 10.1 - We have tried to allow you to manage your Geodatabase completely within ArcGIS applications (ArcCatalog, ArcMap, ArcGIS Server, etc). This is done through the use of dialogues in ArcMap/Catalog and the use of geoprocessing."

    "If you determine that you really need the application server or the command line utilities they are available as a separate install."


    These comments mean that only in some exceptional cases, you might need one of the command line tools. Until you run into some serious trouble that really can't be dealt with using ArcGIS's new tools, you should be fine using Direct Connect and leaving your setup as it is now.
    Last edited by mboeringa2010; 12-22-2012 at 01:53 AM.

  16. #16
    Brian Kaplan
    Join Date
    Apr 2010
    Posts
    33
    Points
    0
    Answers Provided
    0


    0

    Default Re: Why would I install ArcSDE with 10.1?

    HI All, Please help me understand this for the personal ArcSDE. For the previous item...

    No, you do not need to install an ArcSDE 10.1 application server to get full geodatabase functionality, including multi user/versioning/history.


    So can I still use a personal ArcSDE with Desktop without ArcGIS Server, say on a laptop? If so, do I need to through through the same procedure for creating or enabling a enterprise geodatabase? If, so how. The create geodatabase requires an authorization code for ArcGIS Server.

    Thanks

    Brian Kaplan

  17. #17
    Marco Boeringa
    Join Date
    Aug 2010
    Posts
    299
    Points
    183
    Answers Provided
    18


    1

    Default Re: Why would I install ArcSDE with 10.1?

    Quote Originally Posted by BrianK View Post
    HI All, Please help me understand this for the personal ArcSDE. For the previous item...

    No, you do not need to install an ArcSDE 10.1 application server to get full geodatabase functionality, including multi user/versioning/history.


    So can I still use a personal ArcSDE with Desktop without ArcGIS Server, say on a laptop? If so, do I need to through through the same procedure for creating or enabling a enterprise geodatabase? If, so how. The create geodatabase requires an authorization code for ArcGIS Server.

    Thanks

    Brian Kaplan
    Brian, there is no "personal ArcSDE", there is just the ArcSDE DLL's that incorporate all the functionality to allow a Direct Connect connection on your local personal PC to a (remote) enterprise geodatabase, but that isn't a product called "personal ArcSDE".

    Additionally, if you want to create an enterprise geodatabase (so no file geodatabase), you will need an ArcGIS for Server commercial licence, as ArcSDE / ArcGIS for Server is a sale / non-free product of ESRI, and using an enterprise geodatabase requires this licence, even if you only start using it for testing purposes. That is why you are being asked for an authorization code.

    You may be able to get a temporary trial licence for free for testing purposes, IDK, but as soon as you start deploying it, you will surely need a true paid licence. For that, there are two possible licencing levels: "ArcGIS for Server Enterprise" and "ArcGIS for Server Workgroup", see this page:

    http://www.esri.com/software/arcgis/...rise-workgroup

  18. #18
    Brian Kaplan
    Join Date
    Apr 2010
    Posts
    33
    Points
    0
    Answers Provided
    0


    0

    Default Re: Why would I install ArcSDE with 10.1?

    Quote Originally Posted by mboeringa2010 View Post
    Brian, there is no "personal ArcSDE", there is just the ArcSDE DLL's that incorporate all the functionality to allow a Direct Connect connection on your local personal PC to a (remote) enterprise geodatabase, but that isn't a product called "personal ArcSDE".

    Additionally, if you want to create an enterprise geodatabase (so no file geodatabase), you will need an ArcGIS for Server commercial licence, as ArcSDE / ArcGIS for Server is a sale / non-free product of ESRI, and using an enterprise geodatabase requires this licence, even if you only start using it for testing purposes. That is why you are being asked for an authorization code.

    You may be able to get a temporary trial licence for free for testing purposes, IDK, but as soon as you start deploying it, you will surely need a true paid licence. For that, there are two possible licencing levels: "ArcGIS for Server Enterprise" and "ArcGIS for Server Workgroup", see this page:

    http://www.esri.com/software/arcgis/...rise-workgroup

    Hi Marco,

    Thank you for your reply. I must have used the wrong terminology. The install for ArcGIS Desktop includes an option to enable geodatabase storage on SQL Server Express. Isn't this not an enterprise geodatabase?

  19. #19
    Vince Angelo

    Join Date
    Feb 2010
    Posts
    2,033
    Points
    479
    Answers Provided
    71


    0

    Default Re: Why would I install ArcSDE with 10.1?

    Enterprise geodatabases, which run in many different flavors of RDBMS software, require an
    ArcGIS for Server Enterprise license. Desktop (formerly known as "Personal") and Workgroup
    multiuser geodatabases (which only run in SQL-Server Express, and are subject to restrictions
    in user count, storage, RAM, and CPU cores) are available at different licensing levels.

    The Multiuser Geodatabase page breaks down the options.

    - V

  20. #20
    Brian Kaplan
    Join Date
    Apr 2010
    Posts
    33
    Points
    0
    Answers Provided
    0


    0

    Default Re: Why would I install ArcSDE with 10.1?

    Quote Originally Posted by vangelo View Post
    Enterprise geodatabases, which run in many different flavors of RDBMS software, require an
    ArcGIS for Server Enterprise license. Desktop (formerly known as "Personal") and Workgroup
    multiuser geodatabases (which only run in SQL-Server Express, and are subject to restrictions
    in user count, storage, RAM, and CPU cores) are available at different licensing levels.

    The Multiuser Geodatabase page breaks down the options.

    - V
    Thank you. I found that the ArcGIS desktop menu included the ArcSDE install and the ability to take an existing SQL Server Express database and convert it to a geodatabase. Brian.

  21. #21
    Vince Angelo

    Join Date
    Feb 2010
    Posts
    2,033
    Points
    479
    Answers Provided
    71


    1

    Default Re: Why would I install ArcSDE with 10.1?

    Desktop multi-user geodatabases are to Enterprise ArcSDE as "Physics for Social Science Majors"
    is to "Intermediate Electricity and Magnetism" -- the flavor is there, but a good deal of the rigor
    is missing.

    - V

  22. #22
    Ariel Lomes
    Join Date
    Aug 2012
    Posts
    23
    Points
    1
    Answers Provided
    2


    0

    Default Re: Why would I install ArcSDE with 10.1?

    I have a similar question, regarding Oracle.

    Some of you here said that if I do not install ArcSDE application on the server, and use only ArcGIS for Desktop, I'll need to install an Oracle Client (32bit ofcourse) on each desktop that will direct connect to the geodatabase via ArcCatalog/ArcMap.

    However, I need to be able to connect to the geodatabase (direct connection or application connection) via a desktop without an Oracle client installed. For that, I'll need to install the ArcSDE application on the server, correct?

    Also, will I need to use application connection or a direct connection?

    Thanks,

    Ariel.

  23. #23
    Marco Boeringa
    Join Date
    Aug 2010
    Posts
    299
    Points
    183
    Answers Provided
    18


    0

    Default Re: Why would I install ArcSDE with 10.1?

    Quote Originally Posted by ArielLo View Post
    Some of you here said that if I do not install ArcSDE application on the server, and use only ArcGIS for Desktop, I'll need to install an Oracle Client (32bit ofcourse) on each desktop that will direct connect to the geodatabase via ArcCatalog/ArcMap.

    However, I need to be able to connect to the geodatabase (direct connection or application connection) via a desktop without an Oracle client installed. For that, I'll need to install the ArcSDE application on the server, correct?

    Also, will I need to use application connection or a direct connection?
    Ariel, if you need the full geodatabase functionality but can't install the Oracle Client, than yes, your only option is to install and run an ArcSDE Application Server (which isn't a bad thing or so ).

    In this scenario, the connection is called an Application Server connection, so you won't be using Direct Connect.

    Please note you need to add the following line to your Windows services file of your client PC running ArcGIS for Desktop per installation instructions for the ArcSDE Application Server. Please note this has to be done on each machine connecting to your Application Server!:

    esri_sde 5151/tcp

    The Windows services file is simply called "services" without a file extension and in Windows 7 located in:

    C:\Windows\System32\drivers\etc

  24. #24
    Richard Watson

    Join Date
    Nov 2009
    Posts
    1,263
    Points
    281
    Answers Provided
    41


    0

    Default Re: Why would I install ArcSDE with 10.1?

    Quote Originally Posted by mboeringa2010 View Post
    Please note you need to add the following line to your Windows services file of your client PC running ArcGIS for Desktop per installation instructions for the ArcSDE Application Server. Please note this has to be done on each machine connecting to your Application Server!:

    esri_sde 5151/tcp

    The Windows services file is simply called "services" without a file extension and in Windows 7 located in:
    C:\Windows\System32\drivers\etc
    Is this really necessary on client machines? I ask because I have never done this and used the SDE Application Server from Windows extensively. My understanding, which could be wrong, is that this needs to be on machine on which the SDE Application Server is installed.

  25. #25
    Vince Angelo

    Join Date
    Feb 2010
    Posts
    2,033
    Points
    479
    Answers Provided
    71


    2

    Default Re: Why would I install ArcSDE with 10.1?

    The services file on the application server must be modified because the service
    is started by name. It's good practice to distribute a modified services file among
    clients, but it's only necessary if those clients will also lookup by name (if you
    specify the port number, then it isn't necessary).

    - V

  26. #26
    Ariel Lomes
    Join Date
    Aug 2012
    Posts
    23
    Points
    1
    Answers Provided
    2


    0

    Default Re: Why would I install ArcSDE with 10.1?

    Quote Originally Posted by mboeringa2010 View Post
    Ariel, if you need the full geodatabase functionality but can't install the Oracle Client, than yes, your only option is to install and run an ArcSDE Application Server (which isn't a bad thing or so ).

    In this scenario, the connection is called an Application Server connection, so you won't be using Direct Connect.

    Please note you need to add the following line to your Windows services file of your client PC running ArcGIS for Desktop per installation instructions for the ArcSDE Application Server. Please note this has to be done on each machine connecting to your Application Server!:

    esri_sde 5151/tcp

    The Windows services file is simply called "services" without a file extension and in Windows 7 located in:

    C:\Windows\System32\drivers\etc

    Thanks!

    This is exactly what I did, works perfectly.

    I have a question though - I've heared a rumor that ESRI will probably eventually stop supporting Application Server Connection, is that true?

    What is the "recommended" method of connection by ESRI?

    Thanks again,

    Ariel.

  27. #27
    Marco Boeringa
    Join Date
    Aug 2010
    Posts
    299
    Points
    183
    Answers Provided
    18


    1

    Default Re: Why would I install ArcSDE with 10.1?

    Quote Originally Posted by ArielLo View Post
    I have a question though - I've heared a rumor that ESRI will probably eventually stop supporting Application Server Connection, is that true?

    What is the "recommended" method of connection by ESRI?
    Rumours are rumours, and since I don't work for ESRI, I can say nothing sensible about it. From a technical point of view, I see little reason why ESRI would decide to abandon the Application Server option completely. As much of the code base for the Application Server executables is the same as for the Direct Connect DLL drivers (see Derek Law's slightly older but still relevant Enterprise Geodatabase 101 here on the ESRI website), there isn't a whole lot to win by abandoning the Application Server option.

    From a "support" point of view, there may be reasons, as it seems the Application Server option seems to be a bit more difficult to get up-and-running for some users, and causing more questions and confusion requiring ESRI intervention.

    As for "recommended", ESRI made Direct Connect default, so I guess this would qualify as the "recommended" option. I doubt though, Vince would give you such an answer, as he probably justly and more precisely will tell you it all depends on the configuration of your specific client/server hard- and software LAN network environment.

    As I said before in this thread:

    "It is up to you to decide if you want to travel by "public transport" or use your "private car". One mode of transport may be faster than the other (or the other way around), depending on the conditions in your local "area".."
    Last edited by mboeringa2010; 01-21-2013 at 02:19 AM.

  28. #28
    Marco Boeringa
    Join Date
    Aug 2010
    Posts
    299
    Points
    183
    Answers Provided
    18


    1

    Default Re: Why would I install ArcSDE with 10.1?

    Also, in terms of Application Server versus Direct Connect, and why ESRI may have decided to make Direct Connect default, it may have to do with a number of (or probably many) clients of ESRI having seen a significant rise in the number of concurrent users using enterprise geodatabases (and not just through cached webservices).

    Where in the past for most organizations it used to be that only a few highly active editors / viewers concurrently accessed the database (e.g. maximum a dozen) through ArcMap, now for some shops maybe dozens or even hundreds might access it.

    In that scenario, Direct Connect is probably the best option.

    However, if you still are within a mid-size organization, with maybe a (few) dozen maximum active users at any point in time, and have a beefy modern 8+ core database server / Application Server with a tens or hundreds of Gigabytes big enterprise geodatabase, than Application Server connections may still be very much a valid choice. In fact, the server with it's specialized high performance hardware and processors (e.g. Xeon), may outperform your desktop in processing the GIS data, especially in cases of network bandwidth constraints.

    Also, this remark by D.E.Wright on the GIS StackExchange Forum may be of interest:

    “There are some very good reasons to use an ArcSDE Server Engine (Edit: Should be ArcSDE Application Server in official ESRI terminology), the first being the load. When you utilize a ArcSDE (Edit: Application) Server Service you are taking the bulk of that data load off the database server and queuing it versus relying on just your local machine to store all that temp data.
    One thing you will see especially with a MSSQL server when you make your initial database connection in a MXD is that ArcGIS does a 'SELECT *' (as seen in your query analyzer and logs on your DB Server) against that table/feature-class. Now, this can be a huge impact if you have very large datasets; the ArcSDE Service/Process helps in this by aiding in the request of the appropriate data scope.
    Now as we have all gotten bigger machines, with more RAM its much easier to just load everything into the current session and run with it; but don't just discount the idea of using the service just because the ArcGIS docs say you 'don't need it' anymore, versus when you probably could/should use it.”
    Last edited by mboeringa2010; 01-21-2013 at 06:11 AM.

  29. #29
    Stacey Maples
    Join Date
    Nov 2009
    Posts
    39
    Points
    4
    Answers Provided
    0


    0

    Default Re: Why would I install ArcSDE with 10.1?

    I think the length and complexity of this thread make a VERY good case for someone overhauling BOTH the ArcSDE and ArcGIS Server installation documentation. This represents a significant departure from previous architectures and not all of us have the luxury of teams of devs to help us sort out the new 'paradigm.' I just wasted about 2 days trying to figure out how to work with the new iteration of SDE, only to find that I no longer need it from a forum posting, rather than ESRI documentation. This is for a directed study with a student interested in learning to manage these types of architectures. He is quickly learning that, perhaps, the greatest takeaway will be forum mining skills.

    In F, L & T,
    Mr. Stacey D. Maples
    GIS Specialist & Instruction Coordinator

    Twitter = MapNinja
    AIM = yalemapninja
    GTalk = yale.map.ninja
    Yahoo IM = stacemaples
    ICQ = 57891396

    Yale University Map Department
    Sterling Memorial Library 7th Floor
    130 Wall Street /P.O. Box 208240
    New Haven, CT 06520-8240
    P:203-432-8269 F:203-432-8240
    The Yale University GIS Support Page [http://guides.library.yale.edu/GIS]
    The Yale University Map Department [http://www.library.yale.edu/maps]
    Yale GIS-L Mailing List Subscription [http://mailman.yale.edu/mailman/listinfo/gis-l]
    Search for scanned maps and other Digital Objects from Yale's Library [http://discover.odai.yale.edu/ydc/]
    Yale GIS Workshops Calendar [http://bit.ly/xqPvdS]


    "I have a map of the United States... actual size.
    It says, "Scale: 1 mile = 1 mile."
    I spent last summer folding it."
    -Steven Wright-

  30. #30
    Hal Watson
    Join Date
    Oct 2009
    Posts
    8
    Points
    4
    Answers Provided
    1


    0

    Default Re: Why would I install ArcSDE with 10.1?

    I have to admit, as someone who has been managing SDE installs since 9.1, I didn't pick up on this paradigm shift until a few days ago when I did a test 10.1 on Oracle install, and realized that with Toad and the Python interpreter in ArcCatalog I could pretty much do everything I needed to get the enterprise geodatabase created, a user-schema geodatabase created, and the .sde connection files to access them created. I think that is a good step forward for basic installs. If I can take the SDE Application server out of the picture, that is a big time saver. The toolbox tools are a little rough, but with arcpy you can get the job done.

    It would be great to have access to some more of the sde app server command line tools available via the python arcpy module. I'm thinking especially of the tools like sdeconfig and sdedbtune, which still seem necessary to me. I hope that is in the works. If I'm missing something on that front, I would love to be educated.

    Looking at it now, the progression makes sense and I'm glad for the new options.

  31. #31
    Yukun Xing
    Join Date
    Jun 2010
    Posts
    42
    Points
    1
    Answers Provided
    0


    0

    Default Re: Why would I install ArcSDE with 10.1?

    I haven't had much experience with ArcSDE or ArcGIS server in general, and I have one question. While I was reading through the tutorial on ArcGIS API for Silverlight (I believe that was before 10.1 was released) it was mentioned somewhere that to be able to edit a feature class using a web application, the feature class must be stored in an SDE database and published as a feature service. Is the part regarding SDE still true at 10.1?

    Our office is finally getting an ArcGIS sever (Standard Edition at the Workgroup level) so we can play with it and look into web map application development. The system admin is going to set it up soon, and the ArcGIS Server 10.1 SP1 installer is all we've got (no Web Adaptor or ArcSDE installer/setup). Is the following scenario for testing purposes possible? If not, what else do we need to install/configure, or what is the alternative?

    Install ArcGIS for Sever on sever A;
    Using ArcGIS for Desktop on a workstation, create a file geodatabase on either sever A or some other server B on the same office LAN, and create a feature class in the FGDB and publish it as a feature service;
    Create a web mapping application and host it on server A (separate IIS set up necessary?);
    Display, query, and edit the feature class through the web application over the internet.

    If this scenario is possible, does ArcGIS Server create a copy of the feature class and serve the copy when I publish the FC as a service? If that is true, will I be able to access/edit this copy in ArcGIS for Desktop on the workstation?
    Last edited by xyknewtry; 03-26-2013 at 02:10 PM.

  32. #32
    Jake Skinner

    Join Date
    May 2010
    Posts
    1,118
    Points
    629
    Answers Provided
    98


    0

    Default Re: Why would I install ArcSDE with 10.1?

    Hi Yukon,

    You will need the feature class stored in SDE in order to create a feature service. The ArcGIS for Server Workgroup (Standard Edition) comes with SQL Server Express. You should be able to download the installation files from the customer care portal:

    http://resources.arcgis.com/en/help/...00000010000000

    After you install SQL Server Express, you will just need to enable SQL Server Express to store geodatabases:

    http://resources.arcgis.com/en/help/...000000w000000/

    Additional helpful links:

    Setting up a connection:
    http://resources.arcgis.com/en/help/...000002z000000/

    Adding a database server to Desktop:
    http://resources.arcgis.com/en/help/...000001s000000/

    Creating a geodatabase on a database server:
    http://resources.arcgis.com/en/help/...000000m000000/

  33. #33
    Yukun Xing
    Join Date
    Jun 2010
    Posts
    42
    Points
    1
    Answers Provided
    0


    0

    Default Re: Why would I install ArcSDE with 10.1?

    Quote Originally Posted by JSkinn3 View Post
    You should be able to download the installation files from the customer care portal:

    http://resources.arcgis.com/en/help/...00000010000000
    Thank you for the replay Jake, very helpful information. If we have the ArcGIS Sever 10.1 SP1 installer, does it typically include the installation files you mentioned for SQL express (We haven't started installing yet)? I'm hoping it's the case, as due to the structure of our organization, our office is not directly involved in software purchasing/management. I logged into my customer portal with our customer ID, but there is no order history, and I don't see anything for download.

  34. #34
    Karyn Tareen
    Join Date
    Oct 2010
    Posts
    1
    Points
    0
    Answers Provided
    0


    0

    Default Re: Why would I install ArcSDE with 10.1?

    Quote Originally Posted by JSkinn3 View Post
    You will need the feature class stored in SDE in order to create a feature service.
    To confirm, a direct connect is sufficient for a feature service - as long as the database supporting the feature service has the SDE tables within it, correct?

  35. #35
    Marco Boeringa
    Join Date
    Aug 2010
    Posts
    299
    Points
    183
    Answers Provided
    18


    0

    Default Re: Why would I install ArcSDE with 10.1?

    Quote Originally Posted by ktareen View Post
    To confirm, a direct connect is sufficient for a feature service - as long as the database supporting the feature service has the SDE tables within it, correct?
    Karyn,

    ArcGIS for Server is, just like ArcGIS for Desktop, fully capable of using both an ArcSDE Application Server, or Direct Connect, for connecting to an enterprise geodatabase.

    From a functionality point of view, there is absolutely no difference between using an Application Server or Direct Connect. So yes, "Direct Connect" is sufficient for ArcGIS for Server to create (editable) Feature Services.

  36. #36
    Marco Boeringa
    Join Date
    Aug 2010
    Posts
    299
    Points
    183
    Answers Provided
    18


    1

    Default Re: Why would I install ArcSDE with 10.1?

    Quote Originally Posted by stacemaples View Post
    I think the length and complexity of this thread make a VERY good case for someone overhauling BOTH the ArcSDE and ArcGIS Server installation documentation.
    Well, it isn't an overhaul, but I now published a document describing "The ESRI Geodatabase Framework" (as I call it and see it) in another forum thread. It may be a good read for people interested in the contents of this thread and help out with a better understanding of 2-tier Direct Connect and 3-tier Application Server connections to geodatabases:

    "The ESRI Geodatabase Framework" PDF

    Please post any comments to the document in that thread and not here.

    Marco

+ Reply to Thread

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts