Master Data Management & Reference Data Management 🛰️

When i am creating a new flow for export operation,it is not reflecting in the admin console to trigger the respective flow’s execution.Please help how to enable that in the admin console.Please suggest.

When trying to run export operation from localhost admin center, error is thrown saying "Origin code 3389682780300157351 used on InstanceEntity(address) record 37150 not found!". Here address is one of the entity being used in my export operation.Attaching the error log file here and below is the export plan for the full load for policymaster export.Any help,highly appreciated. 

How can I edit existing lookup files to add new values? File location is “files → data → ext → lkp”or how can I create a new lkp file in same path?

Hi All,From source I am getting only one column as FullName and there is no other column which can identify whether the Fullname is person’s name or a company’s name. In Ataccam, is there any out of box functionality built which can parse the FullName column and identify the party type?If yes, then kindly do let me know the steps which I need to perform to achieve this.ThanksFS

Hi All,In my incremental table I am having 300K records which when I am trying to load in MDM, the server is getting crashed. Its running for 2-3 mins then throwing the error that “cant reach local host server”. We are in dev phase and using the local server. Some times it also throws the error “Not enough memory to load this page”. How do I fix this issue?I also saw the post for applying check points in full load but what about incremental load. How do we handle failures for incremental load and how can we optimize it more?Thanks. Your inputs will be much appreciated.

Does anybody need to ingest data into Ataccama by way of an excel file attached to an email?One of our business teams receive a “data feed” from an external supplier. It comes as an Excel attachment delivered by email.We have enquired, they do not have APIs. Excel via email is all we’ve got.As it stands, my integration will depend on the person receiving the email dropping the file into something like an S3 / ADLS Gen2, and for us to build a .ewf to poll the location regularly to ingest the data (into RDM).We’re on PaaS, v14.5.1 for now, soon to be v14.5.3.Don’t think the PaaS stack can automagically read emails and get attachments off. We’re not keen on the dependency on the person to drop the file into ADLS Gen2, but it seems to be my only option at the moment.Do I have any alternatives? 

Hi All,I have a scenario where I have loaded email table with 2 slightly different email data. Now next day source team sent the corrected data which is exactly equal to first data so the 2nd data gets updated but since it is exactly same it should get merged with first data but that is not happening. For email table we dont have any match rule. We just have defined a key rule on email address basically storing unique data for same load.First Loadid email 123 abc@gmail.com 124 abc1@gmail.com  2nd Loadid email 123 abc@gmail.com 124 abc@gmail.com  Now I have duplicate email data with 2 diff id. How can I fix this? I do not have party id in this table. Party and Email are linked using Party_Email table which is having relationship for both the entities.Party_Emailid party_id email_id 1 100 123 2 100 124  

Our experts here can’t seem to get it to work even with support team’s help.  If you happen to have had success and are willing to share some of the details, it would be greatly appreciated.  

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 attachedthanks  

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

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).ThanksFS

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