• Index
  •  » Talend Open Studio for Data Integration » Suggestions
  •  » Pre-canned address/customer matching?

#1 2012-04-30 13:02:07

judda
New member
Registered: 2012-04-30
Posts: 2

Pre-canned address/customer matching?

Tags: [development]

Hi All.

With a lot of the commercial packages you are (potentially) paying for IP around the experience of matching customers (names, address) etc.

So differences in address format e.g. flat number & street number, name aliases such as Tom/Thomas, Mr/Dr and all the other slight differences you might say are the same for a potential match.

Has anyone published any pre-canned customer/address rules for matching?

cheers

Andy.

Offline

#2 2012-05-02 11:30:05

pedro
Member
Registered: 2011-11-17
Posts: 3682

Re: Pre-canned address/customer matching?

Hi Andy

Welcome to Talend Community!

Talend Open Studio for Data Integration is an ETL product. You'd better simplify the business logic in ETL way.
So what's your input source and the result you want?

If there isn't an accurate rule, we won't know how to do this matching.

Regards,
Pedro


Only Paranoid Survive.

Offline

#3 2012-05-09 14:48:16

judda
New member
Registered: 2012-04-30
Posts: 2

Re: Pre-canned address/customer matching?

for example a user logs on to a web site and enters there name as Dr Tom Smith Flat 1, 3 high street, somewhere town. In our customer database we have Mr Thomas Smith 3, high street, somewhere town.

It's quite likely this is the same person. So we want to be able to match based on rules. Commercial products have out of the box rules for things like Dr can be equivalent to Mr, Tom & Thomas the same and give weightings to these for probablistic matching.

In Talend if you get the enterprise support there is matching capability aviailable but we'd need to write all the rules ourselve for matching name and address variations.

So just wondering if anyone had published these for talend in open source traditions to enable a decent head start.

Offline

#4 2012-05-10 10:58:29

pedro
Member
Registered: 2011-11-17
Posts: 3682

Re: Pre-canned address/customer matching?

Hi

According to your description, I think what you want is Talend Open Studio for Data Quality.

Here is a tutorial related to your requirement.

Regards,
Pedro


Only Paranoid Survive.

Offline

  • Index
  •  » Talend Open Studio for Data Integration » Suggestions
  •  » Pre-canned address/customer matching?

Board footer

Powered by FluxBB