topic Re: ArcSDE Personal or Workgroup? in Data Management Questions

ArcSDE Personal or Workgroup?

mattwilliams2 — Wed, 05 Oct 2011 16:15:56 GMT

Just looking into what the ideal set up would be for our purposes. We're looking to build a couple web editing applications as well as a mobile application with editing capabilities. My understanding is SDE Personal allows only 3 concurrent viewers and 1 editor, correct?

We would install SDE on a separate server (virtual) than Oracle. So I would also be interested in hearing any issues or drawbacks associated with that as well.

I'm relatively new to the SDE environment so any info would be helpful. Thanks in advance!

Re: ArcSDE Personal or Workgroup?

VinceAngelo — Wed, 05 Oct 2011 18:00:03 GMT

Personal and Workgroup ArcSDE are only available as SQL-Server Express instances. Only Enterprise
is available with Oracle (and the other RDBMSes).

If you are using Personal or Workgroup, you don't have to worry about virtual host deployment, since
they're Direct Connect-only. Only Enterprise supports an a application server service.

If you do license Enterprise ArcGIS Server, you'd have to license an additional server host to run the
application server on a host other than the AGS host.

- V

Re: ArcSDE Personal or Workgroup?

mattwilliams2 — Wed, 05 Oct 2011 18:25:21 GMT

If we already have ArcGIS Server deployed on the virtual server, can we use that to set up an enterprise sde connection to oracle? I'm a little confused with the integration of server and sde.

Otherwise I'm assuming we would want to set up a sde workgroup on the same server as arcgis server, and connect via oracle client to our oracle db on a separate server? Thanks again.

Re: ArcSDE Personal or Workgroup?

VinceAngelo — Wed, 05 Oct 2011 19:45:47 GMT

What license(s) have you purchased?

ArcCatalog is used to create Personal and Workgroup instances (local to the ArcGIS install).
The Enterprise ArcSDE media is separate from the AGS and Desktop media.

You cannot use a workgroup license to authenticate an Enterprise ArcSDE install within Oracle.

You might be better off contacting Tech Support or your marketing rep to help resolve this issue.

- V