Skip to main content

Recently active topics

21 Topics
S
Data Voyager
Susan24usData Voyager
asked in Data Quality & Catalog ⚙️
Semi Structured Data

Hello, i have a report that we usually saved to hard drive that i would like to bring into Ataccama, the report is in semi structured format . does ataccama accept or work with semi structure data ?or do i need to convert the report first before connecting to source ?

10
S
Data Voyager
5 hours ago
Cansu
Community Manager
CansuCommunity Manager
published in Data Quality & Catalog ⚙️
Data Reconciliation Best Practices 👾Best Practice

Hi Community! In the last few months the focus of our articles was majorly on features of ONE Web platform, from the basics to more complicated practices and now it’s time to move on to the next step. From next week we are moving on to ONE Desktop🖥️ Today we will focus on Data Reconciliation, and cover how you can utilize this feature effectively for seamless data consistency across multiple sources. Let’s get to it! In a nutshell, the Data Reconciliation feature confirms that your migrated data from one database to another is intact and accurate, without any data leaks or glitches. It conducts high-level checks on data consistency by comparing attribute profile statistics and even attributes fingerprints (except for Snowflake data). Step-by-Step Guide to Data Reconciliation 1. Create a Reconciliation Project in Data Quality:To kick off your data reconciliation journey, navigate to Data Quality and then select Reconciliation Projects. Here, you can either create a new project or edit

4484
B
Data Voyager
10 hours ago
Cansu
Community Manager
CansuCommunity Manager
published in Ataccama Community News 🗞️
🎯 How can we help you achieve your 2025 goals?

Hi everyone!Happy New Year 🎉  We hope all of you had a great start to the year. Thank you for coming back to the community regularly, contributing with your solutions and best practices, attending our events, and sharing your feedback with us. We had an amazing 2024, and we’re excited to learn, grow, and share all things Ataccama with you in 2025. If you’d like to take a look back at our journey last year, check out our recap here👇 This year, we’ve got an exciting lineup of initiatives, including product release posts and webinars to showcase our latest updates, exclusive interviews with our product team to give you a voice in shaping our platform, new events and user groups, exclusive perks through our recognition program, and much more! 🔑 We’d love to hear from you! What are your goals for 2025, and how can we help you achieve them? Whether you are in the beginning of your Ataccama journey and need a examples or trying out a new use case that involves a new feature, let us know. �

00
Cansu
Community Manager
12 hours ago
Cansu
Community Manager
CansuCommunity Manager
published in News & Announcements 📣
📚How can we help you? Best practices, use cases, tips & tricks

Hi everyone 🙋‍♀️A couple months ago we published our first Community Feedback Survey and we had an overwhelming number of responses from all our community members so thank you so much for taking the time to contribute and share your suggestions with us.If you’d like to share your thoughts, you can still participate in the survey here. One of the repeated ask was on having more Best Practice posts and Use Case articles on the community - and we would like to make this happen ✒️This is also your sign🎇 to share that good practice you had implemented lately, or a tip you think our wider community can benefit from. Please share in the comments ideas for topics, use cases (how are you planning to use Ataccama, or a certain feature - what is the challenge you are facing), any examples or tips you are looking for 👇 Thank you ✨

556
Joeri
Data Pioneer
14 hours ago
H
Data Voyager
HMJohnData Voyager
asked in Master Data Management & Reference Data Management 🛰️
File iterator task fails when workflow deployed to server

I have a workflow with a file iterator step. It runs without any issues in the IDE on my local machine, but whenever I deploy it my company’s RDM server, I get the following error:2025-01-07 09:05:31 INFO: starting...2025-01-07 09:05:31 ERROR: Problem during initialization of iterator valuejava.io.IOException: An unexpected network error occurred    at java.io.WinNTFileSystem.canonicalize0(Native Method)    at java.io.WinNTFileSystem.canonicalize(Unknown Source)    at java.io.File.getCanonicalPath(Unknown Source)    at com.ataccama.dqc.resources.local.FileResource.getCanonicalPath(FileResource.java:40)    at com.ataccama.dqc.resources.impl.DelegatingResourceBase.getCanonicalPath(DelegatingResourceBase.java:41)    at com.ataccama.adt.task.iterators.FileIterator$FileIteratorInstance.iterate(FileIterator.java:133)    at com.ataccama.adt.task.iterators.TaskIteratorInstance.initAndIterate(TaskIteratorInstance.java:36)    at com.ataccama.adt.task.exec.EwfForEachTaskInstance.run(EwfForEachTas

173
A
Ataccamer
4 days ago
M
Data Pioneer
mahesh ArData Pioneer
asked in Data Quality & Catalog ⚙️
Ataccama and workday integration

By using one url we imported multiple  tables structure from workday into Ataccama. if we need to query any specific imported table in ataccama  is ataccam will dynamically updates the API endpoints ? 

613
Cansu
Community Manager
4 days ago
E
Data Enthusiast
evan.sasowskyData Enthusiast
asked in Data Quality & Catalog ⚙️
Date Field Format Data Quality Check

Hey y’all, I was wondering if anyone had a quality rule or advice on how to construct a quality rule to check a date type field for formatting. I know there is the “matches” function for strings and that you can convert a date field to a string using “toString”, but that requires you to specify a format, which invalidates the point of the rule.The desired format is “MM-dd-yyyy”, as shown in what I’ve got so far.matches("^\d{4}-(0[1-9]|1[0-2])-(0[1-9]|[12][0-9]|3[01])$",toString(ATTRIBUTE_1, "MM-dd-yyyy"))

393
E
Data Enthusiast
10 days ago
GastonQ
Data Voyager
GastonQData Voyager
asked in Data Quality & Catalog ⚙️
How to create a metric with decimal places in Data Story?

Hi, I’m working with data stories, and I’ve created a custom metric to represent by using percentage format.This is the metric expression:iff(sum("Valid") + sum("Invalid") > 0, round(sum("Valid") * 100/ (sum("Valid") + sum("Invalid")), 2) / 100, 0)Both “Valid” and “Invalid” are defined in Snowflake as REAL datatype.I’ve read this article Create Custom Attributes :: Ataccama ONE and I’m using round function, but it doesn’t work.Thanks in advance,Gaston 

141
GastonQ
Data Voyager
11 days ago
P
Data Pioneer L2
pdanpoonkijData Pioneer L2
asked in Data Quality & Catalog ⚙️
Retrive KeyCloak user information using Ataccama One plan

Hello community, I need to retrieve KeyCloak user information (e.g., email address) based on their username using Ataccama One Desktop. Has anyone done this before? If so, can you please share your experience or point me to some documentation?Thank you in advance for your help!

603
Joeri
Data Pioneer
11 days ago
R
Data Voyager
RAZORXData Voyager
asked in Data Quality & Catalog ⚙️
Custom Entity Occurence

Hi Community,I have created a custom entity with parent type as Term as “Class”. Now when i linked it to the catalog items and attributes using Reference Array writer its showing in my Custom Class section in the attributes as well as in the Catalog Item. But unfortunately i am not able to see it in the occurrence tab of this Custom Entity. Is there any way to add some properties in the Occurrence tab so that i can see the link for custom reference arrays. Any help is highly appreciated. 

274
S
Space Explorer
13 days ago
JTH
Data Pioneer
JTH
asked in Data Quality & Catalog ⚙️
Missing input attributes for DQ rule

Hi,In one of my Monitoring Projects I am apparently missing input attributes for a DQ rules which doesn't appear anymore in my MP. The error, however, is still there. How can I get rid of this?  

130
JTH
Data Pioneer
13 days ago
Cansu
Community Manager
CansuCommunity Manager
published in Ataccama Community News 🗞️
Ataccama Community 2024 wrap-up: Year in review 💫

Hi everyone 👋 A BIG thank you to each and every one of you for being a part of Ataccama’s Community in 2024. As we welcome another year, we'd like to take a moment to reflect on the past year and share some of our highlights ⭐️ 🚀 Releases, ideas, interviews and betas of 2024In 2024, we brought numerous releases and updates with ONE AI, data transformation and remediation plans, task management in MDM, DQ Snowflake Native App, data slicing and hiding were among the most popular ones amongst our members.While our ONE AI news got the most views, we have multiple posts under our Product Updates forum if you need a recap feel free to give it a visit or subscribe🔔 to find out the latest in our product and example use cases. 🤫We might have some news coming up - very soon. We also brought back our ideas and User Lab forums where you can share your feedback, suggestions and participate in building Ataccama together with us. We had many great ideas amongst a number of them were launched:And

600
Cansu
Community Manager
13 days ago
R
Data Voyager
RAZORXData Voyager
asked in Data Quality & Catalog ⚙️
Updating Terms and Terms Relationships from One Desktop in Bulk

Hi Team,Is there a way to update the existing Term name or description or any property like termInstance from One Desktop metadata writer? I can only see option to add or delete but no update option. Any idea is highly appreciated.

182
R
Data Voyager
14 days ago
OGordon100
Ataccamer
OGordon100Ataccamer
published in Master Data Management & Reference Data Management 🛰️
📚 Guide: How to run GraphQL requests - Part II Working with MMM

Hi everyone! I’m back with the second and last part of the GraphQL best practice series. First part was all about authentication types & which one you should use and how to authenticate GraphQL requests. This post will focus on how to work with MMM in GraphQL - so let’s get into it.If you’d like to check out the first part I’m sharing it here 👇 ONE Metadata Readers Or GraphQL? MMM is the name for the linked list that holds all metadata and the connections between them. Pretty much everything in MMM can be explored via GraphQL - as GraphQL is what happens behind the scenes in most steps/actions in ONE Desktop.As far as ONE Desktop is concerned, while ONE Metadata Readers are often all you need, highly nested queries and associated joins can become quite tricky to handle via ONE Desktop plans, and can sometimes be simpler to build by just running a specific GraphQL query. In addition to that, some things, such as raw profiling information can only be extracted via GraphQL. Exploring

90
OGordon100
Ataccamer
14 days ago
G
Universe Traveller
GloriaUniverse Traveller
asked in Data Quality & Catalog ⚙️
Folder Directory for Cognos and SSRS Report

 Can the list of reports be arranged on a folder basis. For example, from the image below, my preference would be to have a folder called ‘Cognos-UAT’ with a sub-folder ‘Users Common Folder’ containing all the reports. The current view lists out all the report and specifies the location. 

162
G
Universe Traveller
15 days ago
R
Data Voyager
RAZORXData Voyager
asked in Data Quality & Catalog ⚙️
Assigning Business Terms To Custom Folders

Hi Team,I am trying to add my Business Terms in two separate child folders inside my Business Term Folder(Not Data Domains). Just wanted to know if its possible or not?I have created two child folders inside from navigation in settingsBusiness Glossary→ Terms →  Business Terms → Folder1Business Glossary→ Terms →  Business Terms → Folder2But unfortunately i am not sure how to add Business Terms in those two folders specifically, the normal Business Terms are added directly in the parent folders. Do i need to do some changes in the metadata model for this one or need to create any AQL filter for this folders(Same as Datadomains). Any tips or help is highly appreciated.

356
Albert de Ruiter
Star Blazer L2
17 days ago
Phil Holbrook
Ataccamer
Phil HolbrookAtaccamer
published in Data Quality & Catalog ⚙️
Building a nested GraphQL API call in ONE Desktop

ONE Desktop provides two ways to access the ONE platform data. Usually, it is easiest to use the Metadata Reader step, but sometimes you need a more complex query, or perhaps you are developing a Json API call to be used from another application entirely.  In this case, you will want to start from a Json Call step.The plan I will describe is this: I’ve used a random record generator to “inject” a single row into the data flow to get things started because the Json Call executes once for each row on its input.The “out” output from the Json Call carries all columns from the input; and can also be used to carry connection error messages. I’ve not set that up, so I just sent all that to Trash.I’ve named each of the remaining outputs using a sequential numbered prefix.  This manipulates the automatic alphanumeric sorting of the output connections so that the ordering is more logical than a list of element names would be. I’ve also set the layout of the step to horizontal so I can read the l

49610
Phil Holbrook
Ataccamer
17 days ago
B
Data Voyager
BhuviData Voyager
asked in Data Quality & Catalog ⚙️
Uniqueness DQ Evaluation rule

I am currently using 14.4.0.one-44751-landing-pa-230616-287787-f83b54a4 ONE web application version. While creating a Uniqueness Rule I am not getting WHEN condition as “is unique” and “is not unique” . Could someone help me understand why I am not getting the uniqueness condition  instead Validity condition.  

392
Cansu
Community Manager
18 days ago
OGordon100
Ataccamer
OGordon100Ataccamer
published in Data Quality & Catalog ⚙️
📚 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

510
OGordon100
Ataccamer
18 days ago
T
Data Voyager
ThanujaData Voyager
asked in Data Quality & Catalog ⚙️
One desktop trans comoponent issue

When I try to open a Trans component on Ataccama One Desktop, I receive the error 'Index -1078132736 out of bounds for length 10.' Do you have any ideas or suggestions to resolve this issue?

20
T
Data Voyager
25 days ago
A
Star Blazer L1
aish_TFStar Blazer L1
asked in Master Data Management & Reference Data Management 🛰️
New Full Load for an already loaded source data

I  have a full load already configured for a source system. This load component has 3 different entities(party, contact, address).I have used this to load data into mdm-hub as well.However, now we want to use a different source table for party entity and want to load only the records for party entity. I am planning on using a new full load with mappings only for the party entity. Will thiscreate new instance party records and make the old records inactive? bring any change to the records for contact and address entities? 

365
A
Star Blazer L1
28 days ago

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