Ataccama Community

Recent Posts
Answer Questions

Questions for Ataccama One Power BI connector

Hello community,I’m creating a Power BI source on Ataccama One and have a few queries:Is the built-in Power BI connection allow One to retrieve a Power BI datasets? Or this is strictly for only bringing the Power BI reports to One? The imported catalog items from this connection shows “0” number of attributes and “-” number of records (screenshots below). This is also presents in the the screenshot from the Ataccama support page (link). Is this behave as intended or am I missing anything here?Thank you in advance.Ben

2186

1 day ago

sjettawiData Voyager

Data Quality & Catalog ⚙️

Defintion/Decription Field for Business Terms

Is anyone able to provide guidance on how to make the businessDefintion a required field when creating new terms?

1 day ago

jdordregterData Voyager

Data Quality & Catalog ⚙️

Profiling Date or Datetime

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

1 day ago

GersonData Voyager

Data Quality & Catalog ⚙️

Why can’t I select multiple schemas under a single source with multiple connections in Data Observability?

I'm facing an issue with selecting schemas to observe for schema change detection in Observability for one of our sources(Sybase).Context:In our SQL database source setup, we have a single connection that includes multiple schemas, and Observability allows us to select multiple schemas without issue, as shown below.However, for the Sybase source, we're unable to select multiple schemas under a single connection. I only get the option to choose one connection and one schema from the dropdown. (See screenshot below.)Ideally, I’d like to select all dbo across all connections to monitor for structural changes.Question:Has anyone experienced a similar limitation?Is there a recommended approach for configuring Observability for schema checks on sources that have multiple connections and schemas under a single source — especially in cases like a Sybase database, where multiple connections are used?Any guidance or best practices would be greatly appreciated.

1 day ago

bobparryData Voyager

Data Quality & Catalog ⚙️

Best Practices for Data Quality Rules based on joins

Hello!Wondering if anyone has experience with creating data quality rules for values in joined tables.For example, we have 2 tables (Table A and B), related to each other through a shared attribute. I want a data quality rule where the value of a column in table A must be lower than the value of a column in Table B. My only idea for this is to create a SQL catalog item joining the two tables, and creating a dq rule on the SQL catalog item. This works, but has flaws, I can’t have this data quality rule contribute to the overall data quality of Table A, nor will users who find this table in the catalog know of all the identified data quality issues. Does anyone have a better way of doing this, or is there a built-in tool I’m not familiar with that anyone has used?Thanks!

121

1 day ago

akshayl09Data Pioneer

Data Quality & Catalog ⚙️

DQ Rule for missing values

I want to find out missing values in the columns. Use case, column called colors which has values as [‘ORANGE’,’BLACK’,’BLUE’] and rule is if RED is not part of column values, then Rule should fail and alert that RED color is missing in table.

122

2 days ago

Hanish NData Voyager

Data Quality & Catalog ⚙️

Rule instance details via API

Can we get the metadata of one rule instance. I have been using below query. It is giving all the dq checks. I want to pass only one DQ check ID and get the results. query{ ruleInstances(versionSelector: {draftVersion: true}){ edges { node { gid draftVersion { name displayName, target { gid } } } } } } Can anyone help me on this?

111

2 days ago

srija piratlaAtaccamer

Data Quality & Catalog ⚙️

How to use Dynamic Expression Assigner?

Hi I'm Srija, Solutions Consultant here at Ataccama.In this post, I’ll walk you through how to use a dynamic expression assigner. What is a dynamic expression assigner?The Dynamic Expression Assigner in Ataccama allows you to define dynamic expressions or rules to determine how values are extracted or assigned to specific attributes based on conditions present in your data. Use Case:The Monitoring project results will give the attributes , Invalid DQ rules and Invalid DQ Attributes for the failed rows. If we need to extract the DQ Error Attribute Value based on the Invalid DQ Attribute then Dynamic Expression Assigner can be used in the post processing plan.In the below example, I have a DQ_Error_Attribute which is causing the issue for that record. If I need to extract the respective value of the DQ_Error_Attribute then, I can use the Dynamic Expression Assigner. We can achieve this using a column assigner, but we must hardcode the attributes to extract the value. If any new attribute

1363

3 days ago

CansuCommunity Manager

Getting Started with the Community 👋

Introduce Yourself & Meet the Community 👋

Welcome to the Data People Community 👋 We are very glad you’re here. This is a great space for you to introduce yourself to your fellow community members and offer up a fun fact (or three). Let me start!I’m Cansu, I’m a Community Manager at Ataccama. You’ll see me here a lot; managing the forums, chatting, and generally helping out. A little more about me: I’m based in the City of a Hundred Spires ️🗺️ I have two black cats named Goblin & Monkey🐈‍⬛ I am an amateur surfer ‍🏄‍♀️ Please don’t hesitate to share details about what you're looking to achieve with Ataccama, and what you hope to get from your experience in the Data People Community. See you in the forums 👀

42039

3 days ago

JTHData Pioneer

Data Quality & Catalog ⚙️

Export output location (Monitoring Project)

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.

153

3 days ago

sjettawiData Voyager

Data Quality & Catalog ⚙️

Defintion/Decription Field for Business Terms

Is anyone able to provide guidance on how to make the businessDefintion a required field when creating new terms?

1 day ago

jdordregterData Voyager

Data Quality & Catalog ⚙️

Profiling Date or Datetime

1 day ago

GersonData Voyager

Data Quality & Catalog ⚙️

Why can’t I select multiple schemas under a single source with multiple connections in Data Observability?

1 day ago

bobparryData Voyager

Data Quality & Catalog ⚙️

Best Practices for Data Quality Rules based on joins

121

1 day ago

akshayl09Data Pioneer

Data Quality & Catalog ⚙️

DQ Rule for missing values

122

2 days ago

Hanish NData Voyager

Data Quality & Catalog ⚙️

Rule instance details via API

111

2 days ago

JTHData Pioneer

Data Quality & Catalog ⚙️

Export output location (Monitoring Project)

153

3 days ago

Hanish NData Voyager

Data Quality & Catalog ⚙️

Can we change the catalog name in MP?

Is there any way to give some logical name to the catalog item which is added in Monitoring Project. Actual catalog name and the catalog instance name present in MP should be different. Is that possible?

4 days ago

akshayl09Data Pioneer

Data Quality & Catalog ⚙️

Validate exact two digit after decimal point

There is column called Sales Amount (Long Data type). It has values in decimal point. I wanted to create a DQ evaluation rule that It should have exact two places decimal point. I tried to create rule by converting long to string and validated length after decimal point as 2 but failed for values 1.00 or 2.10 or 0.00 as conversion to string change value from 0.00 to 0, 1.00 to 1 or 2.10 to 2.1 Is there any way to implement this?

458

4 days ago

Delbert71Universe Traveller

Data Quality & Catalog ⚙️

Profiling comma separated file in webui

Hi, This file is comma separated with header and “ text qualifiers and keeps failing as below with a long line error. The data is from an MSAccess table with specific column widths not the default 255 in length. I have tried a number of times to no avail.Any assistance would be most welcome.2025-04-10 16:27:04 [INFO] com.ataccama.lib.securityutil.javaencryption.DefaultEncryptionEngine messageId=createDefaultKeyProvider reason=the 'properties.encryption.keystore' property not specified2025-04-10 16:27:04 [INFO] com.ataccama.lib.securityutil.javaencryption.DefaultEncryptionEngine messageId=createDefaultKeyProvider reason=the 'internal.encryption.keystore' property not specified10.04.2025 16:27:04 [INFO] Using following licenses:10.04.2025 16:27:04 [INFO] /data/ataccama/one/dpe/license_axaUK_PROD-dpe-bde_v14_subscription_updated.plf10.04.2025 16:27:05 [INFO] running job 2f1568e2-0000-7000-0000-00000026b0c8 (14-CRESTDSS POLICY AND POPULATION.txt)10.04.2025 16:27:05 [DEB

123

4 days ago

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