Ataccama Community | Community

Skip to main content

Product Updates
Events
Training Resources
Groups

Getting Started

1 Category
10 topics

Learn & Share

2 Categories
1034 topics

From Ataccama

3 Categories
111 topics

Featured 🟣

Recent Posts
Answer Questions

RoelantVosData Voyager

Data Quality & Catalog ⚙️

Query the monitoring report results at item level

I’m hoping anyone has some good GraphQL examples to share. For us, it is necessary to integrate Ataccama into our standard reporting. To do so I’m trying to get a GraphQL working that returns the scores for each item in a monitoring project. Ideally, listing out all monitoring projects and items with their scores - for the latest processing (although I’ll take all at this point and filter the old ones later). This is all about the statistics (# records passed/failed etc. not the individual results - I am aware I can create post-processing plans to export data, but this is not applicable here).It’s basically the overview from the report tab in the monitoring project, at item level:I can get everything I need, including the total row count except the passed or failed figure. I have tried and looked at all GraphQL examples everywhere, including ONE API :: Ataccama ONE, and have pieced this together based on the structures visible in the desktop app. Things like DqAggregationResultOverTime

laurenruthCommunity Manager

News! Ataccama ONE v16.2 brings AI to data lineage to help business users understand and trust their dataNews

Hi everyone! 👋We’re excited to share the release of Ataccama ONE v16.2! 🎉This version brings AI-powered data lineage, secure edge processing, and expanded pushdown capabilities, making lineage faster, clearer, and accessible to both business and technical users, while improving performance and governance at scale. Let’s dive into what’s new 👇🟣 AI-Powered Data LineageWith v16.2, Ataccama ONE introduces AI-powered data lineage. This new feature leverages advanced AI to automatically discover, classify, and visualize data flows across your ecosystem.Automated Discovery – AI scans your data sources, ETL jobs, and destinations to produce detailed lineage diagrams without manual intervention. Enhanced Visualization – Clear upstream and downstream views with overlays for quickly pinpointing data issues and quality anomalies. Accessibility – Lineage insights are now easily accessible for both business users and technical teams, ensuring transparency and trust across the organization.🟣 Sec

bobparryData Voyager

Data Quality & Catalog ⚙️

Home Page/Landing Page for Data Consumers

Hello!Does anyone have any ideas for how to make a welcoming and useful Home page for Data Users coming to Ataccama just for data discovery? All of the widgets seem to be focused on Data Stewards, but the majority of users arriving on to Ataccama for us are looking to find data to work with, so widgets like Tasks, Processing Centre, Notifications, and even the Getting Started ones are just confusing to them. I’m looking into making a Report that just acts as a welcome page for those new users, but haven’t been able to make anything that nicely introduces the platform without putting too much in front of them. Let me know if anyone’s done something like this before!

sgillaData Pioneer

Data Quality & Catalog ⚙️

OmniGen - changes for change in server ip address

What steps do we take when the both omnigen and DQS are moved to a different IP address. I tried updating the .plf(license file) but it did not work. Seems like there are more steps associated when the application is moved.

bobparryData Voyager

Data Quality & Catalog ⚙️

Automating Group ID Retrieval via ONE Metadata Reader

Hi everyone! I’m currently working on importing terms from ONE Desktop into the ONE web application, and everything’s been going smoothly so far. However, I am running into some challenges related to the Groups metadata. Right now, we're using an excel reader, reading a reference table that contains our organization’s existing Group names and the Group IDs, and joining that to a glossary term intake spreadsheet. However, our organization is expected to create many more stewardship groups, and the current excel spreadsheet containing the group names and IDs will have to be updated each time a new group is created which can be timely and error-prone. I wanted to test how we could reference Groups, especially when working with glossary term intake spreadsheets that list Group names but not their corresponding IDs. At the moment, I'm trying to read the Group entity type in the ONE Metadata Reader, which works well but the only output I can find is the Parent Group ID, rather than the requ

mp_ataccamauserData Pioneer

Data Quality & Catalog ⚙️

Questions regarding Ataccama v15.4 DQ&G Level 2 certification

Hello,I’ve completed the level1 certification exam and all the 4 mandatory courses for Level 2. I’m not able to search for the Level2 certification exam on the Ataccama academy portal. Can someone please help/guide me with the required steps to complete Level2 certification exam.Thanks!

NithaMData Voyager

Data Quality & Catalog ⚙️

Data Quality Rules using API calls

Hi There, We would like to know if the below mentioned Data Quality rules can be exposed as an API through Ataccama One App or One Desktop. Data Quality rule which calls a third party service - say loqate for address validation. Our understanding is that we have to write a plan to invoke loqate. Is there a way to expose this plan as an API to front end application? The usecase here is for the application to call Ataccama for all data quality validations through API calls. If it can be, could you please share the steps? Are there any known challenges? Lookup data quality rules - Can lookup DQ rules be exposed as an API using the steps in DQ Firewalls :: Ataccama ONE

mp_ataccamauserData Pioneer

Data Quality & Catalog ⚙️

In EMAIL notification, images are not loaded, any suggestions on outlook settings that could be applied?

Hi,I am using email notification option on completion of monitoring projects in Ataccama v15.4Somehow the images are not displayed and the email doesn’t look good. Can someone please help me with identifying any settings in my outlook to get the images loaded when I open the auto-generated emails.Thank you,

karangalepranavData Voyager

Data Quality & Catalog ⚙️

DQ rule on Date Validation

How can we write a data quality rule to check if given date in attribute falls on Sunday or not. If it falls on Sunday, it should pass else it should fail.

Quamar HasanData Voyager

Data Quality & Catalog ⚙️

How to Create Catalog items (to apply Ataccama Rule/Run Monitoring projects) while source is XML file.

I need to create Catalog items while my source is distinct XML file.Is there any existing process or we need to create new framework .Please explain detail solutions to work on this requirement.

sgillaData Pioneer

Data Quality & Catalog ⚙️

OmniGen - changes for change in server ip address

What steps do we take when the both omnigen and DQS are moved to a different IP address. I tried updating the .plf(license file) but it did not work. Seems like there are more steps associated when the application is moved.

NithaMData Voyager

Data Quality & Catalog ⚙️

Data Quality Rules using API calls

Hi There, We would like to know if the below mentioned Data Quality rules can be exposed as an API through Ataccama One App or One Desktop. Data Quality rule which calls a third party service - say loqate for address validation. Our understanding is that we have to write a plan to invoke loqate. Is there a way to expose this plan as an API to front end application? The usecase here is for the application to call Ataccama for all data quality validations through API calls. If it can be, could you please share the steps? Are there any known challenges? Lookup data quality rules - Can lookup DQ rules be exposed as an API using the steps in DQ Firewalls :: Ataccama ONE

mp_ataccamauserData Pioneer

Data Quality & Catalog ⚙️

In EMAIL notification, images are not loaded, any suggestions on outlook settings that could be applied?

Hi,I am using email notification option on completion of monitoring projects in Ataccama v15.4Somehow the images are not displayed and the email doesn’t look good. Can someone please help me with identifying any settings in my outlook to get the images loaded when I open the auto-generated emails.Thank you,

karangalepranavData Voyager

Data Quality & Catalog ⚙️

DQ rule on Date Validation

How can we write a data quality rule to check if given date in attribute falls on Sunday or not. If it falls on Sunday, it should pass else it should fail.

Quamar HasanData Voyager

Data Quality & Catalog ⚙️

How to Create Catalog items (to apply Ataccama Rule/Run Monitoring projects) while source is XML file.

I need to create Catalog items while my source is distinct XML file.Is there any existing process or we need to create new framework .Please explain detail solutions to work on this requirement.

AH5Data Voyager

Master Data Management & Reference Data Management 🛰️

Categories in RDM

I have a lot of categories in an RDM setup. In the Web UI, is there anyway to setup “shortcuts” or bookmarks so that users can see just the tables/views/datasets in their category?Looking for suggestions/best practices here on user navigation through many tables in the RDM Web UI please.

JTHData Pioneer

Data Quality & Catalog ⚙️

Integrity check using combination of attributes

Hi,In table ‘School’ I want to check two attributes, street and house number and see if they in combination appear in table ‘Address’. I know how to make a lookup which can check if street is in reference table Address, but I want to know if the combination street + house number as a record is in another table as a record.So below record 1 is valid, but record 2 and 3 both have house numbers in Address table, but not in combination with the street. Is this possible in ONE Web? School street house number 1 West street 45 2 West street 47 3 West street 49 Address street house number 1 West street 45 2 East street 47 3 North street 49

may_kwokStar Blazer L3

Master Data Management & Reference Data Management 🛰️

Changing RDM relationships from one parent table to another (few)

Let’s say we currently have some tables:TableATableBTableCTableD TableA and TableB are parents of TableC, then TableC is parent of TableD.So we have:Relationship Parent Table Child Table Rel1 TableA TableC Rel2 TableB TableC Rel3 TableC TableD We are trying to get rid of Table C, so that the new relationships will be:Relationship Parent Table Child Table Rel4 TableA TableD Rel5 TableB TableD I’ve tried to deploy the model and I get validation messages of missing parent values. Trouble is TableD is quite big in RDM terms (in the magnitude of 200k rows) and I think the application is struggling to start at the moment with all these failed validations.Is there some specific alter hints that can be used or am I going to have to anticipate going into repair mode somehow?

ryan.carpenterData Enthusiast

Data Quality & Catalog ⚙️

Best Way to Set Up Freshness Check as a DQ Rule

Does anyone know how to essentially recreate a freshness check rule with the data quality rules so we can assign the DQ rules to a monitoring project? We are working in Ataccama One Web and do not want to use Ataccama One Desktop currently. I have an attribute that has the date/time new records are loaded into our table. If we get at least one new record on the current date, then we want every single record in the table to pass. So with one record uploaded on the current date, the monitoring project will pass with 100% data quality. However, if no record is loaded on the current date, then the monitoring project will fail with 0% data quality. What is the best approach to set up a rule like this? Thank you in advance!We want to use the monitoring projects automation capabilities vs manually running the freshness check from the knowledge catalog every single day.

AH5Data Voyager

Data Quality & Catalog ⚙️

Community Spotlight - DQ

I attended this community spotlight yesterday. Will there be slides/materials from this presentation made available?

Keep me informed 🔔

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

Upcoming Events 📆

Community Recognition Program ✨

Climb the ranks, earn badges and receive recognition rewards!
Join our recognition program by sharing your best practices, providing solutions, participating in our user interviews, and overall engaging with our community to unlock invites to exclusive events and rewards🎁

Learn more

Community experts

Show full leaderboard

Show full leaderboard

Badges 🏅

Sonalhas earned the badge First idea 💡
sjettawihas earned the badge First idea 💡
serban.zbarceahas earned the badge First idea 💡
csapochehas earned the badge First idea 💡
Manzura Suyunbekovahas earned the badge First idea 💡

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