Registering a Netezza database with the server
As a server administrator, you have the option to register your data folders, databases, and geodatabases with ArcGIS Server. Data registration gives the server a list of locations that the server administrator has verified that the GIS server can access. Data registration also helps the GIS server understand how to adjust data paths when publishing across machines.
The following sections describe how to prepare your ArcGIS client to connect to a Netezza database and register it with ArcGIS Server.
Installing the Netezza ODBC driver
To connect directly from an ArcGIS client to a Netezza database, you must install and configure the Netezza ODBC driver on each ArcGIS client machine.
If your ArcGIS Server site is composed of multiple server machines, you must install and configure the 64-bit Netezza ODBC client on each server.
If ArcGIS Server and ArcGIS for Desktop are installed on the same machine, you must install both the 32- and 64-bit Netezza ODBC driver.
If you configure a data source name for the ODBC drivers, you must use the same name on the ArcGIS Server machine and all ArcGIS for Desktop computers that will publish data to the server and/or register the database with the server.
See Setting up a connection to Netezza for further instructions.
Setting variables
You must set the LIB_ODBC_DRIVER_MANAGER variable in the ArcGIS Server init_user_param.sh script when connecting to Netezza from ArcGIS Server on a Linux machine.
See the "Reference the database client libraries in the init_user_param.sh script" section of Configuring a connection to a database in ArcGIS Server for more information.
Granting privileges
The Netezza group that will be used to connect to the database must be granted privileges in the database to access the data to be published.
The group needs read access to the data. The privileges that must be granted in the database are as follows:
- Select on _V_SYS_PRIV
- Select on SPATIAL_REF_SYS
- Select on GEOMETRY_COLUMNS
- Execute on LIBGEOSLIBS
- Execute on LIBSTDCPP
- Execute on LIBSPATIALUTILS
- Execute on FUNCTION
- Select on all datasets to be published
See User privileges for using ArcGIS with Netezza for more information.
Connecting to Netezza
To register a database with the server, you must provide connection information. There are two ways you can do this:
- Import an existing .sde file that contains the connection information.
You can create a Database Connection (.sde) file from the Catalog tree in ArcGIS for Desktop, using the Create Database Connection geoprocessing tool, or a Python script.
- Provide your connection information at the time of registration.
No matter which way you choose, you must provide the following information to connect directly to Netezza:
- The type of DBMS to which you are connecting (in this case, Netezza)
- The ODBC data source name for the Netezza database or, if an ODBC data source name is not configured, use the following syntax to connect:
ServerName=<host>;Port=<port number>;Database=<database name>
See Database connections in ArcGIS for Desktop for more information and an example.
- Authentication Type set to database authentication
- A valid database user name and password, which must be saved with the connection
Registering the database with ArcGIS Server
You can register the database from Server Manager or the Catalog tree in ArcGIS for Desktop. See the following topics for an explanation of registration options and how to register the database: