Master Data Management & Reference Data Management 🛰️

Dear Fellow Users,I have a certain issue using the Matching step in workflow editor.I composed a Matching Function, and assigned it to a data field as Matching Rule.Now I want to use the result of the Matching Rule further in the next steps as value.Please see the attachment for exact presentation of the case.First attachment demonstrates how the Matching step is structured - the details in question are highlighted in green frames.Second attachment demonstrates the function applied, and the result I want to take as value to be processed further. Any solution is keenly welcome.Thank you, Laszlo

Hi All,Does anyone have a best practice for creating mappings between related reference data?   We need to be able to relate various datasets used by different systems that have the same "entity" but the codes for that entity are different. Some examples:Entity:                     StateTable 1 Value for State:        NYTable 2 Value for State:        034Table 3 Value for State:        34Table 4 Value for State:        New York  Entity:                     AutoTable 1 Value for Auto:        AATable 2 Value for Auto:        AUTable 3 Value for Auto:        01Table 4 value for Auto:        Auto We need to be able to "map" these values within RDM, so we know that NY, 034, 34 and New York are all "State", and that AA, AU, 01 and Auto are all "Auto".  Additionally, these mappings may need to be hierarchical.  In Informatica, these objects are called “crosswalks”, and they exist as base entities within the tool. We need to duplicate that type of behavior. If you’ve implemented this, or have

I have two location tables with 2-letter codes and integer codes but need to keep them both.  Need to create a crosswalk table that maps the codes in both to a location name. Has anyone setup a crosswalk-type table with ONE RDM?

Below are Ataccama ONE Desktop shortcuts organized into categories by particular viewer or editor.A full list of keyboard shortcuts can be found and called by pressing Ctrl+Shift+L at any time.To edit shortcuts, go to Window > Preferences > General > Keys.Data Viewer SQL Editor Profile Viewer Plan Editor Search and Navigate Edit Layout Run Progress Viewer Online Service Editor Common ShortcutsData ViewerCtrl+F - Find - Opens Find dialog. Ctrl+L - Show Columns - Opens dialog where user selects which columns should be visible and which columns should be hidden. Ctrl+Home - Selects and reveals the top left cell. Ctrl+End - Selects and reveals the bottom right cell.SQL EditorCtrl+F - Find - Opens Find/Replace dialog if SQL query field has focus (from v8). Ctrl+Enter - Execute - Executes current query. Ctrl+R - Read Rest - Reads the rest of the query execution. Ctrl+B - Next Batch - Reads the next batch of the query execution. Esc - Stop - Stops the query execution.Profile View

As we have relation for catalog items, can we also have relations for attributes?What are the metadata model changes required for this? Appreciate the support 😊

Ataccama MDM presents particular challenges for multiple developers maintaining a solution together. There is no magic bullet to resolve this, but good working practices can minimise the risk of git conflicts and help resolve them when they occur.Your organization may have established working practices for branch management, naming conventions and so on. Compare these practices with the suggestions here when defining your team processes.This post assumes the reader is familiar both with MDM and with Git usage – there are many good resources available for Git in general and for Eclipse eGit as used in Ataccama ONE-Desktop; and Ataccama provides training for MDM. This post is long enough: I will not explain technical terms or procedures that should already be familiar or can be looked up elsewhere!What is the problem?MDM and RDM use a metadata-based configuration known as a Model Project. This consists of many xml files, and it is very easy for several developers to make model changes at

Introduction What is the Ataccama Admin Centre? Where is Ataccama Admin Centre? What are the serverConfig and runtimeConfig files? Where do I start? Where are these configuration files? Sample project structure What is inside the configuration files? ServerConfig RuntimeConfig IntroductionThis is an introduction to the Ataccama Admin Centre serverConfig and runtimeConfig files:What the files are and where to find them How to setup security on the Admin Centre UI itself How to setup an online service endpoint on Admin Centre How to setup Admin Centre to enable the run of schedulers, workflows and plans / componentsThe intended audience for this article are Power Users for Ataccama ONE. Power Users may have built some plans / components / workflows / schedulers / online services, and are now looking to host them on a server environment. What is the Ataccama Admin Centre?The Atacccama Admin Centre can also be referred to as the “ONE Runtime Server”. For the purposes of this document, we

Hi,After moving internal mdm connection (mdc_db) from mdm.runtimeCfg to runtime/etc/application.properities there is no more chance to see this connection in console under “Database Connections” site and be able to track sql by turning on “SQL Monitoring”.This was handy to see, easy and fast, which SQLs were executed and could help as early warning, that some SQL a running slow. This was working in v13, but since v14, this is not possible anymore to my knowledge.Is there any way, how to monitor this internal MDM connection back in MDM console?Thank you

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?  

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

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

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

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!

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. 

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? 

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

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

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

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

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?

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?

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

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!

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

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,