cancel
Showing results for 
Search instead for 
Did you mean: 

External querying and export

pivotpab
Node

Hi All,

I really apologise if I'm writing this all wrong as it's my first post and I'm new to neo4j.

I simply want to find an external tool that I can connect to neo4j dB with to query the json.

Ideally I'm looking for a way to automate the export of a csv file via a tool each morning... That will query the DB, and return the results as a table within the csv file.

I'm. Sorry if I've not provodes enough info. Please do let me know.

Any help is appreciated

3 REPLIES 3

Not 100% sure what you need, like a cron job?

You could use cypher-shell with a cypher query to gather your data.

cat data-export.cypher | bin/cypher-shell -u username -p password

pivotpab
Node

Thanks for replying Michael. This is interesting.

So basically I want to query Neo4j using Match and Return. A scenario would be to have a batch file execute a tool (perhaps Cypher shell) that has the query stored that will run against Neo4j and export the results to file (e.g. CSV)

I guess then the batch could add the file to a specific folder. Would Cypher shell query and export from a local machine (with the right perms)?

Thanks

Cypher shell runs on the machine you run it on.
It can connect to remote neo4j servers.

You can redirect the output to a file (which might have a date suffix)
And the statements to run can come from a file too

For details on how to do this on your system I recommend to talk to your ops/devops/admin folks.

Nodes 2022
Nodes
NODES 2022, Neo4j Online Education Summit

On November 16 and 17 for 24 hours across all timezones, you’ll learn about best practices for beginners and experts alike.