Master Data Management & Reference Data Management 🛰️

Hi I want to search for a validation message on a field. For example if ABN is empty I can use Advance condition to write: ABN is null However in this case I want to search where the ABN contains a value which has a validation message attached to it, ie where an ABN field is detected to be incorrect as it contains either a dummy value, or it didnt pass a check. Usually these fields will be highlighted as they were scored higher in the cleanse layer in One Desktop For example ABN is 0000000000 at the source layer Is there a way I can search / filter records for their specific validation messages, as opposed to the content in the field. ( As the validation messages are not the actual input in the field, but score and explain what is wrong in the field) See photo attached thanks

Hi, I am getting this error while running the Load Operation for full load for one of the source system. Any help ,highly appreciated.

Hi all,For Postgre SQL,when we are loading its only to our local.eg,if one member is loading the data in load operation,the post gre table that are populated are only visible to the member who loaded.How to enable the postgre table or see the table and its data which will be common to all user? Please suggest.

Hi,I am getting this error while running the Load Operation for full load for one of the source system.Any help ,highly appreciated.

Hi All, I am very new to Ataccama and still exploring everything by myself. I have updated logical model (added new entities), load operation and then configured transformations. Saved and generated the project. But I cannot see the new entities in Postgresql. I was under assumptions that after generating the logical model, tables will be created automatically in postgre but that didn’t happen. Tried saving, generating, stopping and starting servers several time but no luck. Is there any steps to follow? Thanks FS

Hi, I have a requirement to ignore certain columns to not detect as a change when that field comes with a different values in the message. I tried applying the field in ignores comparison columns as shown below, but looks like when the message came in again with a new value for this field, it still got processed. Are there more steps to be done to ignore a field? Also to highlight, we consume data from Kafka streaming consumer.

Hi All, I have created the logical model (Instance and master layer) and then configured the full load operation. I am now working on Transformations layer. Here for few new entities I can see only the clean and match component are generated automatically. Now I want to add merge component. How do I do that? I have the option to create new component under Files → engine → trans → party_address but then that will be blank and there is no Integration input/ output added which gets generated using the model. Am I missing any step? Just like party_address I have also added party_rel and here I can see all the 3 components. (Please refer the attached picture). Thanks FS

Records marked as match_override after being fixed on OGC. When the matching rules changed and subject is reprocessed, these records are being unchanged while they are supposed to match with other records. How do we [omnihealthdata].[dbo].[ids_override_match] and [omnihealthdata].[dbo].[ids_override_property] tables contain these records, did try deleting from these table and rebuild and reprocess with the new match rules but they would not match.

In have a scenario, I need clarifications on: The project has been configured and deployed with the following golden entity and instance entity details:GOLDEN ENTITYemployee_name, stringINSTANCE ENTITYemployee_name, string. The golden entity is related to the instance entity. After deploying, I need to change the GOLDEN entity column - employee_name(String) to staff_name(string) in the ONE Desktop configuration as well as the GUI label. But I dont want to change the instance entity column name. This should be such that the updated staff_name attribute shows the value of employee_name from instance entity record when a golden record is matched. I am not using this attribute to determine a match. Can someone please confirm if this is possible?

Hi there Was wondering how I can use the length function in the Advanced Filtering to filter instance records where they either are under or over a certain length of characters. ie ‘instance record’ LENGTH >= 8 characters

I commit the changes of my MDM project into git regularly, however, I don’t see the changes reflect in ONE Desktop when I Switch branches I.e. if I had committed some changes into a branch and then created an new branch for new changes and commit them. Now if switch to the older branch, I don’t see the changes in Model Explorer-master layer, instance layer, etc. Can someone help me understand why this might be happening?

Hi, We’ve lost access to the Keycloak admin user in one of our environments. How do we about resetting the password for the Keycloak admin user. Regards baz

Hi Team, we have defined date type fields and Ataccama store them in GMT timezone. We need data is EST considering our time zone for the client. @Cansu Could you please let me know how to change this from GMT to EST timezone ASAP.

Need clarification on below scenario. I have party entity (ID, FirstName, LastName, FullName, CompanyName, Birthdate, SSN), address entity (ID, Address_1, Address_2, City, State, Zip) and party_address (ID, party_id, address_id, address_type). Party and address are not directly linked but through this party_address. Now I know that we can create match rule using columns of related entity. But in this scenario how do I use Address attributes to create a match for Party?

Hi All, Can someone please let me know the steps for configuring Survivorship logic for attributes once records are tagged for merge? I couldnt find much of survivorship details in One MDM document. Thanks, fshahin

Is anyone able to configure the Snowflake jdbc connection with OAUTH using AAD? I’m not clear on how to accomplish the instructions in the documentation. Can anyone help with screen shots or a section of their runtimeConfig file (with obfuscated secrets, id’s, etc) ? TIA

I’m new to Ataccama ONE MDM and have recently completed the training. I’m currently doing a POC on it and am stuck at two places. So here’s the situation: First, I’m able to load the data but I’m not sure how to update it. Like, lets say I have a person record and after loading it generated Person_ID X23233X. Now, I made changes to some of the data in the same request. For eg, I’ve updated the contact number or the address of the record. Now, when I’ll be loading this same data again I want the ID to remain the same and just update the contact/address data along with Last_Updated _Timestamp. Secondly, lets say I have a record with 2 different phone types, ‘Home Phone’ and ‘Work Phone’, and I’ve loaded it. So, the Person_ID X12322X will have two contact details associated with it. Now, lets say I removed the ‘Home Phone’ details from the record and send it for update load. So, after updating the same request, ‘Home Phone’ details should be dissociated from the Person_ID X12322X (the con

Hello Team, can someone provide insight around the solution to stop the event generations based on the condition, let's say- if MDM system receives / source system sends less than 50K records for mastering then use events to propagate the changes to downstream system else send a batch extract file. knowing the fact that we can delete the events after generating but looking to stop the events conditionally.

Hi All, I am working on an enhancement project where I am adding more source system in existing model. As per the requirement I have added one match rule in Party Match Component at the bottom of existing matching rules and then I executed the component using Run button. Got message that Plans completed successfully. After that I executed load operation with some sample data in source which is passing that last added rule. Execution completed successfully but the records didnt merge. In master table they are present as 2 separate records. Am I missing any step? Thanks, FS

Hello everyone, Anna here! I work as a projects consultant in Ataccama and today I put together a guide for you on how to work with delta changes in Ataccama ONE. Enjoy! Introduction As part of every project, some kind of integration with other tools is usually required. In most cases, the integration requires synchronization of some data between the tools on regular bases. When it comes to Ataccama ONE, synchronization of assets like business terms or DQ rules may be required – for example with Collibra. It is desired to synchronize only delta changes (changes that happened since the last synchronization) to keep the integration efficient. This article explains how the delta changes can be detected in Ataccama ONE using graphQL queries. There is no simple out-of-the-box delta detection implemented, for that reason multiple graphQL queries are used in plans to achieve this goal. Ataccama doesn’t store a last modified date or similar property within assets. Ataccama creates a History Ch

Hi, We are currently using 13.9. We have multiple kafka topics and they are differently named with a suffix representing the environment like topic.sit, topic.uat. When we do the deployment to prod we have to make sure that the comp files where the topics are specified like event handlers or streaming consumer are cherry picked manually. Since fetching the values from environment variable functionality is not available in MDM or ONE desktop, I was wondering if there is a way we could create an alias for these topics and define them in runtime config as runtime config will anyway not be merged in any deployments. If someone has any workaround for this kind of situation, please suggest. Thanks,

Hi All, I am new to Ataccama and currently working on a POC. I have a requirement that if an update is coming for a master record then it should not again go through the match and merge process, instead it should directly update the master record. Is it possible to achieve the scenario? Do I need to create separate workflow or same workflow can be re-configured? Can someone please explain with detailed steps if at all this is a logical possible scenario? Thanks FS.

Hello everyone! I created a VCI (Virtual Catolog Item) and created a Monitoring Project with Rules in Atacama One, using a Post Processing Plan I wanted to upload the result of the monitoring project to databases, in Atacama One we have a csv file with the results in the Export tab, but I can't upload it to the database, the database is empty. Сreated a Global Runtime Configuration, but there is no result. Who has faced such a problem?