Learn & Share

Discuss data, share best practices, learn, and grow with Ataccama's Community.

70 Topics

SathyaAtaccamer

Adding New Property to Source in MMM ModelBest Practice

METADATA MODEL The metadata model is used to configure the application entities and their properties. The Metadata Model describes the entities and their properties in the application. Web Application) use the Metadata Model to create the frontend user interface. The metadata model is also responsible for the configuration of the left navigation menu of the application. ONE METADATA PROPERTY REFERENCESEntities consist of properties of Simple types, such as strings and integers, and Object types, which link the entity to other entities.ADDING NEW PROPERTY UNDER SOURCES TO THE MMM MODEL Go to left panel of the Webapp and choose Global settings Choose metadata model under Maintenance Center.Choose the Custom filed where you need to add the new property to CatalogItem, Glossary and sources. In our case we adding to Source.Click on the Custom field Source. We can see General Information and Property. Click add property and type in the property to be added.Fill in the name and c

170

4 days ago

aiwaliaRocket Pioneer

asked in Data Governance (DG)

Monitoring Project Export Rule Names

What does the id mention in invalid_rules column in Monitoring Project Export refer to?the alphanumeric term within() after rule name as in the image belowIs this the ruleId of the rule? If not, what does this refer to?Is there a way I can configure Metadata Export step to give rule id?

4 days ago

aiwaliaRocket Pioneer

asked in Data Quality (DQ)

Divide results from Invalid Rule column in Monitoring Project Report Export into multiple columns

The idea is to divide the invalid_rules column as obtained in export for Monitoring Project into two columns- one containing the rule name and the other containing the explanation; and implement this for all the rules mentioned in a cell.For example, The below cell would be divided into invalid_rule_name column containing two records-validation [USA] State and calidation[Noth America] Phone Numbers, and invalid_rule_explanation column containing explanation for the respective rules.The challenge I am facing here is that the rule ID mentioned in Monitoring Project report export is not the same as the rule ID mentioned in the list of rules I export; which I am trying to use to identify the rule in invalid_rules column from Monitoring Project report.Please help me find a solution for this

8 days ago

SathyaAtaccamer

published in Data Governance (DG)

SathyaAtaccamer

posted in Master Data Management (MDM)

Permissions Model Best Practices

MAJOR CONCEPTS IN PERMISSIONSKeycloak, which us primarily used to manage Users and Roles as well as their assignment. ONE web application, where it is possible to assign preconfigured permissions to Users and Roles. It is also possible to change the default configuration there and create custom permissions. Users (Persons) - identify people or services who have access to Ataccama ONE. Role - the container for permissions that users can perform in ONE on entities in alignment with company organization chart. Role refers to roles defined in Keycloak, for example MMM_ admin. Users need to be mapped to Roles, which will determine their node permissions based on the operations allowed for that role on individual nodes. More than one role can be assigned to a user. Users and roles are managed primarily in the Keycloak service, then synced with ONE. Users and Roles access can be regulated by permissions, that are configured via different blocks: Capabilities, Operation Sets, Operations. P

11 days ago

Marnix WisselaarRocket Pioneer

published in Data Governance (DG)

Catch OneWeb GraphQL in Chrome/Edge test and use

We are using some GraphQL to ‘do stuff’. Turns out the easiest way to find the GraphQL is using the Developer-tools in Chrome or Edge. See enclosed.

233

11 days ago

bazSpace Explorer II

asked in Master Data Management (MDM)

Displaying a list in a drop-down

Hi, How do I present a selection of values in a drop-down in the RDM create/edit screens.E.g. I have an entity called Door with a column called state that can have a value of either Open or Closed. Can this be presented as a drop down to a user?baz

12 days ago

anna.spakovaAtaccamer

published in Data Governance (DG)

Export metadata model into ExcelBest Practice

Hello everyone, Anna here! I work as a projects consultant in Ataccama and today I put together a guide for you on how to export a metadata model definition from Ataccama ONE.Ataccama ONE allows to export metadata model definition from the platform into a JSON file. However, the JSON file is not an ideal format for business users. For that reason, parsing of the JSON into more user-friendly format, for instance Excel, is desired. The current JSON parser step in Ataccama DQC, however, is not able to parse this JSON structure.This article introduces a Python script that was developed to parse the JSON structure of the metadata export and provide the metadata model in Excel and CSV formats. It is supported for v13 of Ataccama ONE.As a first step, the metadata model has to be exported from Ataccama. Next step is to run the Python script on top of the exported metadata model to obtain the CSV and Excel format. Chapter JSON parser in Python describes in detail the Python script as well as th

630

12 days ago

smunotSpace Explorer

asked in Data Quality (DQ)

MCQs in Certification

What kind of MCQs are asked in Certification exam?

13 days ago

sgillaRocket Pioneer

asked in Data Quality (DQ)

NULL Valued fields on DQS

How are NULL’s considered? I have a case statement which gives the right value matching measure -used debug to test. But when it comes to matching rules, it skips the rule. Example:Name NPIRamona 12345678NULL 12345678the 2nd row should match the 1st on NPI value and considering on of them is null.Even the scenarioName NPINULL 12345678NULL 12345678these two should match together based on NPI. I do not see a special character. If I replace NULL with a value ‘A’ , they match with rule Matching on NPI. but does not work for NULL. Any thoughts or suggestions appreciated.

15 days ago

JerinSpace Explorer

asked in Data Quality (DQ)

Results message not showing as message.

Hello, I’ve got a question while using DQ evaluation rules.I have been creating rules with valid and invalid messages but just the invalid message at the end does not display as intended. But when I view this in the results tab it just says OTHER as the explanation. Is there a workaround to this problem? Should I edit my rule logic to include some specific condition and leave the rest to fall under the ‘IF none of the conditions above apply THEN’ TIA for the replies.

15 days ago

alinAtaccamer

published in Data Quality (DQ)

Data Quality and Pipeline Execution

Hello, here is a short video to illustrate how an organization might use Ataccama Data Quality to run checks as part of an existing data pipeline, and verify data integrity before further processing. With Ataccama, you can use various data warehouses or ETL tools, and GraphQL API integration allows conditional scheduling and more complex orchestration.In this demonstration, we use DataBricks Notebook to trigger DQ execution and retrieve the results. These determine whether to halt or commence the pipeline, and in-app dashboards display the metrics. All results and metadata can also be exported to a data mart table for further analysis and visualization.The platform is designed to provide visible and usable data quality insights, and we offer flexible integration capabilities to suit any data stack. Thanks for watching.

300

15 days ago

SathyaAtaccamer

published in Data Governance (DG)

Adding a New Entity in MMM ModelBest Practice

METADATA MODELThe metadata model is used to configure the application entities and their properties. The Metadata Model describes the entities and their properties in the application. Web Application) use the Metadata Model to create the frontend user interface. The metadata model is also responsible for the configuration of the left navigation menu of the application.ONE METADATA PROPERTY REFERENCESEntities consist of properties of Simple types, such as strings and integers, and Object types, which link the entity to other entities.ADDING NEW ENTITY TO MMM MODELIf you are creating an entity using the user interface, you must then add it as a property of the root entity metadata and then publishFor example, if we need to add a new entity under Business Glossary named (TestEntity) to the MMM modelClick on the Global settings on the left panelChoose Metadata Model under Maintenance CenterWe must create a new entity under Term so click on create entityFill in the name of the Entity, and

301

15 days ago

MacarenaSpace Explorer

asked in Master Data Management (MDM)

ONE Web connection to amazon Redshift

Is there a way to connect ataccama One Web to a private Redshift?

18 days ago

OjaswiniRocket Pioneer II

asked in Master Data Management (MDM)

RDM Images by value presenters not working

Hello, I’m trying to demo the RDM Banking Example. However, the flag images in the Country table are not showing properly (as shown in Picture1.png).I have fixed the source CSV file to point to an online website with corresponding flag images (shown below) and run its loading plan to update the data on RDM, but those images are still not showing on RDM. (as shown in Picture2.png)

18 days ago

EllieSpace Explorer II

asked in Data Quality (DQ)

Export profiling result

Hi Team, Is there anyway that we can export the result of profiling in ataccama? Thanks, Ellie

18 days ago

maneelloydsSpace Explorer

asked in Master Data Management (MDM)

Getting one browser error while connecting to oracle database

Hi All, We are getting the below error while adding an oracle database from add datasources in One web app. we give jdbc connection string, username and password(doesnt matter/validate if it is right password/username). Please check and let me know how can i troubleshoot/debug the issue. Some browser component is throwing the error. jdbc - format - jdbc:oracle:thin:@<jdbcHost>:1521:<jdbcDatabaseName> error when we try to connect the first time after a restart of one-tomcat servicejava.lang.RuntimeException: java.lang.ExceptionInInitializerError at com.ataccama.one.browser.database.AbstractDatabaseDatasourceClient.retrieveConnectionWithTimeout(AbstractDatabaseDatasourceClient.java:119) at com.ataccama.one.browser.database.AbstractDatabaseDatasourceClient.handleRequest(AbstractDatabaseDatasourceClient.java:353) at com.ataccama.one.browser.database.AbstractDatabaseDatasourceClient.<init>(AbstractDatabaseDatasourceClient.java:92) at com.ataccam

25 days ago

sgillaRocket Pioneer

asked in Data Quality (DQ)

subject_matching.online: Error message: Online configuration is not valid!

During bundle deployment I see this error. I have tried different combination ofUpdate to old bundle. Manually update the component again on the existing old bundle and upload Copying extended unification Updating OmnigenServer folders (bundle,cmd,dbms) with the backup. restarting services as needed.Any thoughts or suggestions? Thank you.

26 days ago

sgillaRocket Pioneer

asked in Data Quality (DQ)

DQC match - slow incremental load

The matching component is slow at the extended unifications step for a incremental load. When a record like ‘WALGREEN%’ is loaded and there are 20K records with similar name on the instance, the records are all considered through the process of matching. Hence the process is slow when processing the increment and even if the incremental load has 11 records to process 30K records have the transaction Id and omni_modified date updated with the work order related on the instance table. When I check history, nothing changes on these records except the omni_modified_date and transaction_id to that of the work order. Tweaking the union keys to create combination of name and key factors or adding separate groups for the high count records is not helping. Any thoughts or suggestions?

29 days ago

maneelloydsSpace Explorer

asked in Master Data Management (MDM)

Ataccama connection to https endpoint

Hi All, we have Ataccama version 12.8.0 version in our one web. Is there a connector available or how can we connect to a https url which points to a csv file? how do we configure https get method using security like oauth in Ataccama?

30 days ago

Lisa KovalskaiaAtaccamer

posted in Data Governance (DG)

How to organize assets in ONE web app: adding columns and filters in Business Glossary

Adding more details to a list view and providing additional filtering options can help business users in their daily tasks as you scale Data Governance across multiple teams, geographies, or business functions.In this article we’ll customize the Business Glossary to show additional term attributes as columns in the list view and to enable filtering by those attributes. This approach generally works across the Ataccama ONE Web app, so you can use this article as a guide to customize other pages, for example Rules, Catalog Items, or Monitoring Projects.You don’t have to be a developer to follow this guide. If you come across any concepts you’re not familiar with, have a look at our documentation. Adding columns First, navigate to the Business Glossary’s Terms list. In the top right, find the 3-dot menu which features the option to Edit page. In the side bar that opens up, go to the Layout tab. You’ll see the JSON that describes how the objects are shown on this page when the web app load

1 month ago

Maxim KimAtaccamer

posted in Data Quality (DQ)

Export Data Quality results

Eventually, you might need all your data quality results evaluated in One monitoring projects or within regular catalog items (via business terms and related DQ rules) exported to some reporting system or into excel. And it would be nice if it looked like this: TLDR; There are 2 components attached you can use to export DQ results, one for monitoring projects, another one for regular catalog items. Monitoring ProjectsThe idea is to read all monitoring projects metadata, join it with their check results as well as rules names, catalog item names and voilà, we can save it to excel/csv or to some database table.It sounds like something very simple, and indeed there is no black magic, but nonetheless component looks a bit more elaborated: Catalog Items DQ (based on Term evaluations)The idea is to find all catalog items that have aggregated overall data quality and join them with the DQ rules results:This component has a bit simpler implementation: Of course, the output of the components

1 month ago

cbre_jonathanSpace Explorer

asked in Data Governance (DG)

Customize Business Glossary Term View

Hi,I’m trying to modify our view of our business terms - currently we have a lot of information showing in the default view that our end users may not care about. What I really want to do is modify the view, so that it only shows Name, Abbreviation, Description and Synonym. I have figured out how to add the columns, but I can’t figure out how to remove unwanted columns. For reference here is the default screen layout in Ataccama One via the Debugging Tools. {"_type": "entity.page.listing","children": {"_type": "relationships.hierarchyListing","enableSelection": true,"columns": {"type": {"dataPath": [],"name": "Type","after": "name","renderer": {"_type": "glossary.termType.tableCell"}}}}}

1 month ago

Page 1 / 3

Learn & Share

70 Topics

Adding New Property to Source in MMM ModelBest Practice

Monitoring Project Export Rule Names

Divide results from Invalid Rule column in Monitoring Project Report Export into multiple columns

Adding New Property to Catalog Item in MMM ModelBest Practice

Simple maker-checker process (approval workflow)

How to increase the speed of profiling data for using Oracle DB?

Permissions Model Best Practices

Catch OneWeb GraphQL in Chrome/Edge test and use

Displaying a list in a drop-down

Export metadata model into ExcelBest Practice

MCQs in Certification

NULL Valued fields on DQS

Results message not showing as message.

Data Quality and Pipeline Execution

Adding a New Entity in MMM ModelBest Practice

ONE Web connection to amazon Redshift

RDM Images by value presenters not working

Export profiling result

Getting one browser error while connecting to oracle database

subject_matching.online: Error message: Online configuration is not valid!

DQC match - slow incremental load

Ataccama connection to https endpoint

How to organize assets in ONE web app: adding columns and filters in Business Glossary

Export Data Quality results

Customize Business Glossary Term View

Badge winners

Let's shape the future of Ataccama together

Learn & Share

Adding New Property to Source in MMM ModelBest Practice

Adding New Property to Catalog Item in MMM ModelBest Practice

Export metadata model into ExcelBest Practice

Adding a New Entity in MMM ModelBest Practice

Badge winners

Let's shape the future of Ataccama together

Sign up

Login to the community

Scanning file for viruses.

This file cannot be downloaded