nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Managed database: SDE Enterprise database or Datastore

Anonymous User

Hi,

I would like to know if someone would have some advice with an On-Premise, Federated Portal
10.3.1 installation, where the Managed database would be our SDE Enterprise
database instead of the Datastore. Anyone know of any downside or limitations we may encounter by not using the Datastore?

Thank you,

Line
Champagne

Gaz Métro,
Montreal

Find more posts tagged with

Accepted answers

All comments

DerekLaw

Hi Line,

Using an Enterprise geodatabase (aka. ArcSDE geodatabase) as a managed data store (i.e., data storage option) for your ArcGIS Server site is fine. In this case, I am referring to the generic concept of a "data store" for ArcGIS Server. Help topic,

Data storage considerations for an ArcGIS Server site—Documentation (10.3 and 10.3.1) | ArcGIS for Server

If you want to enable a hosting server for your Portal for ArcGIS, the "ArcGIS Data Store" (i.e., the software product) is the recommended option, because it has been optimized to store hosted services.

What is ArcGIS Data Store?—Portal for ArcGIS (10.3 and 10.3.1) | ArcGIS for Server

Q) Are you trying to configure and deploy a hosting server for your Portal for ArcGIS? If so, then you should use the ArcGIS Data Store instead of an Enterprise geodatabase.

Hope this helps,

JacobBoyle

As an early adopter of portal, I can attest to the speed benefit of using the Data Store over an SDE database,

The one downside, and it's minor if you pull the data in through portal, is that the Data Store Database is not SDE, and it's not able to be connected to like an SDE-enabled database, at least as I've found.

PaulDavidson1

Jacob;

Curious about one thing.

Since the DataStore is a managed DB, it seems to mean from what I can tell so far that it's pretty much transparent to the user and to the admin. It just does it's thing.

Have you had any issues with things getting out of synch or mashed up?

Anonymous User

Derek,

Q) Are you trying to configure and deploy a hosting server for your Portal for ArcGIS? Yes

There are 2 goals we hope to achieve with our implementation of Portal :

1) Give Portal users the possibility to create new Feature Layers from Portal. From what we understand this can only be achieved if we use ArcGIS Data Store; using an Enterprise geodatabase as our Data store does not unlock this options.

2) We would like to be able to update features located in our Geotatabase using Feature Services for use in Collector. When Data Store (software) is installed all Feature Services are published as Hosted Feature Layers. When the feature layer is hosted in the Data store edits are no longer synched with our ArcGIS Server Geodatabase…

Thanks,

Line

De : Derek Law

Envoyé : 7 octobre 2015 14:17

À : Champagne Line <LChampagne@GazMetro.com>

Objet : Re: - Managed database: SDE Enterprise database or Datastore

GeoNet <https://community.esri.com/?et=watches.email.thread>

Managed database: SDE Enterprise database or Datastore

reply from Derek Law<https://community.esri.com/people/dlaw-esristaff?et=watches.email.thread> in Portal for ArcGIS - View the full discussion<https://community.esri.com/message/558397?et=watches.email.thread#558397>

JacobBoyle

No, it works seamlessly for the end user. There are documented ways to create backups, but we run in our whole GIS in a VMware environment with real-time replication to an offsite location, so we haven't bothered.

We still use traditional backups for SDE though. Some habits are hard to break

This page is worth a read What is ArcGIS Data Store?—Portal for ArcGIS (10.3 and 10.3.1) | ArcGIS for Server

JacobBoyle

for # 1

You don't need to use Data Store, but you do need to have a Managed Geodatabase for content to be published to. This can be an SDE Database or the Data Store, your choice, with the understanding that scenes (3d) can only be published to the Data Store.

You can publish data from SDE as Feature Services and edit them in Collector, Data Store is only used when you don't have data coming from a registered source with ArcGIS Server or for content that's created/uploaded in Portal.

Anonymous User

Hi Line,

"Give Portal users the possibility to create new Feature Layers from Portal. From what we understand this can only be achieved if we use ArcGIS Data Store; using an Enterprise geodatabase as our Data store does not unlock this options."

This is not correct. This works fine also with SDE Enterprise geodatabase, like in Oracle. You may also use the same geodatabase as you are using for other purposes (I do not know if this is recommended, and may of course have impact on response times). We do, and have Portal create new feature classes in a separate Oracle schema.

One benefit of using Enterprise geodatabase, is that the feature classes that users has created is visible as you are used to, like in Catalog. You may also read the feature classes from the Enterprise geodatabase with other tools.

(You might actually also overwrite data in a feature class created from Portal, with ie a FME job, if you have permission to the Oracle schema. We do this to help users get their data updated regulary.)

A constraint is that column names are limited by Oracle column limitations, and when users do like Share from ArcMap to create a new feature layer in Portal, this will fail with a 99999 error message with no further information, if their data definitions are rejected by Oracle. Column names that are accepted in a file geodatabase may be rejected. The most common issue I have encountered is column names longer that 30. Hopefully this works better with Data Store, it should accept all data types that accepted in a filegeodatabase. I have no experience with this.

Regards,

Lars

DerekLaw

Hi Line,

Your requirements:

"There are 2 goals we hope to achieve with our implementation of Portal:

Based on the above, for item 1, I would use the ArcGIS Data Store. Yes, you could use an enterprise geodatabase, but internal testing has shown that the ArcGIS Data Store performs better and is able to host more feature services for Portal for ArcGIS. Also, as Jacob said: if you want to enable and publish scene services (3D data) then you must use the ArcGIS Data Store because scene services are not supported by enterprise geodatabases.

On item 2, I would use an enterprise geodatabase as a managed data store (i.e., data storage option) for the feature services that you publish to your ArcGIS Server site. These services could be used to support your Collector for ArcGIS editing workflows.

The point being, I would actually have 2 separate "data storage tier" options:

1. ArcGIS Data Store for your hosted feature services

2. Enterprise geodatabase for your ArcGIS Server site feature services

Hope this helps,

ZhujingXia

I am new to the data store. I'd like to make sure that if I use data store then I no need to have the SDE geodatabase, the data store could handle everything as the SDE geodatabase did. And I no need to install the RDBMS (for instance the MS SQL server). The data store has PostgreSQL in it already. Am I right?

Thanks

DerekLaw

Hi Zhujing,

> I'd like to make sure that if I use data store then I no need to have the SDE geodatabase, the data store could handle everything as the SDE geodatabase did.

No, this is not quite correct. An enterprise geodatabase has the full and complete spatial data model, such as support for versioning, replication, and archiving. The ArcGIS Data Store does NOT support any of these things. The latter is used to support a hosting server for a Web GIS deployment, while the former can be used to store data that power web services in ArcGIS Server.

> The data store has PostgreSQL in it already. Am I right?

Yes, this is correct. However, you should NOT try to work with the contents of the ArcGIS Data Store directly, like with pgAdmin or anything.

Hope this helps,

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.