Solved

I need the party entity (MDC -ataccama one) to send a notification to kafka when insert or update

Hi, We have a problem in a workflow in DQC, with task “Send Mail”, because the generated message is incompatible with the internet message format RFC 5322. When there are at least 2 recipients, in the generated message, the header “to” is duplicate as many times as there are recipients, but the RFC 5322 standard does not allow this. How to correct this problem ? Thanks for your help.

I have Ataccama 12.x version and I do not see their Aggregate function Please help, how to get it enabled or patch it Thanks, Mukesh

Hi Team, I have few data loads that read data using API’s and writing to Snowflake tables. Often the data is incomplete & inconsistent. Im checking if I can use Attacama to compare the data between different snowflake schema’s : eg) Raw vs Curated? I understand we can write SQL Execute (select col1 from Tab A minus select col1 from Tab b and create a plan. But i have 500+ jobs and needs a lot of plans to be created. Looking for correct way of doing this?

We created a number of data quality business rules that will fail records from the source file we are reading. 1.5 Million records. How do you port the failed records to a flat file? There is no drill down in One Desktop so we are having issues getting business users approval on code without seeing the failed records?

Hi Team, I have bunch of queries sitting in my Oracle tables(queries in one of the column). I am trying to see if I can read the oracle table as source and use the column values(which has sql queries ) to be sent to database & get return value. Is there a component that can help me achieve that? jdbc reader, sql execute components expect you to hard code the query. But in my case the query will come as value from one the table. eg) Col1 Col2 1 select count(*) from tab A 2 select count(*) from tab B In the above example I wanted to use col2 as input and pass the values from Col2 to DB and assign the output to next transformation. Hope its clear.

I have a rule binded to 2 columns in a catalog item. By mistake i have changed the data type of those columns without unbinding the rule. Now i am unable to unbind thise rules from that column.i am getting error while saving or publishing the project : server refused sent data as invalid. Please guide me,what i will do here

We are trying to connect Ataccama with Python code. Could you please help us with what are the possible ways to connect with python, it would be really great if you can share us with any reference links or docs. Thanks in advance.

Hi Folks, I’m super-new to Ataccama - in fact I haven’t even had a hands-on yet. Curious to know whether we can embed content from Ataccama onto Confluence pages via an API or something? Anyone done this before? Mick

Hello there, Please, when sending data about a person to MDM, can we differentiate this data between VERIFIED and UNVERIFIED? I mean, unverified DATA should be stored, but it should never overwrite the existing verified data in MDM. Example: User ELON MUSK, 60 years old, elon@tesla.com, California , etc is created as verified data in MDM and master-ID ABC is assigned to his record. Months later someone tries to create a profile and the data is not yet verified, that data would be ELON MUS K K, 58 years old, elon@tesla.com, Texas. The end result coming from from a “GET” should be ELON MUSK, 60 years old, elon@tesla.com, California, master-ID ID ABC It would be OK to MDM store that UNVERIFIED Data somewhere, but it should NEVER overwrite VERIFIED data nor consider UNVERIFIED information as correct data to be returned to MDM callers/consumers. I know that other MDMs keep unverified data separated of VERIFIED data, I would like to know what is the recommended way to do this in Ataccama. An

Any one can help to create this template using version 13.6? It show the items clearly. Our users can know the data presentation without explanation. However, I can find this template in our current version.

Any best practices for using the Purpose function in Ataccama One (webapp)? I see that it is recommended for monitoring projects but when I create a monitoring project I want to be able to search for that tag. Any tips for searching just based on the purpose tag? I’m very new to Ataccama so any and all tips would be appreciated!

I’m trying to read the file name of a file so I can write it in an email within a Workflow. I’m using the “Operate On File” task. The Operation I selected is “INFO”. I then point to the Source File. Next I’m trying to determine which variable I use to supply to the Send Email task. The Operate On File Documentation says you can use task variables and the example they give is “name”, “localName”, “size”, and “timestamp”. When I try using these variables in the Send Email task they just come across as blank in the email (variables appear to be null). Here is the body of the email I’m using: Name = ${name} localName = ${localName} Two questions: Does any one happen to know what I’m doing wrong in above? Additionally is there a way to pull out a file name within a Plan. I’m using the “Excel File Reader” step. I want to pass along the file name in the flow so I can use it later on. Thanks!

Hi, I’ve just started data profiling with Ataccama One so please bear with me. I have data with technical IDs (e.g. “000123456”, “009876543”,...) in a csv that I imported. The IDs are however interpreted as a number. How exactly can I change the attribute type to text? I have done so when importing the file: but it seems to go to numbers nonetheless. The original file has comma-separated values that are all between double quotes. Thanks for any help! edit: typo

I am getting the error “Column Name cannot be empty” under StringValue. When I click on the drop down, there’s no options available.

Hi, is there a method to make a “wait n seconds” between 2 steps? Thanks a lot

I opened the on-prem AtaccamaONE environment this morning and was looking at recent (auto) profiled catalog items. A majority of them are not found - the error is “Catalog item not found” and the provided explanation is “This catalog item doesn’t exist anymore or someone has revoked your access”. Neither of these cases should be true as I am the only one who currently works in the environment and I’m the one who launched the data discovery on 3/09. This is a recent error - I have not seen this before. Any help you could provide would be appreciated. Thanks.

How can we use functionality like ‘for’ and ‘while’ loop in detection rule field while writing/creating rules for capturing data/records.

Hello, I’m new with Ataccama and I have a simple problem. I want call a Rest service: https://api.bulkemailverifier.com/api/a/v1?key=xxxxxxxxxx&email= myemail.com I’m using the JSON Call step and If I put the full URL with my email it’s working, but now I want read the emails forma txt file and I don’t know how to make the url dynamic. In the step I have 3 parameters: URL: Resource I set it as https://api.bulkemailverifier.com/api/a/v1?key=xxxxxxxxxx&email= Method: GET URL: HERE IS WHERE i DONT KNOW WHAT TYPE. I have tried a lot of combinations without success The input file has one column with the mail: src_mail Thanks

Hi, Am exploring Ataccama MDM and would like to know if Ataccama MDM supports Multiple language in matching and data maintenance. Appreciate your help. Thanks. Vinoth

How can we download files from remote path ( connected through vpn) on to local? I tried with Operate on File component but it is not working. Is there any work around for it?

I was wondering if there is a way in Ataccama that I can move my rows data into columns? I’ve data as such: Element: Dimension: Values: Code: XYZ Validity 200 678 XYZ Completeness 250 678 YUP Completeness 300 555 HIO Accuracy 400 100 I’d like it to look like: Element: Validity: Completeness: Accuracy; Code: XYZ 200 250 250 678 YUP 500 300 300 555 HIO 200 450 400 100 Thank you!

We would like to have a user group in AtaccamaOne so that when new people join, we do not have to manually add them for access of rules, catalogs or projects. Simply adding them to a user group should give them all the necessary access. How to create such a user group?

Hi there, Imagine Ataccama is the primary source of truth (transactional) for PII information inside a Financial Service company. Now, we would have different ONBOARDING systems (one for each Financial Line of Business that we offer). When a new person tries to create a profile, the Onboard system would (while the user is still looking into the APP) SYNCHRONOUSLY call an Ataccama API with meaningful data that we collected from this person, say: (Full Name, DoB, Insurance Number / Any other ID document, Email(s), Phone(s))m then Ataccama would quickly do the “Match” and return if this person (according to the information we provided) is likely to ALREADY exist. If the probability is higher than some threshold (Ie. 95%), it would also return the MASTER UUID for this person in Ataccama (Lookup key). Then the onboarding would ask this person to log in, as this person ALREADY exists in our Ataccama Database. Can Ataccama do the MATCH and return the % probability in near real-time? Instead o

Hi, I am creating a plan under IDE to group the records on the basis of two column values and then to calculate the sum of all common records having sales value column. I was using Group aggregator step but no luck. Could you please suggest any help. Thanks