Ataccama Community | Community

Skip to main content

Product Updates
Events
Training Resources
Groups

Getting Started

16 topics
34 Replies

Learn & Share

778 topics
1810 Replies

From Ataccama

95 topics
41 Replies

Featured 🟣

Recent Posts
Answer Questions

aish_TFData Pioneer

Master Data Management & Reference Data Management 🛰️

Duplicate instance record IDs with different contact values

Taking reference of CDI Example, I have multiple contact values for the same person and I want all of these contacts to be a part of the contact master entity. I am not sure how the same instance record id will affect this. Will ataccama load both these records? Will both these records partivipate in match logic(same master_party_id, same_contact_type,same contact_value) or will it consider just the first one?Also, if someone can please confirm if the master_party_id is id for master record derived on processing of all party records?

manikanta vData Enthusiast

Data Quality & Governance ⚙️

How to Implement Logic in Ataccama to Process One Record and Flag Another as Error for Duplicate Correlation ID and Version Number

Two records as same correation id and same version number one should process another one should error out how to implement this logic in ataccama

Jason.SupticUniverse Traveller

Master Data Management & Reference Data Management 🛰️

Programming Languages

Howdy community!Today’s post is a very quick thought on some language knowledge that seems to help me when searching for answers about a project I might be working on in Ataccama. When I search online for an answer about an expression, or maybe an error I am seeing, I typically search in the following order. In this example we will assume I want to change a date to a string in a Column Assigner.I always start with SQL. So my search might be “PGSQL to turn a date into a string” Next I usually go to JAVA. Same search but with JAVA instead of PGSQL. Finally (and I usually reserve this one more for troubleshooting), I go to XML. While it might not be super useful for this example, there have been a couple times where searching for certain XML. One example is from another of my post on making a field nillable (able to accept a null value). The way I was helped by looking up XML functions, was that I was actually able to view the XML for the Enrichment I was creating and search it piece by p

ritguptaData Voyager

Data Quality & Governance ⚙️

Access to Transformation Plan

Hi,I am not able to access the transformation plan feature in v15.3 from both the Transformation Plan tab and from the monitoring projects tab. Can someone explain why is there a restriction on creating transformation plans and how can I get access to it?Thanks

Albert de RuiterStar Blazer L2

Data Quality & Governance ⚙️

Business glossary – computed content (part 4)

Hi Community,The first posts about the business glossary dealt about applying more term types (attribute and entity terms), and how they get context by adding relationship types. The previous post was about implementing multilingualism. The post ended with a remark about computed content, being the topic of this post.To refresh your memory, at the end of the article I showed this screen print, depicting how the translated terms show in the term’s detail page. So like this.Notice that the translation of the term name is preceded by the language code, so it is a concatenation in other words. I will describe how you can define this. Actually to accomplish this I made use of a document that Ataccama provided and that I will add to this article. The document also describes another use-case, so make sure to have a look! Anyhow, this is how the concatenation of the language code and translated term name is done.The calculation is defined in a new metadata model entity. As naming convention yo

CansuCommunity Manager

DQ Snowflake Native App ❄️

❄️Introducing DQ Snowflake Native App

Hi everyone 👋 Any Snowflake users amongst us? 👀We have some exciting news to share - Snowflake’s AI Data Cloud now features a native data quality solution, brought to you by Ataccama with zero cost.With this new App you can leverage data validation to elevate the data quality capabilities of Snowflake, enabling you to maintain high data standards effortlessly within your existing workflows. Let’s get into the details 👇One of the common issues data engineers face today is not being able to validate the quality of the data stored in the Snowflake. While it’s possible to do some basic analysis using SQL this isn’t always sufficient enough when there is a need to validate a phone number, or if a physical address is existing, or email has valid syntax. So this is when we enter - Ataccama DQ here.How it works?The App has a predefined set of 50+ DQ rules available for you out of the box that you can use while writing SQL code in Snowflake. The DQ scores will be a part of the output of the

CansuCommunity Manager

🎉Community Update: New Ranks in Ataccama's Recognition Program (& rewards)! 🎉

Hi everyone 👋 We're so excited to announce a major update to our gamification program!As part of our ongoing efforts to recognize and reward your valuable contributions to the Ataccama Community, we've revamped our ranks system to make your journey even more engaging and rewarding. What are user ranks?Member ranks are a fun gamification element that incentivizes participation, rewards quality, and establishes reputation in the community. Every member of the community is assigned a rank based on their contributions. So, what's new?🌟 Fresh ranks: We've introduced new ranks to reflect your growing expertise and involvement within the community. Whether you're a seasoned member or just starting your journey, there's a rank that aligns with your level of participation. You will see your rank icon displayed next to your profile image. 🚀 Clear progression: With our updated ranks, we aim to provide a clearer path of progression as you contribute and engage with the community. Watch as you c

Vanja GilbertUniverse Traveller

Data Quality & Governance ⚙️

Issue Viewing Rule Logic in Sectioned Report View

Hi,I have a question about the rule logic display when a section is applied. In the report view, I can see the rule logic/implementation when I select a rule. However, once I select a section and do the same, I can only see the valid and invalid results, not the rule logic. Is there a reason behind it? Thank you!

FionaFData Voyager

Master Data Management & Reference Data Management 🛰️

Load data in ERP Systems

How to load result data from Ataccama ONE MDM to ERP systems like SAP?

aish_TFData Pioneer

Master Data Management & Reference Data Management 🛰️

Deactivation of historical data based on deletion in source

I have a scenario where I do not want to deactivate the source party records in Ataccama, even though it no longer exists in the source. Is there a way to achieve this?

ritguptaData Voyager

Data Quality & Governance ⚙️

Access to Transformation Plan

Hi,I am not able to access the transformation plan feature in v15.3 from both the Transformation Plan tab and from the monitoring projects tab. Can someone explain why is there a restriction on creating transformation plans and how can I get access to it?Thanks

Vanja GilbertUniverse Traveller

Data Quality & Governance ⚙️

Issue Viewing Rule Logic in Sectioned Report View

Hi,I have a question about the rule logic display when a section is applied. In the report view, I can see the rule logic/implementation when I select a rule. However, once I select a section and do the same, I can only see the valid and invalid results, not the rule logic. Is there a reason behind it? Thank you!

FionaFData Voyager

Master Data Management & Reference Data Management 🛰️

Load data in ERP Systems

How to load result data from Ataccama ONE MDM to ERP systems like SAP?

aish_TFData Pioneer

Master Data Management & Reference Data Management 🛰️

Deactivation of historical data based on deletion in source

I have a scenario where I do not want to deactivate the source party records in Ataccama, even though it no longer exists in the source. Is there a way to achieve this?

ritesh.ranjanData Voyager

Master Data Management & Reference Data Management 🛰️

Apply Last Changed Date Field Delta Change only on Instance Layer and not on Master Layer

Hi @Cansu and AllIn the event if there is no change in the delta records coming in MDM except one of the Sequence Generated column, is their a way that the date field(Last Changed) gets updated with the date of the new row only on INSTANCE layer and not on the MASTER layer. So, if MDM ingests the delta record in Instance Layer and sees that there are no changes detected on any columns except the sequence column and it has nothing to update the Golden Record already existing then it should update the date field on Instance Layer only and not on Master Layer.Please let me know if you have any additional questions.Thank YouRitesh Ranjan

RoelantVosData Voyager

Data Quality & Governance ⚙️

Reproducing the Term level Data Quality overview from GraphQL

Hi Ataccama community,I’m hoping someone with better grip on the Ataccama GraphQL model can shine a light on this. For internal reporting, we are looking to retrieve data quality details via the Ataccama GraphQL API. One of the requests it to produce an overview of the DQ score across the (rule’s) DQ dimensions. This is basically the same as is shown in the web UI when navigating to the ‘Data Quality’ tab for a Term. It shows the score broken down by dimensions, based on how the rules are defined.What I’m trying to do is retrieve the passed/failed rows at this level, so for each term and each dimension. This would allow me to summarise this into a score per dimension.However, I am unable to get this out of the API.I’ve approached this from both the ‘terms’ and ‘rules’ pathway. In both approaches I always end up with the ‘Overall Quality’ score for each term - not the per dimension details.The ‘rules’ query looks promising, but ultimately only returns the passed/failed records for the

MohtaramData Voyager

Data Quality & Governance ⚙️

Monitoring Projects - Notifications with Dashboard

I want the result of my monitoring project to appear in the dashboard in the Report section when I receive it by mail. Is it possible to amend the mail notification regarding this?The notification in mail should look like this:

Data Quality & Governance ⚙️

Anomaly detection icon

Hi,When there's an anomaly detection notification icon present in the Catalog Items overview I open the CI and confirm/dismiss the anomalies. When I dismiss all the anomaly detection icon notification goes away - perfect. When at least one anomaly is confirmed then the notification icon is still present (even though it's confirmed). Question: Is this intended?It's hard to judge which Catalog Items have been looked at and which have not. The anomaly detection icon shows regardless if confirmed or not. My idea is that the icon should change showing that you have looked at the CI which has now a confirmed anomaly. This way it's clear which CI have been looked at.Anomaly detection before confirming/dismissingAnomaly detection after confirming/dismissingIcon notifications in the Catalog Item overview. It's not clear for me nor for any other users if these Catalog items have been judged yes or no.Idea: If the icon is changed to another color, let's say red it will be clear for me and any oth

lekshminairData Voyager

Data Quality & Governance ⚙️

Lineage with matillion ETL tool

If we use matillion ETL tool for data integration to snowflake. Can we still see the lineage and transformation code in Ataccama?

mbiteyeData Enthusiast

Data Quality & Governance ⚙️

Monitoring Project Specific Notifications - Separated

I have been testing rule specific notifications within monitoring projects and it seems to add those notifications to the bottom part of the general notifications, but we are trying to see if we can receive separate emails due to different users needing to see specific issues.The documentation link is shown in the link below,https://docs.ataccama.com/one/latest/monitoring-projects/results-reports-notifications.html#specific-notifications

Keep me informed 🔔

- Master Data Management & Reference Data Management 🛰️
- Data Quality & Data Governance ⚙️
- News & Announcements 📣
- Ataccama User Lab 🧪

Upcoming Events 📆

Community experts

Show full leaderboard

Show full leaderboard

Badges 🏅

PierreLequyhas earned the badge First idea 💡
NickMikedishas earned the badge First idea 💡
Vanja Gilberthas earned the badge First idea 💡
GastonQhas earned the badge First idea 💡
may_kwokhas earned the badge 10 ideas 💡

Show all badges

Powered by Gainsight

Community Terms of Use & Conditions Cookie settings

Sign up

Already have an account? Login

For Ataccama Customers and Partners

or

Username *

E-mail address *

Company *

Job Title *

A bit about yourself

How did you hear about the Data People Community? *

Ataccama version

Password *

I accept the terms & conditions

loginBox.register.email_repeat

Login to the Ataccama Community

No account yet? Create an account

For Ataccama Customers and Partners

or

Username or Email

Password

Remember me

Forgot password?

Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.

Enter your e-mail address

Back to overview

Scanning file for viruses.

Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.

OK

This file cannot be downloaded

Sorry, our virus scanner detected that this file isn't safe to download.

OK