Skip to main content

Master Data Management & Reference Data Management 🛰️

Discuss, learn, ask, suggest, share all things MDM and RDM 🔍

  • 249 Topics
  • 542 Replies
249 Topics
F
Universe Traveller
fshahinUniverse Traveller
asked in Master Data Management & Reference Data Management 🛰️
Survivorship Configuration

Hi All, Can someone please let me know the steps for configuring Survivorship logic for attributes once records are tagged for merge?I couldnt find much of survivorship details in One MDM document.Thanks,fshahin

325
F
Universe Traveller
3 months ago
M
Data Voyager
Mr.DQData Voyager
asked in Master Data Management & Reference Data Management 🛰️
Configure Snowflake connection to use OAuth via AAD

Is anyone able to configure the Snowflake jdbc connection with OAUTH using AAD?  I’m not clear on how to accomplish the instructions in the documentation.  Can anyone help with screen shots or a section of their runtimeConfig file (with obfuscated secrets, id’s, etc) ?TIA

560
M
Data Voyager
3 months ago
R
Data Voyager
RandomStranger37Data Voyager
asked in Master Data Management & Reference Data Management 🛰️
Survivorship Logic in Ataccama

I’m new to Ataccama ONE MDM and have recently completed the training. I’m currently doing a POC on it and am stuck at two places.So here’s the situation:First, I’m able to load the data but I’m not sure how to update it. Like, lets say I have a person record and after loading it generated Person_ID X23233X. Now, I made changes to some of the data in the same request. For eg, I’ve updated the contact number or the address of the record. Now, when I’ll be loading this same data again I want the ID to remain the same and just update the contact/address data along with Last_Updated _Timestamp. Secondly, lets say I have a record with 2 different phone types, ‘Home Phone’ and ‘Work Phone’, and I’ve loaded it. So, the Person_ID  X12322X will have two contact details associated with it. Now, lets say I removed the ‘Home Phone’ details from the record and send it for update load. So, after updating the same request, ‘Home Phone’ details should be dissociated from the Person_ID X12322X (the cont

814
Cansu
Community Manager
3 months ago
Cansu
Community Manager
CansuCommunity Manager
published in Master Data Management & Reference Data Management 🛰️
MDM Model ❇️

Hi everyone!We are wrapping up our introduction to the MDM series with this post delving into the core of MDM—the Model. MDM is a model-driven implementation, where the model takes center stage, driving the generation of structures and orchestrating crucial processes. Let’s dive in 😎 Unlocking the MDM Model MagicThe MDM Model is the maestro orchestrating the symphony of Ataccama MDM's capabilities. Here's a glimpse of how it weaves its magic: Automated Database Structures: Say goodbye to manual database creation. Ataccama MDM automatically generates database structures based on your model. MDM Workflow Wizardry: Cleansing, matching, and merging—the three crucial phases—are seamlessly handled by the MDM Workflow, automating the orchestration of these intricate processes. Native MDM Services Creation: The model isn't just a blueprint; it's a generator. Native MDM services spring to life based on your model, simplifying service creation and eliminating unnecessary complexities. Con

2882
Cansu
Community Manager
3 months ago
S
Universe Traveller
sriniUniverse Traveller
asked in Master Data Management & Reference Data Management 🛰️
Auto Stop on MDM Events

Hello Team,can someone provide insight around the solution to stop the event generations based on the condition, let's say- if MDM system receives / source system sends less than 50K records for mastering then use events to propagate the changes to downstream system else send a batch extract file. knowing the fact that we can delete the events after generating but looking to stop the events conditionally.  

332
S
Universe Traveller
3 months ago
F
Universe Traveller
fshahinUniverse Traveller
asked in Master Data Management & Reference Data Management 🛰️
Configure Match Rule

Hi All, I am working on an enhancement project where I am adding more source system in existing model. As per the requirement I have added one match rule in Party Match Component at the bottom of existing matching rules and then I executed the component using Run button. Got message that Plans completed successfully. After that I executed load operation with some sample data in source which is passing that last added rule. Execution completed successfully but the records didnt merge. In master table they are present as 2 separate records. Am I missing any step?  Thanks,FS

281
A
Ataccamer
3 months ago
K
Data Pioneer L2
KundanData Pioneer L2
asked in Master Data Management & Reference Data Management 🛰️
Schedule load in MDM

I have MDM setup and records are loaded using a Full Laod configuration. I need to create a load such that all the records that were added into the source are moved into to MDM hub on a daily basis. The approach being used is to identify all the records updated today and load them into MDM. Can you please suggest if I need to create a Delta Load for this or Full Load works. Also, I need to schedule a run of the load file on daily basis.How can I do it?

221
A
Ataccamer
3 months ago
anna.spakova
Ataccamer
anna.spakovaAtaccamer
published in Master Data Management & Reference Data Management 🛰️
Working with delta changes in Ataccama ONE

Hello everyone, Anna here! I work as a projects consultant in Ataccama and today I put together a guide for you on how to work with delta changes in Ataccama ONE. Enjoy!IntroductionAs part of every project, some kind of integration with other tools is usually required. In most cases, the integration requires synchronization of some data between the tools on regular bases. When it comes to Ataccama ONE, synchronization of assets like business terms or DQ rules may be required – for example with Collibra. It is desired to synchronize only delta changes (changes that happened since the last synchronization) to keep the integration efficient.This article explains how the delta changes can be detected in Ataccama ONE using graphQL queries. There is no simple out-of-the-box delta detection implemented, for that reason multiple graphQL queries are used in plans to achieve this goal.Ataccama doesn’t store a last modified date or similar property within assets. Ataccama creates a History Change

2373
greglvaughan
Data Enthusiast
3 months ago
H
Universe Traveller
hkulkarniUniverse Traveller
asked in Master Data Management & Reference Data Management 🛰️
Is it possible to pass kafka topics in Runtime config?

Hi, We are currently using 13.9.We have multiple kafka topics and they are differently named with a suffix representing the environment like topic.sit, topic.uat. When we do the deployment to prod we have to make sure that the comp files where the topics are specified like event handlers or streaming consumer are cherry picked manually.Since fetching the values from environment variable functionality is not available in MDM or ONE desktop, I was wondering if there is a way we could create an alias for these topics and define them in runtime config as runtime config will anyway not be merged in any deployments. If someone has any workaround for this kind of situation, please suggest.Thanks,

344
Cansu
Community Manager
3 months ago
F
Universe Traveller
fshahinUniverse Traveller
asked in Master Data Management & Reference Data Management 🛰️
Update in MDM

Hi All,I am new to Ataccama and currently working on a POC. I have a requirement that if an update is coming for a master record then it should not again go through the match and merge process, instead it should directly update the master record. Is it possible to achieve the scenario? Do I need to create separate workflow or same workflow can be re-configured? Can someone please explain with detailed steps if at all this is a logical possible scenario?ThanksFS.

344
Cansu
Community Manager
3 months ago
F
Data Pioneer
FCB developerData Pioneer
asked in Master Data Management & Reference Data Management 🛰️
How to upload DQ results from my monitoring project into a database?

Hello everyone!I created a VCI (Virtual Catolog Item) and created a Monitoring Project with Rules in Atacama One, using a Post Processing Plan I wanted to upload the result of the monitoring project to databases, in Atacama One we have a csv file with the results in the Export tab, but I can't upload it to the database, the database is empty. Сreated a Global Runtime Configuration, but there is no result. Who has faced such a problem?

45411
M
Data Enthusiast
3 months ago
R
Ataccamer
Robert MarinovicAtaccamer
published in Master Data Management & Reference Data Management 🛰️
Upgrading RDM project from version 12.3 to 14.5.x

Hello everyone,In this post, we will cover upgrading your RDM project from version 12 to 14. This will also be applicable to any other version, but some specific details we will cover are specific when going from version 12 to 14. This is because of new features and options within the RDM model which were newly added in some version between 12 and 14. For the purpose of this article I will assume you are familiar with the desktop tool already and know how to open up the model explorer view.The first step is to ensure you have both the Ataccama Desktop tool downloaded and installed for both versions. To download latest version visit this link. Then setup the desktop as needed and ensure at a minimum you can start up the sample project.Once everything has been setup correctly our next step is to export our previous project mdc file from our version 12 desktop tool.To export your project, right click on the project and click on the “Export...” option. Then you will pick somewhere to save

210
R
Ataccamer
3 months ago
P
Data Voyager
PrithikaData Voyager
asked in Master Data Management & Reference Data Management 🛰️
ONE Desktop: How to run plans on One Web

Hello, how to run the plan below (created using ONE Desktop) on Ataccama Web ?  

431
S
Ataccamer
3 months ago
JTH
Data Pioneer
JTH
asked in Master Data Management & Reference Data Management 🛰️
Lookup ONE Desktop

Hi,I have a .csv file containing country codes that looks like:countrycode.csvI want to use this file as a lookup. In ONE Web it is possible to use a .lkp file as a lookup (why not just import an excel file there is beyond me). In order to do this I understoond I had to create a lookup builder:Lookup builder​​In the Text File Reader I selected the documented with the encoding (I hope this is the right one?). As for the columns I created nm_lnd and kd_lnd (both string).Text File Reader - GeneralText File Reader - ColumnsAs for the Lookup Builder:Lookup BuilderWhen I run it a .lkp is created but also a rejected.txt with everything that is inside the .csv meaning I'm not able to create the desired .lkp file. What can I do to resolve this? Is there also documentation on how to create lookup using .csv somewhere? I can't find it.

343
JTH
Data Pioneer
3 months ago
K
Data Pioneer L2
KundanData Pioneer L2
asked in Master Data Management & Reference Data Management 🛰️
Difference between Full Load and Complex Delta Load

I need to understand the difference between Full and Complex Delta Load in MDM.As per this document on Complex Delta Load,  Delta Dependency Mode  needs to be setup for each entity. I see there are two options for it -Autonomous and Central. Can someone please explain the difference between these and in what scenario these should be used?I also see that The engine expects an additional column in the input interface denoting the type of record change (change_type: I - insert, U - update, D - delete). Where shall we define these and what how can we identify which records needs which change_type?TIA 😊

301
A
Ataccamer
4 months ago
T
Data Voyager
TylerData Voyager
asked in Master Data Management & Reference Data Management 🛰️
Set MDM records to inactive based on source flag and not delete

Hello, from one of our source systems we were previously excluding any inactive addresses, contact details, etc. Our users have requested we load these records into MDM for visibility. My issue is that while we can add these records as is, they will not show as inactive on MDM. We could add a source active flag but for consistency with other sources we would like them to show as inactive on MDM (Greyed out). We have considered doing a one time load of all the inactive instances and then excluding them from the daily load but because it is possible to create address and contact details as inactive from the source that would not work. I have explored using the delta load as it has a change type column that could be appropriate for our use case.Has anyone had to set records in MDM as inactive as part of the load not using the deletion strategy? What method did you use?I have also looked into creating new instance entities to store inactive records but that would be a large undertaking as

552
Cansu
Community Manager
4 months ago
K
Data Voyager
Kelvin FongData Voyager
asked in Master Data Management & Reference Data Management 🛰️
Export info from catalog items on web?

Hi all, is there any configurations we can edit in the page template and/or the metadata model, so that we can (best having a hyperlink or button to) export the content from e.g. the access, data structure or profile tabs of the catalog items? Thanks a lot.

672
Cansu
Community Manager
4 months ago
abir
Ataccamer
abirAtaccamer
published in Master Data Management & Reference Data Management 🛰️
IDs in MDM

Hello everyone, I am Abir 👋. I am a Principal Consultant at Ataccama. I have recently worked on a project where I had to explore how IDs in Ataccama MDM work, what to consider if any customization is required from the default behavior and how to utilize the dedicated ID sequence feature. I will share in this post what I have learned from MDM gurus and from the overall experience when implementing a custom solution for anyone else venturing into the same journey. Understanding IDs in MDMMDM generates IDs for columns such as id, master_id, xid, tid, etc. utilizing a database sequence created based on the model definition. When an MDM process creates new records, it fetches the NEXTVAL value from this sequence, multiplies it by 1000, and generates and assigns IDs to the new records. Once the MDM process is completed, using the maximum ID value assigned, the sequence is updated for the next MDM process. The sequence is cached in Java (for performance reasons) during this process, this is

1201
S
Ataccamer
5 months ago
C
Universe Traveller
C_RUniverse Traveller
asked in Master Data Management & Reference Data Management 🛰️
One Desktop Git Intergration

Hi all,I am in process of learning ONE Desktop and was curious if there any documentation or best practices on integrating GIT. I have searched and found a related topic that was helpful.  Thanks for any help. 

1885
Joeri
Universe Traveller
5 months ago
M
Data Voyager
Mr.DQData Voyager
asked in Master Data Management & Reference Data Management 🛰️
Is it possible to create a table in RDM that will not keep historical data, just current values?

Checking to see if there is a way to create a “current values only” table in RDM, with no historical records to be kept?  I don’t see any option for this in the documentation or One Desktop dialogs.     

224
Joeri
Universe Traveller
5 months ago
P
Data Pioneer L2
pdanpoonkijData Pioneer L2
asked in Master Data Management & Reference Data Management 🛰️
Make RDM tables permissions editable from the web app.

Hello community,I’m working on an RDM project and have a question regarding the security configurations. I find that if I tick the Fixed Permission checkbox in the Security config. node, the roles permissions I have setup in the IDE will get uploaded onto the web app., but it won’t be editable later there. However, if I don’t tick this checkbox, none of the permissions will get loaded on to the web app., but I will be able to fully customize the roles permissions on the web app.Is there a way to have the initial roles permissions loaded from IDE, but also editable later on the web app.?Thank you in advance

634
Joeri
Universe Traveller
5 months ago
R
Data Voyager
rpainte1Data Voyager
asked in Master Data Management & Reference Data Management 🛰️
One Desktop 13.3.2 Compatible with MS Windows Server 2022?

Is anyone able to confirm if One Desktop version 13.3.2 is compatible with with MS Windows Server 2022

192
Joeri
Universe Traveller
5 months ago
N
Data Voyager
nigelData Voyager
asked in Master Data Management & Reference Data Management 🛰️
Seeking to concatenate two columns into one (within the same record)

Hello allA basic (and rookie) question, but I couldn’t find the answer in the manual or tutorials, or on this forum.After I’ve loaded source data into Ataccama ONE Desktop, I’m looking to create a new column and fill it with the concatenated content of some other columns (two or more), maybe with a bit of text in between. In Excel I’d use the Concatenate function...Example from ExcelAs you can see, I can then lookup information based on Column D and use that for bringing in various lookup values (the real use case is not name-based, this is just to create a simple example)Note - I’m not looking to merge different tables (with join, union, or representative creator - unless those tools can do what I’m looking for) - this is simply creating a new column/field which is a concatenation of two or more other fieldsContext: I’m building a lookup based on multiple attributes - I’ll combine them into a single attribute to give me a single lookup key and then I can use that for various other pur

2216
anna.spakova
Ataccamer
5 months ago
D
Data Enthusiast
Devi PotturiData Enthusiast
asked in Master Data Management & Reference Data Management 🛰️
MDM server file start issue

Hello I am trying to start the MDM Sever and I am facing the below issue. I have cleared the database and started the database and key-cloak. Database and key cloak started successfully. After that I am triggering the start-mdm-server.bat file and its causing the below issue.  Did anyone face similar issue while starting the MDM server? Could you please let me know how to resolve this issue 

283
Cansu
Community Manager
5 months ago
J
Data Voyager
jebellData Voyager
asked in Master Data Management & Reference Data Management 🛰️
MDM records inactive in Ataccama but active in source system - How do I re-activate those in Ataccama?

We recently had a glitch in our Test MDM load, and only 1,000 of the 4 Million+ records came into the MDM from our source system. MDM inactivated most of the 4 Million records (appropriately). However, now that we have fixed the glitch and are pulling all 4 Million into MDM from our source system, it is is not reactivating the ones it had previously inactivated… how can I force a re-activation of those records?

475
Cansu
Community Manager
5 months 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