topic Direct connection to RDBMS in ArcGIS GeoEvent Server Questions

Direct connection to RDBMS

Srinivasa_MurthyNemani — Mon, 13 Jul 2015 04:07:40 GMT

Hi, i'm new bee to GeoEvent Processor, I created a small project where I followed the below listed steps.

Created a RESTful (json) service with a valid RDBMS.
Used "Poll an External Website for JSON", as input connector.
Used "Send a Mail", as output connector.
Created a Geoevent Service.

Every thing works fine as I could get the Mail response.

My concern is, I want to push data directly from RDBMS to an input connector instead of using a web service.

If possible please let me know how can I achieve the same.

Re: Direct connection to RDBMS

larryzhang — Mon, 13 Jul 2015 04:32:30 GMT

S.,

Are you looking for a 'live' mapping solution without GeoEvent?

Re: Direct connection to RDBMS

Srinivasa_MurthyNemani — Mon, 13 Jul 2015 04:44:17 GMT

Hi Larry thank you for quick reply,

My data is fed to Oracle database which comes from multiples sensors.

So, I want a way to add Oracle database as an input connector, by which i can map the events.

Re: Direct connection to RDBMS

larryzhang — Mon, 13 Jul 2015 05:05:49 GMT

Sound nice idea.

It looks to me that ESRI GeoEvent does not directly map 'live' data in RDBMS like Oracle. However, some of the recommendations from ESRI are offered for reference. Pls refer to GeoEvent process Oracle/SQL connector

++++++++++

In fact, some of the massive oil producing data (i.e., streaming into Oracle database from massive live sensors in the oil fields) could be mapped in this way, while analyzing big data ...

Re: Direct connection to RDBMS

Srinivasa_MurthyNemani — Mon, 13 Jul 2015 05:33:41 GMT

Hi Larry Thanks for that,

I did the same using .Net technology.

Here is the screenshot, which depects the basic workflow

What I'm looking is some thing shown below.

Just want to confirm whether can we achieve that.

But according to RJ Sunderman is not possible I guess.

Re: Direct connection to RDBMS

larryzhang — Mon, 13 Jul 2015 05:58:07 GMT

Without some hard coding effort, it would be challenging, mostly!

However, we may look for a third-party or request Oracle building a bridge (saying, GeoEvent for Oracle). One of the reasons is: ESRI is trying to keep GeoEvent database-independent...

What do you think of it?

Re: Direct connection to RDBMS

Srinivasa_MurthyNemani — Mon, 13 Jul 2015 06:04:20 GMT

Yeah!, but i wanna stick to ESRI ..

Re: Direct connection to RDBMS

larryzhang — Mon, 13 Jul 2015 06:17:41 GMT

nice to conduct ESRI GE team for this...

please update any progress...