Learn & Share

Hi everyone, I was wondering if anyone could share how the i_event_log table is configured, as well as its details for the front-end (UI)? Also, could anyone provide guidance on how to configure the back-end audit log and retrieve it using pgAdmin? I’d really appreciate any insights. Thank you!

I have been trying to explore the Reprocess and Rematch options in MDM.From this post I understand that Reprocess is used to reprocess the records. For example, lets say, after an initial load where the email values were not being modified in contact_clean.comp, we are now to determine which emails have the domain company-name.com and are now being updated to have domain companyname.com . So, I need to run the reprocess job.Rematch is to run the match step on top of the reprocess since the email values have been modified. What I do not understand is do I run a rematch job only if the email value participates in determining the master record or do I need to run it whenever the reprocess jobs is run irrespective of the changes that took place due to a reprocess?There is another question I have. When we run a load job, the change detection is done right. Does this change detection run on all the records or just the delta records. Post the change detection, matching and merging is run only

Hello All,I am using group aggregator in our plan but I am not sure how to make all the columns flow from input till the end/output through group aggregator. 

Hi,Could someone guide me on creating rules for the Productline field? I am following the lab exercise but am unable to find the option for selecting "is not from reference data."Any guidance would be appreciated.Thanks,Shikoh Zaidi   

I have 10 excel sheets, which need to be combined in one single excel sheet. can this be done in Ataccama?

I have a column in my catalog item which contains sensitive data. I have tagged this column with a Business Term. This business term is tagged as PII in Data Protection Classification section in Glossary terms. Is there a way to show at catalog item level that this table contains PII data?

Hi everyone, Data Observability tab and AI functionality  are  not available. How can I check SCD Type 2 using DQ rules?Data Freshness. How can I check  using DQ rules? Datetime datatype is for eff_strt_dttm, it’s one column where data is, but I don’t know how make:   today() >>>as datetime  minus 1 day   

Hi guys! Is there any opportunity to check data freshness in case we have Redshift connection?I see there is no such driver in freshness configuration drivers list - https://docs.ataccama.com/one/latest/data-observability/data-freshness-custom-configuration.html.  

Need support with AQL expression to filter terms based on a particular relationship type. Referring to Relations section under Glossary Terms.  

Hi ,I am trying to access “Monitoring projects” through API calls. For this purpose , I have created service account in KeyCloak with ‘default” and “DQIT_admin” IAM role access. Able to generate tokens with the service account. But unable to access “Monitoring projects” API , receiving 401 “Unauthorized” response.2 questions:How to check whether this service account is able to access the Ataccama application or not ? Any other or what level of access rights need to be provided to access API calls for a service account?Please note I am using Ataccama web application version 14.4.  

HiI would like to ask whether we could do fuzzy check in Ataccama that involves two different datasets let’s say Set 1 and Set 2 from different data sources. Please note that both datasets have different number of columns but fuzzy checks involved only customer name and address. However, these datasets don’t have any unique identifier. Is it achievable in Ataccama and what would be the possible steps to achieve the results after the fuzzy checks? Thanks.

Hello everyone! I currently have a large group of catalog items that I am trying to assign a Data Usage Licensing Agreement too. I know that I can manually add these through Atacama online, however because of the large number I was wondering if it would be possible to create a plan to do this for me? I have all the catalogItem ids already compiled I simply do not know how to assign the policy.While I do see the option to write to policy, I cant seem to set the parent as a catalog item. Any help would be appreciated. Thank you!!! 

Hi ,Could someone guide me on creating rules for Name field.Rule : Name should not have any special characters but can have numbers and spaces. Ex: Jhon Leo - ValidJho1 Leo - ValidJho( Leo* - Not Valid  Regards,Bhuvi

Hello all,I’m using the Ataccama v14.5 there we have created the custom entity for classifications and created the classification types (Internal, Public etc) and added them with tables and attributes through the One Desktop plan. But when i am using the same plan to delete it from table or attributes just by changing the One Metadata Writer property in General tab “workflow state as deleted” and in the Columns tab providing the “Id Column Name as table_id” then it is not deleting anything. Any guidance or suggestions is really helpful. Thanks.General tab Screenshot:Columns tab screenshot: 

Hello, i have a report that we usually saved to hard drive that i would like to bring into Ataccama, the report is in semi structured format . does ataccama accept or work with semi structure data ?or do i need to convert the report first before connecting to source ?

Hello, does anyone faced with issue when primary key/ nullable/ column size fields are gone after refreshing catalog item and rerun data select?I use ONE Web app v14, after setting attribute as primary key, nullable or defining column size then it disappears after  rerunning query.How did you solve this issue? 

Hello guys, does someone know where I can find the information about all functions list that are available from Advanced builder while creating DQ rules? Will appreciate any help or advice, thanks.

Hi ,Kindly share your inputs on below scenario.I am trying to place the “Monitoring Projects” export  “.csv” file in a shared path/folder with in the organization. Purpose of this “Report need to accessed by different set of stakeholders who do not have Ataccama access” Is there a way to access this export file by any API calls or we can directly configure the shared folder path for example “S:/SharedPath/Ataccama/Exports” in output location field ?  Note : This is on Ataccama ONE 14.4 version. Any input is appreciated. Thanks,Bhuvi

Hi,Could anyone help me on below scenario. I am using Ataccama ONE web 14.4. Millions of records are populated in testing environment from Production real time data. However , for testing purpose manipulated few 1K records. Is there any way in Ataccama where we can apply rules and perform “Monitoring Projects” only to the new records 1K created by giving any date created filter? Regards,Bhuvi

In the above image I want to clear all special characters expect .(dot) As their can be any thing in place of  ! number may have *, &, %, $, etc. I tried it using trashnondigit() function but it will remove all the characters from the number, Is their a way to do it?

Hi everyoneCould you please advice if there is any instruction how smpt server can be configured for e-mail notifications?Where we can perform this configuration? Is there any option in Ataccama ONE web? I have checked this part of documentation MMM Configuration :: Ataccama ONE but it is still not clear where mmm configuration can be done

Hello all,I am on v14.5.3, so I haven’t seen the Data Slice feature hands on yet. Been reading the documentation on the Data Slice and its use in the monitoring project. Say for example, I have a table of transactions, and I have some statuses:Pending Active Inactive Cancelled  Let’s say I have the following rules and the respective slices they need to be applied on:Rule 1 Status = ‘Active’ Rule 2 Status in (‘Active’, ‘Pending’) Rule 3 Status = ‘Pending’  Is it then possible to create an ‘Active’ slice, and a ‘Pending’ slice?And then in my monitoring project, I add my catalog item, then I apply my Rule 1 to the Active slice, Rule 3 to the Pending slice, and Rule 2 to both the Active and Pending slices? Or something like that? Trying to gauge how we can use it, how much maintenance overhead there will be and the effort to try and start using this feature. Any insights from people who’s already using v15 much appreciated!