Skip to Content
Technical Articles
Author's profile photo Peter Ha

Advantco Neo4j adapter for SAP PO


Neo4j is a graph database designed to treat the relationships between data as equally important to the data itself. Neo4j natively supports relationships is able to store, process, and query connections efficiently. While other databases compute relationships at query time through expensive JOIN operations, a graph database stores connections alongside the data in the model.

Cypher is Neo4j’s graph query language that allows users to store and retrieve data from the graph database. Neo4j wanted to make querying graph data easy to learn, understand, and use for everyone, but also incorporate the power and functionality of other standard data access languages.

The Advantco Neo4j adapter makes integration easy with the Neo4j graph database and supports following operations Create, Update, Delete, Merge and Query. The adapter supports Cypher’s syntax to query the graph database.


Example of Neo4j sender channel using Cypher query.

MATCH (t:Tournament {year: 2019})<-[:PARTICIPATED_IN]-(team) WITH team, [(team)-[:PARTICIPATED_IN]->(other) WHERE other.year < 2019 | other] AS otherTournaments RETURN, size(otherTournaments) AS tournaments

Neo4j receiver channel supports following operations: Create, Update, Delete, Merge, Query

Mapping of XML payload to CREATE an order with multiple lineitems.

<?xml version="1.0" encoding="UTF-8"?>
				<customerID>match (c:Customer {customerID: &quot;WHITC&quot;}) return c.customerID</customerID>
				<shipName>match (c:Customer {customerID: &quot;WHITC&quot;}) return c.companyName</shipName>
				<orderDate>2020-02-17 00:00:00.000</orderDate>
			<START_ID>match (c:Customer {customerID: &quot;WHITC&quot;}) return c</START_ID>
			<END_ID>match (p:Product) where p.productID in [&quot;11&quot;] return p</END_ID>


We will provide more detailed steps in follow-up blogs.



Assigned Tags

      1 Comment
      You must be Logged on to comment or reply to a post.
      Author's profile photo Ashish Bahl
      Ashish Bahl

      Please connect to me at for a demo or any of your technical/sales questions.