Learn & Share

Hi,  is it possible to remove a specific run of the data observability? We had to rerun data observability today, but now we see a lot of anomalies because part of the data had remained the same between two runs. I want to trow away both runs and then rerun again to keep things clean. kind regards, Jur Dördregter

Can we connect Ataccama to Sharepoint xl file? if yes, how can I achieve this? I am new this forum and new to ataccama.

I have an Excel file that contains the SCI names, corresponding queries, folder name(workspace name), source connection name for each catalog item. I want to create a desktop plan which will help to generate the SCI though ONE Metadata writer or graphql query. Is there any possibilities to do that?

Hello,I want to integrate my Ataccama monitoring results with Teams notification.I checked the below link but Office 365 connectors within Teams are retiring, that's may be why I do not see Incoming webhook on my Teams. Is there any way to set up Teams with Atacamma using workflows instead?https://docs.ataccama.com/one/latest/notifications/ms-teams-integration.html#add-incoming-webhook-to-ms-teams-channel Please suggest.

Is it possible to create and assign DQ rules from one desktop without using/taking any rules from one Web. I also want to know if we could assign dimension information to rules in desktop.

The ProblemI need to connect to a Collibra API that has a tricky two-step login process: First, I get a temporary access token using a standard Client ID and Secret. Then, to actually get data, every API call must include two headers: the temporary token and a second, custom header called XFeedAuth that acts like a static password. The issue is that the standard Ataccama connectors (like the Collibra Reader or a generic server connection) don't seem to have a way to add that second, custom XFeedAuth header. My Plan & My Question My plan is to build the connection manually using two chained Json Call steps: the first step gets the token, and the second step uses that token and manually adds both the required headers.My question for you is: Does this sound like the right way to do it? Or is there a simpler, more built-in way in Ataccama to handle an API that requires both a bearer token and a second custom authentication header?

Is there a way to disable the “Create Task” option for Data Consumers (view only users)?  

 Can we restrict Admins to view sample data in Catalog or Invalid records in Monitoring Projects. 

Hi ​@anna.spakova My manager wanted to get a metric on how many rules each person created. Is it possible to take the metric from ONE Desktop Plan?

Is there a way to implement data slices or leverage other techniques on Salesforce tables to monitor only specific attributes, rather than profiling the entire table?Our Salesforce tables are quite large, and attempting to profile the full dataset is causing our on-prem DPM service to crash. We're looking for a more targeted approach to reduce the load and improve stability.Any guidance or best practices you can share would be greatly appreciated.

Hi I am using v15.4.0 on windows 11 cloud pc and trying to run a small metadata reader project from Advanced DQ training projects that come along with ataccama installation.I’m getting the warning -’Status Tracking Issue’ when tried running it with correct Ataccama Environment selected. The result of the plan are not rendered but the job status is shown as completed on Admin Server. What could be the issue here? Any resolution that you can think of pls advise?cc: ​@Ataccama Community Admin 

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.Really looking forward for your inputs here!

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 Informatica, these objects are called “crosswalks”, and they exist as base entities within the tool. We need to duplicate that type of behavior. If you’ve implemented this, or have

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 - Find - Opens Find dialog. Ctrl+L - Show Columns - Opens dialog where user selects which columns should be visible and which columns should be hidden. Ctrl+Home - Selects and reveals the top left cell. Ctrl+End - Selects and reveals the bottom right cell.SQL EditorCtrl+F - Find - Opens Find/Replace dialog if SQL query field has focus (from v8). Ctrl+Enter - Execute - Executes current query. Ctrl+R - Read Rest - Reads the rest of the query execution. Ctrl+B - Next Batch - Reads the next batch of the query execution. Esc - Stop - Stops the query execution.Profile View

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 xml files, and it is very easy for several developers to make model changes at