Solved

Hello everyone, We recently upgraded to version 13.9.3, and gained the ability to export DQ rules from one Ataccama environment and import them into another. This works great, but I need to do the same thing for our monitoring projects. I would like to be able to export them from DEV and import them into a higher environment. Unfortunately, there doesn’t seem to be a plan available in my version to export monitoring projects. Has anybody figured out a way to migrate monitoring projects without recreating them in each environment? Alternately, I am considering trying to write my own plan. Is there any documentation out there on how to write the JSON for export plans? Thanks!

Hi, I am not able to access the transformation plan feature in v15.3 from both the Transformation Plan tab and from the monitoring projects tab. Can someone explain why is there a restriction on creating transformation plans and how can I get access to it? Thanks

I have a One Data table created by importing data from a .csv file. I need to use some of the data in this table by joining it with an existing Catalog Item by creating a SQL Catalog Item so that I can implement some rules on it. Where you select the source when starting to create the SQL Catalog Item I do not get an option to select oneData. Is it even possible to do this in OneWeb?

Hi, I have a question about the rule logic display when a section is applied. In the report view, I can see the rule logic/implementation when I select a rule. However, once I select a section and do the same, I can only see the valid and invalid results, not the rule logic. Is there a reason behind it? Thank you!

How to load result data from Ataccama ONE MDM to ERP systems like SAP?

I have a scenario where I do not want to deactivate the source party records in Ataccama, even though it no longer exists in the source. Is there a way to achieve this?

Hi All, Is there a way to parse a copybook file in order to transform the data file into JSON/CSV? The use case is to be able to provide profiling metrics on the web via VCIs? Thank you😁

When creating groups, are the names always public to everyone who uses the instance? Or is there a way to create a group of groups that only the members of that groups can see?

Hi all, I have a file with a ¬ delimiter and text qualifiers and in the file it looks fine but when I look at the local file system in Ataccama to bring the file into the catalog the ¬ shows as Z with an accent. Are there different regional settings in the config that need setting or changing or is this something else? Many thanks for any help Des

hi Team, i need to split a word based on a delimiter and try to add inceremental number to it, can you please help in acheiving this scenario. Input : select * from order;select * from customer output should be like select * from order - query 1, select * from customer - query 2 i itried using split operator , but could not able to append the incremental number

Hello, I am trying to use MPP step to derive some values from some free text field. I am struggling to parse any regex pattern for string like “A/B”. It seems to work but whenever there is / sign it just doesn’t parse it. I tried to escape it using \/ and also some other different options but nothing seems to work. What am I doing wrong? EDIT:Tried to parse similar REGEX against Regex Matching step and here it seems to work: Could it be possible that MPP step is parsing incorrectly? EDIT 2:I might have found the issue. I took Tokenizer part from our another component and it started working correctly. However, I still don’t understand exactly how Tokenizer works and the docs aren’t providing with great examples on how to understand it. Szymek

Please help/guide me on how to create parameters to enter values for a workflow in admin centre. I have an already configured workflow with parameters in Admin centre but I want to remove it. I am not aware of this change as it was made previously by another person. If there is some documentation in ataccama docs that someone could point me towards, that would also be great. TIA

Can we have duplicate source_id column values in mdm full load?

I created two Complex Delta Load file and this led to addition of related details in .metadata/md/co‎nnected_systems‎ But these two files don’t show up in the Admin Centre. Please tell me what can be done?

Hi,We have a use case to accept a request from collibra with details like JDBC URL, username, password and query to Ataccama and I need to return the results and size of the results in reponse from Ataccama.Can you please share usecase/documentation for implementing this usecase in Ataccama. Regards, Rohith

Has anyone experience of integrating Ataccama with Alation Data Catalog? I’ve searched the support and knowledge base article without any success.

Hi all, what about if I had a fixed width file in the catalog with the first row as the header (in error). The column data comes in as one string which renders it unusable for profiling and DQ. How can I get these types of files into the catalog so I can use them in my monitoring project? I have used VCI’s before to add headers to csv files in the catalog and they work well. Kind regards Des

I have created a workflow to call a component which is selecting data based on a value provided by user in the admin center workflow input parameter. To make it error free so that the user doesn’t input any wrong value for the parameter, I was wondering if it is possible to create a dropdown or bullet with accepted parameter values in the admin center so we could just choose the value and run the workflow? Please let me know if anyone has tried this. Thank you,

hi, i had a word like this “12345 - Data min”, i need to split this word based on - operator and get the first word. I had another requirement like split and save the words in another varaible ex : select * from emp;select * from customer query variable should have splitted value like select * from emp can you help in implementing above scenario

Hi folks, Is there some way that I can display a notification banner on Ataccama ONE and RDM, to notify users in advance of any platform maintenance? I’d like to notify my users in advance if we have any planned works, including and not limited to platform version upgrades, or RDM model updates.

Hi All, How can I use the file us_ca_firstname_synonym.lkp to create a match? Like Robert Smith should match with Bob Smith. I checked the file and for one name it has multiple synonyms. I can fetch the result in clean component but not sure how do I use that in Match component to generate match. Your help is much appreciated. Thanks in advance. Thanks FS

On the last 8 months we were working on deploy cloud resource to integrate databricks solution with ataccama dpe and develop jobs to execute on databricks and see the results on ataccama one. The deployment is executed on cloud provider side (aws - microsoft) and the configuration is manually so it takes time to set up with corresponding values, one of the task we would like to improve is the configuration of one databricks with unity catalog to be part of ataccama dpe. On past forums topics I saw helm is part of the tech stacks of ataccama and I am interested to know more about on. I would like to get more information kind of library to repository to understand helm on ataccama dpe. thank you

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

Hi, 13.9.4 In 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?