Learn & Share

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/

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

Does anybody need to ingest data into Ataccama by way of an excel file attached to an email?One of our business teams receive a “data feed” from an external supplier. It comes as an Excel attachment delivered by email.We have enquired, they do not have APIs. Excel via email is all we’ve got.As it stands, my integration will depend on the person receiving the email dropping the file into something like an S3 / ADLS Gen2, and for us to build a .ewf to poll the location regularly to ingest the data (into RDM).We’re on PaaS, v14.5.1 for now, soon to be v14.5.3.Don’t think the PaaS stack can automagically read emails and get attachments off. We’re not keen on the dependency on the person to drop the file into ADLS Gen2, but it seems to be my only option at the moment.Do I have any alternatives? 

We are trying to pass a csv file’s column which is generated from the Run DQC and contains a list of emails to the Send Mail’s “to” section. What are the other ways of passing a column to that particular section. Let me know if there are any alternative steps. This is the workflow planConfiguration of Send Mail:Regards,Emmanuel

we need to achieve completeness DQ control by comparing data in the file and the table irrespective of the position of primary key in either of them or by using composite keys. - This is in continuation with the query posted in ataccama community - Regarding DQ controls (ataccama.com) Do we have any step or document to follow on how we can import that file into ONE web app as catalog item and can we upload the file from local or we need to get that from the file system? Thanks,Karthikeyan.

I have created a rule that detects if a record is in the table more than once based on aggregation of 2 attributes in OneWeb application.  This gives a proper result in Invalid samples data and exports giving 2 errors if the record is in the table 2 times etc.  But the customer requires that only 1 record should be visible in Invalid samples and also in exporting to db.  It does not matter which one.  Is it possible to configure the result to do this?

Hi All,I have a scenario where I have loaded email table with 2 slightly different email data. Now next day source team sent the corrected data which is exactly equal to first data so the 2nd data gets updated but since it is exactly same it should get merged with first data but that is not happening. For email table we dont have any match rule. We just have defined a key rule on email address basically storing unique data for same load.First Loadid email 123 abc@gmail.com 124 abc1@gmail.com  2nd Loadid email 123 abc@gmail.com 124 abc@gmail.com  Now I have duplicate email data with 2 diff id. How can I fix this? I do

Our experts here can’t seem to get it to work even with support team’s help.  If you happen to have had success and are willing to share some of the details, it would be greatly appreciated.  

Hi Team This is the continuation of the of the below thread about using reconciliation project for comparing a file with the table.Compare data between file and table (ataccama.com) The data compare is working fine when I followed the approach suggested.  But from this link (Data Reconciliation Best Practices 👾 (ataccama.com) - it is mentioned as (except snowflake data).So, what will be the approach for the snowflake related connections. I have one more qu

Hello,I was wondering if someone has an idea to help my question about one of my DQ check. Basically let me explain what i have and what i want to achieve with them.I have; one list consisting 2 columns. Column A has unique values having 2 or 3 digits with a mixed combination of letters and numbers. Column B has names according to the column A. Here is the example: Column A Column B abc name1 abd name1 abe name1 abf name2 xy name3 1a1 name4

Hi  I want to search for a validation message on a field.For example if ABN is empty I can use Advance condition to write: ABN is null However in this case I want to search where the ABN contains a value which has a validation message attached to it, ie where an ABN field is detected to be incorrect as it contains either a dummy value, or it didnt pass a check. Usually these fields will be highlighted as they were scored higher in the cleanse layer in One Desktop For example ABN is 0000000000 at the source layer Is there a way I can search / filter records for their specific validation messages, as opposed to the content in the field. ( As the validation messages are not the actual input in the field, but score and explain what is wrong in the field) See photo attachedthanks 

Hi, I am getting this error while running the Load Operation for full load for one of the source system. Any help ,highly appreciated.