Solved

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, I have my input like below example. May I know how can I transpose the data from columns to rows? Input Data: Pilot_Yr10 Vermont_Yr10 Pilot_Yr9 Vermont_Yr9 Pilot_Yr8 Vermont_Yr8 2014 2014 2015 2015 2016 2016 9.67 9.67 -3.76 -3.76 18.4 18.4 9.02 9.02 -4.33 -4.33 17.7 17.7 13.69 13.69 1.41 1.41 11.96 11.96 Expected Output Data: Period Pilot Vermont SI Since Inception 1/1/91 Since Inception 1/1/91 Yr1 2023 2023 Yr10 2014 2014 Yr2 2022 2022 Yr3 2021 2021 Yr4 2020 2020 Yr5 2019 2019 Yr6 2018 2018 Yr7 2017 2017 Yr8 2016 2016 Yr9 2015 2015

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

On my virtual desktop I have two ways I do an API call to ServiceNow to create an incident. With Postman it is working. I've managed to create an incident in ServiceNow serveral times.With One Desktop, with the same URL, header and JSON body I get Connection reset every time. And the Json call response debug file isn't even created. So here is my Postman setup: Authorization is a basic auth. Headers: When I run this I get the following response: { "import_set": "ISET0012345", "staging_table": "u_str_call", "result": [ { "transform_map": "STR - Call API", "table": "incident", "display_name": "number", "display_value": "INC0217277", "record_link": "https://mydev.service-now.com/api/now/table/incident/8c47e2e6472fb11016fd2e61e36d4336", "status": "inserted", "sys_id": "8c47e2e6472fb11016fd2e61e36d4336" } ] } Now here is my One Desktop setup: And my component with Json Call: This is my Json Call: And the headers: You can see there is no auth header here. I assume it gets that from the serve

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

I have a ‘provider_name’ cleansing component under ‘provider’ component. When I test the ‘provider_name’ cleansing component on DQS in a test plan, the values on pur* and out* fields look good. And the provider component shows the propertied of the name component as but for some reason, none of my changes are reflected or seen when the component is deployed with changes and subject is reprocessed. Am I missing something? I did debug at the name level and the component level, the values come out right but not after being deployed and reprocessed. Any suggestions?

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

Hi All, as we are adding more data product to our Ataccama One environment als more profiling jobs run every morning. For every succesful job from the processing center we currently get a flash pop up that it ran succesfull. Can we somehow hide these pop-ups? Or only show the failed ones for instance? Regard, Jur Dördregter

Hi, is ataccama one available for deployment in VM?Because of data confidentiality and system requirement, i need to deploy data catalog & governance tool in VM within private network. if available, can someone provide link for documentation for VM deployment?need to check the sizing, required component, etc also do ataccama one (cloud) support private link to aws cloud? thank you

Hey community, The term overview screen shows the entries of all types. I would like to implement a ‘term type’-filter (via Application Settings → Search Configurations) on that page. For that I need to know in which entity and property term type has been implemented, but I cannot find that. We have version 13.9.4. Does anyone have a clue? Kind regards, Albert de Ruiter

Hi, What is Fractional digit used for? Can it help to identify character length within an attribute?

I'm trying to connect to a SericeNow API to create data quality related incidents. (see: ServiceNow API call keeps running into Connection reset | Community (ataccama.com)). It is now pretty clear this is failing because the proxy isn't letting me through. And it also now seems pretty clear I need to use a certificate to authenticate on the proxy. So I have .crt file that I might use. But where do I change the config of One Desktop so it will use it? Under Window > Preferences > Network Connections you can find the proxy settings: But the proxy settings have no certificate settings: Under Network Connections there is a SSH2 screen, but I have no idea where to enter the location of my .crt file here. Any idea?

I have tried to implement MS teams notifications for the monitoring projects - but after following the instructions in the user documentation ( https://support.ataccama.com/home/docs/aip/14.3.0/development-guides/one-development-guide/configuring-the-one-web-application/ms-teams-integration ) I don’t get any messages to my teams channel, is there something else that needs to be configured for this to work?

Hi, does anybody have experience with integrating with service now? We want to create an incident on a dq check that breaches a threshold to raise an incident. Any examples?

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?)

We are on version 14.2 and trying to create a connection to Microsoft OneDrive, so we can export some data from RDM to it. We are planning to write the data using onPublish plan. We see that Ataccama ONE supports Onedrive in the ONE webapp (https://support.ataccama.com/home/docs/aip/14.2.0/user-guides/one-web-application-user-guide/knowledge-catalog/data-catalog/working-with-data-sources/microsoft-onedrive-storage-connection) But I cannot find a corresponding connection type in ONE Desktop. In here One drive is not an option: How can we set this up please?

Hello everyone!In the new version of Ataccama 14.5, how is the configuration done for regular scanning of data schemas to detect the appearance of new tables: metadata import? I need to regularly automatically import tables based on a specific schema that are not in the Catalog Item. I will be very grateful for your help🤗 Thank you!

I got 2 questionsFirst: how can I replicate my DQ rules from one environment to another ? (example: from dev to QA)Second: how can I make the rules automatically replicate to new records on a table ? Like if I have a table with 500 rows and I add 50 more rows, I need to re apply the rules to all the table, instead I wanna make it in an incremental way so only my new records would need to have the rules applied.

how to be ataccama data integration(migration) to azure cloud?

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?

We had a internal discussion, but ended up not being 100% sure. So here's the question. When we run DQE on a CI, where are the rules evaluated? Does the DPE get the full data (possibly with filters on the MP?) and the run the rules evaluation IN the DPE. Or does the DPE create a SQL-like statement and does the source DB return the results? As we also run on Hadoop with DPE on Hadoop. Is this the same.

Hi community, I am looking for a bit more clarity about Term Suggestions Synchronization. In the Documentation Portal I read that the synchronization is only relevant after a database restore or ‘by importing any initial content (default, demo, etc.)’. For me it is not clear what is meant with this initial content. Importing a catalog item for the first time, or? Does anyone know? Kind regards, Albert

The performance of one of the subject is bad. This what is happening. A new or existing records loaded and it runs matching against 1000 records (one master and 999 slaves) because they are similar and have same master_id 123. So if we think of overall if 500 records are loaded during an incremental load and each have similar conditions, its ending up touching 500000 records and taking several hours. IS there a way to make the record only try to match against the Master record? or other ways to improve the performance? Please suggest. Thank you.