Connection to Oracle DB without a GeoDatabase

[ManfredPaul]

Hi, 

We are currently facing a problem with ArcGIS Server that concerns a connection to an Oracle Database without "SDE or Enterprise GDB" functionalities. This means we have an Oracle 19c DB with tables that use SDO geometries. We are able to use these tables with ArcGIS Desktop (10.7.1). 

But here is the problem: How to publish these maps to an ArcGIS Server (Linux)?

Do I still need to create a ".sde" connection file (or register a data item with the Rest API directly)? This seems to only make sense with enterprise geo databases. 

Is is even possible to use ArcGIS Server without an Enterprise GDB but data from Oracle (SDO)?

Thanks

Manfred

[George_Thompson]

Yes, you still publish from a non-geodatabase to ArcGIS Server. You also still need to create the .sde file. That is the file that ArcGIS Server will need to make the connection to the Oracle DB.

Make sure that you have installed the following so that the ArcGIS Server can access and read the Oracle data:

• The Latest patches (security and otherwise) on your ArcGIS Server machine - Esri Support ArcGIS Server 10.7 (10.7.1) .
  • Especially make sure you have this one: ArcGIS (Desktop, Engine, Server) Support for Oracle 19c Patch - Esri Support ArcGIS Server 10.7 (10.7.1) 

• Installed & configured the Oracle 64-bit client on your ArcGIS Server machine:
  • Configure a database connection for ArcGIS Server—Manage data | Documentation for ArcGIS Enterprise 
  • https://enterprise.arcgis.com/en/server/latest/manage-data/windows/connect-oracle.htm#ESRI_SECTION1_... 

• Register the Oracle DB with ArcGIS Server - Register an Oracle database with ArcGIS Server—Manage data | Documentation for ArcGIS Enterprise 

Hopefully that will get you going!