Skip to main content

Learn & Share

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

1077 Topics
Q
Data Voyager
Quamar HasanData Voyager
asked in 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.

231
I
Ataccamer
A
Data Voyager
AH5Data Voyager
asked in 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. 

222
I
Ataccamer
may_kwok
Star Blazer L3
may_kwokStar Blazer L3
asked in 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? 

193
I
Ataccamer
J
Data Voyager
Jukanti VishwasData Voyager
asked in Data Quality & Catalog ⚙️
Guidance Needed: Connecting to Microsoft Fabric in Ataccama Desktop

Hello Community,Could you please guide me on how to connect to Microsoft Fabric from Ataccama Desktop? What are the prerequisites or requirements for this connection? Could you also share the detailed steps involved in setting it up? Thank you in advance for your support!

380
J
Data Voyager
K
Data Voyager
karangalepranavData Voyager
asked in 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.

272
K
Data Voyager
OGordon100
Ataccamer
OGordon100Ataccamer
published in Data Quality & Catalog ⚙️
📚 Guide: How to run GraphQL requests - Part I
📚 Guide: How to run GraphQL requests - Part I

Hi community 👋 Ever wondered about the best ways to authenticate GraphQL requests while maintaining security and efficiency?Whether you’re new to Ataccama ONE or looking to optimize your workflows, here’s an approachable guide to using Service Principle and various authentication methods.In this first post of two part GraphQL series, I will share authentication types & which one you should use and how to authenticate GraphQL requests. Second part will be on how to work with MMM in GraphQL - so watch out this space for that!Let’s get into it👇 ⚙️API authentication User Accounts vs Service Principles User accounts and service principals serve different purposes in identity and access management. User accounts are designed for (unsurprisingly!) human users, providing them with access to applications and resources based on their roles and permissions. These accounts typically require interactive login with credentials like usernames and passwords. Service Principals, on the other hand

3521
T
Data Voyager
kayhan.turker
Ataccamer
kayhan.turkerAtaccamer
published in Data Quality & Catalog ⚙️
Adding a DQ Check to a Monitoring Project with ONE API
Adding a DQ Check to a Monitoring Project with ONE API

Hello everyone!With this post, I wanted to go through a use case that I found a solution for that may help others, so I thought I’d share. The goal with this is to assign DQ checks to Monitoring Projects using a ONE API call instead of doing it manually. I’m going to assume the following: that you’ve already made monitoring project and DQ rules you’re interested in, and a catalog item has already been added to the monitoring project.The GraphQL query will be a mutation that applies the DQ check to your attribute. It will use variables to indicate where this check should be applied. I’ll explain where to get all of these variables belowThe last section will briefly go through how to run the queries using Ataccama Playground. Query to Apply DQ CheckThe query used to apply the DQ check is provided in the file mutation SaveEntity_projectCatalogItemInstance.txt and the variables which will be necessary to include for this query to work, are in the mutation variables.txt file.In the variable

2481
T
Data Voyager
O
Star Blazer L1
OjaswiniStar Blazer L1
asked in Master Data Management & Reference Data Management 🛰️
Behavior of Invalid records in RDM Approval workflow

Dear Community,I have query regarding RDM approval workflow. In our project we have stages Initiator → Review → Publish .It has been noticed that when a record is invalid, its status is displayed as 'INVALID,' yet it progresses in the workflow for review. The reviewer has the option to accept this invalid record, and it moves to the Publish section. However, when the approver attempts to publish the record, an error occurs, stating that the record is invalid and cannot be published.The client is now requesting clarification on why an INVALID record is allowed to progress through these stages in the first place. They propose that it should not be permitted to move to the review state initially.Anyone faced this scenario before? Can we do something in approval workflow configuration that record should not move to review state if it is Invalid.Any help regarding this will be really helpful.Best regards,Ojaswini

665
A
Data Voyager
R
Data Voyager
RoelantVosData Voyager
asked in 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

893
A
Data Pioneer
B
Data Voyager
bobparryData Voyager
posted in 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!

50
B
Data Voyager
S
Data Pioneer
sgillaData Pioneer
asked in 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.

102
S
Data Pioneer
B
Data Voyager
bobparryData Voyager
asked in 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

253
anna.spakova
Ataccamer
M
Star Blazer L1
mp_ataccamauserStar Blazer L1
asked in 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!

315
B
Ataccamer
M
Star Blazer L1
mp_ataccamauserStar Blazer L1
asked in 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,  

403
anna.spakova
Ataccamer
JTH
Data Pioneer
JTHData Pioneer
asked in 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  

263
konstantinos.patikas
Ataccamer
A
Data Voyager
aisayev001Data Voyager
posted in Master Data Management & Reference Data Management 🛰️
Progress Update: On-Prem AI Agent Integration with Ataccama ONE

Happy to share a quick update with the community on the progress we’ve made with our on-premise AI agent integration into Ataccama ONE. We’ve now developed and tested four distinct use cases that support users across various data governance tasks. All of these are accessible through a lightweight chat-based interface that runs alongside the Ataccama UI, without modifying the core product.Here’s a brief overview of what’s working today:Data Quality InsightsThe agent detects data quality issues and provides root cause analysis with natural-language explanations. When needed, it also offers recommendations for resolving common problems, making DQ monitoring faster and more intuitive.AI-Assisted Data Catalog NavigationUsers can search and explore the Ataccama catalog using natural language. The agent retrieves relevant metadata and provides contextual recommendations, helping non-technical users find and understand data without needing to know the structure.Compliance & Sensitive Data

140
A
Data Voyager
A
Data Voyager
AH5Data Voyager
asked in Data Quality & Catalog ⚙️
Community Spotlight - DQ

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

244
A
Lazov
Data Voyager
LazovData Voyager
asked in Data Quality & Catalog ⚙️
Ranking numeric values in code query

Dear members,I am struggling with a step that rather reflects query/array logic than the logic of steps available in component editor.Task is to find the maximum from a range of values. I tried to retrieve it through a dynamic query written in a Representative Creator step, see details below:L1:= round((1-(levenshtein(W_CUA1,W_CUA1_MATCH)/(max(length(W_CUA1),length(W_CUA1_MATCH)))))*100,0);L2:= round((1-(levenshtein(W_CUA1,W_CUA2_MATCH)/(max(length(W_CUA1),length(W_CUA2_MATCH)))))*100,0);L3:= round((1-(levenshtein(W_CUA1,W_CUA3_MATCH)/(max(length(W_CUA1),length(W_CUA3_MATCH)))))*100,0);L4:= round((1-(levenshtein(W_CUA1,W_CUA4_MATCH)/(max(length(W_CUA1),length(W_CUA4_MATCH)))))*100,0);L5:= round((1-(levenshtein(W_CUA2,W_CUA1_MATCH)/(max(length(W_CUA2),length(W_CUA1_MATCH)))))*100,0);L6:= round((1-(levenshtein(W_CUA2,W_CUA2_MATCH)/(max(length(W_CUA2),length(W_CUA2_MATCH)))))*100,0);L7:= round((1-(levenshtein(W_CUA2,W_CUA3_MATCH)/(max(length(W_CUA2),length(W_CUA3_MATCH)))))*100,0);L8:= ro

788
Lazov
Data Voyager
S
Data Voyager
stuart.campbellData Voyager
asked in Data Quality & Catalog ⚙️
Published Terms in limbo

Hi Everyone,On the Terms page, there is the views of ‘Published’, ‘Unpublished’, and ‘All’. We have an odd scenario where about 150 published Terms (of all types) are showing in ‘All’ but not in ‘Published’. When I search an abbreviation of these Terms, it doesn’t pick it up in Global Search.When I modify one of the Terms in limbo and the publish it, it appears in the ‘Published’ view and has all the expected Global Search functionality.Has anyone experienced this issue before, and identified an appropriate fix? I’m trying to avoid manually modifying and published 150 Term changes.Thanks for your time and support.Stu   

182
S
Data Voyager
Albert de Ruiter
Rocket Pioneer L1
Albert de RuiterRocket Pioneer L1
asked in Data Quality & Catalog ⚙️
'Deleted by' details via GraphQL

Hi all,Some time ago I posted a question ('Published by' details via GraphQL) about how to make visisble who published for instance a glossary term.I noticed that like this you can't show who may have deleted the asset.Does anyone have a clue how to retrieve this details via graphQL (or in a different manner)?Kind regards,Albert

647
Albert de Ruiter
Rocket Pioneer L1
W
Universe Traveller
WesTUniverse Traveller
asked in Data Quality & Catalog ⚙️
Issues with Ataccama's GitLab Files Running Properly

Hello, We’ve created three files, one component file that extracts metadata from Ataccama, one workflow file which helps coordinate communication with the runtime server, and one scheduler file to control the frequency of the runs for the extraction of the metadata. We’ve been running into issues when trying to get the files to run automatically from Ataccama’s GitLab cloud. Note - we did reach out to the tech support team to restart the orchestration server. The error message we’re currently getting is as follows: Process finished with result code 2. Detail: Unable to instantiate the given resource provider: com.ataccama.dqc.s3.resource.S3ResourceProvider$Type We’re unsure what this error means and how to troubleshoot it. We’ve already corrected the output location path for the text-writer steps in the component file to point to the proper s3 bucket within our organization. Any idea how we can fix this error and get the files to land in our s3 bucket?

242
W
Universe Traveller
M
Data Enthusiast
monkmachineData Enthusiast
asked in Data Quality & Catalog ⚙️
Json attributes with dollar sign

We have some json which contains dollar signs e.g.{ "$guid": "2d5f7c9c-8e72-4f23-9538-8e07d4c5dcbc", "user": { "name": "Alice", "$guid": "e891cba7-5565-4c48-a2e1-02cd07f81f54" }, "orders": [ { "$guid": "77e4e751-80e8-470e-92c6-493361a9484f", "total": 100.50 }, { "$guid": "b1263c77-4e5f-4c1e-88e0-6df67ee99f61", "total": 250.00 } ]}I can’t get the json call step to read the $guid attribute as it just says invaild json path. Is there any work around to this?

354
M
Data Enthusiast
M
Star Blazer L1
mp_ataccamauserStar Blazer L1
posted in Data Quality & Catalog ⚙️
Ataccama learning and Certification path for newcomers

Hi,Can anyone please suggest the next level of certification after Ataccama ONE v15 | DQ&C Consumer Certification?Thanks in advance and Happy Learning!

341
A
Albert de Ruiter
Rocket Pioneer L1
Albert de RuiterRocket Pioneer L1
published in Data Quality & Catalog ⚙️
How to find and restore faulty page layout in OneWeb

Hi Community,Don't know if you ever have made changes to the page layout in OneWeb, but sometimes it can be an uncomfortable task: while often there is a preview option, for ‘create’ and ‘edit’ pages this is not the case. So after having made the changes and pressing Ctrl-s to save them, if you made a mistake it can turn out your screen will go white, without option to make a correction afterwards (yes, speaking from experience). Lately we had a bit of an awkward situation, that the System Changes screen in the Global Settings area was no longer accessible, showing an error message about a screen layout error. But we never applied any layout changes to the System Changes screen, so we were rather puzzled. I consulted Ataccama Support about this and I would like to share their solution.First conclusion by Support was that this was caused by an erroneous page layout from another page. Indeed we had done quite some development and experimenting (dev environment), so finally we figured out

251
A
A
Data Pioneer
akshayl09Data Pioneer
asked in Data Quality & Catalog ⚙️
Multiple job selection to schedule disable/Enable

Is there any to select multiple schedule jobs (data profiling, lookup and monitoring project) and disabled at once or enabled them at once?

395
anna.spakova
Ataccamer

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