Skip to main content

Master Data Management & Reference Data Management 🛰️

Discuss, learn, ask, suggest, share all things MDM and RDM 🔍

  • 273 Topics
  • 628 Replies
275 Topics
G
Data Voyager
Gopal PatilData Voyager
asked in Master Data Management & Reference Data Management 🛰️
Data Governance

Hi,How is data governance concepts used in Ataccama tool?

151
E
Ataccamer
A
Data Voyager
AH5Data Voyager
asked in Master Data Management & Reference Data Management 🛰️
detecting duplicate records upon import

re: Duplicate record checking upon inputting new records into RDM-WebI know about setting up the uniqueness check and validations on the data once. I have users in the Web portal potentially entering duplicate values, can we set up uniqueness checks BEFORE they publish records. So, any record that is deemed duplicate (on 1 or more columns) would not be publishable. If this question has already been submitted/answered, please direct me there.Thanks,

152
A
Data Voyager
G
Data Voyager
girish.chalkeData Voyager
asked in Master Data Management & Reference Data Management 🛰️
http.nonProxyHosts

Hello,Looking for some help on using http proxy in RDM. We are trying to perform HTTP POST to external endpoint which is accessible only via proxy. Below param were added in JAVA_OPTS in onlinectl.sh file however   -Dhttp.nonProxyHosts is ignored and ataccama is pushing all https requests via proxy.!--scriptorstartfragment-->   -Dhttp.proxyHost=outbound-service-proxy.gateway.aws-euw1-np.mydomain.com \  -Dhttp.proxyUser=svc_nonprod_service_proxy_fdplife \  -Dhttp.proxyPassword=xxxx \  -Dhttp.proxyPort=80 \  -Dhttp.nonProxyHosts=localhost|127.0.0.1|*.uk-dwh.nonprod.aws-euw1-np.mydomain.com" !--scriptorendfragment-->

141
R
Ataccamer
O
Universe Traveller
onufryUniverse Traveller
asked in Master Data Management & Reference Data Management 🛰️
One Data on Hybrid Env

Hello Ataccama Community,I'm currently managing a hybrid deployment of Ataccama ONE, where our Data Processing Engines (DPEs) are running on-premise while the rest of the platform is in the cloud. I've noticed that the ONE Data module is not available in this setup, and attempts to enable or use it result in errors or feature flags being disabled.Could you please clarify: Why is ONE Data not supported in environments running purely on hybrid DPEs (both cloud and on-premise)? Is there a technical roadmap or timeline for when ONE Data will be available or fully functional in hybrid environments? Are there any recommended workarounds or alternative approaches in the meantime for organizations that require hybrid deployment but also need ONE Data capabilities? Thank you in advance for your insights!

80
O
Universe Traveller
C
Data Voyager
csapocheData Voyager
asked in Master Data Management & Reference Data Management 🛰️
Is there a way to change the default Referenced Data Display mode globally?

I’d like to default the referenced data display mode to “label” rather than “binding keys” as the default display mode option for all tables. See this link for details on how it is changed per table: Viewing Data in RDM :: Ataccama ONEIs there a way to accomplish this?

50
C
Data Voyager
A
Star Blazer L1
aish_TFStar Blazer L1
asked in Master Data Management & Reference Data Management 🛰️
MDM Instance output to represent Ids from each system

I want to convert the instance export table values to a new table/view.The instance export contains 3 columns that I want to utiliseSharing an example-I have the following instance table structure :MASTER_ID SOURCE_SYSTEM SOURCE_ID 001 sys1 1234 001 sys2 12232 001 sys3 1292 001 sys4 13432 001 sys2 12334  5 records from 4 different source system make a master record, I want to group it in such a manner that there is a single row for each source_system id. If a source system participate twice(with two unique records) in formation of master record, I want two rows representing the different source_ids and a column with the source system that participates twice. Here is how I intend the output table to be: MASTER_ID SYS1_ID SYS2_ID SYS3_ID SYS4_ID MULTIPLE_REC 001 1234 12232 1292 13432 SYS2 001 1234 12234 1292 13432 SYS2  Can someone help me with the ONE Desktop step I can use for this?I have explored using Aggregating Column A

252
A
Ataccamer
may_kwok
Star Blazer L3
may_kwokStar Blazer L3
asked in Master Data Management & Reference Data Management 🛰️
RDM REST API - using count and offset to get all records

Let’s say I have a table that has 500,000 rows.I need to query this table using REST API (because I want to get both published records and records still in edited/waiting for publish states).I have some params to filter the data with, but even with params, the result set could be say, 10000.I tried using the REST API using JSON call step in a plan, setting “count” to 10000, and the API says maximum is 1000.I see that the REST API provides the offset param as well. Is there an example of how I can use that offset param to paginate and query all the records that I will need, but in one plan/component?This component will be a part of a complex set of components as a larger operation, and I’d prefer to not have to create an extra .ewf and iterator for it, otherwise this whole thing gets too complicate for anyone else to understand… Any ideas?

326
Cansu
Community Manager
J
Ataccamer
joyceAtaccamer
published in Master Data Management & Reference Data Management 🛰️
Running MDM v14.5 Locally on MacOS

Steps overview:Download all components Install ONE Desktop Launch ONE Desktop and create the MDM CDI example project Place the files in the right structure Modify a bunch of files so they are working on MacOS Configure the Mac permissions to run things Launch ONE Desktop and create the MDM Banking example project Launch it all (keycloak, postrgres, mdm-server, server), one by oneDownload:Builds (Latest versions here): MDM: Mdm-assembly-14.5.0-linux.zip ONE Desktop: Ataccama-one-desktop-14.5.0-macos.dmg  ONE MDM Server: Mdm-server-assembly-14.5.0-linux.zip   Plugins (Latest versions here, the official Postgres version for Linux missing for now): Postgres:  https://drive.google.com/file/d/1Lho_9BQh78xRWR2QHAAGoQuERof-Rn-e/view?usp=sharing  Keycloak: https://ataccama.s3.amazonaws.com/products/releases/keycloak/keycloak-21.1.2-3-demo.zip Your license (.plf file)Install ONE Desktop:Install ONE Desktop (Ataccama-one-desktop-14.5.0-macos.dmg) Rename the application so that there

1682
Cansu
Community Manager
K
Data Voyager
karangalepranavData Voyager
asked in Master Data Management & Reference Data Management 🛰️
Question on monitoring project extractions

Need help with graphQL query. I need to bring in All the metrics like DQ scores, Overall quality for CIs that are part of monitoring projects. Is there a way to get it? Also, do we have document which tells us more about when to use edges and nodes appropriately.

81
T
Data Pioneer L2
O
Star Blazer L1
OjaswiniStar Blazer L1
asked in Master Data Management & Reference Data Management 🛰️
Is self joining possible in RDM tables ?

Hello,Is it possible to self-join tables in RDM to populate some information? I would like to try something like shown in the screenshot. Attribute 4 and 5 values are selected from RDM UI. So, dropdown should only show values from the same table where att2 = CAT2 for Att4 and att2 = CAT3 for Att4Table1                 Selection from RDM UI   Att1 Att2  Att3 Att4 (where att2 = CAT2) Att5 (where att2 = CAT3)   ID1 CAT1 val1 ID3 ID5   ID2 CAT1 val2 ID4 ID6   ID3 CAT2 val3       ID4 CAT2 val4       ID5 CAT3 val5       ID6 CAT3 val6                    I somehow tried to create self join in relationship like below. I was able toi upload configuration successfully on RDM with these relationships.  However, when edit the record on RDM the lookup is blank. it does not show any value although table is populated.   (this can also be understood as employee info vs manager info relationship.

192
O
Star Blazer L1
Raja Koushik
Data Enthusiast
Raja KoushikData Enthusiast
asked in Master Data Management & Reference Data Management 🛰️
Merge Realm Roles

We have multiple Realm roles created for our data domains in the below fashionData Domain 1 Realm Role - Data Owner Realm Role - Data Steward Data Domain 2 Realm Role - Data Owner Realm Role - Data Steward How can I merge Data Domain 1 and Data Domain 2 into one single New Domain and merge the corresponding Realm Roles?I.e.Data Domain 1 Realm Role - Data Owner Realm Role - Data Steward                                            = New Data Domain Data Domain 2                                                                                           New Realm Role - Data Owner Realm Role - Data Owner                                                              New Realm Role - Data Steward Realm Role - Data Steward

263
Lisa Kovalskaia
Ataccamer
S
Universe Traveller
sriniUniverse Traveller
asked in Master Data Management & Reference Data Management 🛰️
read MDM workflow status using API in v15.4

How can we retrieve or read the workflow status (running, success, or failed. Etc) using a GET API after triggering the workflow via an Http service?

222
S
Universe Traveller
Y
Data Voyager
Yasharth MisraData Voyager
asked in Master Data Management & Reference Data Management 🛰️
Master data Layer matching- MDM

Hello, I wanted to know that how do we implement matching options in the master layer of the MDM project.I have used in the columns in the instance layer and then used the same in the master layer in the matching step just as used in the cdi example. and then I have used the same name in the matching step but still  nothing is  showing the UI part. Can someone help me with that.

363
O
Ataccamer
S
Universe Traveller
Susan24usUniverse Traveller
asked in Master Data Management & Reference Data Management 🛰️
Preparing for Ataccama Version Upgrade – What Should I Document and Test?

Hello everyone,My organization will soon be upgrading to a higher version of Ataccama, and I want to make sure the transition goes as smoothly as possible. I'm reaching out to ask:What should I be documenting or looking out for before, during, and after the upgrade?Some specific things I'm wondering: Are there key areas (like DQ rules, workflows, configurations, etc.) that I should definitely back up or document? What kind of testing should I plan for in UAT? Should I be validating things both before and after the upgrade? Are there any common issues or changes I should be aware of that might affect how things work in the new version? If anyone has experience with a recent version upgrade, I’d love to hear what worked well for you—or what you wish you had done differently!Also, if there are any official resources or checklists from Ataccama that you found useful, feel free to share.Thanks in advance!

201
R
Universe Traveller
A
Data Voyager
Akashsingh1991Data Voyager
asked in Master Data Management & Reference Data Management 🛰️
While running adddress match componenet I am getting Persistence is not set error. Please help

07.05.2025 16:24:30 [INFO]     Using Ataccama DQC configuration file D:\ataccama\workspace1\General MDM project - CDI example\Files\engine\trans\address\address_match.comp07.05.2025 16:24:30 [INFO]     Using runtime configuration file C:\Users\AS001086183\AppData\Local\Temp\runtimeCfg31836356917877677.tmp07.05.2025 16:24:30 [INFO]     Ataccama DQC engine initialized.07.05.2025 16:24:30 [INFO]     Creating runtime...07.05.2025 16:24:31 [INFO]    [Address deduplication] parallel processing of partitions: false07.05.2025 16:24:31 [INFO]    [Address deduplication] parallel processing of key rules: false07.05.2025 16:24:31 [INFO]    [Address deduplication] parallel processing of matching rules: false07.05.2025 16:24:31 [INFO]     Starting runtime...07.05.2025 16:24:31 [INFO]     Running runtime...07.05.2025 16:24:31 [FATAL]    Internal error occurred during run of the plan: Persistence is not set (the standalone mode may not be configured)[STEP Address deduplication[Md Unify]]07.05.2025 16:

101
Cansu
Community Manager
Cansu
Community Manager
CansuCommunity Manager
published in Master Data Management & Reference Data Management 🛰️
Introduction to RDM - Part 3️⃣

Hi everyone,In the last post of our RDM best practice series, we will go through an example Project configuration, uncovering the key nodes and functionalities. I’ll be linking further reads if you are interested in a deep dive and try testing your skills ⚡ 1. RDM Logical ModeAt the heart of the RDM model project lies the RDM Logical Model. This node is the epicenter for configuring reference data, its entities, relationships, and organizational structures. With support for a myriad of tables and relationships, you can effortlessly model data, define attributes, and establish complex hierarchies. Dive into the details at Creating the RDM Data Model.  2. Connected SystemsIn the realm of Connected Systems, databases and servers take center stage. Efficiently import/export data to/from RDM by configuring connections to external databases and remote servers. Explore detailed instructions at Adding Databases Synchronized with RDM and Adding Remote Servers for File Transfers. 3. Workflow Con

1491
Elena Bu
Data Enthusiast
K
Data Enthusiast
karine.davtyanData Enthusiast
asked in Master Data Management & Reference Data Management 🛰️
Accessing Data of Catalog Item via Rest API or GraphQL

Hello everyone,I’m working on a project that integrates a data masking tool with Ataccama, and I’m encountering some issues when trying to retrieve actual catalog item data (the row-level data) via the REST API. I’ve been testing both GraphQL and REST approaches, and here’s what I’ve found so far:GraphQL vs. REST for Data Retrieval:The GraphQL API appears to focus on metadata – attributes, versioning, policies, etc. However, based on my understanding, the actual table data (the rows and cells) isn’t available through GraphQL; it’s only accessible via a REST endpoint. Based on available documentation for MDM and RDM REST APIs, the REST endpoints follow a pattern using a fixed base path (/api/rest) on the default port (8051) and use basic HTTP authentication.Endpoint URL Confusion:Initially, I attempted to use an endpoint like:  https://teranet.test.ataccama.online/catalog/data/catalogItem/<gid>/datawhich returned a 404 error. Later, based on the docs, I switched to the documented

917
Cansu
Community Manager
Elena Bu
Data Enthusiast
Elena BuData Enthusiast
asked in Master Data Management & Reference Data Management 🛰️
RDM users in Approval workflow without email notifications

Hi All,I have a question regarding RDM approval workflow. In our project, we have stages Initiator → Review → Publish. We have a customer request to allow RDM_admin users to participate in the approval process (i.e., they must be able to review and publish records) but not receive any email notifications.We tried removing RDM_admin role from Notifications section, but that didn’t help because this role remains in Workflows section. We can’t remove RDM_admin role from Workflows section, since that would prevent RDM_admin users from reviewing or rejecting records at all, they wouldn’t be able to participate in Approval workflow.The following settings don’t work, RDM_admin users still receive emails:Is there a way to keep RDM_admin’s ability to review and publish without receiving emails? Perhaps by checking user’s role or username in the Conditions section, so that Approval workflow gets skipped for certain users?The documentation for version 15.4 mentions something like meta.username, b

332
Elena Bu
Data Enthusiast
Cansu
Community Manager
CansuCommunity Manager
published in Master Data Management & Reference Data Management 🛰️
Ataccama Academy Learning Journey: Master Data & Reference Data Management

Hi everyone 👋 Following up on our first post about getting started with Data Quality & Catalog, we’re excited to guide you through another key path in your learning journey—Master Data Management (MDM) and Reference Data Management (RDM). Whether you’re a business user, technical implementer, or solution architect, the MDM & RDM On-Demand Learning Path in Ataccama Academy will give you the essential skills to design, configure, and operate these critical components of the Ataccama platform. 📚Start with the basics to get familiar with MDM & RDM:Managing Master DataGain a foundational understanding of Ataccama’s MDM capabilities, platform UI, and core data concepts.Managing Reference DataExplore how reference data is governed and maintained in Ataccama to ensure consistency and control. 🧱Build on your foundation with practical configuration, workflows, and deeper implementation techniques:ONE Desktop CoreLearn to design data flows, transformations, and rules using the ONE

190
Cansu
Community Manager
M
Data Voyager
MayureshData Voyager
asked in Master Data Management & Reference Data Management 🛰️
MDM Validation

 I am trying to do validation on Tin , on which score and explanation are getting populated but the records which are invalid are not getting highlighted in red and i have enabled validation in the Tin columnAttaching the snapshots of the steps which i have done while configuring the validation:  How should i fix this.

131
Phil Holbrook
Ataccamer
alexAguilarMx
Data Pioneer
alexAguilarMxData Pioneer
asked in Master Data Management & Reference Data Management 🛰️
how to apply new changes into clean operation for records already in the db?

We made changes into the clean operation of an entity. it will take effects for new transactions.How can we apply this to the current records that we already have into the database? We are exploring use a full reprocess of this entity:but we have some doubts about the setup. For example:What is the difference between a reprocess vs rematch checkbox? We tried to read the documentation but there is not detail explanation about it. Thanks in advance!

825
Ales
Ataccamer
A
Star Blazer L1
aish_TFStar Blazer L1
posted in Master Data Management & Reference Data Management 🛰️
Usage of Rematch and Reprocess jobs

I have been trying to explore the Reprocess and Rematch options in MDM.From this post I understand that Reprocess is used to reprocess the records. For example, lets say, after an initial load where the email values were not being modified in contact_clean.comp, we are now to determine which emails have the domain company-name.com and are now being updated to have domain companyname.com . So, I need to run the reprocess job.Rematch is to run the match step on top of the reprocess since the email values have been modified. What I do not understand is do I run a rematch job only if the email value participates in determining the master record or do I need to run it whenever the reprocess jobs is run irrespective of the changes that took place due to a reprocess?There is another question I have. When we run a load job, the change detection is done right. Does this change detection run on all the records or just the delta records. Post the change detection, matching and merging is run only

536
Cansu
Community Manager
A
Data Voyager
A_NData Voyager
asked in Master Data Management & Reference Data Management 🛰️
How to delete the classification types from the tables and attributes level through One Desktop Plan?

Hello all,I’m using the Ataccama v14.5 there we have created the custom entity for classifications and created the classification types (Internal, Public etc) and added them with tables and attributes through the One Desktop plan. But when i am using the same plan to delete it from table or attributes just by changing the One Metadata Writer property in General tab “workflow state as deleted” and in the Columns tab providing the “Id Column Name as table_id” then it is not deleting anything. Any guidance or suggestions is really helpful. Thanks.General tab Screenshot:Columns tab screenshot: 

222
Cansu
Community Manager
K
Data Pioneer L2
KundanData Pioneer L2
asked in Master Data Management & Reference Data Management 🛰️
Schedule load in MDM

I have MDM setup and records are loaded using a Full Laod configuration. I need to create a load such that all the records that were added into the source are moved into to MDM hub on a daily basis. The approach being used is to identify all the records updated today and load them into MDM. Can you please suggest if I need to create a Delta Load for this or Full Load works. Also, I need to schedule a run of the load file on daily basis.How can I do it?

556
A
Star Blazer L1
A
Star Blazer L1
aish_TFStar Blazer L1
asked in Master Data Management & Reference Data Management 🛰️
Run MDM Export workflow task does not recognize the export component

The Workflow task Run MDM Export does not recognize the export component and and gives error message.I am assuming it is because there is no path variable set for the Export folder.Can someone please help me identify the issue?

133
A
Star Blazer L1

Badge winners

Show all badges

Let's shape the future of Ataccama together

Join User Research at Ataccama!
See new features and prototypes before everyone else, and have an opportunity to shape the future of new products.

Read more
Community Terms of Use & ConditionsCookie settings