Business Intelligence Blogs

View blogs by industry experts on topics such as SSAS, SSIS, SSRS, Power BI, Performance Tuning, Azure, Big Data and much more! You can also sign up to post your own business intelligence blog.

A Simple Twitter Console Application

  • 17 December 2009
  • Author: Brian Knight
  • Number of views: 6386
  • 0 Comments

I've been working this week to automate the BIDN.com's twitter connectivity and to do so, decided to build a quick Twitter interface to communicate with BIDN.  I needed a simple console application that could be called via a trigger or a SQL Agent Job (my actual method).

The entire application winds up only being a 50 lines of code or so. Essentially from a command line, you pass in your twitter account, password, the message and optional URL. If you pass a URL in, it will be converted to TinyURL (if it's shorter than your URL). The return will either give you a success or a failure in XML from the console.

Call TweetConsole as shown below:

TweetConsole.exe

Example:

TweetConsole.exe UserName Password "My twitter message in quotes" "http://www.bidn.com/inquotes"

Then whalla, a DBAs way to integrate twitter into a database for posting at least. It isn't the prettiest applicaton but it works Laughing

Download TweetConsole

I'd love to hear if you actually use it! The benefit for me is now on BIDN any new blog posts gets automatically tweeted.

Print
Tags:
Rate this article:
No rating
Brian Knight

Brian KnightBrian Knight

Other posts by Brian Knight

Please login or register to post comments.