From recent consulting projects, I have learned that analyzing data in Microsoft Office enables unique and valuable business insights across an organization. In particular, these projects were based on ODBC connectivity to Excel/Access from applications such as SAS (SAS/Access interface to ODBC),...
2012 has certainly been an exciting year! London hosted the XXX Olympic games, the U.S. had an election, Hurricane Sandy struck the East Coast, ‘The Hobbit’ is coming out soon, and that’s just the beginning! It’s been an interesting year for the IT world as well, and as we close in on 2013, I wanted...
This tutorial shows how you can use the world's most widely used BI tool, Microsoft Excel, to get direct SQL access via ODBC to SaaS applications hosted in the cloud. More specifically, we'll look at how Excel power users can leverage PowerPivot to build enhanced analytic capabilities directly on...
It’s hard to believe, but it’s September already! Along with going back to school and preparing for Fall, September also marks something else this year: the 20th birthday of the ODBC standard. That’s right, our beloved ODBC, co-founded by Progress’ very own...
A few weeks ago I explained the life of ODBC drivers from their inception in 1992 until version 3 was released, in 1995. In case you need a refresher,...