Skip to main content

Master Data Management & Reference Data Management 🛰️

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

  • 286 Topics
  • 646 Replies
286 Topics
C
Data Enthusiast
csapocheData Enthusiast
asked in Master Data Management & Reference Data Management 🛰️
Retiring and Archiving Reference Data - No State for this?

We are new to Ataccama’s RDM app and have a question regarding the retiring and archiving of reference data.  It appears that “Published” is that last state for reference data within the app. Any workflow statuses that we would create for custom workflow happens between “Edited” and “Published”, by design, so there does not seem to be the ability to create a “retired” state.Yes, we could use versioning and create a business date that could be used in querying/filtering the data, but that both adds unnecessary complexity AND the data still “shows” in the Published view mode. In terms of the application, we could also delete the data, but we have various user groups that do not delete data as best practice, and don’t want to go that route. What have others done to reflect “retired/archived” reference data?  

101
A
Ataccamer
H
Universe Traveller
Hanish NUniverse Traveller
asked in Master Data Management & Reference Data Management 🛰️
How to get the relations of a catalog item via API?

 How to get the catalog item related to the main catalog item via API? Please help me to get that API.

281
anna.spakova
Ataccamer
Lazov
Data Voyager
LazovData Voyager
asked in Master Data Management & Reference Data Management 🛰️
Loop solution is needed in Ataccama component step

Dear Colleagues, I am seeking a solution for looping over the data and also for using iteration.What I need to achieve: matching a 4-value string against another 4-value string for Levenshtein match score.Method is to match every 4 value in the string against every 4 value in the other string. It adds up to 16 combinations.Somehow like below I want to create a loop:String1:= L1+' '+L2+' '+L3+' '+L4;String2:=MATCH_L1+' '+MATCH_L2+' '+MATCH_L3+' '+MATCH_L4;MS:= null; //this will be the match string – a dynamically extending string as shown belowfor i := 0 to 3MV1 := set.subSequence(String1,i,1); //match value is L1 For i2 = 0 to 3MV2:= set.subSequence(String2,i2,1); //match value is MATCH_1MC:=levenshtein(MV1,MV2); //we have some score here as match case Next i2;MS:=MS+MC+'_MC'+toString(i)+';'; //match string value and case number stored here and in each loop, new values are getting added to the stringNext i;MS //here I use the final match string value as it is and that's al

421
L
Ataccamer
T
Data Voyager
Taleh13Data Voyager
asked in Master Data Management & Reference Data Management 🛰️
How to fetch monitoring project success status using Python and GraphQL?

Hi all,I’m working on a Python script to fetch monitoring project results via GraphQL. My goal is to determine whether the monitoring project is 100% successful or if there are any issues.I’ve checked the documentation but can’t find the exact GraphQL query or fields that return the project’s overall success status or completion percentage.Could anyone please share: A sample GraphQL query to get the monitoring project status (success, percentage, etc.) How to execute this query using Python (e.g., with requests or any GraphQL client) Tips on parsing the response to identify if the project is fully successful or not Thanks a lot!

301
OGordon100
Ataccamer
A
Data Voyager
AH5Data Voyager
asked in Master Data Management & Reference Data Management 🛰️
Categories in RDM

I have a lot of categories in an RDM setup. In the Web UI, is there anyway to setup “shortcuts” or bookmarks so that users can see just the tables/views/datasets in their category?Looking for suggestions/best practices here on user navigation through many tables in the RDM Web UI please. 

222
I
Ataccamer
may_kwok
Star Blazer L3
may_kwokStar Blazer L3
asked in Master Data Management & Reference Data Management 🛰️
Changing RDM relationships from one parent table to another (few)

Let’s say we currently have some tables:TableATableBTableCTableD TableA and TableB are parents of TableC, then TableC is parent of TableD.So we have:Relationship Parent Table Child Table Rel1 TableA TableC Rel2 TableB TableC Rel3 TableC TableD  We are trying to get rid of Table C, so that the new relationships will be:Relationship Parent Table Child Table Rel4 TableA TableD Rel5 TableB TableD  I’ve tried to deploy the model and I get validation messages of missing parent values. Trouble is TableD is quite big in RDM terms (in the magnitude of 200k rows) and I think the application is struggling to start at the moment with all these failed validations.Is there some specific alter hints that can be used or am I going to have to anticipate going into repair mode somehow? 

193
I
Ataccamer
O
Star Blazer L1
OjaswiniStar Blazer L1
asked in Master Data Management & Reference Data Management 🛰️
Behavior of Invalid records in RDM Approval workflow

Dear Community,I have query regarding RDM approval workflow. In our project we have stages Initiator → Review → Publish .It has been noticed that when a record is invalid, its status is displayed as 'INVALID,' yet it progresses in the workflow for review. The reviewer has the option to accept this invalid record, and it moves to the Publish section. However, when the approver attempts to publish the record, an error occurs, stating that the record is invalid and cannot be published.The client is now requesting clarification on why an INVALID record is allowed to progress through these stages in the first place. They propose that it should not be permitted to move to the review state initially.Anyone faced this scenario before? Can we do something in approval workflow configuration that record should not move to review state if it is Invalid.Any help regarding this will be really helpful.Best regards,Ojaswini

665
A
Data Voyager
A
Data Voyager
aisayev001Data Voyager
posted in Master Data Management & Reference Data Management 🛰️
Progress Update: On-Prem AI Agent Integration with Ataccama ONE

Happy to share a quick update with the community on the progress we’ve made with our on-premise AI agent integration into Ataccama ONE. We’ve now developed and tested four distinct use cases that support users across various data governance tasks. All of these are accessible through a lightweight chat-based interface that runs alongside the Ataccama UI, without modifying the core product.Here’s a brief overview of what’s working today:Data Quality InsightsThe agent detects data quality issues and provides root cause analysis with natural-language explanations. When needed, it also offers recommendations for resolving common problems, making DQ monitoring faster and more intuitive.AI-Assisted Data Catalog NavigationUsers can search and explore the Ataccama catalog using natural language. The agent retrieves relevant metadata and provides contextual recommendations, helping non-technical users find and understand data without needing to know the structure.Compliance & Sensitive Data

140
A
Data Voyager
A
Data Voyager
aisayev001Data Voyager
asked in Master Data Management & Reference Data Management 🛰️
On-Prem AI Chat Widget Integration into Ataccama ONE UI

Hi everyone, We’ve developed an on-premises AI agent that supports users in data governance tasks such as data quality monitoring, catalog navigation, and metadata enrichment. We’re now looking to integrate this AI agent as a chat widget directly into the Ataccama ONE user interface.Our goal is to embed a floating or sidebar-style chat widget inside the Ataccama UI to provide real-time assistance to users without modifying the Ataccama core UI code.This is strictly for on-premise deployment, so cloud-based or external proxy solutions are not relevant for our use case.We’d appreciate any insights or guidance from the community on the following: Has anyone successfully embedded a custom widget into the Ataccama ONE interface? Are there any supported mechanisms or hooks for extending the UI in on-prem installations? Are there UI customization capabilities available in the Ataccama ONE roadmap for partners or customers? Happy to share our approach and progress with the community as we

491
A
Space Explorer
C
Data Enthusiast
csapocheData Enthusiast
asked in Master Data Management & Reference Data Management 🛰️
Best practice for utilizing/stacking multiple validations for RDM

Hi All - new to Ataccama’s products and I’ve got a question re: RDM and validations. What is the best practice for creating multiple validations for a field (column) level validation, with the aim being reusability and scalability? For example, I might have the following use cases:string must be all upper case string must not contain all spaces string must be camel case string must be alpha characters only string must be alphanumeric only string can contain digits but not special characters …...etc - the list could be lengthy!…….And I want to apply the rules in various combinations like this:Column A: 1,2,4 Column B: 1,2,6 Column C: 1,2,3,5….etc.Current thinking: It seems like domains would be a good place to start, but that given the different permutations it would mean creating a multitude of domains, and the regex could be cumbersome.  Expression validations don’t promote reuse Online services: this might be more in line with modularizing validations - setting up a “library” of vali

80
C
Data Enthusiast
C
Data Enthusiast
csapocheData Enthusiast
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?

173
A
S
Universe Traveller
shikoh.zUniverse Traveller
asked in Master Data Management & Reference Data Management 🛰️
How to acess MDM Web Application

Hi,I'm currently working with Ataccama ONE and would like to access the MDM (Master Data Management) Web Application. Could someone please guide me on the steps to access it? Specifically:What is the typical URL format to access the MDM web interface?Do I need any specific roles or permissions to view or manage master records?Is there any difference in access for cloud vs on-premise deployments?What should I do if I don't see the MDM module after logging in?

293
E
Ataccamer
V
Data Voyager
vvalcakData Voyager
asked in Master Data Management & Reference Data Management 🛰️
XSD validation of XML files

Hello,do you plan to add feature for One Desktop regarding xsd validation of xml files? So it is possible to check if the xml file has correct structure.Thank you.RegardsVeronika

70
V
Data Voyager
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!

201
OGordon100
Ataccamer
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?

231
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,

232
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-->

161
R
Ataccamer
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

292
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?

456
A
J
Ataccamer
joyceAtaccamer
published in Master Data Management & Reference Data Management 🛰️
Running MDM v14.5 Locally on MacOS
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

1762
A
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.

171
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.

202
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

293
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?

232
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.

453
O
Ataccamer

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