# Store twitter data into DB2
**URL:** https://discourse.nodered.org/t/store-twitter-data-into-db2/29891
**Category:** General
**Created:** [11 July 2020 10:58 UTC](https://discourse.nodered.org/t/store-twitter-data-into-db2/29891 "2020-07-11T10:58:04Z")
**Posts on this page:** 7
**Page:** 1
### Author:  [@jahnavi\_30](https://discourse.nodered.org/u/jahnavi_30)
#### Post date: [11 July 2020 10:58 UTC](https://discourse.nodered.org/t/store-twitter-data-into-db2/29891/1 "2020-07-11T10:58:05Z")
Hello Team, I'm working with Twitter Sentiment Analysis using Node-RED. Have to collect the streaming twitter data into a DB2(dashDB) database. Could someone help me out with this.
Thank you.
---
### Author:  [@zenofmud](https://discourse.nodered.org/u/zenofmud)
#### Post date: [11 July 2020 11:16 UTC](https://discourse.nodered.org/t/store-twitter-data-into-db2/29891/2 "2020-07-11T11:16:07Z")
This seems straight forward:
1- data comes in form the twitter node
2 - you formate the data nto a insert query (based on the DB node ou are using)
3 - you insert the data
What part of this are you having problems with?
1 - have you defined the database yet?
2 - which node are you using to access the database?
3 - can you do a query of the database?
4 - what data from the twitter streem are you storing in the database?
Add `debug` nodes in the flow so you can see what is coming out of various nodes. If you capture the data coming out of the `twitter` node, you could put it in an `insert` node for testing the formating of the query and insert.
---
### Author:  [@jahnavi\_30](https://discourse.nodered.org/u/jahnavi_30)
#### Post date: [11 July 2020 12:00 UTC](https://discourse.nodered.org/t/store-twitter-data-into-db2/29891/3 "2020-07-11T12:00:12Z")
@zenofmud Can I share the link of my flow, so that you can review?
---
### Author:  [@ristomatti](https://discourse.nodered.org/u/ristomatti)
#### Post date: [11 July 2020 12:14 UTC](https://discourse.nodered.org/t/store-twitter-data-into-db2/29891/4 "2020-07-11T12:14:54Z")
See [How to share code or flow json](https://discourse.nodered.org/t/how-to-share-code-or-flow-json/506).
---
### Author:  [@jahnavi\_30](https://discourse.nodered.org/u/jahnavi_30)
#### Post date: [11 July 2020 12:21 UTC](https://discourse.nodered.org/t/store-twitter-data-into-db2/29891/5 "2020-07-11T12:21:46Z")
@ristomatti, Here is the link to my flow
`[EDIT: Link removed by Moderator]`
Kindly check if I went wrong somewhere in the DB2 tweet store function node and TWEETS dashdb node.
Thank you.
---
### Author:  [@zenofmud](https://discourse.nodered.org/u/zenofmud)
#### Post date: [11 July 2020 13:05 UTC](https://discourse.nodered.org/t/store-twitter-data-into-db2/29891/6 "2020-07-11T13:05:16Z")
I really don't think you want to provide that link. Someone could go in and delete your entire flow.
Go read the link @ristomatti poined you to and then add you export to a reply.
Look at any error messages you get in your debug sidebar and use only one debug per naoe to make it easier to see where problems are occurring.
---
### Author:  [@system](https://discourse.nodered.org/u/system)
#### Post date: [9 September 2020 13:05 UTC](https://discourse.nodered.org/t/store-twitter-data-into-db2/29891/7 "2020-09-09T13:05:24Z")
This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.