Data Quality & Catalog ⚙️

HiI’m running your free version of DQ Analyzer, but when I want to run my profiles this can’t be done.   As I understand it, it is due to a needed version update.Can you advice how I get my license key updated and not losing my existing profiles and still running the free version?I do not want to install Ataccama One.

Hi Community!We are starting the week by exploring best practices for effectively working with Lookup Items and integrating them into your Data Quality (DQ) rules. Lookups are essential in ONE Web Application as they provide a list of predefined values for attributes, enhancing data validation and detection capabilities.If you remember we have previously covered how to create Lookup files in rules in our Working with DQ Rules series, today we will expand on the lookup items feature. Overview of Lookup ItemsLookup Files in ONE Web Application enable you to use reference data, offering a catalog of predefined values for an attribute. You can utilize Lookup Files in both DQ Evaluation rules and Detection rules. To find Lookup Files, go to Data Quality → Lookup Items.  Uploading and Creating Lookup FilesCreating Lookup FilesTo create a Lookup File, follow these steps:In Knowledge Catalog, navigate to Data Quality. Select Lookup Items and click Create. Provide the required details, such as

Hello everyone, Anna here! I work as a projects consultant in Ataccama and today I put together a guide for you on how to migrate permissions after upgrade of v13 to v14. In v14, we introduced a fresh new permissions model introducing Groups and Stewardship. The downside is, though, that after the upgrade the old permissions model cannot be automatically migrated into the new setup.Attached to this guide is a migration package – a set of plans that you can use that will help you through the process of migrating the old permissions into the new setup in more automated way. It is not meant for fresh v14 installations.The article is split to two parts:Preparation phase – steps you need to do BEFORE you upgrade your environment to v14. Post-upgrade phase – steps you need to do AFTER the upgrade, meaning in your new v14 environment.Preparation phaseFollowing steps should be run on version 13 prior running the migration scripts and upgrade of the environment.1. Create server connection in ON

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.

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

How do you extract the catalog item with their associated terms (final) in a report?

How can I set-up email in workflow? I am using Microsoft 365 Please help