# Creating a new node from relational database

**URL:** <https://community.neo4j.com/t/creating-a-new-node-from-relational-database/3801>\
**Category:** Neo4j Graph Platform\
**Created:** [December 12, 2018, 5:47pm UTC](https://community.neo4j.com/t/creating-a-new-node-from-relational-database/3801 "2018-12-12T17:47:15Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![jcuevasmunoz](https://sea1.discourse-cdn.com/flex021/user_avatar/community.neo4j.com/jcuevasmunoz/32/2263_2.png) [@jcuevasmunoz](https://community.neo4j.com/u/jcuevasmunoz)\
**Post date:** [December 12, 2018, 5:47pm UTC](https://community.neo4j.com/t/creating-a-new-node-from-relational-database/3801/1 "2018-12-12T17:47:15Z")

</div>

Hi,

I have a connection between SQL SERVER to my neo4j db using APOC. I created a node called "People" and have 88 people in the graph. My question is: if I add a person on my relational database, how can I see that person in my neo4j database as new node?

Best.

---

<div class="post-metadata">

**Author:** ![ameyasoft](https://sea1.discourse-cdn.com/flex021/user_avatar/community.neo4j.com/ameyasoft/32/32639_2.png) [@ameyasoft](https://community.neo4j.com/u/ameyasoft)\
**Post date:** [December 14, 2018, 4:02am UTC](https://community.neo4j.com/t/creating-a-new-node-from-relational-database/3801/2 "2018-12-14T04:02:05Z")

</div>

Hi,

I am having some problems in connecting my sql server to Neo4j. I appreciate sharing the steps you took to make the connection.  
Thanks,  
-Kamal

---

<div class="post-metadata">

**Author:** ![jcuevasmunoz](https://sea1.discourse-cdn.com/flex021/user_avatar/community.neo4j.com/jcuevasmunoz/32/2263_2.png) [@jcuevasmunoz](https://community.neo4j.com/u/jcuevasmunoz)\
**Post date:** [December 14, 2018, 11:28am UTC](https://community.neo4j.com/t/creating-a-new-node-from-relational-database/3801/3 "2018-12-14T11:28:40Z")

</div>

Hi, Kamal:

I connected SQL SERVER using APOC.

1.- Install APOC in neo4j.  
2.- Create a query, in my case:

```auto
call apoc.load.jdbc(jdbc:sqlserver://localhost:1433;databaseName=DATABASENAME;user=USER;password=PASSWORD,'House') 
yield row
create (p:House) 
set p=row
set p.NodeName = 'House';

```

I don't have a connection automatically, but now, I'm searching how I can do it.

---

<div class="post-metadata">

**Author:** ![ameyasoft](https://sea1.discourse-cdn.com/flex021/user_avatar/community.neo4j.com/ameyasoft/32/32639_2.png) [@ameyasoft](https://community.neo4j.com/u/ameyasoft)\
**Post date:** [December 14, 2018, 5:46pm UTC](https://community.neo4j.com/t/creating-a-new-node-from-relational-database/3801/4 "2018-12-14T17:46:37Z")

</div>

Hi,

Thanks for sharing the code and that really helped me. I could connect to my sql server.

For updating, check this Kafka integration article by Michael Hunger:

> **[A New Neo4j Integration with Apache Kafka](https://medium.com/neo4j/a-new-neo4j-integration-with-apache-kafka-6099c14851d2)**
>
> Today we want to make this available in a first release under an Apache License for you to try out and test. It works with Neo4j from 3.4.x

-Kamal