topic Re: Access live data in Oracle in ArcGIS Insights Questions

Access live data in Oracle

ModyBuchbinder — Fri, 04 Aug 2017 07:23:23 GMT

One of the new features in 2.0 is the connection to Oracle.

The problem with this connection it does not support geodatabase.

My understanding was that it just ignore the metadata tables and see all tables as simple tables.

It looks like it will not connect if it find metadata tables (gdb_items etc).

All our data in Oracle geodatabase and we do not like to publish/register each layer to be able to see it in Insights.

Is there any work around? Maybe create a new user that will not have access to the metadata tables (but they are public!!).

Any ideas?

Thanks

Re: Access live data in Oracle

Asrujit_SenGupta — Fri, 04 Aug 2017 09:11:59 GMT

No, as the Supported databases—Insights web help Use tab | ArcGIS Enterprise link clearly states:

Currently, Insights for ArcGIS does not allow you to create a connection to a relational database that has an enterprise geodatabase defined.

Re: Access live data in Oracle

ModyBuchbinder — Sun, 06 Aug 2017 04:40:27 GMT

I understand if it does not read the metadata and just ignore them. I find it hard to believe that someone in ESRI wrote a code that if metadata tables exists then do not connect.

Re: Access live data in Oracle

ModyBuchbinder — Tue, 12 Sep 2017 04:50:20 GMT

Hi All

I see that only Oracle 12 is supported. We currently have Oracle 11 only. Any way to access Oracle 11?

Thanks

Re: Access live data in Oracle

Asrujit_SenGupta — Tue, 12 Sep 2017 17:58:04 GMT

If this request is for direct access to a native Oracle 11g instance, for native support, Insight currently only supports direct read of Oracle 12c as you already checked.

If this request is for Geodatabase, Insight does support Oracle 11g gdb through the use of feature services.

Re: Access live data in Oracle

Asrujit_SenGupta — Wed, 11 Oct 2017 04:51:48 GMT

Mody Looks like it is finally here!

What’s new in Insights for ArcGIS 2.1 | ArcGIS Blog

Supported databases—Insights web help Use tab | ArcGIS Enterprise

Re: Access live data in Oracle

farahQasem91 — Sun, 18 Apr 2021 10:34:55 GMT

Hi Asrujit,

I can read from Oracle 11g, but when trying to perform analysis its not giving something went wrong and the error from ArcGIS server is : Query [55] failed "ERROR: syntax error at or near "." Position: 146": CREATE TABLE "$IN_import_b8slbb2gt98ba0pktb0598e3nf"