[Neo4j] ODBC connection
patenlee
know if a Neo4J ODBC driver is available to access the Neo4j objects.
--
View this message in context: http://neo4j-community-discussions.438527.n3.nabble.com/ODBC-connection-tp3566658p3566658.html
Sent from the Neo4j Community Discussions mailing list archive at Nabble.com.
_______________________________________________
Neo4j mailing list
Us...@lists.neo4j.org
https://lists.neo4j.org/mailman/listinfo/user
Mattias Persson
2011/12/7 patenlee <leo.de...@bpsolutions.nl>
--
Mattias Persson, [mat...@neotechnology.com]
Hacker, Neo Technology
www.neotechnology.com
_______________________________________________
NOTICE: THIS MAILING LIST IS BEING SWITCHED TO GOOGLE GROUPS, please register and consider posting at https://groups.google.com/forum/#!forum/neo4j
Rickard Öberg
Yes, I have written an experimental JDBC driver that uses the REST API
to map JDBC calls to Cypher. It is available at:
http://github.com/rickardoberg/neo4j-jdbc
This can be used to access Neo4j data. Since Cypher does not yet
support updates this is read-only, but can be good for reporting
purposes. I have so far tested it with DbVisualizer and
LibreOffice/OpenOffice, and it works there (the driver has "quirks
mode" for each of these to translate the standard SQL calls these
tools make into Cypher). I have also packaged the driver as an applet
so that it can be used from Javascript in an HTML page:
https://github.com/rickardoberg/neo4j-jdbc-applet
With example:
https://github.com/rickardoberg/neo4j-jdbc-web
These were done yesterday, so not yet production ready, but feel free
to try it out and provide feedback.
This allows Neo4j to be accessed by tools that support JDBC, but not
ODBC. I'm trying to find out if there's a way to do it (the standard
JDBC/ODBC bridge does it in the other direction), but have little hope
that it can be done easily. What is the tool that you want to use to
access Neo4j from, and does it only support ODBC, or would JDBC be
fine?
/Rickard
Rickard Öberg
Sooo, I had a look at ODBC, and there is actually a ODBC-JDBC Gateway
available from here:
http://www.easysoft.com/products/data_access/jdbc_odbc_bridge/index.html
I downloaded and installed it, and then tried out a generic ODBC tool with it:
http://www.sliksoftware.co.nz/products/odbcview/
With this I could set up a Neo4j ODBC source in Windows, and send
Cypher requests to a Neo4j Server and view that as a table in the
tool. So, that chain actually works.
But I think it is entirely dependent on what ODBC client you want to
use, as I'm sure each and every one of them will do slightly different
calls. So if you can let me know maybe I can test whichever you are
interested in, to see if it works. I am actually able to remote debug
the driver to see what is going on, so that is pretty simple.
regards, Rickard
pate...@hotmail.com
I will thank you for the information. The idea is to connect IBM Optim
(tool for subsetting and masking data) to Neo4j. The standard solution
is the implementation of a federation server to connect Optim with a
not supportted database platform. The federation server is the ODBC-
JDBC Gateway and uses nicknames in a DB2 database to translate the
Optim database schema to the schema of the native database. This has
impact on the architecture of the solution because an additional layer
is required to do the translation. I am will discuss the details with
my peers and will come back to you if we have additional questions and
need your support.
Kind regards,
Leo
On 14 dec, 07:34, Rickard Öberg <rickard.ob...@neotechnology.com>
wrote:
> >> 2011/12/7 patenlee <leo.de.vr...@bpsolutions.nl>
>
> >>> I want to access from an external application Neo4j objects. Does anybody
> >>> know if a Neo4J ODBC driver is available to access the Neo4j objects.
>
> >>> --
> >>> View this message in context:http://neo4j-community-discussions.438527.n3.nabble.com/ODBC-connecti...
> >>> Sent from the Neo4j Community Discussions mailing list archive at Nabble.com.
> >>> _______________________________________________
> >>> Neo4j mailing list
> >>> U...@lists.neo4j.org
> >>>https://lists.neo4j.org/mailman/listinfo/user
>
> >> --
> >> Mattias Persson, [matt...@neotechnology.com]
> >> Hacker, Neo Technology
> >>www.neotechnology.com
>
> _______________________________________________
> NOTICE: THIS MAILING LIST IS BEING SWITCHED TO GOOGLE GROUPS, please register and consider posting athttps://groups.google.com/forum/#!forum/neo4j
>
> Neo4j mailing list
> U...@lists.neo4j.orghttps://lists.neo4j.org/mailman/listinfo/user- Tekst uit oorspronkelijk bericht niet weergeven -
>
> - Tekst uit oorspronkelijk bericht weergeven -