SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Building a Yahoo Finance input adapter for SQL Server StreamInsight


Building a Yahoo Finance input adapter for SQL Server StreamInsight

Author
Message
JAhlen
JAhlen
SSC-Addicted
SSC-Addicted (404 reputation)SSC-Addicted (404 reputation)SSC-Addicted (404 reputation)SSC-Addicted (404 reputation)SSC-Addicted (404 reputation)SSC-Addicted (404 reputation)SSC-Addicted (404 reputation)SSC-Addicted (404 reputation)

Group: General Forum Members
Points: 404 Visits: 134
Comments posted to this topic are about the item Building a Yahoo Finance input adapter for SQL Server StreamInsight
Ayyappan Thangaraj
Ayyappan Thangaraj
SSC Veteran
SSC Veteran (204 reputation)SSC Veteran (204 reputation)SSC Veteran (204 reputation)SSC Veteran (204 reputation)SSC Veteran (204 reputation)SSC Veteran (204 reputation)SSC Veteran (204 reputation)SSC Veteran (204 reputation)

Group: General Forum Members
Points: 204 Visits: 154
Thanks for your time spend for this article.

It is a wonderful article for Intro about StreamInsight. How can it help BI developer?

Please share your view according to real time data processing and reporting.
JAhlen
JAhlen
SSC-Addicted
SSC-Addicted (404 reputation)SSC-Addicted (404 reputation)SSC-Addicted (404 reputation)SSC-Addicted (404 reputation)SSC-Addicted (404 reputation)SSC-Addicted (404 reputation)SSC-Addicted (404 reputation)SSC-Addicted (404 reputation)

Group: General Forum Members
Points: 404 Visits: 134
adolf.ayyappan (11/25/2009)
Thanks for your time spend for this article.

It is a wonderful article for Intro about StreamInsight. How can it help BI developer?

Please share your view according to real time data processing and reporting.


That could be the subject of another article! :-)

I would say it helps BI developers build systems that react fast. For instance you can monitor blogs and news feeds, sending automatic alerts to key persons so they can act directly in case of bad publicity.

You can also use StreamInsight to do the collection job and initial filtering when you have environments that produce high speed data output.

/Johan
fotothis
fotothis
Grasshopper
Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)

Group: General Forum Members
Points: 15 Visits: 196
Thank you for a great post on such a new technology, Johan.

Have you had a chance to test the code on the SQL Server 2008 R2 November CTP release? At first glance, it won't compile with Nov CTP version.
noeld
noeld
SSC Guru
SSC Guru (51K reputation)SSC Guru (51K reputation)SSC Guru (51K reputation)SSC Guru (51K reputation)SSC Guru (51K reputation)SSC Guru (51K reputation)SSC Guru (51K reputation)SSC Guru (51K reputation)

Group: General Forum Members
Points: 51208 Visits: 2052
What I still don't get is "What does all of this has to do with SQL Server ?". It looks like a completely independent product. Sure you can insert into a database or read configuration data from it but why is it bundled with SQL Server?


* Noel
JAhlen
JAhlen
SSC-Addicted
SSC-Addicted (404 reputation)SSC-Addicted (404 reputation)SSC-Addicted (404 reputation)SSC-Addicted (404 reputation)SSC-Addicted (404 reputation)SSC-Addicted (404 reputation)SSC-Addicted (404 reputation)SSC-Addicted (404 reputation)

Group: General Forum Members
Points: 404 Visits: 134
fotothis (11/25/2009)
Thank you for a great post on such a new technology, Johan.

Have you had a chance to test the code on the SQL Server 2008 R2 November CTP release? At first glance, it won't compile with Nov CTP version.


I submitted this article over a month ago, before the Nov CTP. I will submit a new version that compiles on Nov CTP on Codeplex

http://stockticker.codeplex.com
JAhlen
JAhlen
SSC-Addicted
SSC-Addicted (404 reputation)SSC-Addicted (404 reputation)SSC-Addicted (404 reputation)SSC-Addicted (404 reputation)SSC-Addicted (404 reputation)SSC-Addicted (404 reputation)SSC-Addicted (404 reputation)SSC-Addicted (404 reputation)

Group: General Forum Members
Points: 404 Visits: 134
noeld (11/25/2009)
What I still don't get is "What does all of this has to do with SQL Server ?". It looks like a completely independent product. Sure you can insert into a database or read configuration data from it but why is it bundled with SQL Server?



Hi Noel,

I think Microsoft sees it as a component like SSIS. It's like an SSIS for CEP (Complex Event Processing). I guess also it may later be integrated into Management Studio.

/Johan
evald
evald
Ten Centuries
Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)

Group: General Forum Members
Points: 1160 Visits: 245
Hello,
thanks for this article. Very simple and clear.
A question: what if i want to persist the stock quotes on a database(i.e sql2008)?
What approach would you advice?
Using an outputadpater?
thank you
JAhlen
JAhlen
SSC-Addicted
SSC-Addicted (404 reputation)SSC-Addicted (404 reputation)SSC-Addicted (404 reputation)SSC-Addicted (404 reputation)SSC-Addicted (404 reputation)SSC-Addicted (404 reputation)SSC-Addicted (404 reputation)SSC-Addicted (404 reputation)

Group: General Forum Members
Points: 404 Visits: 134
evald (12/10/2009)
Hello,
thanks for this article. Very simple and clear.
A question: what if i want to persist the stock quotes on a database(i.e sql2008)?
What approach would you advice?
Using an outputadpater?
thank you


Yes, you should use an output adapter.

Kind Regards,
Johan
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum








































































































































































SQLServerCentral


Search