Learn & Share

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.

On a matching component if address table is mapped as shown in the screenshot. Why would the process still run for the address table for both insertion and deletion. while its not being used. How to avoid it run through it and why would it run through? it would not need a master_id associated wither as it is tied to parent by u_parent_id. 

I'm currently using the "start-server.bat" file within the Ataccama Desktop tool to manually start Ataccama Server. However, if I forget to start the server, certain workflows fail to execute. I've attempted to automate server startup using Windows Task Scheduler, but it's not working as expected. Is there a reliable method to start Ataccama Server independently of the Desktop tool, perhaps through a scheduled task or another approach?

Hello: I have a use case specifically for assigning a term. If the data is a 9 digit number and if the field name is NOT one of the list i want to exclude - then that term be assigned. I also have additional field names that i want to be tagged with that term - irrespective of value with in that field.As of now - iam able to create  separate rules one that runs on metadata and other runs on real data - and put a OR condition or AND condition between the two rules. But that is not addressing my use case very well. I need one rule that can refer to both real data and metadata.  OR - i should be able to give a complex join condition with more than two rules(Rule 1 AND Rule 2) OR (Rule 3) Has anyone done something like that?

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

I’m trying to build a GET API call to an external data provider.This provider requires me to send my GET call with the certificate.We managed to test it in POSTMAN, where I had to add the certificate in the Settings → Certificates menu: I have a .pfx file with a passphrase, and I needed to specify the host.This works on my laptop in POSTMAN. Now I’m trying to do the same call in ONE Desktop using JSON Call step.By way of googling, I’ve managed to convert my .pfx file into .cer, then I imported the .cer file into {DQC_HOME}/jre/lib/security/cacerts . Then I have restarted ONE Desktop. But when I call the API I’m still getting an error message from the other side saying my certificate is not sent. I have a suspicion that the certificate is sitting in the keystore but it is not used. Is there some way to ensure it is used? Some java parameter somewhere?

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

Hey all!Now that incoming webhooks within Microsoft Teams is discontinued (Existing configurations will work until end of 2025), is there a plan for how teams will continue to integrate with notifications from Monitoring Projects? This was a big sell to a lot of our users, and now that we are unable to use incoming webhooks for new monitoring projects, I want to see if there is a plan to have a work around, or if it will be not supported in the future.    

Hello: I have a use case where when the data in a given column - for a key changes from previous day to next day - that should trigger an alert/notification For Ex: Security Ratings, and/or ESG ratings generally dont change for a given security. I have a table that has one record for each day for each security. And the ratings are in the columns of that table. Now - on a regular day - all ratings from previous day should be same for next day, and day after (until it changes). And on the day when it changes - i want to capture that security, ,what field changed - what was yesterday;s value vs todays value. The way - i would like to solve this - is create a SQLCatalog item - with previous day - and current day values combined into one dataset for each security and write scripts to compare them one by one, and report any changes. But I want to know if there is an out of box - date driven compare that can be done for this. 

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 Team, i need to get yesterday date in my workflow global variable, can you please help in getting.when i use toString(now(),"yyyy-MM-dd") -- printed me todays date when i use toString(now() - 1 ,"yyyy-MM-dd"), getting error as operator “-” can not be used

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.

Hi, I am trying to write some rules to check the data type of attributes within sql tables or flat file columns. I am aware that profiling checks this but I have a requirement to check the data type as well. There don’t appear to be any parse functions in the interface. Any help would be appreciated, I am a noob so please be gentle :)

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?