Skip to main content

Learn & Share

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

803 Topics
A
Data Pioneer
aiwaliaData Pioneer
asked in Data Quality & Governance ⚙️
Trying to connect a neo4j database to ONE Desktop

I need the jar files to create a neo4j database connection from ONE desktop.Can anyone please help?

411
M
Ataccamer
1 year ago
H
Data Voyager
Harshit_srivastavaData Voyager
asked in Master Data Management & Reference Data Management 🛰️
RDM Web application Role

I(Using admin creds) have assigned a user the role of “RDM-Work_DataEntry”  from Keycloak for being able to make an entry on RDM Web app. But he is not able to see any Table or View details on the web app, Can anyone help me with the mistake i might be committing. Which role should be assigned for the purpose of being able to add/remove/delete/edit entries on RDM tables on Web App/UI?Also, Where can i find the descriptions for all the roles that are available on the Keycloak to be assigned?

431
M
Ataccamer
1 year ago
R
Data Voyager
rene.requenesData Voyager
asked in Data Quality & Governance ⚙️
Ataccama ONE Desktop - SFTP wildcard

Hello,I want to use “SFTP Download File” and use a wildcard for the filename and a date.  Is that possible ?  For example :/<mydirectory>/input/MYFILE_<TODAY_YYMMDD>_*.txt When i enter an asterisk symbol in the  “File or Directory” section, I get an error. Thanks,Rene Requenes 

351
A
Ataccamer
1 year ago
A
Anonymous
published in Data Quality & Governance ⚙️
#3 Business TermsGet certified with Ataccama

Glossary terms are used to add more metadata to different assets in the Ataccama ONE, they are necessary for data quality evaluation of Catalog Items after profiling. 👉 Get Certified with Ataccama article series#1 Adding Data Sources#2 Add a Data Source to the Catalog 🔎 LET’S TEST YOUR SKILLSUsing the ONE Web App, in the ONE Business Glossary module, create business terms for '<your_name>_Blood Type', '<your_name>_Rhesus Status', '<your_name>_Blood Group'. Using the ONE Web App, in the ONE Business Glossary module, configure the business terms '<your_name>_Blood Type' and '<your_name>_Rhesus Status' as child terms of the parent term '<your_name>_Blood Group'.💡 How to do it? Navigate to Business Glossary in the left navigation menu and click on Create in the top right menuSelect Type - Business Term, fill in Name and SaveYou will see that your business term has been successfully created, repeat the same process for remaining business termsOnce you

3637
T
Data Voyager
1 year ago
shafeeqzaman
Ataccamer
shafeeqzamanAtaccamer
published in Data Quality & Governance ⚙️
How to preserve spaces in DQC plans and DPE monitoring projectsBest Practice

Hi there! Shafeeq from Ataccama here. I’m a Software Support Engineer and occasionally I come across issues that are shared among different customers. One of those issues is how one can get Ataccama tools to preserve spaces before and/or after certain strings. This might be when trying to perform certain operations using the Column Assigner in the IDE, or in a monitoring project running on the Web App where a DQ rule checks that a field does not have trailing spaces, etc.  The solution to this problem is simple, in the form of Java VM arguments. These  are typically values that change the behaviour of the Java Virtual Machine (JVM) which is used by our products. Below, I’ll share the solution.  When this issue arises for a plan, workflow, etc. in the IDE, you may follow the steps below:   Click on the arrow next to the run button and then click on "Run Configuration".   Click on the Runtimes tab and add the following parameter in the VM arguments text box:  -Dengine.trimStringValues=f

1200
shafeeqzaman
Ataccamer
1 year ago
B
Data Voyager
BenSData Voyager
asked in Master Data Management & Reference Data Management 🛰️
Rollback loading of configuration to DEV environment

I loaded a configuration with a new table to my organisations DEV PaaS environment and it dropped the existing tables in DEV. How do I rollback this transaction? Any help would be greatly appreciated

602
B
Data Voyager
1 year ago
P
Data Pioneer L2
pdanpoonkijData Pioneer L2
asked in Master Data Management & Reference Data Management 🛰️
Strange error during RDM publish with OnPublish

Hello community,I’m working on an RDM project which has the OnPublish implementation. However, I am encountering an error whenever I try to publish a record. The error message from the Action History states:The response message was:null and response error was 'errorMsg:Cannot get credentials for request.'I have checked all the database connections and the connection to the RDM web application on the runtime server, and there does not seem to be any issue in that regard.Is anyone familiar with this error and could provide assistance? Thank you in advance.

432
P
Data Pioneer L2
1 year ago
O
Star Blazer L1
OjaswiniStar Blazer L1
posted in Data Quality & Governance ⚙️
Does anyone have any document for How to read/ use OperSearch Discovery portal.

Can anyone provide a document or link on how to effectively navigate and interpret the logs in the OperSearch Discovery portal? Our client is using Ataccama PAAS. And sometimes we go to OperSearch Discovery for logs. I find challenging to understand. For instance, to locate runtime errors, I need to input "Kubernetes.container_name = runtime-server" in the filter section, followed by "error" in the search section. This will display any errors related to the runtime server. Otherwise, the log page appears to be quite intricate. Any help or link is very much appreciated.

440
O
Star Blazer L1
1 year ago
C
Data Voyager
chetan2784Data Voyager
asked in Master Data Management & Reference Data Management 🛰️
Atacamma APIs for RDM

Hi All,I am looking for the documentation around available Out of the box APIs in Ataccama which can be exposed to extract data out of RDM tables. Are there any available documentation or APIs provided by Ataccama to expose the reference data tables out of RDM via APIs.Looking forward for any directions here.Thanks,Chetan

3973
A
Ataccamer
1 year ago
G
Data Voyager
GregersData Voyager
asked in Data Quality & Governance ⚙️
"Null" value in Business rules

HiI’m Using the Windows DQ Analyzer - free version.I have used the business rules functionality, but I have been wondering what the idea behind the “null” value is? And what makes data fall into the “null” value?Br.Gregers

811
anna.spakova
Ataccamer
1 year ago
P
Data Voyager
Pattern GroupsData Voyager
asked in Data Quality & Governance ⚙️
CatalogItem Term Suggestion Metareader

Which ONE Metadata Reader entity type will let me read the all suggested business terms against all items?   

1168
anna.spakova
Ataccamer
1 year ago
B
Data Voyager
bazData Voyager
asked in Master Data Management & Reference Data Management 🛰️
RDM restricting publish rights based on the current user

Hi,   Is it possible to stop someone Publishing a row if they are the ones who “Moved it to Publish”? A team want the ability for all its members to create, edit and publish but restrict an individual team member from publishing a row they create or edit. Those rows would need to be published by another team member.  

523
A
Ataccamer
1 year ago
M_Fabianova
Ataccamer
M_FabianovaAtaccamer
published in Master Data Management & Reference Data Management 🛰️
How to resolve ONE Desktop error “The model project is not licensed for use on this machine”Best Practice

When you use in ONE Desktop application the project synchronization with Git, you can in some cases meet with the error “The model project is not licensed for use on this machine”, followed by warning “Project signature is invalid”.At first glance, it seems there must be an issue with the license. However, mostly it is not the case, and the issue is related to Windows line endings, as Eclipse utilizes Unix syntax line endings.How to resolve this?Follow the steps below:In ONE Desktop select your project name (as an example further we use the project Reference Data Manager - Banking example), and click in the top menu panel to choose:File => Convert Line Delimiters To => Unix.   Uncheck Show only text files option and click Deselect All.   Open .metadata folder in the "Select files to convert" menu, select meta.mmd and manifest.xml files.   Click on the small arrow next to the .metadata folder to display contents, and click on the checkbox beside the libs folder to select all

3390
M_Fabianova
Ataccamer
1 year ago
C
Data Voyager
ckaushikData Voyager
asked in Data Quality & Governance ⚙️
Temp Data Files Purging in Ataccama

DPM and DPE - Ataccama ONE Gen2 Platform LatestOnce DPE connects to a data source, it creates metadata and optional sampling of records that do not satisfy DQ rules.Could you please answer the following questions or direct me to a link that can answer the below questions?1. Does DPE create other temporary files as a result of processing as well?2. What happens to the metadata, sample records that do not satisfy DQ rules and any temporary files generated during processing after the connection to the data source get closed?3. How does purging of data works in Ataccama?

1131
anna.spakova
Ataccamer
1 year ago
P
Data Pioneer L2
pdanpoonkijData Pioneer L2
asked in Master Data Management & Reference Data Management 🛰️
RDM Incremental load to CONFIRM state

Hello, communityI want to implement an RDM solution where we periodically load the data from a database and import them to RDM in the published state. Each load could contain new and updated records.So I set the RDM Importer step to load data to CONFIRM state in the INCREMENTAL fashion (which as description state: new records are imported, existing records not present in the input file are untouched, matched records are updated).However, I encountered an error indicating the “Key” is already exist when execute the plan.Could anyone help me on this please? I’m not sure the incremental option only works for loading to EDIT state or do I need to setup anything additionally in the column section.Thank you in advance

792
P
Data Pioneer L2
1 year ago
M
Data Pioneer L2
MayKwokData Pioneer L2
published in Data Quality & Governance ⚙️
Creating JSON String From DataBest Practice

In Ataccama ONE Desktop, we have steps like JSON Reader, or JSON Parser, to read JSON data and put them into a data flow.We also have a JSON Call step that allows you to construct a JSON template to send JSON Calls outwards.But what if you wanted to transform the data into a JSON string but not necessarily send it anywhere? If that’s what you want to do, read on…Our dataLet’s take an example of this data:I have some fruits:id name 1 Apple 2 Orange 3 Pear 4 Grape  I have also some fruit variety names:id variety fruit_id 1 Gala 1 2 Golden Delicious 1 3 Jazz 1 4 Pink Lady 1 5 Navel 2 6 Blood 2 7 Seville 2 8 Conference 3 9 Comice 3  Join them together as our base data:(See json_1.comp in zip)Output looks like this: 💡 I want to now turn this into a JSON string. Variety should be an array within each fruit.To achieve this, we first need to aggregate the variety back into fruit, and then a final aggregation to get the whole set

3620
M
Data Pioneer L2
1 year ago
P
Data Pioneer L2
pdanpoonkijData Pioneer L2
asked in Master Data Management & Reference Data Management 🛰️
Import records with username to RDM

Hello Ataccama community 😀Has anyone previously used the USERNAME column type in the RDM Importer or RDM History Importer? I want to specify the [ Username ] on RDM, indicating who made changes to each record in an automated fashion.However, I got an error telling me that unknown column 'username'; I tried using “USERNAME” instead of “username,” but still had no luck.Could anyone familiar with this help me please?

555
P
Data Pioneer L2
1 year ago
A
Data Pioneer
aiwaliaData Pioneer
asked in Data Quality & Governance ⚙️
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?

23310
anna.spakova
Ataccamer
1 year ago
A
Data Pioneer
aiwaliaData Pioneer
asked in Data Quality & Governance ⚙️
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

1482
A
Data Pioneer
1 year ago
M
Data Voyager
manzuraData Voyager
posted in Data Quality & Governance ⚙️
Manage Nodes Access, Access Level in v.14.2 (VS v.13.9)

​Hello everyone! Foreword and problem statementThere are several subcategories of terms. I need to set up access for manager and steward of each subcategory so that:The steward of certain subcategory is able to create new terms, edit old ones in his subcategory only. However, he can not publish any changes The manager, in addition to above, can publish changes, but also in his own subcategory only.I have the list of questions concerning access management in v.14.2:Is it possible to grant ownership to node? And if it’s yes, how can I implement it? Do you know any way to solve my manager-steward task? (there are my understanding of the solution below) In States of approval workflowwhat are the “User roles” : governance or identity provider ones? (looks like the second ones, but doesn’t work) what is the “OWNER” for this version of workflow?_______________________There is a long prelude to where the questions came from. Version: 13.9There is the ability to create a special capability to b

932
M
Data Voyager
1 year ago
S
Ataccamer
SathyaAtaccamer
published in Data Quality & Governance ⚙️
Adding New Property to Catalog Item 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 TO THE MMM MODELGo to left panel of the Webapp and choose Global settings   Choose metadata model under Maintenance CenterChoose the Custom filed where you need to add the new property to CatalogItem, Glossary and sources. In our case we adding to CatalogItem   Click on the Custom field CatalogItem. We can see General Information and Property. Click add property and type in the property to be added.   Fill in the name and choose the

1150
S
Ataccamer
1 year ago
E
Data Voyager
Evgeny ChernoskutovData Voyager
asked in Data Quality & Governance ⚙️
How to increase the speed of profiling data for using Oracle DB?

Hello, I have a speed of profiling data for using Oracle DB of about 4000-7000 rows per minute.I use Ataccama DQ Analyzer (Version: 11.1.1.ga-2017-06-14).  Please, can you take me to advise me on how to increase the speed of profiling data for using Oracle DB?I hope to take the profiling speed to about 100 000 rows per minute...  Connation config:   Log:17.03.2023 12:56:04 [INFO] Switching to logging setup from C:\Users\ECHERN~1\AppData\Local\Temp\loggingConfig3307204922660014311.tmp17.03.2023 12:56:04 [INFO] Using following licenses:17.03.2023 12:56:04 [INFO] C:\Ataccama DQ Analyzer 11\runtime\license_keys\license.plf17.03.2023 12:56:04 [INFO] Using DQ Analyzer configuration file C:\Ataccama DQ Analyzer 11\workspace\sqb_prof_pilot\data\out\sqb_all_table.plan17.03.2023 12:56:04 [INFO] Using runtime configuration file C:\Users\echernoskutov\AppData\Local\Temp\runtimeCfg1065525328424309714.tmp17.03.2023 12:56:04 [INFO] Changing CPU affinity to 4 CPU(s).17.03.202

1372
E
Data Voyager
1 year ago
S
Ataccamer
SathyaAtaccamer
posted in Master Data Management & Reference Data Management 🛰️
Permissions Model Best Practices

MAJOR CONCEPTS IN PERMISSIONSKeycloak is primarily used to manage Users and Roles as well as their assignment.  ONE Web Application - where you can assign preconfigured permissions to Users and Roles. It is also possible to change the default configuration and create custom permissions on the ONE Web Application. 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 the company organization chart. “Role” refers to the roles defined in Keycloak, for example, MMM_ admin. Users need to be mapped to Roles. This will determine their node permissions based on the operations allowed for that role on individual nodes. A user can have more than one role assigned to them. 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

3060
S
Ataccamer
1 year ago
M
Star Blazer L2
Marnix WisselaarStar Blazer L2
published in Data Quality & Governance ⚙️
Catch OneWeb GraphQL in Chrome/Edge test and useBest Practice

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. 

1303
M
Star Blazer L2
1 year ago
anna.spakova
Ataccamer
anna.spakovaAtaccamer
published in Data Quality & Governance ⚙️
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

2860
anna.spakova
Ataccamer
1 year ago

Badge winners

Show all badges

Let's shape the future of Ataccama together

Join User Research at Ataccama!
See new features and prototypes before everyone else, and have an opportunity to shape the future of new products.

Read more
Community Terms of Use & ConditionsCookie settings