Open Government Platform Aims at Businesses

Adam DuVander, October 2nd, 2012

Socrata Open Data A company best known for its tools to help governments open their data now wants to provide the same aid to businesses. Socrata today launched the API Foundary, which can convert Excel spreadsheets (and other data repositories) into customizable APIs. The company will continue to focus on governments, but it also is courting enterprises–or anyone who wants to share data and “mass produce APIs.”

“Some of the same problems we’re seeing from governments are relevant to businesses,” Socrata’s Will Pugh said. “A lot of this stuff is sitting around in Excel spreadsheets,” which makes it difficult to share. The new Socrata API Foundary can take those spreadsheets and turn them into APIs. As governments opened their data, so now can businesses. But will they?

Socrata customers have estimated creating a new API costs up to $100,000, according to Socrata’s Saf Rabah. “API Foundary helps our customers mass produce APIs,” said Rabah. There’s a strong case at saving money, as Rabah said most customers would pay a few thousand per month for Socrata (though developers can get started uploading public datasets for free). The low barrier of simply uploading Excel files may be the real kicker, because organizations could open data without programmer or database administrator intervention.

Rabah is quick to point out that Socrata also allows for updating and real-time datasets via the Socrata Open Data Syncing API. That requires a little more technical intervention than re-uploading Excel spreadsheets.

Regardless of how the data gets into Socrata, the company provides powerful tools for developers to access it, including SQL-like select and group options.

This sort of self service API creation will help bring about our prediction that every company will have an API and maybe more than one.

Both comments and pings are currently closed.

One Response to “Open Government Platform Aims at Businesses”

October 8th, 2012
at 4:30 am
Comment by: Link Roundup – October 8, 2012 | Enterprise Information Management in the 21st Century

[...] Open Government Platform Aims at Businesses (ProgrammableWeb) – Excel into APIs? Interesting idea, but imagine the governance headaches there… [...]

Follow the PW team on Twitter

APIs, mashups and code. Because the world's your programmable oyster.

John Musser
Founder, ProgrammableWeb

Adam DuVander
Executive Editor, ProgrammableWeb. Author, Map Scripting 101. Lover, APIs.