NEW - IDC WebcastFree E-NewslettersRSS Feeds | Site Map
Security Resource CentreBusiness Value of TechnologyMunicipal Centre
SearchSearch
Tips
Registration
Slice by Program

City of Brantford turns to open source for data integration

By: Greg Enright, editor, CIO Government Review(Apr 11, 2008 06:00:00)

An Ontario city has opted to use open source software to integrate a number of its most important applications, choosing to turn away from larger, proprietary options.

The City of Brantford was looking for a system to help consolidate some of its payroll data and to standardize a number of databases onto one platform, according to Muzammil Rajpurkar, database administrator at the City of Brantford.

"It's not proprietary, so we can customize it how we want. The main thing was there were a lot of adaptors that we saw we wanted and suited our needs, (such as) importing data from our Oracle databases. We have a specific budget for the municipalities, so we were looking at [different options] and this was the best in the market."

Rajpurkar said the city also looked at offerings from Jaspersoft, "but this was a bigger version of the same thing."

Headquartered in Suresnes, France, Talend offers Talend Open Studio for data integration; Talend Integration Suite, a subscription-based service aimed at large outfits; and Talend On Demand, a data integration Software as a Service suite.

"The first version of Talend Open Studio was released in 2006 and has been downloaded over 250,000 times, which makes it the most widely-used data integration solution out there, both open source and proprietary," said Yves de Montcheuil, vice-president of marketing for Talend.

De Montcheuil said that the company does not even know most of its users, as the software is simply downloaded and they go off and use it.

"But we launched early this year a challenge where we wanted users to present projects that they had been developing using our technologies," explained de Montcheuil. "Brantford submitted an entry and they have a very interesting project where they're doing real-time integration between several apps using a combination of direct access to the applications and Web services. The idea is to keep several systems for the management of the city's assets in sync."

The cost factor was a big impetus for the city to go the open source route, said Rajpurkar.

"Products like Microsoft Vista, they are all big-money in the market, involving a huge investment. We are not a bank and aren't doing anything on a transactional basis. The money factor is definitely there."

Rajpurkar said the city intends to expand its use of open source software.

"It's a really evolving tool, because many versions are coming out with the new components and I think it will be good to stick with it."

De Montcheuil also believes that open source will continue to grow in popularity in the government sector.

"A lot of the adoption is related to the low cost, and the fact that they don't want to depend on Microsoft. In Europe, the budgets are a big issue also, but there is also a big thing about being independent form a country that provides most of the software from a handful of vendors that rule the software world."

Related content:

Open source gaining traction in U.S. government, says survey

Environment Canada opens up to open source

Top three consolidation considerations

Bookmark on:del.icio.us| Digg it| Furl| Google| Technorati| StumbleIt| Yahoo!

Have something to say about this article?
Add a new commentLetter to the Editor
Find an inappropriate comment? You can notify the moderator by clicking the Report an innapropriate comment icon.
ADD A COMMENT
Name:*Your email address will not appear online and will be used only in the event that the editor wishes to contact you personally for additional comment.
City:
Email:
Title:*
Comment:*
* required fields
Blog Spotlight: Sandford Borins
Sandford Borins

As Professor of Strategic Management at the University of Toronto, Sandford Borins brings InterGovWorld.com readers exclusive insights into how and why the public sector is changing. You'll find new perspectives and questions, observations and objectives, lessons and answers. Cover to Cover, the blog by Prof. Sandford Borins, appears every Thursday.

Inside Cover to Cover

Unified Communications
Data Defence

Unity is a word often heard in the public sector, with myriad agencies and departments looking to foster collective thinking around some of today's most pressing issues. The word, however, doesn't usually get mentioned in the same breath as technology. That's a situation, though, that might soon be changing, thanks to a new software platform known as unified communications.

Inside the latest issue of CGR

More Resources
Driving innovation through effective service management
This white paper discusses how a service-oriented governance framework can help ensure that IT decisions are consistent with business vision, values and strategies-and that IT delivers maximum value to the business. Complimentary with registration.
IT Service Management Solutions and the service desk
This white paper presents the capabilities of IBM Tivoli CCMDB, and describes how Tivoli CCMDB extends the value of the service desk and integrates other essential ITIL processes in support of IBM Service Management. Complimentary with registration.
Stalled PCI DSS compliance efforts put Canadian organizations in limbo: Hereb�s how to get back on track
You might have long ago abandoned your efforts to achieve full PCI DSS compliance, but herebs a report that offers some helpful ideas to get back on track again. It highlights the five bsticking pointsb that typically hinders PCI DSS compliance progress and suggests how to get unglued from the mess.
Advertisement
2007 Salary Calculator
Knowledge Centres at a Glance
White Papers
read more white papers
New blog entries
Thoughts of the day
This week's top stories
Most popular stories of the week
Readers write back
Comments from Intergovworld readers
Government to government
Inside the public sector machine
Government to business
P3: Public-private partnerships
Government to citizen
e-Government service transformation
Blogs
Browse Blogs By:
WiFi Hot Spot Finder
Upload Centre
Upload Your Documents
Contribute and share with your peers by uploading:
- Initiative updates
- White Papers
- Job Links
- Events
- Other
Download Centre
Most popular downloads:
Download More Documents
Download:
- Initiative updates
- White Papers
- Job Links
Subscription Services
Manage your InterGovWorld.com account!
Change your account information, password, e-mail address, and existing e-newsletter subscriptions.
Site Feedback Survey
Tell us what you think of InterGovWorld.com!
FUN SurveyFUN Survey
Take the one-minute Family Unit Networking survey!
IT Salary Survey IT Salary Survey
Take the IT Salary Survey '06 Today
Career Resources
InterGovWorld provides links to resources for government job seekers and current employees, including: current job postings, job search strategies, career options and training, and employee rights, provided by all levels of government from everywhere across Canada.

Public Service Commission of Canada
Service Canada
Jobs in Canada
Service Canada
Public Service Human Resources Management Agency of Canada