Learn & Share

Hi everyone!Today, we’ll be sharing a tutorial and guide on how to configure "reporting metadata structure" and "bulk import" to the Ataccama ONE Gen2 metadata solution using two different methods. This is workshop is targeted for advanced users.Hear from Ataccama's VP of Platform Strategy, Marek Ovcacek, as he goes over what it means to explore lesser-known but very powerful functionalities of the Ataccama software and teaches users how to best integrate them to create their own custom solutions. *Ataccama platform and functions featured here are reflecting the time the video was published.Please don’t hesitate to let us know if you have any questions in the comments below 👇

Hi All, Our requirement is to use an api call for removing a cde term and adding another cde term associated to a rule.we thought of using PUT /rule-versions/{id} api. However some points we noted. in one webapp for the ruke, if we remove cde and add another cde, the rule gets created as a newer version. We just want to update the existing version Please let us know which api we can use?

Hello!My team and I are working on connectivity to be able to pull rules down from the web version into the Desktop version, make some minor tweaks, and then reupload them back to the Web version. Is this possible? We have our ONE platform connected to our desktop and can see all of our catalog items and rules, but when I try and drag a rule into a component / plan or make any changes, we get an error and we can only view the rule. Has anyone ran into similar issues? Or are we attempting to do something that the Desktop version does not support? Any answers would be appreciated, thanks!

Hi, In Ataccama web there's a way to set a certain treshold about validity when monitoring (default is 70% I believe). Is there a way instead of percentages to have it as raw number of records?Basically the idea is that I want to see the treshold met when (example) 100 records are met. The amount of records added to the dataset varies hence percentages might not work for me.Currently I have 1000 records. 100 are invalid. Treshold could be set to 10%.But if overnight 4000 records are added totalling 5000 records then 2% is invalid, assuming the invalid numbers stay the same. In the ideal world I want to be able to make a choice whether I want the treshold to be set through percentages or raw number. Because in this scenario I'd still like to be given a notice 100 records are invalid.

Hi All,I would like to map keycloak roles present in gen1(12.8) to gen2(13.9/14.3).Has anyone done this activity while migrating Ataccama 12.8 to 13.9/14.3 version? Thanks,Parvesh Soni

I am trying to apply a rule on a boolean type attribute to find if the value is “Ja” or "Nee”. However I couldn’t  achieve the expected outcome with advanced expression as its a bolean type. Also looked in to the documentation for one expression.Any suggestions to get the similar results with boolean type attribute?

Hi,Situation: I wrote a(n) SQL catalog item joining multiple tables and in Ataccama I'm using rules to compare the values if they are the same. LONG = LONG, check if the nr_loan = the same a.nr_loan, etc.My question is if there's an easier way to see if two tables are identical. I'm doing this to check the integrity.I couldn't find anything relatable asked in the community.  

Hello all, is there anyone who knows about creating a rule to detect the duplicate records of a particular attribute and mark it as duplicate using one web?

How do you extract the catalog item with their associated terms (final) in a report?

Can Ataccama connect tot SQL Server Analysis Server?

How can I set-up email in workflow? I am using Microsoft 365 Please help

Hi everyone! This week, we are continuing to explore the Ataccama ONE platform basics. Today, we are looking into Tasks and Collaboration. Collaborate with Your TeamCollaboration plays a vital role in any project, and ONE DG makes it simple for you. You can easily comment and initiate conversations with your team members by using the comment section. To notify someone specifically, just tag them using the "@" symbol. You can even add emojis and gifs to make your discussions more lively! Don't worry about missing any updates - you'll receive in-app notifications whenever someone tags you or responds to your comments. Streamline Your Workflow with TasksThe Task management system in the Ataccama ONE Platform helps you keep track of your work and ensures efficient progress management. The system organizes tasks into a Kanban Board, providing a visual representation of your workload. With tasks, you can perform the following actions:Create and manage tasks and their subtasks. Assign tasks t

Hi Everyone,      My DQ and KeyCloak is running integrated for authentication but the password in the attribute name=”truststore-password” is using password without encryption.    I tried to encrypt via command encrypt.bat on DQ  but  without success. I just have a success in the authentication using clear password.    Is there someone that have success to encrypt the value for the property truststore-password with keycloak? <config class="com.ataccama.server.keycloak.KeycloakDeploymentContributor">        <keycloakConfigs>            <keycloakConfig name="keycloak-admin-center.json">                <!-- Define common parameters for all clients. They can be overridden by client-specific settings.-->                <url>https://srvkeycloak:8446/auth</url>                <realm>ataccamaone</realm>                <attributes>                    <!--<attribute name="ssl-required" value="external"/> -->                    &lt

Getting the above error when I tried to run a comp which uploads the terms from excel workbook to ataccama. Please help! @anna.spakova  

Hi all! Hope you are enjoying our getting started series 😎 In this post, we will cover Business Glossary and learn more about Business Terms. Business terms play a crucial role in analyzing data, as they provide the basis for evaluation and quality checks. You can establish expected values and gain deeper insights by assigning terms to specific data elements. The Business Glossary automatically maps these terms to real data sources, ensuring that your catalog is always up to date and synchronized with the latest assigned terms. Plus, an unlimited hierarchy structure lets you visualize the relationships among different data elements, systems, and processes. Let's explore the different types of terms you'll encounter in the Business Glossary:Business Terms: These are predefined labels that help you understand and organize your data. They are assigned based on set conditions. Custom-Created Terms: This term group allows you to create your own terms according to your specific needs. For e

Hello all, I have a task of detecting duplicate records from particular tables. So is there anyone who know about creating rule for this, a rule to detect duplicate values and mark it using One Web and One Desktop?

I have a workflow(.ewf file) which in turn calls several components and workflows. How do i run the workflow and get to know the trace of which all components and workflows are executed?Is there any property that can be enabled which will give the components and workflows that are getting executed? If there is some kind of information like input to each step and output from the step that also would be useful 

From the ataccama one url, click environment settings, create environment we have the below properties executor endpointadmin centerexecution mode then we have the option to add a datamart, with a jdbc string.  What exactly is the executor endpoint, admin center and execution mode?is the datamart a place(database) to store something from the executor(server)?Please provide some links which explains this.

Global runtime configuration (GRC) is the answer to the following questions:How to upload DQ results from my monitoring project into a database/other data source instead of CSV file? How to send my DQ results into PowerBI to create some nice reports?  How to connect to my data source from a VCI if this data source is not supported from the Catalog?These three questions are the most frequent use cases for using the Global runtime configuration. It allows us to define additional connections to databases, servers (e.g. MiniO or S3), APIs etc. and perform different kinds of operations with it - like save our DQ results in a post-processing component to a database or upload data from additional data sources using the VCI (Virtual Catalog Item).How to create a Global runtime configurationThe GRC is attached as a parameter plugin.dqc-support.ataccama.one.dqc.runtime-config.default in the DPM application.properties (or using the Configuration Service). What is very important, the GRC is an XML

If you just configured the integration between Manta and Ataccama and have no experience using it, here’s your guide to getting started. Integrating Data Sources First, you’ll want to turn on the integration for the Data Sources in your Ataccama Knowledge Catalog.If you are creating a new data source in ONE, simply mark the checkbox Enable Manta Integration in the Connection details. This will automatically propagate the new source to Manta. If you want to integrate an existing source in ONE, go to Source >> Connection >> Edit and mark the Enable Manta Integration checkbox and Save. To confirm that the Connection is successfully propagated to Manta, check that it appears in the Manta Admin UI (Connections >> Databases). You might have some data sources connected directly to Manta - it’s fine to keep them alongside the ones propagated from Ataccama. Note that when you trigger Calculate Lineage from the Ataccama ONE app, the Manta workflow will execute lineage revision