Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
dbonneau
Yak Posting Veteran
50 Posts |
 Posted - 2009-03-26 : 17:02:46
|
| Hi,Is is possible to store streaming data into MS SQL SERVER in realtime and display the data in Excel concurrently using ODBC ?Thanks ! |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2009-03-26 : 17:08:08
|
Do you mean streaming data? (I've got an idea about steaming data, but you don't want to hear it)  You need to be more clear about what you mean by streaming data and more details on your scenario. My opinion is that even if you could do it, sending it back out to Excel kinda defeats the purpose. Again, without clarification it's hard to say. |
 |
|
|
voyager838
Yak Posting Veteran
90 Posts |
Posted - 2009-05-10 : 12:13:39
|
| Hi I also want to stream the data into MS SQL SERVER in realtime.My situations is thisI have lots of data that comes directly from several measuring devices, i have teen devices on different location that in every 2 minutes tries to send data to database.I have one though about how to performing this. I would proberly have to create some kind of trigger that would update the pre-prepare tablethat i already have in my database. When a new data is incoming, it will trigger the events and update the pre-prepare datatable. I also will have to signal that this events have happen somewhere so if i have an front-end application i could check if a new data has incoming. And sending and query to recieve that new data.One important thing here is to sync the data in some way, but here is where the problem starts, if every device is sending on the same time to database, what can we do to handle several input that arrived to our trigger? What can be done to handle that in database?Could it be buffering up somewhere, maby in a tablevariable or somewhere, and when all data has incoming than update the table?I dont know if this a really good way, or if does an better way to store data in realtime?But this is an idea.Gratefull if other has different aspects or though on this.It is an very interesting challenge indeed. |
|
|
|
|
|
|
|
|
store steaming data into MS SQL SERVER