Unable to register Snowflake with ArcGIS Server 11.0 on Linux

Description

If the portal's hosting server runs on Linux machines, you must install the latest Snowflake 64-bit ODBC driver on each machine in the GIS Server site and configure the init_user_param.sh script on each machine to access the drivers. In ArcGIS Enterprise 11.0, additional configuration is required in the init_user_param.sh script. If this is not configured correctly, registering a Snowflake cloud data warehouse with ArcGIS Server fails.

Cause

In ArcGIS Enterprise 11.0, a second export line is required in the init_user_param.sh script.

Solution or Workaround

In ArcGIS Enterprise 11.0, configure the init_user_param.sh script on each machine to access the drivers:

To connect to a Snowflake cloud data warehouse, install and configure client files to implement communication between ArcGIS and Snowflake and create database connection files from ArcGIS Pro. To publish web layers, the database connection files must be registered with the ArcGIS Enterprise portal's hosting server site.

You must install the drivers on each machine in the GIS Server site. If the portal's hosting server runs on Linux machines, it is also necessary to configure the init_user_param.sh script on each machine. Alter the init_user_param.sh script installed with ArcGIS Server as described in the documentation ArcGIS Server: Connect to Snowflake from ArcGIS.

1. Remove the comment marks (#) from the lines beginning with export and replace <Location_to_ODBC_driver_manager_libraries> with the location of the ODBC driver on the machine.

# Modify this section to configure a connection to Snowflake Data Warehouse
#
# -----------------------------------------------------------------------
export LIB_ODBC_DRIVER_MANAGER=<Location_to_ODBC_driver_manager_libraries>/libodbc.so.2

2. Now add the second export line as shown below: # Modify this section to configure a connection to Snowflake Data Warehouse

#
# -----------------------------------------------------------------------
export LIB_ODBC_DRIVER_MANAGER=<Location_to_ODBC_driver_manager_libraries>/libodbc.so.2
export LD_PRELOAD=$LD_PRELOAD:$LIB_ODBC_DRIVER_MANAGER:<Location_to_libSnowflake.so>/libSnowflake.so

In ArcGIS Enterprise 11.0, if the second export line is not added to the init_user_param.sh script in the ArcGIS Server machine(s), registering the database connection fails in ArcGIS Pro, ArcGIS Server Manager or in ArcGIS Enterprise portal.

• In ArcGIS Server Manager, after importing the database connection file, ArcGIS Server tries to validate the connection and fails with a blank error message.
• In ArcGIS Pro - the ‘Add data Store ’ dialog box Status displays the following tooltip text “The connection property set was missing a required property or the property value was unrecognized. Underlying DBMS error[Unknown error. No extended error.]”
• In an ArcGIS Enterprise portal, after importing the database connection file when adding a user-managed database data store item, it will take some time to validate the connection but this eventually fails with the Status 'Not Available' .