Master Data Management & Reference Data Management 🛰️

I have an xml file with a structure like this: <model xmlns="http://www.ataccama.com"> <entities> <entity name="table1" /> <columns> <column datatype="varchar(100)" name="abc" required="false" /> <column datatype="int" name="xyz" required="false" /> <column datatype="datetime" name="123" required="false" /> </columns>... I want to produce a data stream that combines the column name and data_type with the name from the parent entity node. If I define the columns using xpath nm:model/nm:entitles/nm:entity/nm:columns/nm:column then I cannot access the entity name using ../../@name (or any xpath expression for that matter). If I define the columns using entity level xpath epxression nm:model/nm:entitles/nm:entity and the columns with xpath nm:columns/nm:column/@name then I only get 1 record per entity with the first column only. How can I get the entity name, column name, and column data_type on each line?

Hi Team, could someone please assist in getting idea of implementing checkpoints in master data consolidation process.? as currently we observed MDM follows a one lengthy workflow of MDM data consolidation process from Data acquisition to publish data to the downstream systems [ data acquisition → change detection → cleansing → match→ and then merge.] during this entire flow execution if any one of the components failed after few hours due technical some issues, then it is required to restart this entire flow. just to avoid this we wanted to restart the jobs from the point where failure happens, is there any way to breakdown or separate the jobs or implement the check points to restart.? please suggest with the recommendations. Thanks,

Hi all, Can I export lookup file and import to another environment? Thanks in advance.

We have recently upgraded to RDM V14.5.0 and are finding that if you leave the screen idle for 5-10 mins the system will log you out and back in immediately. When it logs you back in it has closed all the tables that you had open previously. Also, when you want to close RDM and press the “Log out” button it more often than not logs you out and then back in again. It takes a 2nd press of the “Log out” button to finally log out. Is there a setting somewhere that will increase the idle time so we don’t keep losing the open tables and is the need for a double log out a bug or some setting that we need to change. Any help would be appreciated.

Hello Team, require help, we are on MDM 13.9.3 → newly added columns to the Instance and Master entities are not visible in REST API calls, do we required to enable any configuration to visible those new attributes in get calls.? thanks in advance for your inputs.

I want to load around 832,032 records from Excel file to DB table using Plan. Plan is not executing. It giving below error message :- 1)Not enough memory to run the plan file. java.lang.OutOfMemoryError: Java heap space at org.apache.commons.io.IOUtils.byteArray(IOUtils.java:338) at org.apache.commons.io.output.AbstractByteArrayOutputStream.needNewBuffer(AbstractByteArrayOutputStream.java:104) at org.apache.commons.io.output.UnsynchronizedByteArrayOutputStream.<init>(UnsynchronizedByteArrayOutputStream.java:51) at org.apache.poi.util.IOUtils.toByteArray(IOUtils.java:181) at org.apache.poi.util.IOUtils.toByteArray(IOUtils.java:153) at org.apache.poi.openxml4j.util.ZipArchiveFakeEntry.<init>(ZipArchiveFakeEntry.java:67) at org.apache.poi.openxml4j.util.ZipInputStreamZipEntrySource.<init>(ZipInputStreamZipEntrySource.java:98) at org.apache.poi.openxml4j.opc.ZipPackage.<init>(ZipPackage.java:132) at org.apache.poi.openxml4j.opc.OPCPackage.open(OPCPackage.java:312) at com.ataccama.dqc.io.ms

Hello hive mind, Has anyone out there who have RDM v14.3 or later, and successfully used the new RDM REST API feature? We’ve upgraded our dev environment to v14.5.1 this week, I tried the REST API, and it keeps returning with “java.lang.Exception: org.springframework.security.access.AccessDeniedException: Cannot access entity: address_type” error. (Was trying to query my entity called address_type) I ensured my service account client has full access to the table. That service account client calls other API endpoints that I have built before on rdm-server and that authenticates fine. I wonder what I’m missing. Anybody successful before and we can compare notes? Thanks!

Hi Team, require help- when clicking on any entity in web URL, popup error box and not able to edit for seach any records. error- "getRowsWithDraftsFailed to determine origin for record party, id = 37104” MDM log capture as per below: 2024-02-09 19:24:33,338 ←[39mDEBUG←[0;39m [476bff][admin][http-nio-8050-exec-4] ←[36mc.a.m.s.MdaRemoteServlet:31←[0;39m - actionId=findRecords() status=START2024-02-09 19:24:33,355 ←[31mWARN ←[0;39m [476bff][admin][http-nio-8050-exec-4] ←[36mc.a.m.s.MdaRemoteServlet:51←[0;39m - actionId=findRecords() status=FAILURE message=findRecords() method failed. Error: Failed to determine origin for record party, id = 371042024-02-09 19:24:33,356 ←[31mWARN ←[0;39m [476bff][admin][http-nio-8050-exec-4] ←[36mc.a.m.s.MdaRemoteServlet:51←[0;39m - actionId=findRecords() status=FAILURE message=findRecords() method failed. Description: java.lang.NullPointerException: Failed to determine origin for record party, id = 37104 at com.ataccama.dqc.commons.util.AssertUtil.assertN

Hi All, require help on below error "This user does not have sufficient rights to access the application”.

Would you like to cover the case what will happen when a user enters her/his credentials incorrectly many times? The setting of Max Login Failure can be set in Keycloak Admin Console, follow these steps: Log into Keycloak Admin Console Go to Realm Settings (Ataccamaone) on the left-hand menu Go to Security Defenses tab Select Brute Force Detection and enable the feature Set the Max Login Failure to the desired amount Brute Force Detection before enablement When enabled, all setting can be changed accordingly to your needs Any question or comment? Let us know!

Dear Community, I have query regarding RDM approval workflow. In our project we have stages Initiator → Review → Publish . It has been noticed that when a record is invalid, its status is displayed as 'INVALID,' yet it progresses in the workflow for review. The reviewer has the option to accept this invalid record, and it moves to the Publish section. However, when the approver attempts to publish the record, an error occurs, stating that the record is invalid and cannot be published. The client is now requesting clarification on why an INVALID record is allowed to progress through these stages in the first place. They propose that it should not be permitted to move to the review state initially. Anyone faced this scenario before? Can we do something in approval workflow configuration that record should not move to review state if it is Invalid. Any help regarding this will be really helpful. Best regards, Ojaswini

How to delete orphan but active records on source and instance table in Omnihealthdata. The records were deleted at source but the load to onramp was missed for delete batch. Is there other way I could delete these records from _s(source) and instance tables? Is a manual SQL delete a right way to go with or would it cause any future issues?

I’m using RDM 14.2 (soon to be upgraded to 14.5) and I need to build an API endpoint to accept incoming data. I have an integration input and will use an RDM Importer step to import the data into my table. My table has a generated id as a primary key and I need to provide the generated id as a response back to the incoming API call. But the RDM Importer step stops there. It doesn’t tell me the id. How do I then get the id back? I could make an RDM Extended Reader step in the plan, but I cannot guarantee the Reader step is executed after the Importer step, because the Importer step doesn’t have an out endpoint, it only has an err endpoint. And if I query the data before the insert is committed then I will end up with nothing to provide. Any ideas? (I believe the new RDM REST API functionality is read only so that won’t be relevant here?)

My requirement is to get all the RDM tables in Ataccama to Snowflake or to amazon S3. Could anyone please let me know how to do that.

Hi Team, Can anyone please help me with below Information on MDM licensing? Is Ataccama MDM licensing model based on number of records that we load form various sources (unconsolidated) or based based on unique profiles in MDM (Consolidated) Apart from number of records, are there other aspects that affects licensing price like the domain that I want to master (Customer/Product/Location etc.), the number of API calls, the number of batch jobs that execute per day, total volume required to host source records + history + merge history etc. ? Any other factor that is required to calculate MDM licensing cost?

Hi Team , Can anyone please help me setup my MDM environment locally . Please help me with the plugins and folder structure . Regards, Kundan

Hi Team, I need to upgrade my ataccama 13.8 to new latest one…. request you to please provide upgrade version download path or URL's. As I am facing some issue on current repository- ";Cannot instantiate class: com.ataccama.dqc.jms.sqs.SQSInitialContextFactory”

I am working on template project for MDM and i am not able to run the pgsql script in it and i did followed the steps mentioned in this MDM Example Project - Ataccama ONE Gen2 Platform Latest Kindly let me know if you have any solution for this.

When working with Reference Data table there may be a business requirement to control what kind of values can be input into a given attribute which are checked whenever a user creates or edits records within the RDM application. There are two kinds of validations: The first kind are called Instantaneous validations. These conditions, e.g., regular expressions or string size are checked automatically when you enter an attribute value. When the input value fails to meet these condition, an INVALID message appears next to the attribute field. The second kind are called Online validations. These are more complex conditions, which are triggered by clicking Validate in the Create detail/Edit detail dialogue or upon closing them. Such validations are performed by DQC plans (using, e.g., phone number or address lookups) or SQL queries in RDM. When the input value fails to meet these condition, a Warning message appears next to the attribute field. Records which do not satisfy online conditions

Hi Team, In Ataccama IDE, while connecting to database we need to provide connection string. Also, username and password. In other tools like SQL server, we can use windows authentication to login so no need to enter username and password. Could you please help me how we can achieve the same integrated login for database connection.

HTTP ERROR 404 Not Found URI: /rdm STATUS: 404 MESSAGE: Not Found SERVLET: com.ataccama.server.http.ServletContextDispatcher-5eefa415

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? ServerConfig RuntimeConfig Introduction This is an introduction to the Ataccama Admin Centre serverConfig and runtimeConfig files: What the files are and where to find them How to setup security on the Admin Centre UI itself How to setup an online service endpoint on Admin Centre How to setup Admin Centre to enable the run of schedulers, workflows and plans / components The intended audience for this article are Power Users for Ataccama ONE. Power Users may have built some plans / components / workflows / schedulers / online services, and are now looking to host them on a server environment. What is the Ataccama Admin Centre? The Atacccama Admin Centre can also be referred to as the “ONE Runtime Server”. For the purposes of this document,