Leading Bank Feeds Data into Identity Management Platform
With more than 6,000 systems to work with, managing and standardizing multiple data formats was proving cumbersome and expensive for one leading bank.
Managing user access permissions to a banks' systems is a critical part of keeping the business secure and compliant. But working with many different sources was challenging.
The organization was using Oracle Identity Manager (OIM) to track and monitor permissions - making sure that the right people had access to the right systems, and keeping access updated as staff assignments changed.
Large volumes of constantly changing data
With large volumes of constantly changing data coming from different sources in different formats, feeding the necessary data into OIM was a challenge. OIM is strict about the data format it ingests, so the bank needed a dedicated development team to create and manage the manual process of data integration for OIM. Not only was this expensive, but the scripts to transform the data were cumbersome to develop, test and deploy into production.
The IT security team were looking for a solution that would automate the data integration process, and would enable business teams to take on some of the work that previously only the technical team could handle.
A data transformation framework
With CloverDX the project’s technical staff created a data transformation framework to ingest data from different sources and transform it into a standardized format that OIM could recognize. The team used the flexibility of CloverDX to build, tweak and augment configurable, repeatable templates quickly, and then pass these templates onto the business team to add in details and manage the majority of the work.
"CloverDX gives the business team more capability to do the work themselves.”
Project Manager of IT Security
The new solution fits the requirements of both the technical teams - who have the flexibility to hack the software to adapt the solution to their methods of working - and the business teams, who now have an intuitive graphical interface that has given them more capability to do the identity management work themselves.
The bulk of the operational work - making sure feeds are coming in, sending notifications to users, acting as the first line of support for recertification and coordinating onboarding of new applications - has now been moved out of the technical team’s domain, meaning that they can now focus on OIM implementation, knowing that the more automated identity and access management process is keeping the bank’s system’s secure.
Data integration software and ETL tools provided by the CloverDX platform (formerly known as CloverETL) offer solutions for data management tasks such as data integration, data migration, or data quality. CloverDX is a vital part of enterprise solutions such as data warehousing, business intelligence (BI) or master data management (MDM). CloverDX Designer (formerly known as CloverETL Designer) is a visual data transformation designer that helps define data flows and transformations in a quick, visual, and intuitive way. CloverDX Server formerly known as CloverETL Server) is an enterprise ETL and data integration runtime environment. It offers a set of enterprise features such as automation, monitoring, user management, real-time ETL, data API services, clustering, or cloud data integration.