Data Quality & Catalog ⚙️

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

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.

I need the jar files to create a neo4j database connection from ONE desktop.Can anyone please help?

Hello,I want to use “SFTP Download File” and use a wildcard for the filename and a date.  Is that possible ?  For example :/<mydirectory>/input/MYFILE_<TODAY_YYMMDD>_*.txt When i enter an asterisk symbol in the  “File or Directory” section, I get an error. Thanks,Rene Requenes 

Can anyone provide a document or link on how to effectively navigate and interpret the logs in the OperSearch Discovery portal? Our client is using Ataccama PAAS. And sometimes we go to OperSearch Discovery for logs. I find challenging to understand. For instance, to locate runtime errors, I need to input "Kubernetes.container_name = runtime-server" in the filter section, followed by "error" in the search section. This will display any errors related to the runtime server. Otherwise, the log page appears to be quite intricate. Any help or link is very much appreciated.

HiI’m Using the Windows DQ Analyzer - free version.I have used the business rules functionality, but I have been wondering what the idea behind the “null” value is? And what makes data fall into the “null” value?Br.Gregers

Which ONE Metadata Reader entity type will let me read the all suggested business terms against all items?   

DPM and DPE - Ataccama ONE Gen2 Platform LatestOnce DPE connects to a data source, it creates metadata and optional sampling of records that do not satisfy DQ rules.Could you please answer the following questions or direct me to a link that can answer the below questions?1. Does DPE create other temporary files as a result of processing as well?2. What happens to the metadata, sample records that do not satisfy DQ rules and any temporary files generated during processing after the connection to the data source get closed?3. How does purging of data works in Ataccama?

What does the id mention in invalid_rules column in Monitoring Project Export refer to?the alphanumeric term within() after rule name as in the image belowIs this the ruleId of the rule? If not, what does this refer to?Is there a way I can configure Metadata Export step to give rule id?

The idea is to divide the invalid_rules column as obtained in export for Monitoring Project into two columns- one containing the rule name and the other containing the explanation; and implement this for all the rules mentioned in a cell.For example, The below cell would be divided into invalid_rule_name column containing two records-validation [USA] State and calidation[Noth America] Phone Numbers, and invalid_rule_explanation column containing explanation for the respective rules.The challenge I am facing here is that the rule ID mentioned in Monitoring Project report export is not the same as the rule ID mentioned in the list of rules I export; which I am trying to use to identify the rule in invalid_rules column from Monitoring Project report.Please help me find a solution for this

​Hello everyone! Foreword and problem statementThere are several subcategories of terms. I need to set up access for manager and steward of each subcategory so that:The steward of certain subcategory is able to create new terms, edit old ones in his subcategory only. However, he can not publish any changes The manager, in addition to above, can publish changes, but also in his own subcategory only.I have the list of questions concerning access management in v.14.2:Is it possible to grant ownership to node? And if it’s yes, how can I implement it? Do you know any way to solve my manager-steward task? (there are my understanding of the solution below) In States of approval workflowwhat are the “User roles” : governance or identity provider ones? (looks like the second ones, but doesn’t work) what is the “OWNER” for this version of workflow?_______________________There is a long prelude to where the questions came from. Version: 13.9There is the ability to create a special capability to b

METADATA MODEL The metadata model is used to configure the application entities and their properties. The Metadata Model describes the entities and their properties in the application.  Web Application) use the Metadata Model to create the frontend user interface. The metadata model is also responsible for the configuration of the left navigation menu of the application. ONE METADATA PROPERTY REFERENCESEntities consist of properties of Simple types, such as strings and integers, and Object types, which link the entity to other entities. ADDING NEW PROPERTY TO THE MMM MODELGo to left panel of the Webapp and choose Global settings   Choose metadata model under Maintenance CenterChoose the Custom filed where you need to add the new property to CatalogItem, Glossary and sources. In our case we adding to CatalogItem   Click on the Custom field CatalogItem. We can see General Information and Property. Click add property and type in the property to be added.   Fill in the name and choose the

Hello, I have a speed of profiling data for using Oracle DB of about 4000-7000 rows per minute.I use Ataccama DQ Analyzer (Version: 11.1.1.ga-2017-06-14).  Please, can you take me to advise me on how to increase the speed of profiling data for using Oracle DB?I hope to take the profiling speed to about 100 000 rows per minute...  Connation config:   Log:17.03.2023 12:56:04 [INFO] Switching to logging setup from C:\Users\ECHERN~1\AppData\Local\Temp\loggingConfig3307204922660014311.tmp17.03.2023 12:56:04 [INFO] Using following licenses:17.03.2023 12:56:04 [INFO] C:\Ataccama DQ Analyzer 11\runtime\license_keys\license.plf17.03.2023 12:56:04 [INFO] Using DQ Analyzer configuration file C:\Ataccama DQ Analyzer 11\workspace\sqb_prof_pilot\data\out\sqb_all_table.plan17.03.2023 12:56:04 [INFO] Using runtime configuration file C:\Users\echernoskutov\AppData\Local\Temp\runtimeCfg1065525328424309714.tmp17.03.2023 12:56:04 [INFO] Changing CPU affinity to 4 CPU(s).17.03.202

We are using some GraphQL to ‘do stuff’. Turns out the easiest way to find the GraphQL is using the Developer-tools in Chrome or Edge. See enclosed. 

What kind of MCQs are asked in Certification exam?

How are NULL’s considered? I have a case statement which gives the right value matching measure -used debug to test. But when it comes to matching rules, it skips the rule. Example:Name      NPIRamona  12345678NULL       12345678the 2nd row should match the 1st on NPI value and considering on of them is null.Even the scenarioName      NPINULL       12345678NULL       12345678these two should match together based on NPI. I do not see a special character. If I replace NULL with a value ‘A’ , they match with rule Matching on NPI. but does not work for NULL.  Any thoughts or suggestions appreciated. 

Hello, I’ve got a question while using DQ evaluation rules.I have been creating rules with valid and invalid messages but just the invalid message at the end does not display as intended. But when I view this in the results tab it just says OTHER as the explanation.    Is there a workaround to this problem? Should I edit my rule logic to include some specific condition and leave the rest to fall under the ‘IF none of the conditions above apply THEN’ TIA for the replies.