Master Data Management & Reference Data Management 🛰️

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

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,

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

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

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?

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.

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.

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