Discuss data, share best practices, learn, and grow with Ataccama's Community.
Recently active
How can we retrieve or read the workflow status (running, success, or failed. Etc) using a GET API after triggering the workflow via an Http service?
Hi Ataccama Community,Β IsΒ the data freshness feature is supported for data bricks database now?Β In the documentation it saysΒ Snowflake, PostgreSQL, BiqQuery, and Oracle are supported. I am using Ataccama version 15.4Β
Hello,Is this possible now in latest version? I am using 15.4.0. Requirement is to schedule profiling of specific schema in the database. Or subset of that schema if schema is too big (set of tables).Thanks in advance.
Hello,Β I wantedΒ to know that how do we implement matching options in the master layer of the MDMΒ project.I have used in the columns in the instance layer and then used the sameΒ in the master layer in the matching step just as used in the cdi example. and then I have used the same name in the matching step but still Β nothing is Β showing the UI part. Can someone help me with that.
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. Following posts described an implementation for multilingualism and how to apply computed content. Especially the last one was rather tough to digest, so for my last post about the glossary I promise a soft landing.I think one thing needs some further attention and that regards synonyms.Defining a synonym for a term is existing functionality: you can define a synonym by pointing to another term.This means though that when you want to define a synonym for a term, you would have to define a new term first. For that term you would also have to define its metadata. In fact the new term including metadata would be redundant with the original term. Or would you leave out the additional metadata?We chose to use a different approach: for a synonym only its name is relevant, as the other metadata would be the same. So
Hello,I have two questions I would love to inquire about:1. Exporting Lookup Items in AtaccamaI would like to know if it's possible to configure exports for lookup items in Ataccama.When I try to export my lookup items, the export option is greyed out. When I hover over it, I see a message saying: "No export plan exists for the selected lookup items."Under Global Settings > Import and Export, I see an option to create a new export plan. I tried using this, but got to a stage where I need to input a code for the export plan. I found the following JSON online and was wondering if this would work as-is or if it needs any tweaks:{ "name": "Export_All_Lookup_Items", "description": "Exports all lookup items for backup or migration", "type": "LOOKUP_ITEM", "format": "JSON", "filters": { "lookupTypes": ["ALL"], "tags": [], "projects": [] }, "output": { "combineIntoSingleFile": true, "fileName": "lookup_export.json", "includeMetadata": true }}Would this JSON-based e
Hello,I am new to DQ and Ataccama. Our code is in development environment and soon to be deployed in Test/UAT for UAT testing and later to Prod once we get UAT signoff.My question is what is the way to export DQ monitoring project and its related components (like rules, etc) from Dev environment to UAT/Test environment? Is there anyΒ export capability? I have also heard that we may need to recreate it again in UAT environment.Β Really appreciate anyΒ direction in this.Thanks in advance.
Hi!I am profiling tables and am looking at the profiles. I noticed that for date and datetime the profile does not show the MIN orΒ MAX values. That is something I had expected though. Working on the data quality of this data, I really would like to know the MIN and MAX values for these attributes. Is there a way to change the configuration and include these profile statistics for these datatypes?Β kind regards, Jur DΓΆrdregter
Hello everyone,My organization will soon be upgrading to a higher version of Ataccama, and I want to make sure the transition goes as smoothly as possible.Β I'm reaching out to ask:What should I be documenting or looking out for before, during, and after the upgrade?Some specific things I'm wondering: Are there key areas (like DQ rules, workflows, configurations, etc.) that I should definitely back up or document? What kind of testing should I plan for in UAT? Should I be validating things both before and after the upgrade? Are there any common issues or changes I should be aware of that might affect how things work in the new version? If anyone has experience with a recent version upgrade, Iβd love to hear what worked well for youβor what you wish you had done differently!Also, if there are any official resources or checklists from Ataccama that you found useful, feel free to share.Thanks in advance!
Is there any mutation to create terms in Ataccama web using API.
Are you looking to connect toΒ SAP HANA using jdbc driver? Here are the simple stepsΒ Download and copy SAP HANA jdbc driver file into /opt/ataccama/one/dpe/lib/jdbc/ folder Add a set of properties for SAP HANA driver in /opt/ataccama/one/dpe/etc/application.properties.( Check the attached document for properties) Restart DPE & Β check logs of DPE service for any errors Go to ONE Web UI and new driver βSAP HANAβ is available under connections βSelect Connection type βdrop-down menu Β
on v15.4, can we customize the snowflake table overview page after cataloging, to show or hide certain properties? I donβt see edit page option in top right 3 dot.Β Β I do see the βedit page templateβ option for MDM data, but not for snowflake tables.Β is this intended product feature?Β Thanks.Β
Ataccama One Web:How to handle large dataset with 1 B rows in the data set while working on data profiling & Data quality evaluation? (Best Practices) What is expected Infrastructure configuration required with respect to infrastructure in case such huge datasets?
07.05.2025 16:24:30 [INFO] Β Β Using Ataccama DQC configuration file D:\ataccama\workspace1\General MDM project - CDI example\Files\engine\trans\address\address_match.comp07.05.2025 16:24:30 [INFO] Β Β Using runtime configuration file C:\Users\AS001086183\AppData\Local\Temp\runtimeCfg31836356917877677.tmp07.05.2025 16:24:30 [INFO] Β Β Ataccama DQC engine initialized.07.05.2025 16:24:30 [INFO] Β Β Creating runtime...07.05.2025 16:24:31 [INFO] Β Β [Address deduplication] parallel processing of partitions: false07.05.2025 16:24:31 [INFO] Β Β [Address deduplication] parallel processing of key rules: false07.05.2025 16:24:31 [INFO] Β Β [Address deduplication] parallel processing of matching rules: false07.05.2025 16:24:31 [INFO] Β Β Starting runtime...07.05.2025 16:24:31 [INFO] Β Β Running runtime...07.05.2025 16:24:31 [FATAL] Β Β Internal error occurred during run of the plan: Persistence is not set (the standalone mode may not be configured)[STEP Address deduplication[Md Unify]]07.05.2025 16:
In Ataccama One web we can downloadΒ Canada.lkp but on Ataccama Desktop we could not find this file (searched on drive C: as well).Where are these lookup tables stored?How to get a complete list of all of them?Thanks!
Heard about Ataccama x Snowflake pushdown and wondering how to leverage it?Youβre in the right place. In this guide, weβll walk through what Snowflake pushdown is, why it matters, and how to get started with it using Ataccama.What is Snowflake pushdown?Run processing directly in Snowflake by enabling pushdown. Pushdown allows Ataccama to offload data processing tasks directly to Snowflakeβright where your data lives. That means faster performance, better security, and less infrastructure overhead.Why use pushdown processing?Enabling pushdown unlocks multiple benefits:π Performance: Evaluate millions of records in seconds. No need to pull large datasets into external servers for processing. π Security: Processing is executed inside Snowflake. Results (and invalid samples, if configured) are returnedβno external data transfers required, all processes run on secured and governed Snowflake warehouses. π₯οΈ Infrastructure: Leverage your existing Snowflake environmentβno need to set up or m
Hi,ONE Web > Monitoring ProjectI have a MP A which contains 7 CIs, I want to copy this MP to create MP B. For MP B I only want to use 6 out of the 7 CIs as the last CI is unnecessary. I use the import configuration (great qol btw) and for the 7th CI I use same CI.After the import configuration has been completed I delete the 7th CI from the MP. Inside the Report tab I still see that same CI appear which is not ideal. You'd think clicking the three dots besides it lets me Delete it from the page, but to my surprise that option is greyed out. How do I get rid of this CI from the Report page?βββ
Hi everyone πBy default, Keycloak admin access is limited to a single account with fixed credentials provided by Ataccama. But just as we recommend using SSO for logging into the Ataccama platform, itβs also best practice for Keycloak administrators to log in the same wayβfor better security, auditability, and ease of access.Β Hereβs a quick guide to help you set up and enable SSO login for Keycloak admins πΒ 1οΈβ£ Set up admin access in KeycloakFirst, log in to your Keycloak instance using the default admin credentials at:<your_env>/authOnce logged in:Switch to the ataccamaone realm Go to the Realm Roles tab Decide whether to use an existing role (e.g., admin) or create a new one (e.g., Keycloak_Admin) based on your security requirements2οΈβ£ Assign the right permissionsOpen the role you've selected or created:Navigate to the Associated Roles tab and click Assign Role Under Filter by, select ClientsNow assign the appropriate permissions. At a minimum, these should include:manage-acc
Can weΒ fetch Rule and Catalog item metadata from a monitoring project usingΒ Graphql API ? If yes, can you share the Graphql query ? I could not find it on ONE API Documentation
Is anyone able to provide guidance on how to make the businessDefintion a required field when creating new terms?Β
Hi,In ONE Web Monitoring Project there's an export tab with an export funcationality build within ONE Desktop. In ONE Desktop there's an output location.Might be an easy question, but how can I select an output location for the invalid records in this case to be send to a location inside my file directory? So basically what I want is the .csv/.xlsx file that come from invalidRecords to be sent automatically to a file directory folder I created. I understand the file can be downloaded from the Ataccama ONE Web export tab, but our customers have no use for this as the downloaded file will be downloaded in a file directory outside their working environment. Automatically moving the export invalid records to a file directory which they can access is a better solution in this case.
Can we add reference data in case statement in Computed content?
Hi,I want to create DQ rule to check data within same column. For example, from below table, I want to check if Value of Category B is >= Value of Category D.How can I do this in the Ataccama One UI?Β ThanksCategory Value A 5 B 2 C 6 D 4
Hi everyone,Β Β We're excited to share highlights from our very first Community Spotlight event, where we heard directly from β@Albert de Ruiter, Lead Data Management at Stater, the largest mortgage service provider in the Netherlands.Albert took us on a deep dive into how his team tackled glossary customization in Ataccama ONE to better reflect their business logic and metadata needs. With over 25 years of experience in data, Albert brought both expertise and practical insights to the session.Β π‘ Here are some key takeaways: Why customize the glossary? Stater needed different metadata for catalog items and their attributesβcustomizing allowed them to reflect these distinctions clearly. Custom term types: They introduced entity terms, attribute terms, and business terms to better align with their logical data model. Reusability with relationships: Using relationship types ("roles"), they elegantly modeled attributes that appear in multiple entitiesβlike keys, foreign keys, and descri
We need to extract the Rule and other Metadata from Monitoring project. Below is the set of Metadata Information that is requiredDQ Rule UIDΒ - Ataccama system generated unique identifier of Data Quality rule Name of DQ Rule Definition of DQ Rule Threshold DQ Dimension DQR Owner DQ Rule Start DateΒ DQ Rule End Date DQ Rule CreationΒ Date DQ Rule Modified Date
Already have an account? Login
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.