Connector to Oracle to pump data to ES

Johnny · July 25, 2012, 7:23pm

Hi All,

I am new to ES, I am looking for.

A connector that should pump my Oracle data to ES on full build.
If any changes[Delta] happens to my oracle records, it should detect and
pump the changes alone to ES.

Is there anything like data import handler[As like SOLR] stuff available in
ES?

Thanks,

Johnny

dadoonet · July 25, 2012, 7:40pm

Have a look at the great JDBC plugin from Jörg :

https://github.com/jprante/elasticsearch-river-jdbc https://github.com/jprante/elasticsearch-river-jdbc

David.

De : elasticsearch@googlegroups.com [mailto:elasticsearch@googlegroups.com] De la part de Johny Jebaraj Israel
Envoyé : mercredi 25 juillet 2012 21:24
À : elasticsearch@googlegroups.com
Objet : Connector to Oracle to pump data to ES

Hi All,

I am new to ES, I am looking for.

A connector that should pump my Oracle data to ES on full build.
If any changes[Delta] happens to my oracle records, it should detect and pump the changes alone to ES.

Is there anything like data import handler[As like SOLR] stuff available in ES?

Thanks,

Johnny

Karussell1 · July 25, 2012, 9:44pm

also there is a "sql connector" compilation:

gist.github.com

https://gist.github.com/karussell/2878392

elasticsearch-import-data

Why is there no such DataImportHandler thing in ElasticSearch? Uhm, well ... but because:

1. You should really consider your own scripts 
(be it jvm based, perl, ruby, php, nodejs/javascript) 
to feed ElasticSearch via bulk indexing: 
http://www.elasticsearch.org/guide/reference/java-api/bulk.html

2. There are two projects doing it already:
 * http://code.google.com/p/sql-to-nosql-importer/
 * https://github.com/Aconex/scrutineer (keeps DB in synch with ES or solr!)

This file has been truncated. show original

Regards,
Peter.

R_Donovan · February 19, 2014, 4:46pm

Some great suggestions already, we use mule esb to feed a number feeds and
data sources into ES

Richard

On Wednesday, July 25, 2012 8:23:51 PM UTC+1, johnny jebaraj wrote:

Hi All,

I am new to ES, I am looking for.

A connector that should pump my Oracle data to ES on full build.

If any changes[Delta] happens to my oracle records, it should detect
and pump the changes alone to ES.

Is there anything like data import handler[As like SOLR] stuff available
in ES?

Thanks,

Johnny

--
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/38a58e04-3d90-439b-a152-05b6470caaf6%40googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.