Skip to main content

Learn & Share

Discuss data, share best practices, learn, and grow with Ataccama's Community.

878 Topics
Cansu
Community Manager
CansuCommunity Manager
published in Data Quality & Catalog ⚙️
Getting Started with Monitoring Projects 🎢Best Practice

Hi Community!In the next few days, we will discuss Monitoring Projects, a powerful tool to evaluate and monitor data quality over time for selected catalog items. Monitoring projects use DQ checks, automatic anomaly detection, and structure checks to maintain data quality. We also have a short video introduction to Monitoring Projects, go check it out here 👇 If you are ready, let's dive in 🤿 Accessing Monitoring ProjectsTo access Monitoring Projects:Go to the left-hand menu and select Data Quality. Choose Monitoring Projects.     In this section, you'll find all configured projects. If you want to start a new project, click Create.Each project listed will show the following information:Name: The project's name. Terms: The glossary terms associated with the project. Items: The number of items monitored within the project. Latest run: The date of the project's last evaluation.   The current state of a project is indicated through row highlighting, showing if it's published, recently ad

1420
Cansu
Community Manager
G
Data Voyager
GregersData Voyager
asked in Data Quality & Catalog ⚙️
License issue with free desktop version of DQ analyzer

HiI have with great success been using your free desktop version of DQ Analyzer.But the license has run out. Last time I had this issue a new download and a re-installation solved it.I have tried to do the same, but it did not work.  See issue “DQ analyzer windows version update” for further details.Any advice what to do?

71714
G
Data Voyager
P
Data Voyager
PiotrPietData Voyager
asked in Data Quality & Catalog ⚙️
Is there any option to set up diffirent 'Teams' channels for each DQ Monitoring project ?

I would like as an example to have one ‘MS Teams’ channel for one DQ Monitoring to reach out different groups of people tus set up diffirent Teams connections  Is there any option to set it up in the current version? cheersPiotr 

381
Cansu
Community Manager
Cansu
Community Manager
CansuCommunity Manager
published in Data Quality & Catalog ⚙️
Scheduling Lookup Item Rebuilds and Managing Lookup Files 🗃️Best Practice

Hello Community! In this second part of the lookup best practices series, we'll cover how to schedule automatic rebuilds of Lookup Items and provide some useful tips for managing your Lookup Files effectively. If you’ve missed the first post you can check it out here: Scheduling Lookup Item RebuildsAutomating the rebuild process of your Lookup Items can save time and effort. To schedule automatic rebuilds, follow these steps:In the Lookup Item, select the more options icon, and then click Schedule.   In the sidebar, choose Add scheduled event.   Set up the scheduled events for the rebuilding of lookups. For more details, refer to the Scheduler documentation.Managing Lookup FilesEditing Lookup FilesOnce Lookup Items have been uploaded, you can edit them manually or reupload the files if necessary. To edit the lookup manually: Select the required item. Click the more options icon, then choose Edit.   To reupload the lookup item: Select the required item. Click Upload new version

820
Cansu
Community Manager
M
Data Voyager
MarcelData Voyager
asked in Data Quality & Catalog ⚙️
AVG and avg not working

Hi guys, I'm doing the dq foundation course and I'm stuck.I have tried to look it up, but no result.This is on an environment in the portal.When I'm doing, with AVG or avg, this:It says:How do I make this work? Kind regards,Marcel

625
M
Data Voyager
M
Data Voyager
mdaflucasData Voyager
asked in Data Quality & Catalog ⚙️
How do I evaluate multiple columns for possible composite primary key?

I have a legacy database without primary keys.  I know how to evaluate a single column for uniqueness, and thus a primary key. How do I evaluate multiple columns which together would be unique and thus be a composite primary key?

631
DannyRyan
Ataccamer
B
Data Voyager
bazData Voyager
asked in Master Data Management & Reference Data Management 🛰️
Displaying a list in a drop-down

Hi,   How do I present a selection of values in a drop-down in the RDM create/edit screens.E.g. I have an entity called Door with a column called state that can have a value of either Open or Closed. Can this be presented as a drop down to a user?baz

926
Cansu
Community Manager
G
Data Voyager
GregersData Voyager
asked in Data Quality & Catalog ⚙️
DQ analyzer windows version update

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.

3424
Cansu
Community Manager
Cansu
Community Manager
CansuCommunity Manager
published in Data Quality & Catalog ⚙️
Lookup Items and Rules ✍️Best Practice

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

2560
Cansu
Community Manager
O
Star Blazer L1
OjaswiniStar Blazer L1
asked in Master Data Management & Reference Data Management 🛰️
RDM: The capability to create a new record with a unique Primary Key column through the UI, accompanied by the restriction of disallowing any subsequent edits to the Primary Key ID.

Dear Community,I require your assistance with a specific scenario in RDM (Record Data Management).We have a table in RDM that allows users to create, edit, and delete records, which are synchronized back to the database. This table contains a primary key ID column. During the creation of a new record, the user provides the Primary key value. However, the challenge we face is that this primary key column should not be editable afterward to maintain its uniqueness as a key.We attempted to restrict column-level permissions, but this resulted in the Primary key column not being visible even during the creation of a new record.I would appreciate your guidance on this matter.Thanks very much.Ojaswini

482
O
Star Blazer L1
anna.spakova
Ataccamer
anna.spakovaAtaccamer
published in Data Quality & Catalog ⚙️
Migration of permissions from version 13 to version 14Tutorial

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

2640
anna.spakova
Ataccamer
S
Data Voyager
sandipilagData Voyager
asked in Master Data Management & Reference Data Management 🛰️
MDM Server start issue

Receiving error when trying to start ataccama server: Description:Parameter 1 of constructor in com.ataccama.mdm.core.SpringServerConfig required a bean of type 'com.ataccama.dqc.server.config.ServerConfigImpl$IServerConfigConfigBeanProvider' that could not be found.Action:Consider defining a bean of type 'com.ataccama.dqc.server.config.ServerConfigImpl$IServerConfigConfigBeanProvider' in your configuration. Need help on this please?  

441
Cansu
Community Manager
J
Universe Traveller
Jason.SupticUniverse Traveller
published in Master Data Management & Reference Data Management 🛰️
RDM Table Enrichment with Null Value

Let me start with the fact that I am new to developing Ataccama RDM (as in a couple months into development/learning).Problem statement: I am working on a project for creating new RD in the RDM module, and came across an instance where I needed an Enrichment that could not only fill in a field in the request, but could also delete the data in that field. I attempted many different methods, and could not get it to work, as having the field blank it would be considered a null value. After looking through the XML for the enrichment, I found that the column I was trying to set to null was set up in such a manner as to not allow null values (which appears to be the default in Ataccama RDM).Solution: When creating an Enrichment there is an .online file that is created for deployment in the online application services. In this file, there is a setting for Strategy. The default for Strategy → Output Format → Root Section for each column is set to Optional Element, which does not allow null/bla

641
Cansu
Community Manager
Cansu
Community Manager
CansuCommunity Manager
published in Data Quality & Catalog ⚙️
Introduction to Working with Components - Desktop Edition⛏️Best Practice

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

1760
Cansu
Community Manager
Cansu
Community Manager
CansuCommunity Manager
published in Data Quality & Catalog ⚙️
Introduction to Working with Components ⛏️Best Practice

Hello everyone! Welcome back to our Data Quality (DQ) series. Today, we're diving into component rules!We're also excited to announce that we'll be hosting a live training session on component rules on July 27th. Don't miss the opportunity to learn from our certified trainer and engage in live Q&A. Register now here!  Component Rules, also known as components, are a powerful feature in the ONE Desktop application. They serve three key data processing purposes: Post-processing components: These components allow you to perform various actions on your data after processing it based on predefined rules. You can easily apply transformations, validations, or any other required post-processing steps. Transformation components: With transformation components, you can automate the process of transforming data records according to specific rules. For instance, you can standardize gender markers to "M" and "F" while transforming any other variations to these standard values. Validation co

1400
Cansu
Community Manager
R
Data Voyager
ritguptaData Voyager
asked in Data Quality & Catalog ⚙️
Row Count Comparison Between Source and Target

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.

1523
anna.spakova
Ataccamer
A
Universe Traveller
AkashUniverse Traveller
asked in Master Data Management & Reference Data Management 🛰️
RDM Web App deleting the data

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.

542
tomas.reichel
Ataccamer
A
Universe Traveller
AkashUniverse Traveller
asked in Master Data Management & Reference Data Management 🛰️
Add table in RDM web application.

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

511
tomas.reichel
Ataccamer
A
Universe Traveller
Ajeesh_GUniverse Traveller
asked in Data Quality & Catalog ⚙️
How to run WorkflowInstanceState file

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. 

291
Cansu
Community Manager
S
Data Pioneer
suryakanth.EmishaData Pioneer
asked in Data Quality & Catalog ⚙️
Ataccama IDE - Postman Api tool integration tutorial?

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!

1492
S
Data Pioneer
Cansu
Community Manager
CansuCommunity Manager
published in Data Quality & Catalog ⚙️
Introduction to Aggregation RulesBest Practice

Hi all! We hope you’re enjoying our DQ Rules best practice series and finding useful tips & tricks to implement in your day-to-day work. In this post, we will cover aggregation rules and give an overview of creating and configuring aggregation rules to unlock the grouping capabilities.Aggregation rules in Ataccama's ONE can be used in various types of data quality rules, such as Validity, Uniqueness, Completeness, Timeliness, and Accuracy. Let's dive in! How to create aggregation rules?To create an aggregation rule, follow these steps:Select "Aggregation rule" as the rule type in the ONE web application.   The "Group by" section will now be available, allowing you to define the grouping criteria.You can create aggregation rules using either the condition builder or ONE expressions, both of which offer flexibility and ease of use. These methods allow you to select input attributes, apply transformations to create variables, and aggregate data based on the desired grouping. No Code

2310
Cansu
Community Manager
Cansu
Community Manager
CansuCommunity Manager
published in Data Quality & Catalog ⚙️
Working with Data Quality (DQ) Rules - Part 2️⃣Best Practice

Hi community! We hope you’ve found some useful insights in the first part of our Working with Data Quality Rules article. Check it out below if you haven’t seen it already or if you need a refresher!In this post, we will focus on duplicating rules, scoring records, and creating rules from mask, patterns, and frequency analyses. Let's dive in! Duplicating RulesDuplicating rules can save you time and effort, especially when you have similar rules that need to be assigned to multiple lookup files. Follow these steps to duplicate a rule:Navigate to the rule you want to duplicate. Expand the "More Options" menu and select "Duplicate."   A copy of the rule will open in a new tab with the settings already populated.   Edit the information as required and click "Save."Power users can also perform this action via API. Scoring RecordsScoring records helps you assess the severity of data quality issues. The score represents the numeric expression of each record's invalidity according to the rul

3490
Cansu
Community Manager
DannyRyan
Ataccamer
DannyRyanHead of Technical Training
published in Data Quality & Catalog ⚙️
121. Managing Comments

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

160
DannyRyan
Ataccamer
K
Data Pioneer L2
KundanData Pioneer L2
asked in Data Quality & Catalog ⚙️
How to connect to One Data

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

473
DannyRyan
Ataccamer
Cansu
Community Manager
CansuCommunity Manager
published in Data Quality & Catalog ⚙️
Working with Data Quality (DQ) Rules - Part 1️⃣Best Practice

Hi community! In this post, we will explore how to create and implement DQ rules effectively. Rules play a crucial role in ensuring data quality, and understanding the process is essential for data management. So let’s get started! Creating Rules Manually To create a rule from scratch, follow these steps:Navigate to the Data Quality > Rules page. Click on Create in the upper-right corner. Provide the necessary information: Name: Give your rule a descriptive name. Description (optional): Add a brief description of the rule and its purpose. Rule definition source (optional): Specify the associated data source for the rule. Stewardship: Select the owner group responsible for the rule's accuracy and approval. Click Save to create a draft of the rule.     Before publishing or submitting for approval, you need to define the rule logic. Proceed to the Implementation tab for further steps. Implementing Rule Logic On the Implementation tab, you can perform the following tasks:Add a descr

2960
Cansu
Community Manager

Badge winners

Show all badges

Let's shape the future of Ataccama together

Join User Research at Ataccama!
See new features and prototypes before everyone else, and have an opportunity to shape the future of new products.

Read more
Community Terms of Use & ConditionsCookie settings