Attention: Confluence is not suitable for the storage of highly confidential data. Please ensure that any data classified as Highly Protected is stored using a more secure platform.
If you have any questions, please refer to the University's data classification guide or contact ict.askcyber@sydney.edu.au
3. DQ Software: Requirements, Procurement and Implementation
- albie.roets
- Manpreet Sidhu
Timeline
Key Business Outcomes:
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.
Procurement Policies
No | Description | Document |
|---|---|---|
1 | Procurement Policy and rules for engagement |  |
Key Requirements
Date | Document | Distribution |
|---|---|---|
Dec 5, 2022 |  Passcode: &m.TT0?K | @john.humphreys @Liz Enright @Brad Fernandes (Unlicensed) @AlainGasquet @Manpreet Sidhu @Jules Levin |
|
|
|
Vendor Capability Analysis
| Ataccama | Informatica | |
|---|---|---|---|
Best in class: https://www.ataccama.com/analyst-research/gartner-magic-quadrant-data-quality-solutions-2022 | Gartner ‘challengers’ percentile | Gartner ‘leaders’ percentile | Gartner ‘leaders’ percentile |
Dashboards w Historical Progress Graphs | |||
Address Validation | |||
National Change of Address (NCOA) | |||
Mobile Validation | |||
Phone Validation | |||
Email Validation | |||
Consumer Segmentation | |||
Field Level Analysis (isnull, info(), etc | |||
Data Quality Rules | |||
Ease of use out of 10 | 5 * | 8 * | 10 * |
Access Control Mechanism | |||
Vendor and Cyber Security Assessment | https://sydneyuni.atlassian.net/wiki/spaces/PHOEN/pages/2266891703 | ||
Cost | $55,000 for 10x licenses | TBA | Current provider - will be using existing licences |
Comments | - |
|
|
Pro’s & Cons moving to Informatica
Pro’s | Cons |
|---|---|
|
|
|
|
TAP BI Team User Details
SSO UAT Link: https://dm-ap.informaticacloud.com/ma/sso/eMfunfYtOoUhLleAo4to6F
Name | Unikey | |
Albie Roets | aroe8216 | |
Manpreet Sidhu | msid4459 | |
Yeng Sembrano | msem3353 | |
Polina Nikulina | pnik2390 | |
The-Ho Trang | ttra9492 | |
Binila Russel | brus4814 | |
Pat Dennis | pden4556 | |
Beha Parsa | Bpar2671 | |
James Allen | Jall6216 | |
Aneev Singh | asin2558 | |
Miranda Adams |
|
POC Outcomes:
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.
(Desensitised - No PII info in the file)
POC Area | Outcome | Comments |
|---|---|---|
Address quality - comparison |
|
|
Email Formatting - comparison |
|
|
Telephone Formatting - comparison |
|
|
TAP BI Team User Details
SSO UAT Link: https://dm-ap.informaticacloud.com/ma/sso/eMfunfYtOoUhLleAo4to6F
Name | Unikey | |
Albie Roets | aroe8216 | |
Manpreet Sidhu | msid4459 | |
Yeng Sembrano | msem3353 | |
Polina Nikulina | pnik2390 | |
The-Ho Trang | ttra9492 | |
Binila Russel | brus4814 | |
Pat Dennis | pden4556 | |
Beha Parsa | Bpar2671 | |
James Allen | Jall6216 | |
Aneev Singh | asin2558 | |
Miranda Adams |
|
Meeting Minutes / Actions:
Date | Description | Comments |
|---|---|---|
Feb 14, 2023 | Cyber Security to review Workbench https://sydneyuni.atlassian.net/browse/TAP-1216 | Get Cyber Security to security review Workbench, @albie.roets , Feb 28, 2023 |
Feb 15, 2023 | KEY POINTS FROM ATACCAMA DEMO SESSION :- 1. Data Cataloging/Metadata Management to give enterprise-wide view of the data. 2. Ability to integrate the cleansed data into other cloud platforms eg: Snowflake, Azure etc 3. Ability to integrate with JIRA / Confluence 4. Addresses are verified using Google API / Aus Post services. 5. Ability to identify patterns in the data. 6. Supports in-built data quality rules as well as custom rules (tag/column level) based on the data asset. 7. Supports rule based access control. 8. Provides the feature of Data Quality Firewall which helps to prevent entry of poor quality data. 9. Data quality can be tracked down using score card & other metrics.
| @Polina Nikulina @AlainGasquet @albie.roets @Brad Fernandes (Unlicensed) FYI |
Mar 3, 2023 | Demo of Informatica: ICT → Advancement Services https://uni-sydney.zoom.us/rec/share/Yx2yMNHeKgnrdRoAargPZ2yv2oKbQ6KvdqYZMM1aXpZ0ch1K1tfOw95yKhK8X7KX.w8OeJ6WLu_JHf7NW Actions: Provide a list of users with UniKey for access to Infomatica and send the same to Arvind, @albie.roets , Mar 6, 2023 Check if existing Salesforce connection is available to the UAT environment., @Aravind Bobba , Mar 8, 2023 Do a POC in UAT environment once access is granted, @albie.roets , Mar 24, 2023 Support the Advancement team as needed with any implementation steps/ user guides, @Aravind Bobba , Mar 24, 2023 (FYI @AlainGasquet , @Polina Nikulina , @Manpreet Sidhu , @Brad Fernandes (Unlicensed) , @Yeng Sembrano , @Eric Park , @paras.nath , @mahesh.donthireddy , @Jerry Hartard , @Michael Tran (ICT) , @Con Bautista , @md.adil , @Kevin Koay) | 
|
|
|
|
|
|
|
|
|
|