Ataccama Digital Conference
Live
Join us for a lineup of webinars,
podcasts, and online demos!
About

We miss meeting you at conferences, so this spring, we're delivering digital content of your interest straight to your home office.

DIGITAL DEMO DAY
Drop in throughout the day for live demos of the Ataccama ONE platform.
April 2
Register now
Drop in throughout the day for live demos of the Ataccama ONE platform.
Agenda

Check out what live sessions are coming up.

RSA

RSA implemented Ataccama’s Reference Data Management solution on AWS to centralize data management, avoid data duplication, and propagate a single version of reference data to consuming systems.

Initial data challenges

Our client had their reference data stored in Excel and hardcoded in source files. There was limited information available about changes to the files or the file versions, and data for target systems was saved in multiple places and in multiple versions. ETL processes were set up to work with files which were saved in a specified location and loaded into the reporting components.

Proposed solution

Ataccama helps the client maintain control of the data, provide necessary information for high data quality standards, and ensure all files are synchronized on a daily basis via standard processes, limiting the introduction of user and data issues into the process.

Proposed solution (RDM architecture)

Solution & benefits

Our client has access to a web interface where they can manage their reference data. Data quality is set up for all elements, and extracts are provided each day to the consuming systems. If it is needed, the system can provide online synchronization with consuming / source systems. Data users have a full history of the changes in the web application, and the approval workflow of every change is set up for the data stewards.

Ataccama manages the solution, including the technical configuration, system integration, orchestration processes, and availability for users.

TCO analysis results

One of the key aspects of the solution was the deployment. The client considered on-prem installation operated and maintained by their own team (outsourced) as well as Ataccama’s Managed Solution. In the end, an Ataccama Managed Solution came out at less than 50% of the overall cost (taking into consideration the cost of the infrastructure, maintenance, ongoing operation, necessary training, and so on.

Lessons learned

It was challenging to set up the database in a way that completely satisfied client requirements for the RTO and SLAs. We originally used PostgreSQL, which was available in the AWS environment. After a short time, we migrated to RDS (PostgreSQL managed by Amazon), which provided all needed services out of the box and without effort from IT.

Intéressé par une solution similaire?

Entrez en contact pour établir un appel.

(optional)
(optional)
En soumettant, vous acceptez la politique de confidentialité d'Ataccama.

Nous utilisons des cookies sur notre site Web pour améliorer votre expérience Web. En utilisant notre site Web, vous acceptez l’utilisation de cookies. Pour mieux comprendre comment nous utilisons les cookies ou comment modifier vos préférences et les paramètres du navigateur, veuillez consulter notre Politique de confidentialité.

Fermer
Nous Contacter