Archive | Integration RSS feed for this section

7 June 2012 15 Comments

Building and Loading Sexy Operational Dashboards with

You never know what awesome stuff you’re going to find… While I was browsing the web yesterday evening, I landed upon a article explaining how ‘Starting Pages’ are out-of-fashion and now everyone wants a ‘Data Dashboard’. Which, intrigued me – since dashboards and operational analytics are a big part of what I do for a […]

13 March 2012 38 Comments

Harvesting Twitter Search Results for Analysis using Python & SQL Server

Twitter. It’s everywhere. It’s Data. Realtime, Social, Contextual Data. But, if you want to do any real trending, data mining, post-processing, or even simple analysis on it – you really need to be making a historical record of what you’re looking for and store it in a usable way. I will show you how to create SQL Server tables and use a simple Python script to pull out tweets and save them for future analysis.

18 August 2010 7 Comments

Mortgage Software Hack: Importing Contacts automatically into Encompass WITHOUT the SDK (just with SQL)

Anyone who has ever dealt with the mortgage software package “Encompass” from Ellie Mae – from any kind of support / IT standpoint knows the pain. It just… well, doesn’t behave as you would assume. Seemingly simple things (from an integration / workflow standpoint) just don’t play nice, help in the web forums is laughable, […]