Learn & Share

Dear Fellow Users,I have a certain issue using the Matching step in workflow editor.I composed a Matching Function, and assigned it to a data field as Matching Rule.Now I want to use the result of the Matching Rule further in the next steps as value.Please see the attachment for exact presentation of the case.First attachment demonstrates how the Matching step is structured - the details in question are highlighted in green frames.Second attachment demonstrates the function applied, and the result I want to take as value to be processed further. Any solution is keenly welcome.Thank you, Laszlo

Hi ​@anna.spakova,Would Ataccama provides REST APIs to read metadata of rules, catalog items and monitoring projects?We would like to use python API capabilities and read the metadata from API in the form of JSON. Please let us know if this is a possibility.

hi Team,I would like to understand a couple of things related to implementation of slices directly on catalog item v/s filtering out records in sql or virtual catalog items and then using these items in monitoring projects (MPs) I am adding a data slice on a data catalog item X having e.g., 300 millions of records in total, sliced subset is having records around 30-35 millions -Question: when I run the MP, will it first pull all 300 records and then filter out those 30 million records based on slice and then do the DQ evaluation? Also, In case I use SQL catalog item (SCI), I am already cutting down undesired records, so I’m directly applying DQ evaluation on 30 million records, will it be faster in this case than above scenario?In any case, Slice / SCI/ VCI - how are we calculating the overall quality of the data catalog item here? Are there any guidelines on calculation of DQ on the whole dataset using output/score from DQ of subset of data.

Hey Community!I would like to create an overview with One Desktop that provides me insight in which assets have been shared with which groups/persons with which type of access. I have been checking the metadata model, but cannot exactly locate the relevant entities that I could use for this purpose. Does anyone have an idea? Maybe only possible with GraphQL?Kind regards,Albert

Hi All,Does anyone have a best practice for creating mappings between related reference data?   We need to be able to relate various datasets used by different systems that have the same "entity" but the codes for that entity are different. Some examples:Entity:                     StateTable 1 Value for State:        NYTable 2 Value for State:        034Table 3 Value for State:        34Table 4 Value for State:        New York  Entity:                     AutoTable 1 Value for Auto:        AATable 2 Value for Auto:        AUTable 3 Value for Auto:        01Table 4 value for Auto:        Auto We need to be able to "map" these values within RDM, so we know that NY, 034, 34 and New York are all "State", and that AA, AU, 01 and Auto are all "Auto".  Additionally, these mappings may need to be hierarchical.  In Inform

I need some assistance creating a AQL query for finding a table within a database and schema. How would this be written? 

I have few monitoring projects in web but I would want to add them as components in workflows and run from desktop on schedule.Is it possible and if so what are the steps to do?  Are there any pre-requisites for this?Thanks in advance!

Hi,Via ONE Desktop I created an invalid records component file which can be extracted in the Monitoring Projects → Export tab. It is in regards to a Float attribute. However, when I download the .xlsx file and open to check the invalid records it shows blanks. While if I check the database I see values.How do I show Float attributes within the .xlsx file?

Our team has just started using reconciliation project in Ataccama ONE UI, just wanted to confirm if we can apply a DQ rule on reconciliation projects, you can take a requirement e.g. if source data is having Wed as a record in an attribute and target is having Wednesday as a record in an attribute with same name, it shouldn't be highlighted as a different record.

We have environment with 14.5 and now we have established totally new environment with new Ataccama 15.4. We want to migrate all the object from one environment to another without manually re-creation of objects.Is possible to use metadata database & Audit Database of 14.5 in 15.4 Environment with some upgrade process so that all the objects can be accessed in 15.4 without any issues?What are the steps to be taken for this?

I have two location tables with 2-letter codes and integer codes but need to keep them both.  Need to create a crosswalk table that maps the codes in both to a location name. Has anyone setup a crosswalk-type table with ONE RDM?

Below are Ataccama ONE Desktop shortcuts organized into categories by particular viewer or editor.A full list of keyboard shortcuts can be found and called by pressing Ctrl+Shift+L at any time.To edit shortcuts, go to Window > Preferences > General > Keys.Data Viewer SQL Editor Profile Viewer Plan Editor Search and Navigate Edit Layout Run Progress Viewer Online Service Editor Common ShortcutsData ViewerCtrl+F

As we have relation for catalog items, can we also have relations for attributes?What are the metadata model changes required for this? Appreciate the support 😊

Ataccama MDM presents particular challenges for multiple developers maintaining a solution together. There is no magic bullet to resolve this, but good working practices can minimise the risk of git conflicts and help resolve them when they occur.Your organization may have established working practices for branch management, naming conventions and so on. Compare these practices with the suggestions here when defining your team processes.This post assumes the reader is familiar both with MDM and with Git usage – there are many good resources available for Git in general and for Eclipse eGit as used in Ataccama ONE-Desktop; and Ataccama provides training for MDM. This post is long enough: I will not explain technical terms or procedures that should already be familiar or can be looked up elsewhere!What is the problem?MDM and RDM use a metadata-based configuration known as a Model Project. This consists of many

In Ataccama Monitoring projects, the email notifications currently provide summary details (e.g., number of failed rules, scores, etc.). Is it possible to customize the email notification content so that it also includes a snippet or sample set of failed records directly in the email body (instead of just attaching or linking to error tables)?If yes, what would be the recommended approach or configuration to achieve this in V15.4.1?

I have two BDE DPEs pointing to different Hadoop clusters. They have different cluster ids set in the configuration. In the DPM they both show up separately with their own configuration. In ONE Web I have a connection that uses DPE 1, which is working fine when only DPE 1 is connected. However, when both DPEs are connected I get the following error when I try to browse this connection:It seems to me that ONE Web can't seem to differentiate between the two DPEs. I have tried all kinds of different constraints in the application.properties files of both DPEs, but nothing has worked so far.Does anyone know if this is possible and if so, how I can get this done? Please let me know.

In One Web, with invalid sample records uploaded to ONE Data, we would like to filter data that failed on a particular DQ (Data Quality) rule and download it. However, at present, there is no way to download a filtered view.The system currently only allows us to download the entire table. This means that when we download the whole table, all the DQ rule filters are lost, and there is no way to figure out which rows failed on which DQ rule. This is quite problematic as we want to be able to download records that errored on a particular rule so we can send them to the appropriate team for corrections specific to that rule.Also, we often perform DQ evaluations on spreadsheets and setting up post processing or remediation plan on an excel sheet is not the most efficient approach. This is because each time there is a new version of the excel data, we would need to rebuild the whole plan again. Considering that the download functionality is already available, I believe addin

Hi ​@anna.spakova Is it possible to download the list of rules (maybe using metadata reader if not from UI)?Also, anything/any links related to functionality of Export List Of Items option could help here.Thanks! 

Hi I see we can configure PowerBI as data source in connections but want to know if it’s possible to use the BI report to be treated as catalog item to apply DQ checks and profile these.

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?

Introduction What is the Ataccama Admin Centre? Where is Ataccama Admin Centre? What are the serverConfig and runtimeConfig files? Where do I start? Where are these configuration files? Sample project structure What is inside the configuration files?

Hi,After moving internal mdm connection (mdc_db) from mdm.runtimeCfg to runtime/etc/application.properities there is no more chance to see this connection in console under “Database Connections” site and be able to track sql by turning on “SQL Monitoring”.This was handy to see, easy and fast, which SQLs were executed and could help as early warning, that some SQL a running slow. This was working in v13, but since v14, this is not possible anymore to my knowledge.Is there any way, how to monitor this internal MDM connection back in MDM console?Thank you

I have created new Email template and wants to use that template while send Project Result notification. Please guide how to link new email template instead of default template? Do I need to change any property?

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!

We are new to Ataccama’s RDM app and have a question regarding the retiring and archiving of reference data.  It appears that “Published” is that last state for reference data within the app. Any workflow statuses that we would create for custom workflow happens between “Edited” and “Published”, by design, so there does not seem to be the ability to create a “retired” state.Yes, we could use versioning and create a business date that could be used in querying/filtering the data, but that both adds unnecessary complexity AND the data still “shows” in the Published view mode. In terms of the application, we could also delete the data, but we have various user groups that do not delete data as best practice, and don’t want to go that route. What have others done to reflect “retired/archived” reference data?