This Week in Neo4j – Neo4j ETL Tool Tutorial, Release of JDBC Driver, Neo4j on AWS Marketplace

This week’s featured community member is opens in new tabDavid Meza, Chief Knowledge Architect at NASA.

David has been part of the Neo4j community for several years and is best known for his work building a graph of the public NASA Engineering Network lesson learned database, which he opens in new tabwrote about in July 2015. He was also opens in new tabinterviewed about his work on the Graphistania podcast.

David’s opens in new tabHow NASA Finds Critical Data Through a Knowledge Graph talk at GraphConnect San Francisco 2016 was one of the most popular at the conference. You can also find opens in new tabthe slides from David’s talk.

David was interviewed as part of the Forbes article “Why NASA Can Now Visualize Its Lessons Learned” and was also interviewed as part of our opens in new tab5 minute interview series.

On behalf of the Neo4j community, thanks for all your work David!

opens in new tabJennifer Reif has opens in new tabwritten a detailed post explaining how to use the opens in new tabNeo4j ETL Tool from the Neo4j Desktop.

Jennifer starts by showing how to enable the tool via an activation key , and then imports the Northwind dataset from a PostgreSQL relational database into Neo4j.

If you’d like to get an activation key send us an email devrel@neo4j.com and we’ll send one over.

Will Lyon opens in new tabwrote a blog post in which he shows how to build an application that makes use of the temporal and geospatial data types that were introduced in Neo4j 3.4.

Will takes us through the steps to build a React.js dashboard type application that allows a user to search for businesses by location that have reviews within a certain date range and display some charts based on aggregations of these reviews.

You can find opens in new tabthe code for this project on Github and try it live here.

opens in new tabRik has also been exploring how to opens in new tabuse the spatial data type to locate breweries in the opens in new tabOpen Beer Database.

opens in new tabDave Bechberger shared the slides from his NDC Oslo 2018 talk – opens in new tabA Practical Guide to Graph Databases.

If you’re just getting into graph databases this is an excellent overview of the field and different tools available.

Aaron Lelevier has been learning about Graph Theory and has opens in new tabwritten a blog post in which he distills his learnings.

Aaron explains the different types of graphs, ways of representing them, and shares a project where he built a opens in new tabbidirectional graph of his GitHub followers.

A couple of years ago there was opens in new taba big story about the 1Malaysia Development Berhad (IMDB), a fund that was created by the Malaysian government to promote economic development through global partnerships and foreign direct investment. The FBI posted a filing to seize their assets under the US Department of Justice and FBI’s Kleptocracy Asset Recovery Initiative.

There was an opens in new tabarticle written back in 2016 by The Sinar Project where they explained how they’d used their Popit Database of Politically Exposed Persons helps uncover culprits and hold officials accountable.

This week sweemeng, a member of the Sinar Project, opens in new tabwrote a blog post explaining in more detail how they built the graph, how the data’s organised, and why their method worked for exploring this type of data.

You can find the source code for the data loader in the opens in new tabsinar/popit_relationship GitHub repository.

This week our friends at LARUS opens in new tabreleased version 3.3.1 of the Neo4j-JDBC driver.

The release has been upgraded to work with recent Neo4j 3.3.x versions and Bolt driver 1.4.6. Work is in progress on Neo4j 3.4.x and drivers 1.6.x.

The main addition has been support for Neo4j clusters, the JDBC driver now supports, routing, read-only transaction, routing-policies and bookmarks for causal consistency.

There are also other improvements including support for in-memory databases, a debug feature to inspect how the driver works when used by third-party tools, and support for TrustStrategy.

If you want to use the Neo4j-JDBC driver in your application, you can depend on org.neo4j:neo4j-jdcb:3.3.1 in your build setup or grab the opens in new tablatest release from GitHub.

What’s happening next week in the world of graph databases?

My favourite tweet this week was by opens in new tabEddy Wong:

Don’t forget to RT if you liked it too.

That’s all for this week. Have a great weekend!

Cheers, Mark