We're excited about tools that make life easier. We believe in open source and open standards. We want to work with
companies that are building those kinds of tools with that kind of philosophy. And that’s why Ronin Technologies is
a Talend technology partner and holds a Talend programming certification.
we were creating a proposal for a project that would combine different web services with several ETL jobs and business rules.
The end result needed to be an application that could be maintained by the client with very little to no coding needed to
make changes to the business rules and data. And, of course, the client wanted to keep the upfront costs down - no unnecessary
software licenses, please!
Our research led us to Talend Open Studio. Free, open source, built on Eclipse, with a graphical interface, metadata-driven and connectors to every database imaginable…we were hooked! We quickly
put together a proof of concept that took data from a SQL server database, transformed it into XML, called a .NET web service
application and logged the responses. Talend generated Java code that we then ran by calling a .bat file from Windows Scheduler.
The development cost savings from using this code generation tool? It reduced the project cost by 50%.
We do a lot of work in the real estate sector, and aggregation is the movement of the moment, with syndication being a
close second. MLS’s, state associations, brokers, and third party vendors are all dealing with not only ETL (Extract-Translate-Load)
but work-flow issues as well. We work to provide business integration solutions at points in the transaction for all
of these different parties.
In keeping with our agile development methodology, our design goals are:
Talend allowed us
to fulfill these goals for a variety of projects over the past year. I don’t want to sound as if it is a golden hammer;
it’s not. But it is a valuable tool in our development toolkit.
Let me give you a real-world example of data
syndication using Talend to create a series of jobs that:
- Call an external RETS client program, passing it parameters, and retrieves listing data from an MLS in RETS COMPACT format.
the RETS data as an internal XML metadata and pass it into a Talend mapper object.
- Create three different output
maps and build the corresponding output XML files - one for Zillow, one for Trulia, one for Yahoo.
- Transform the single RETS feed into three syndication formats.
- Call the built-in FTP client to
put each xml file on the appropriate server and directory expected by the syndicators.
Email us for more information about how we can use Talend to solve your data integration needs.