Learn & Share

If my MDM instance is up and running with the model same as the example project. But there were standardization changes that need to be implemented now. Example: ph no. (+91)22343 24532 is being standardised to +91234324532.Will this affect matching for contact.master records? If so, will it create new master ids in any scenario? 

I’m building an API call request, where I first need to obtain an access token, before I make my actual API call.I have tested the 2-step process using 2 separate JSON calls successfully. The message body of the OAuth request looks like this. Sensitive info redacted: scope is a required parameter. The above call successfully retrieves my token. I tried to setup this as a Generic server:But there is no available space to specify the scope parameter. When I run my plan: I get:2024-09-04 09:33:16 INFO: Validating model...2024-09-04 09:33:16 INFO: Creating runtime...2024-09-04 09:33:17 INFO: Running runtime...2024-09-04 09:33:17 [JsonCall] DEBUG: IOException when making request GET https://preprod-api.londonmarketgroup.co.uk/reference-data/acord/v2/version HTTP/1.1java.io.IOException: Cannot get credentials for request. at com.ataccama.dqc.io.http.CommonHttpClient.makeRequest(CommonHttpClient.java:351) at com.ataccama.dqc.tasks.io.json.call.JsonCall$Runtime.run(JsonCall.java:425) at com.at

Hi,13.9.4In the Monitoring Project there's a way to only display the data quality of the last run via Advanced settings ​​​​​Is there also such a way to do accomplish this with Full Profiling on (SQL) Catalog Items?

I want the result of my monitoring project to appear in the dashboard in the Report section when I receive it by mail. Is it possible to amend the mail notification regarding this?The notification in mail should look like this: 

Hi community,Has anyone managed to connect Ataccama (we’re on PaaS), or even ONE Desktop, to a corporate network folder, download files, and work with it in .ewf workflows and components / plans?Yes I know Ataccama connects to S3 buckets / ADLS Gen2 containers, but the environment that I work in people are really used to shared network drives and a lot of applications are integrated with them. It would make my life a lot easier if I can make Ataccama connect into it.When I look at either the SCP or SFTP upload/download steps, it requires a server to be set up with Basic authentication - of course when I connect to the network drive personally I don’t need to enter any of that.Has anyone done something similar?

HiI have a workflow with Send Email step configured and this workflow will be pushed to orchestration server to run it. I have an attachment need to be included in the email notification generated from the workflow and realized that if I put only the file name for example RESULTS_ABC.xlsx, by default it will find it the same folder of the workflow that is being created. Let’s say if I put the RESULTS_ABC.xlsx in different folder like Data/Out, how do I configure it correctly at the Attach Files configuration as shown in the image below? I saw a discussion to use filePath variable but I am not too familiar with that. Could you please explain how can we achieve running the workflow and read the file that is stored from different folder so that it can attach in the email. 

Hi, I was wondering if there is a way to profile a subset of the data based on a certain criteria in the web application. For example, I want to get the profiling results only for records with the ‘Active’ status in the ‘Status’ field.I am able to do this in the desktop application by writing a custom sql query to filter the results. If I can do this directly in the web app that would be really helpful.Thanks in advance!

Could you please help to share steps to setup connection from ataccama to Snowflake

Is there a way that I can use to make an API call to trigger a workflow?We want to start a workflow to Load Data into MDM after the data is refreshed in all source systems, each time it is refreshed.Please suggest if there is a way do define a service for this.Thanks in Advance :)

Hi All,I have recently made created new export delta operation along with made minor tweaks in the full load export operation too.After making changes,once i save and generate,trying to up the MDM server,getting the below erro.Please suggest,what is could be the missing dots here. Sharing the error log received in console for start_mdm_Server.bat file.2024-09-27 12:23:30,456 ←[1;31mERROR←[0;39m [][][main] ←[36mo.s.b.SpringApplication:835←[0;39m - Application run failedorg.springframework.beans.factory.BeanCreationException: Error creating bean with name 'workflowServerComponentService': Invocation of init method failed; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'nmeEngine' defined in class path resource [com/ataccama/nme/services/config/NmeBeansConfiguration.class]: Bean instantiation via factory method failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [com.ataccama.nm

Hello Dears,Is there a functionality or a tool available to search on the code of VCI, catalog items, DQ rules…. in all the object types that we use in Ataccama.We know that there is possibility to search on the names, but not on the underlying levels.  Thank you for ideas.Kind regards,Maria

Hello,I was able to parse a fixed width file using the Ataccama One App by editing the metadata.  But when i try to parse the same file using the Ataccama Web App it doesn’t parse correctly.  Is there a way to give the metadata file to the Web App for it to parse the file correctly ? Thanks, Rene Requenes

I would like to know what will be the effects in mdm web application if I make the following changes.Here goes the scenario:Let’s say I am using email attribute in my match logic of contact(silver) entity and have already loaded the email records into my mdm-hub.But now, I do not want to use email information from 1 of 3 source systems while determining the contact(silver) master. I think the option is to not load email information from the said system.Will the email information (from the records that were loaded previously from system 1 )still show up after I run a reprocess job( after loading the records from system 1 without any email information.)?

When i am creating a new flow for export operation,it is not reflecting in the admin console to trigger the respective flow’s execution.Please help how to enable that in the admin console.Please suggest.

When trying to run export operation from localhost admin center, error is thrown saying "Origin code 3389682780300157351 used on InstanceEntity(address) record 37150 not found!". Here address is one of the entity being used in my export operation.Attaching the error log file here and below is the export plan for the full load for policymaster export.Any help,highly appreciated. 

Hi Team,I am checking on connecting to Cosmos database from Ataccama One Desktop, can you please share any documentation or usecase available to do that. Thanks,Rohith

How can I edit existing lookup files to add new values? File location is “files → data → ext → lkp”or how can I create a new lkp file in same path?

Hi All,From source I am getting only one column as FullName and there is no other column which can identify whether the Fullname is person’s name or a company’s name. In Ataccam, is there any out of box functionality built which can parse the FullName column and identify the party type?If yes, then kindly do let me know the steps which I need to perform to achieve this.ThanksFS

Need an automation to map Active Directory groups to access to groups and monitoring projects on Ataccama UI. 

I have a use case where I want to store some client id and secret in my own company’s Azure keyvault.Then I have a component which needs to use the client id and secret to authenticate against a 3rd party, so I can issue a GET call to get some data. So I am thinking:Runtime server authenticate against keyvault Runtime server issue a “get secret” call to keyvault Keyvault sends back the secret Runtime server takes the secret and authenticate against 3rd party Runtime server issue a “get data” call to 3rd party 3rd party sends me back the actual data What authentication methods from runtime server to keyvault are supported? I had a look at Azure keyvault’s documentation but I don’t think I understand it fully. https://learn.microsoft.com/en-us/azure/key-vault/general/authentication Has anybody else done it? What’s your experience?

Good Morning, I have a quick question in regards to loading data and how it appears into Ataccama from a database. I did not see this topic addressed but I wanted to reach out and ask this and see if this question made sense.In the Knowledge Catalog, if terms are “table names” and attributes are “columns” as described in the documentation. How does Ataccama interpret duplicate attributes spread across separate tables of data? For example, how would Ataccama interpret two different tables that have duplicate titled columns within those tables? Especially if those column headers have different meanings across the tables. If any further explanation is needed feel free to send me a message.

Hi All,In my incremental table I am having 300K records which when I am trying to load in MDM, the server is getting crashed. Its running for 2-3 mins then throwing the error that “cant reach local host server”. We are in dev phase and using the local server. Some times it also throws the error “Not enough memory to load this page”. How do I fix this issue?I also saw the post for applying check points in full load but what about incremental load. How do we handle failures for incremental load and how can we optimize it more?Thanks. Your inputs will be much appreciated.

I have been given a list of emails that I want to transpose—converting the data from rows to separate columns—and then concatenate these columns into a single row. How can I do that in the IDE? Original Data After Transpose Final Output Note: All the emails will be unique, so I don’t want them to be grouped. Could you please suggest how I can transpose these rows into columns and later merge them into one single row?Thank you.Regards,Dhaval