ArcSDE no longer needed?

[ErikEngstrom]

Through my frustration of not finding the post-installation wizard with ArcSDE 10.1 and being unsuccessful with the command line tool to start an SDE service on our SDE databases, I found I was able to access the databases and copy/past/add features/delete features/etc. all through direct connections to our SQL Server 2012 machine. This was WITHOUT ArcSDE running.

So... The question is, why do I need to go through the trouble of trying to get the SDE services to run if I can manage our databases through the Desktop tools? I was even able to create an enterprise geodatabase and verified that all of the necessary business tables were created.

Perhaps I'm missing something...

[JamalNUMAN]

Hi Jamal,



A1. Please review the documentation below for more info:

* ArcGIS for Server is available in two levels, Enterprise and Workgroup
* ArcGIS for Server Functionality



A2. ArcSDE technology is included "in the box" with ArcGIS for Server. It is available in all functional editions. See the previous links above for details.

Hope this helps,

Many thanks Derek for the elaboration.

And even the ArcSDE and ArcGIS server are installed separately! None of them is a prerequisite for the other.

[ATTACH=CONFIG]20264[/ATTACH], [ATTACH=CONFIG]20265[/ATTACH]

Do we need to install the ArcSDE and ArcGIS server on the Server machine only or on the clients (users) machines as well?

Best

Jamal

[DerekLaw]

Hi Jamal,

Do we need to install the ArcSDE and ArcGIS server on the Server machine only or on the clients (users) machines as well?

You would typically install ArcGIS for Server and ArcSDE technology on server-side machines to enable a GIS server and an ArcSDE geodatabase, respectively. Both are server-side software.

Regarding ArcSDE technology - you can have it on client (end user) machines when they use ArcGIS for Desktop. This relates to making "direct connections" to your geodatabase (as mentioned in Kim's post earlier in this thread), instead of using an ArcSDE application server connection.

FYI, Enterprise Geodatabase 101 ArcUser article
(look under the section "Type of Client Connections")

Esri is now actively promoting the "Direct Connection" model when connecting to an ArcSDE geodatabase.

Hope this helps,

[JamalNUMAN]

Hi Jamal,



You would typically install ArcGIS for Server and ArcSDE technology on server-side machines to enable a GIS server and an ArcSDE geodatabase, respectively. Both are server-side software.

Regarding ArcSDE technology - you can have it on client (end user) machines when they use ArcGIS for Desktop. This relates to making "direct connections" to your geodatabase (as mentioned in Kim's post earlier in this thread), instead of using an ArcSDE application server connection.

FYI, Enterprise Geodatabase 101 ArcUser article
(look under the section "Type of Client Connections")

Esri is now actively promoting the "Direct Connection" model when connecting to an ArcSDE geodatabase.

Hope this helps,

Many thanks Derek for the very useful information you have provided.

Then still we need to install the ArcSDE (in addition to its installation on the server) in each machine of the users who are supposed to connect (direct connection) to the database on the server. Is this correct?

How about the ArcGIS Server? Do we still need to install it (in addition to its installation on the server) in ALL the machines of the users who are supposed to publish?

Best

Jamal

[RichardWatson]

Derek said "Both are server-side software" which implies that they only need to be installed on servers (i.e. not clients).

ArcMap includes "ArcSDE technology" which implies that no additional installation is required on the clients.

[JamalNUMAN]

Derek said "Both are server-side software" which implies that they only need to be installed on servers (i.e. not clients).

ArcMap includes "ArcSDE technology" which implies that no additional installation is required on the clients.

Thank you Richard.

�?� In case of ArcGIS Server: I couldn�??t figure out how the �??end user�?� who has the ArcGIS Desktop installed in his/her machine will be able to publish, for example, an mxd file? I think in this case the option �??share as service�?� will be greyed out.

[ATTACH=CONFIG]20324[/ATTACH]

�?� In case of ArcSDE: if we are still able to pop up the dialogue box of the �??database connection�?� then it is logic that we can then access the data on the server without having the ArcSDE installed on the end user machine

[ATTACH=CONFIG]20325[/ATTACH]

�?� How about the SQL server? Do we need to install it on the server only or also at the end user machines?

Best

Jamal

[RichardWatson]

Here are a tutorial on how to publish map services from ArcMap:

http://resources.arcgis.com/en/help/main/10.1/index.html#//0154000003vt000000

Here is a discussion about making a connection to ArcGIS Server from ArcMap:

http://resources.arcgis.com/en/help/main/10.1/index.html#/About_connecting_to_ArcGIS_Server_in_ArcGI...

Security is complex.

When you ask about SQL*Server I assume that you are using this as an enterprise geo-database.  This would only be installed on a single server machine.

ArcSDE is not installed on client machines.  If you chose to install this then it would be on a server machine which could be shared by clients.  This configuration contrasts with using direct connect whereby the ArcSDE is embedded in ArcMap/ArcGIS Server.  In other words, if you are using direct connect then you probably do not need to install ArcSDE.  I say "probably" because I believe that there are some configuration tools which require this.

In your situation, I believe that the only software that you need to install on the client machines is ArcMap.

[MarcoBoeringa]

To Jamal:

I am working on a small PDF file with one figure / diagram that should clear up much of your, and other's, confusion around the "ESRI Geodatabase framework" (if I may call it so...) and all the components / applications involved.

I hope to post it tomorrow in the "Why would I install ArcSDE with 10.1?" thread, as there is already a ton of good info by multiple contributors in that particular thread.

Stay tuned.

Marco

[JamalNUMAN]

To Jamal:

I am working on a small PDF file with one figure / diagram that should clear up much of your, and other's, confusion around the "ESRI Geodatabase framework" (if I may call it so...) and all the components / applications involved.

I hope to post it tomorrow in the "Why would I install ArcSDE with 10.1?" thread, as there is already a ton of good info by multiple contributors in that particular thread.

Stay tuned.

Marco

Thank you Richard and Macro for the valuable comments.

Yes please share it. Appreciated

Till now I could summarize the following:

Server machine:
�?� Windows 7 �??server�?�
�?� IIS
�?� Sql server 2008
�?� ArcGIS Server 10.1
�?� ArcSDE 10.1
�?� ArcGIS Web Adaptor 10.1

Client Side
�?� Windows 7
�?� ArcGIS Desktop 10.1

In this case

�?� The users can access (depending on their credentials) the database through the �??add database connection�?� (choosing the database platform, instance and database)
�?� Can access (depending on their credentials) the services or publish (mxd, loc, tbx, lyr, etc.) through the url: http://servername/arcgis/rest/services

hope I'm right!