Transcript

00:06In this video, I will demonstrate how to register the data in your database...

00:10...with ArcGIS 10.1 for Server.

00:13When publishing GIS services, the server needs to access the data.

00:17In 10.1, data registration is a recommended task that provides ArcGIS Server a list of...

00:22...data locations that it can access.

00:25If ArcGIS Server detects that you’re using data from an unregistered location...

00:29...the data is copied to the server automatically to ensure the service works correctly.

00:34Registering data locations can suppress this data copying. When publishing...

00:38...across machines, data registration allows ArcGIS Server...

00:41...to adjust the file paths to your data.

00:44You can register any database compatible with ArcGIS.

00:48For example, you can register enterprise databases such as Oracle, PostgreSQL...

00:53...and SQL Server by importing the database's connection file.

00:57Keep in mind that when you register your database, the ArcGIS Server account is not...

01:01...granted permissions to access your data.

01:04Before registering, you'll need to ensure that the ArcGIS Server account...

01:07...has at least read permissions to the database and the database connection file.

01:12Granting permissions is beyond the scope of this video...

01:14...but I wanted to emphasize this is an important step to complete before registering your data.

01:19There are a couple of scenarios you may encounter...

01:21...when attempting to register your data with ArcGIS Server. For example...

01:26...the data in your database can be accessed by ArcGIS Server...

01:29...or, the data in your database cannot be accessed by ArcGIS Server.

01:34In this video, I’ll cover these scenarios by using a map document as an example.

01:39I’m going to do the data registration in ArcGIS for Desktop...

01:42...but I could alternatively use ArcGIS Server Manager to register the data...

01:46...the dialogs are similar.

01:48To get started, I’ll right-click my publisher connection to ArcGIS Server and...

01:52...choose Server Properties. In the Server Properties dialog box, I’ll click the...

01:56...Data Store tab. This is where I’ll register my data.

02:00The first scenario I’d like to cover is registering database data that can be...

02:04...accessed by ArcGIS Server.

02:06In this scenario, my map document references data in a database that is visible to both...

02:11...ArcGIS for Desktop and ArcGIS Server.

02:14When I publish my map document as a map service, ArcGIS Server will be able to...

02:18...view and access data in the same database.

02:21By registering my data in this manner, I can avoid having a copy of the data placed...

02:25...on the server.

02:26I’ll use my map service to demonstrate this.

02:29Next to the Registered Databases dialog box, I’ll click Add.

02:34I’ll enter a unique name for the registered database.

02:37Then, I’ll click Import to specify the path to the database connection file.

02:42Prior to recording this video, I granted the ArcGIS Server account...

02:45...read permissions to the database. I also placed the connection file in a...

02:49...directory that is accessible to the ArcGIS Server account. Keep in mind that...

02:53...in order for the data to be registered, the ArcGIS Server account must have...

02:57...access to both the connection file and the database.

03:00Once I’ve specified the connection file, I’ll make sure Same as publisher database connection...

03:04...is selected.

03:06I’ll click OK to register the database with ArcGIS Server. The name I entered...

03:10...for the database appears on the Registered Databases dialog box.

03:14Now, I’ll publish my map document.

03:19After publishing, I’ll verify that my map service is referencing the database.

03:24I’ll right-click my map service and choose Service Workspaces.

03:28I see that my map service is using the data in the database.

03:32The second scenario I’d like to cover is registering database data that cannot be...

03:36...accessed by ArcGIS Server.

03:38You may encounter this scenario because of differences between computing platforms...

03:42...firewalls, the desire to keep a separate copy of the data for web use...

03:46...or publishing to a cloud-based environment such as ArcGIS Server on Amazon Web Services.

03:52Due to one or a variety of these factors, you’ll need to manually...

03:55...copy your data to a database on the server before publishing.

03:59You can optionally have a geodata service created automatically when you register.

04:03You can use this service to manually send a replica of the data to the database on the server.

04:08If you’ll be editing your data, you can also use the geodata service to synchronize changes...

04:12...between the databases.

04:14When you publish, the data paths are automatically modified to...

04:17...reference the database on the server. I’ll use my map service to demonstrate this.

04:22Next to the Registered Databases dialog box, I’ll click Add.

04:26I’ll enter a unique name for the registered database.

04:30Then, I’ll click Import to specify the path to the database connection file.

04:35Since my server uses a different database, I’ll uncheck...

04:37...Same as publisher database connection and click Import...

04:40...to specify the server’s database connection file.

04:43I want to use a geodata service to send a replica of my data to the server...

04:47...so I’ll make sure Create geodata service is selected.

04:51Keep in mind that the name of the geodata service is inherited from the name...

04:54...I specified above.

04:56I’ll click OK to register the databases with ArcGIS Server.

04:59The name I entered for the databases appears on the Registered Databases dialog box.

05:04If I refresh my connection to ArcGIS Server, I see my geodata service is created.

05:09Since my database on the server is empty...

05:11...I’ll use the geodata service to send a replica of my data to the database on ArcGIS Server.

05:16On the Distributed Geodatabase toolbar, I’ll click Create Replica.

05:21I’ll select Two way replica and click Next.

05:24I’ll make sure Data is selected and then choose my geodata service running on ArcGIS Server.

05:32I’ll give it a name and accept the remaining defaults.

05:36Now, a replica of my data is sent to the database on ArcGIS Server.

05:41Now, I’ll check to see if the replica exists in the server’s database.

05:49I see that the replica has been successfully transferred to ArcGIS Server.

05:53Now, I’ll publish my map document.

05:58After publishing, I’ll verify that my map service is referencing the database on the server.

06:03I’ll right-click my map service and choose Service Workspaces.

06:07I see that my map service is using the server’s database.

Copyright 2014 Esri
Auto Scroll (on)Enable or disable the automatic scrolling of the transcript text when the video is playing. You can save this option if you login

Registering database data with ArcGIS 10.1 for Server

This video shows how to register database data with ArcGIS 10.1 for Server.

  • Recorded: Jun 15th, 2012
  • Runtime: 06:19
  • Views: 13972
  • Published: Jun 18th, 2012
  • Night Mode (Off)Automatically dim the web site while the video is playing. A few seconds after you start watching the video and stop moving your mouse, your screen will dim. You can auto save this option if you login.
  • HTML5 Video (Off) Play videos using HTML5 Video instead of flash. A modern web browser is required to view videos using HTML5.
Download VideoDownload this video to your computer.
<Embed>Customize the colors and use the HTML code to include this video on your own website
480x270
720x405
960x540
Custom
Width:
Height:
Start From:
Player Color:

Right-click on these links to download and save this video.

Comments  (4)

All Comments
To post a comment, you'll need to login.
If you don't have an Esri Global Login ID, please register here.
Regarding this error, the most likely cause is that the you did not install the 64-bit database client libraries on the server. If the libraries don’t exist, then the server will not be able to access the database.

Please read the following supporting documents:

http://support.esri.com/en/knowledgebase/techarticles/detail/40409

http://resources.arcgis.com/en/help/main/10.1/index.html#//0154000004qt000000#anchor12

Veronica
ArcGIS Resource Center Team
vrojas  (Staff Comment) 1 Month ago
Report
thanks for the video , please i have a problem with registration i made the same steps of the video but i have an erreor saying the data item is inaccessible
dyousra 1 Month ago
Report
helpful, thanks!
diligentpig 2 Years ago
Report
great
jack.gis64 2 Years ago
Report
  • 4 total