Learn & Share

Happy Wednesday Community!Today’s post will cover how to work with component rules on ONE Desktop Application. If you missed yesterday’s article we had an introduction to working with components on ONE Web. Check it out here: Component rules play a crucial role in tackling complex data validation tasks that may go beyond what standard DQ rules in the web application can handle. By leveraging component rules, you can define custom validation logic tailored to your specific data quality requirements.To ensure accurate and effective results, follow these best practices when working with component rules:1. Creating a Component Rule on ONE DesktopTo create a component rule, follow these steps: Open ONE Desktop and add Ataccama ONE Platform Server by creating a new server connection. Navigate to the ONE Metadata Explorer tab. Select the component you've created in ONE Web Application (e.g., "Email Check" in this example). For more information on creating a component in ONE Web Applicatio

Hi,I want to compare the number of not null records in source (custom sql using JDBC writer) and target (salesforce object) using a VCI. Is there any way to do that in Ataccama version 14.1.0. The aim is to get the records which are in source and not in target and records which are in target but not in source.Thanks.

In RDM web app, I see State column as waiting for confirmation as its not getting published due to data error.I am manually deleting record one by one by going to Problems section in web app.Can it be deleted in bulk and please tell me the procedure.

How to add a new table by uploading a excel file data in RDM web application which is already having a list of existing tables.Also, could you please help how to add a new business user in RDM web app via keycloak who will have access to RDM tables to edit records.@Cansu please help

I am using desktop app, and I want to schedule the workflow. Can anyone give some idea of scheduling workflows? I am trying to achieve the task ie. run the flows as per scheduled time(either weekly or monthly - like 5th day of each month)Below is the screenshot that I am having the file, but some how it is not working for me.Thanks in advance. 

Hello all, i have a task of validating email with the help of api. I want to know is there any documentation which properly explains the integration of postman api to ataccama desktop? or is there any tutorial for working on with apis' using ataccama. Graphql is there but i'm in need of a very basic one to execute and practice.Thank you!

In this tutorial video, you will learn how to efficiently manage comments in the Ataccama ONE platform. Discover the step-by-step process of closing, reopening, and deleting comments, allowing you to keep your comment sections organized and up to date.In this video, we will guide you through the key features of comment management in Ataccama ONE. You will learn how to close a comment when its content has been resolved, providing clarity and closure. We will show you how to navigate to the "Closed" tab to access and view previously closed comments, ensuring easy reference and tracking.Reopening a closed comment is made simple in Ataccama ONE. We will demonstrate how to reopen closed comments, making them visible again in the "Open" tab. Keep in mind that if a comment has replies, the entire thread will be reopened, maintaining context and continuity.Additionally, we will explain how to delete comments that are no longer necessary or if a mistake has been made. You will learn the criteri

How to connect ONE DATA as a source  ?What's the URL value that is required to connect ? 

I am trying to parse an XML File that has data related to employees in the following format<TABLES>        <DATA>            <item>                <WA>Emplyee1No Employee1Name Employee1PhNo Employee1Email</WA>            </item>            <item>                 <WA>Emplyee2No Employee2Name Employee2PhNo Employee2Email</WA>            </item>            ….            ….       </DATA></TABLES>I am using XML parser to parse this but it does not give any result.I think the issue is with the same tag containing multiple records.As I am able to parse it when there is just one record i.e. one <WA> and <item> tag.Can anyone please help me with this?

Hi everyone!Today, we’ll be sharing a tutorial and guide on how to configure "reporting metadata structure" and "bulk import" to the Ataccama ONE Gen2 metadata solution using two different methods. This is workshop is targeted for advanced users.Hear from Ataccama's VP of Platform Strategy, Marek Ovcacek, as he goes over what it means to explore lesser-known but very powerful functionalities of the Ataccama software and teaches users how to best integrate them to create their own custom solutions. *Ataccama platform and functions featured here are reflecting the time the video was published.Please don’t hesitate to let us know if you have any questions in the comments below 👇

Hi All, Our requirement is to use an api call for removing a cde term and adding another cde term associated to a rule.we thought of using PUT /rule-versions/{id} api. However some points we noted. in one webapp for the ruke, if we remove cde and add another cde, the rule gets created as a newer version. We just want to update the existing version Please let us know which api we can use?

Hello!My team and I are working on connectivity to be able to pull rules down from the web version into the Desktop version, make some minor tweaks, and then reupload them back to the Web version. Is this possible? We have our ONE platform connected to our desktop and can see all of our catalog items and rules, but when I try and drag a rule into a component / plan or make any changes, we get an error and we can only view the rule. Has anyone ran into similar issues? Or are we attempting to do something that the Desktop version does not support? Any answers would be appreciated, thanks!

Hi, In Ataccama web there's a way to set a certain treshold about validity when monitoring (default is 70% I believe). Is there a way instead of percentages to have it as raw number of records?Basically the idea is that I want to see the treshold met when (example) 100 records are met. The amount of records added to the dataset varies hence percentages might not work for me.Currently I have 1000 records. 100 are invalid. Treshold could be set to 10%.But if overnight 4000 records are added totalling 5000 records then 2% is invalid, assuming the invalid numbers stay the same. In the ideal world I want to be able to make a choice whether I want the treshold to be set through percentages or raw number. Because in this scenario I'd still like to be given a notice 100 records are invalid.

Hi All,I would like to map keycloak roles present in gen1(12.8) to gen2(13.9/14.3).Has anyone done this activity while migrating Ataccama 12.8 to 13.9/14.3 version? Thanks,Parvesh Soni

I am trying to apply a rule on a boolean type attribute to find if the value is “Ja” or "Nee”. However I couldn’t  achieve the expected outcome with advanced expression as its a bolean type. Also looked in to the documentation for one expression.Any suggestions to get the similar results with boolean type attribute?

Hi,Situation: I wrote a(n) SQL catalog item joining multiple tables and in Ataccama I'm using rules to compare the values if they are the same. LONG = LONG, check if the nr_loan = the same a.nr_loan, etc.My question is if there's an easier way to see if two tables are identical. I'm doing this to check the integrity.I couldn't find anything relatable asked in the community.  

Hello all, is there anyone who knows about creating a rule to detect the duplicate records of a particular attribute and mark it as duplicate using one web?