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 |
|
jpad
Starting Member
2 Posts |
 Posted - 2008-01-16 : 12:37:26
|
Hello all,I have been reading these forums for a while but I am now a new member and relatively new to SQL (< 1 year exp). In a project that I am currently working on I would like to include information related to current market news. An example would be news updates for certain companies that are generated from the Wall Street Journal or MarketWatch. The application would only be used internally and information would only be shared within the organization.What I'd like to find out is: - Has anyone else worked with or developed something like this? If so, can you please share some insight.
- Would I need to purchase a Corproate License to use this information or would a personal account that can access the information be enough?
- What would be the best way to feed the database with this information? E-mails to the server, SSIS, etc.
Thank you for your help and I look forward to learning from you insight and experience. |
|
|
jhocutt
Constraint Violating Yak Guru
385 Posts |
Posted - 2008-01-16 : 15:11:11
|
| >>>Has anyone else worked with or developed something like this? If so, can you please share some insight.Yes, and they are farly easy to implement>>Would I need to purchase a Corproate License to use this information or would a personal account that can access the information be enough?I am not a Lawyer, but I would bet your personal account says for personal use only. When we were loading news feeds we purchased an API and a license to resell the feed >>What would be the best way to feed the database with this information? E-mails to the server, SSIS, etc. Depends on the news service. But the ones we used supported a flat file Pipe delimited that we bulk loaded. "God does not play dice" -- Albert Einstein"Not only does God play dice, but he sometimes throws them where they cannot be seen." -- Stephen Hawking |
 |
|
|
jpad
Starting Member
2 Posts |
Posted - 2008-01-16 : 15:34:19
|
| Thanks for the info jhocutt, I really appreciate it. I reached out to a couple vendors today to receive more information. Can you reccomend any service in particular and do you have a guideline for what I can expect for costing? |
|
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2008-01-17 : 07:41:57
|
| I assume you are using SQL Server - if so , if the feed comes as an XML file , then use OPENXML , to read feed into a table , whereby you can allow various clients to viewJack Vamvas--------------------Search IT jobs from multiple sources- http://www.ITjobfeed.com |
|
|
|
|
|
|
|
|
Feeding Database with External News Feeds