Learn & Share

Hello, Is it possible to mask attributes that are classified as restricted/confidential using Ataccama One Web? I was able to assign rules and terms to attributes, but I was not able to create/apply any masking methods. Please let me know if anyone has tried this before. Thanks in advance!

Hi Team,I am trying to find how we can achieve completeness DQ control by comparing data in the file and the table irrespective of the position of primary key in either of them. Also, need to know how we can achieve the same by using the composite keys.

Hi,I have a question about the display of invalid samples when a specific section is selected. It's helpful that the invalid samples are based on that section's checks, but I'm wondering why all attributes are shown by default.Wouldn't it make sense to show only the attributes relevant to the failed rules, with an option to add more if needed? The current setup is a bit confusing.Thank you!

Hi community,Does anyone know about documentation about visualizing relationship types? On the documantation portal I found this, but that doesn't seem to cover the setup in the Graph Visualization section in the Application Settings. The documentation mentions “For more information, see Configure Graph Visualization.”, but that is a link to the page you are already on.Kind regards,Albert

Hello Dears! Would someone advise if there any watch outs once I want to rename Monitoring projects and DQ rules on ONE Web?I have running projects and DQ rules naming convention of which I would like to improve. If I just simply change names, won’t it have negative impact anywhere?Thank you. Kind regards,Maria

I would like to setup a generic data quality rule to check string length. Requirements for length checks differs per attribute. Say column1 needs to have max length of 10 column2 needs to have max length of 15 and so onIs it possible to create a generic rule to check string length, passing value of length as parameter?I am aware of attribute length insights available as part of DQ profiling results but I would like to make the check as part of monitoring project. Thanks!

HiI would like to get a summary of DQ checks and results like the one we have in ONE web like how many in % and count of broken rules, how many are passing and how many records do we have in total etc. in Ataccama ONE desktop. I tried looking out any related topic in the community but I could not find one. Is it possible to achieve this via Ataccama ONE desktop as we have an existing plan comparing data fields in two different sources. Do you mind sharing the suggested steps to achieve this? Thanks in advance!

Hi, is it possible to have a  single rule that checks many condition. example is below   i want a single rule named--Name Validationi want this rule to check  and validate name that are in -Title Case --first letter upper case follow by all lower case  Accented--- Accepts accented character  Accepts special characters  Could have Hyphen - the rule should should invalidate any other names that does not meet these conditions . or is there a better way to do this ? preferred to break it down so its will be easy to know the reason why the names are not valid whenever its does not matches 

Hello,I have a runtime-server online service that I am trying to call using Azure Synapse using OAuth authentication. I created a REST Linked Service in Azure that connects successfully to the runtime-server online service. I am using a copy activity in Azure to do a POST call on the online service. When running the copy activity I get the following error:{ "errorCode": "2200","message": "Failure happened on 'Source' side. ErrorCode=UserErrorCharSetInvalidOrNotSupported,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=The CharSet '\"UTF-8\"' is invalid or not supported from Response.Headers.Content-Type.,Source=Microsoft.DataTransfer.ClientLibrary,''Type=System.ArgumentException,Message='\"UTF-8\"' is not a supported encoding name. For information on defining a custom encoding, see the documentation for the Encoding.RegisterProvider method.\r\nParameter name: name,Source=mscorlib,'", "failureType": "UserError", "target": "CopyDataCatalogToRaw","details": [] }T

Hi Community,Would there be a way in Ataccama Desktop to select records from for instance entity term that have been inserted/updated/deleted from a certain datetime, like the Published on datetime in the History tab? My intention is to use the metadatareader to read the details from term and then use this mutation datetime in the filter in the metadatareader.Kind regards,Albert

Hello, I’m trying to mask certain attributes in a table and be able to export them while exporting the table as a file. Is it possible to mask them as part of the JSON code while creating an export plan or create masking rules and apply it to the attributes and then export them. (using ataccama ONE Web). Has anyone tried doing this before or has any idea about this? Please let me know!Thank you,Prithika  

Hi Everyone,We are in the process of transitioning to Ataccama as our DQ solution. In our current setup, we perform various data controls such as:Empty File Check Duplicate File Check Header or Trailer Validation (e.g., validating trailer record count or checksum)We are keen to understand if these types of data controls can also be implemented using Ataccama. Our goal is to consolidate all data quality processes into a single tool for better efficiency and management.Thank you!

Hi all, is there any configurations we can edit in the page template and/or the metadata model, so that we can (best having a hyperlink or button to) export the content from e.g. the access, data structure or profile tabs of the catalog items? Thanks a lot.

Hi all,I am in process of learning ONE Desktop and was curious if there any documentation or best practices on integrating GIT. I have searched and found a related topic that was helpful.  Thanks for any help. 

Checking to see if there is a way to create a “current values only” table in RDM, with no historical records to be kept?  I don’t see any option for this in the documentation or One Desktop dialogs.     

Hello community,I’m working on an RDM project and have a question regarding the security configurations. I find that if I tick the Fixed Permission checkbox in the Security config. node, the roles permissions I have setup in the IDE will get uploaded onto the web app., but it won’t be editable later there. However, if I don’t tick this checkbox, none of the permissions will get loaded on to the web app., but I will be able to fully customize the roles permissions on the web app.Is there a way to have the initial roles permissions loaded from IDE, but also editable later on the web app.?Thank you in advance

Is anyone able to confirm if One Desktop version 13.3.2 is compatible with with MS Windows Server 2022

Hello allA basic (and rookie) question, but I couldn’t find the answer in the manual or tutorials, or on this forum.After I’ve loaded source data into Ataccama ONE Desktop, I’m looking to create a new column and fill it with the concatenated content of some other columns (two or more), maybe with a bit of text in between. In Excel I’d use the Concatenate function...Example from ExcelAs you can see, I can then lookup information based on Column D and use that for bringing in various lookup values (the real use case is not name-based, this is just to create a simple example)Note - I’m not looking to merge different tables (with join, union, or representative creator - unless those tools can do what I’m looking for) - this is simply creating a new column/field which is a concatenation of two or more other fieldsContext: I’m building a lookup based on multiple attributes - I’ll combine them into a single attribute to give me a single lookup key and then I can use that for various other pur

Hello, I am trying to create a rule for validity on Names. The logic and condition is that the rule matches names that are Title Case --first letter upper case follow by all lower case  Accented Accepts special characters  Mandatory Could have Hyphen - I have this regex ^[a-zA-Z '-]+$ ^[A-Z][a-z]*(?:[ '-][A-Z][a-z]*)*$(?<=^|\s)[a-z]*[A-Z][a-z]*[A-Z]*[a-z]* above regex capture and validate names like John DoeMary Anne which are okay.  but also validate name in all lower case for example john doe which is not okay. i want to know what i need to do to allow the regex not validate names in all lower case .