Data Quality & Catalog ⚙️

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!

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 . 

Hi all, I have a group of PPP that need to be renamed. Is it possible to update name once published? How? Thanks

I want to configure one general email notification that will be used for all of my monitoring programs. I would prefer to receive a single email notification that compiles the findings from various monitoring projects rather than the numerous emails I usually receive for each monitoring project. I'm aware that I should use One Desktop, but I'm not sure how to proceed precisely. Well, I know that I have to call monitoringProjectProcessing which allows me to  retreive the finish time with processing ID. And then I have to complie to get the ID link of notification but the problem is here that I dont know the step exactly. It would be great if you could help.Thanks in advance.

Let’s say we have some properties placed at the table attribute level. Is it possible to display those table attribute properties in the data structure page of the catalog item as shown below? Thanks in advance.  

Hello, I’m trying to figure out why the export plan section in Ataccama ONE desktop keeps showing “No Records Found” although I have created a list of export plans. Once I create an export plan, I save and publish it, but it does not show up as part of the export plan section instead it says, “JSON error”. Does anyone have any idea on how to fix this issue ?Thank you,Prithika  

Hi,There are certain records that contain “white spaces” at the beginning and/or at the end. Ex: “    100137069       “, “    100017129       “, etc. We don't allow the use of white spaces and want to build a DQ rule to check the invalid records. Hence the advanced expression:  length(String_ATTRIBUTE_1) <> length(trim(String_ATTRIBUTE_1)). When I test the DQ rule it works as intended. I copy the above results and paste them in the test environment and it shows me the record is invalid. When I remove the white spaces it will considered valid. However, when I run the Monitoring Project based on the same records and DQ rule it gives me 100% validity. How is this possible? And maybe more importantly, how can I create a rule that will show the invalid records shown earlier?  

Hi Community,I have used this community tutorial (thanks @anna.spakova !) and this part of the documentation portal to create a custom relationship (and an existing custom relationship as example). So that should be enough info, but still I encounter an issue. As follows.The relationship is between an extension of term (entity term) and custom entity application. The new relationship has been defined in entity entityTermSourceOfRecordRel as followsThis new entity has also been defined in entity metadata as array.A new relationship type has been defined for this purpose:In the entity term screen I have defined the realtionship as follows:{"_type": "relationships","relationshipPropertyPath": "/entityTermSourceOfRecordRel"}On the entity term screen I would now expect to be able a new relationship like this (from the example we already had implemented):Instead I only have the option to define a new relationship type, like:What am I overlooking? We are on version 13.9.Thanks and kind regard

Hey Everyone!We have a use case involving datastage and curious if anyone has worked with this in the past. We have a team who has datastage jobs that are triggered by a table being pushed information downstream. We are wondering if there is a way either in the web or desktop, if we can use the trigger files that are created by datastage, somehow plug into the datastage flow, or another way that would trigger a monitoring project simultaneously to run data quality checks against the load? if certain data is not loaded in correctly, it will break the connection for the two tables, and in turn break the job, and they want to see the population of what is breaking the join. Hope this makes sense! Thanks,Thomas

Hi everyone! I’m wondering if its possible to trigger or use the Review workflow from one desktop? For instance, im currently updating a large amount of attribute descriptions and am publishing them with one desktop. Whenever I use the One Metadata writer it will apply the descriptions automatically without further approval.I would like to know if its possible to write the descriptions and then have them sent to the tasks board for the data owner to review and approve or deny.Example of what im trying to do:Use one desktop to write descriptions to attributes Review workflow is triggered, and new descriptions are assigned to data owner for review (preferably in batches of 15-20 if possible) Owner either approves changes, causing descriptions to be updated or denies them causing no change to descriptionsThank you for any help!

Hi Team, I am working on task to check the number of rows in a column. I am using count of ATTRIBUTE_1 but not able to achieve it . can you please suggest a better approach. let me know if i miss anything. 

Hello Ataccama team Checking ataccama admin center on resource section there is mentioned the JVM Heap Memory,I would like to know more about the Ataccama JVM Heap Memory configuration , as I understand Ataccama manage Java APIs (mmm comment, dpe,...) , I am curious to know if Ataccama has a configuration file to define the limits of JAVA memory to use on each ataccama api, or if Ataccama has a configuration file to manage the whole java resources.

I am working on the usecase of comparing two different columns in two different csv files. I need to compare these column, remove any duplicates and merge them into single column. I am trying to use join component but not sure about this approach will work or any better solution is available to achieve this use case - If anyone can suggest a better apprach it will be helpful. - Thanks.