We are looking to build an application wherein the app will poll a SQL CRM database and then utilize the TwitterAPI to search for tweets where a term is found.
Later we will need same for Facebook and LinkedIn, etc. so the program must be modular in design.
The results will be posted back into the CRM database related to the @username and/or #hash searched on.
DETAILED DESCRIPTION
We are a CRM Systems consulting company. It is our goal to assist our clients and ourselves in building deeper relationships with prospects in order to build the client base.
We desire to have a program that will take a twitterID and/or #hashtag and use the TwitterAPI to search for posts by the twitterID and post such information found back into the CRM database. The CRM databases are MSSQL 2005 and/or MSSQL 2008.
The program should have the ability to fetch multiple search terms from the CRM database; execute the search on Twitter using the TwitterAPI; bring the content of the tweets back to the CRM database and post such information into a record matched on the twitterID.