Learn & Share

HI I need to find duplicate tables by comparing the row to row from two or more than two tables. i have 300 tables i need to find duplicate tables. Please help to find this out

Hello, I have a rule looking for unique vendors that is tied to a monitoring project.  The monitoring project is running on a regular basis; however, the report is not showing on the report tab of the monitoring project.  This is the only project I’m seeing this behavior.  Has anyone encountered this issue?  We are on version 16.1.

How to add notification to all the rules in monitoring Project for all the catalog items and set alert at 95% at once instead of doing it manually one by one?

Last week we noticed that the export files we created for the summary results of monitoring projects are no longer generating and landing in our S3 bucket. The component/scheduler/workflow were all created by an Ataccama consultant and so we never tamper with these in ONE Desktop. One thing that recently changed is the way the DPE works with the monitoring projects. We were having trouble with scheduled monitoring projects running (they would always fail). Our platform engineer determined that the scheduled runs were going to the wrong DPE so he forced it to go to the hybrid-DPE instead. The scheduled monitoring project runs are no longer failing, but coincidentally the summary export files stopped working the same day that the scheduled runs problem was fixed. Could the change with the hybrid-DPE be the cause of the issue?

Hi All,toDate(Input, “yyyy/MM/dd”) function is not throwing null when I am passing value “1/1/1”. Input datatype is string.can anybody help why it takes 1/1/1 as valid date value?Regards,Shefhali

I’d like to default the referenced data display mode to “label” rather than “binding keys” as the default display mode option for all tables. See this link for details on how it is changed per table: Viewing Data in RDM :: Ataccama ONEIs there a way to accomplish this?

Hey y’all, I was wondering if anyone had a quality rule or advice on how to construct a quality rule to check a date type field for formatting. I know there is the “matches” function for strings and that you can convert a date field to a string using “toString”, but that requires you to specify a format, which invalidates the point of the rule.The desired format is “MM-dd-yyyy”, as shown in what I’ve got so far.matches("^\d{4}-(0[1-9]|1[0-2])-(0[1-9]|[12][0-9]|3[01])$",toString(ATTRIBUTE_1, "MM-dd-yyyy"))

Can someone share the list of different types of APIs available for reading and writing of Metadata and Data that can be used along with their GraphQLs ?

Hi,I'm currently working with Ataccama ONE and would like to access the MDM (Master Data Management) Web Application. Could someone please guide me on the steps to access it? Specifically:What is the typical URL format to access the MDM web interface?Do I need any specific roles or permissions to view or manage master records?Is there any difference in access for cloud vs on-premise deployments?What should I do if I don't see the MDM module after logging in?

Hello,do you plan to add feature for One Desktop regarding xsd validation of xml files? So it is possible to check if the xml file has correct structure.Thank you.RegardsVeronika

What is the exam fee for  Ataccama ONE v13 Data Quality & Governance Foundation Level certification for attendees who exchange a minimum of 12 months hands-on experience for the must have training? How can we apply for the certification exam? Is the application process online or offline? Is the exam proctored? 

Do we have any API that will trigger ONE Desktop jobs? We are doing some post DQ steps in databricks, we want to trigger ONE Desktop job from that notebook via API. Could anyone help me on this?

hi,I have a scenario where two columns ID and Value to be verified using DQ check together (like key value pair) against two columns of Table1 key (compared against ID) and name (compared against Value)I am using Atacama web, I see we can create lookup but it could be created only for one column and not both.Appreciate your suggestions here.Cheers!

I have a plan that reads a CSV file from my storage and writes the data to the Business Glossary page.What I Want to Achieve:I would like to enhance this plan to not only insert new terms, but also check for existing terms and update them if necessary to avoid duplicate If a term already exists and nothing has changed, it should be skipped. If the term exists but the definition (or any attribute) has been modified, it should update the existing entry with the new information. If the term does not exist in the glossary, it should be inserted as a new entry. Challenge:I noticed that some solutions in the community reference a unique ID for each term---community chat on bulk term update, but my business glossary terms currently do not have an ID field.Question:How can I structure the plan to perform insert, update, and skip logic effectively, What’s the best practice for comparing and managing term updates in this scenario?below is a snip of what my current plan that write only new pl

 Hi, I am using Ataccama One Desktop 15.4.0. In this case, I am creating a DQC (Data Quality Center) plan with an HANA database as the source. Now, in this database, I also have columns with GZIP data. I would like to unzip these in the DQC plan, but how? Unfortunately, the database does not have this feature. Such functionality does not exist in DQC either. Developing a custom step? It's possible, but apparently not encouraged by Ataccama. Perhaps you could recommend an approach. Best regards, Sergej

Hello, I am trying to make connectivity to ADLS in Azure subscription from One Desktop. What would be the Authentication token endpoin?

We would like to make a customised dashboard for observed data quality issues on a set of complex spreadsheets loaded into Ataccama via an S3 bucket. What are the best ways to create non standard dashboards rather than out of the box style data insights please?

Hello Ataccama Community,I'm currently managing a hybrid deployment of Ataccama ONE, where our Data Processing Engines (DPEs) are running on-premise while the rest of the platform is in the cloud. I've noticed that the ONE Data module is not available in this setup, and attempts to enable or use it result in errors or feature flags being disabled.Could you please clarify: Why is ONE Data not supported in environments running purely on hybrid DPEs (both cloud and on-premise)? Is there a technical roadmap or timeline for when ONE Data will be available or fully functional in hybrid environments? Are there any recommended workarounds or alternative approaches in the meantime for organizations that require hybrid deployment but also need ONE Data capabilities? Thank you in advance for your insights!

Hi, I need to extract metadata using One Desktop and store in Parquet file format in ADLS. Do we have any recommendations on how this can be achieved in One Desktop?

I'm working on workflows on my local machine and have set up a scheduler to trigger every 10 minutes. Each time the workflow runs, I would like to capture the following details from the job execution history, such as: Execution Date, Execution State, Executed Action ID, Details. I am using Apache Derby as my database and would like to store this information there. Please let me know if there is a way to retrieve the above-mentioned details and store them in my database.Thank you for your assistance.Best regards,Dhaval

Hi I am new to Ataccama and would like to understand the Sql Catalog Item feature provided in Ataccama web v15.4.I am trying to create a sql catalog item on a table and unable to save it to workspace → new folderI am curious to know what level of access is needed on Ataccama to save the SCI. Also would like to know where exactly the SCI and it’s metadata is stored.

Hi,How is data governance concepts used in Ataccama tool?

re: Duplicate record checking upon inputting new records into RDM-WebI know about setting up the uniqueness check and validations on the data once. I have users in the Web portal potentially entering duplicate values, can we set up uniqueness checks BEFORE they publish records. So, any record that is deemed duplicate (on 1 or more columns) would not be publishable. If this question has already been submitted/answered, please direct me there.Thanks,

Hi everyone,I’m exploring ways to automate the import of Qlik reports (or datasets exported from Qlik Sense) into Ataccama’s data management platform using API-based workflows. My goal is to ensure that reference data or analytical results generated in Qlik can be seamlessly ingested into Ataccama for further processing, enrichment, or distribution to downstream systems.From what I understand, Qlik offers REST APIs for data export and integration, while Ataccama provides robust APIs for job execution and data ingestion. However, I’m looking for practical advice or examples on how to best orchestrate this integration—specifically: What is the recommended approach to export data from Qlik (e.g., via Qlik’s REST API or by generating CSV/Excel files from the load script) and then import it into Ataccama using its API? Are there any existing patterns, connectors, or scripts that community members have used to automate this process? How do you handle data validation, error handling, or s

Hello,Looking for some help on using http proxy in RDM. We are trying to perform HTTP POST to external endpoint which is accessible only via proxy. Below param were added in JAVA_OPTS in onlinectl.sh file however   -Dhttp.nonProxyHosts is ignored and ataccama is pushing all https requests via proxy.!--scriptorstartfragment-->   -Dhttp.proxyHost=outbound-service-proxy.gateway.aws-euw1-np.mydomain.com \  -Dhttp.proxyUser=svc_nonprod_service_proxy_fdplife \  -Dhttp.proxyPassword=xxxx \  -Dhttp.proxyPort=80 \  -Dhttp.nonProxyHosts=localhost|127.0.0.1|*.uk-dwh.nonprod.aws-euw1-np.mydomain.com" !--scriptorendfragment-->