The key business outcome is to ensure any relevant comms (mail, email, SMS) reaches the target audience (e.g. Alumni, Donor, Friend, etc.) thereby increased engagement and uplift in philanthropy donations.
Current provider - will be using existing licences
Comments
-
Pro’s & Cons moving to Informatica
Pro’s
Cons
I think the tool is quite flexible and UI friendly:-
Data quality rule/data dictionary is managed separately and at the same time can be referenced for the data profiling.
Data Profiling pipeline looked quite intuitive. (Drag and Drop feature).
Data masking is easy (just simply drag that function onto the sheet and choose the field you want to mask).
Automatic tagging on target fields, and ability pick source fields and map onto target fields. (again quite viaual and intuitive).
Data enrichment capability, will definitely help us to fix lot of missing data.
I think Uni people are already using it (Aravind), so will be able to get timely support to resolve any query (if needed).
the tool is more complex, not straight forward to use comparing to Aperture DS. with Aperture DS the people who don't have training still could used it after have sometime to look at the exist work flow. example James pick up quick
We have to define verify rule while Aperture DS has it build in rule.
with aperture ds we could upload the data directly from our computer, but this tool we need to load the file to AWS of some kind before we could access. The connection to Source is not easy.
I agree with Manpreet that there are more features like data masking, ....
It will be time consuming: as the output of which I saw wasn't usable yet. I think we have to spend lots of times to define and set up to be able to output a passing data file and a failed data file.
Informatica also has in built rules, and we can define ours as well. It can automatically pick up data elements and create data dictionary based on the majority of data.
Ensure that as a minimum it can replicate the Aperture address check functionality → Run a salesforce file through Aperture and Informatica and compare.
Ensure that as a minimum it can replicate the Aperture telephone formatting functionality → Run a salesforce file through Aperture and Informatica and compare.
Ensure that as a minimum it can replicate the Aperture email checking functionality → Run a salesforce file through Aperture and Informatica and compare.