Learn & Share

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

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

I(Using admin creds) have assigned a user the role of “RDM-Work_DataEntry”  from Keycloak for being able to make an entry on RDM Web app. But he is not able to see any Table or View details on the web app, Can anyone help me with the mistake i might be committing. Which role should be assigned for the purpose of being able to add/remove/delete/edit entries on RDM tables on Web App/UI?Also, Where can i find the descriptions for all the roles that are available on the Keycloak to be assigned?

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 

I loaded a configuration with a new table to my organisations DEV PaaS environment and it dropped the existing tables in DEV. How do I rollback this transaction? Any help would be greatly appreciated

Hello community,I’m working on an RDM project which has the OnPublish implementation. However, I am encountering an error whenever I try to publish a record. The error message from the Action History states:The response message was:null and response error was 'errorMsg:Cannot get credentials for request.'I have checked all the database connections and the connection to the RDM web application on the runtime server, and there does not seem to be any issue in that regard.Is anyone familiar with this error and could provide assistance? Thank you in advance.

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.

Hi All,I am looking for the documentation around available Out of the box APIs in Ataccama which can be exposed to extract data out of RDM tables. Are there any available documentation or APIs provided by Ataccama to expose the reference data tables out of RDM via APIs.Looking forward for any directions here.Thanks,Chetan

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?   

Hi,   Is it possible to stop someone Publishing a row if they are the ones who “Moved it to Publish”? A team want the ability for all its members to create, edit and publish but restrict an individual team member from publishing a row they create or edit. Those rows would need to be published by another team member.  

When you use in ONE Desktop application the project synchronization with Git, you can in some cases meet with the error “The model project is not licensed for use on this machine”, followed by warning “Project signature is invalid”.At first glance, it seems there must be an issue with the license. However, mostly it is not the case, and the issue is related to Windows line endings, as Eclipse utilizes Unix syntax line endings.How to resolve this?Follow the steps below:In ONE Desktop select your project name (as an example further we use the project Reference Data Manager - Banking example), and click in the top menu panel to choose:File => Convert Line Delimiters To => Unix.   Uncheck Show only text files option and click Deselect All.   Open .metadata folder in the "Select files to convert" menu, select meta.mmd and manifest.xml files.   Click on the small arrow next to the .metadata folder to display contents, and click on the checkbox beside the libs folder to select all

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?

Hello, communityI want to implement an RDM solution where we periodically load the data from a database and import them to RDM in the published state. Each load could contain new and updated records.So I set the RDM Importer step to load data to CONFIRM state in the INCREMENTAL fashion (which as description state: new records are imported, existing records not present in the input file are untouched, matched records are updated).However, I encountered an error indicating the “Key” is already exist when execute the plan.Could anyone help me on this please? I’m not sure the incremental option only works for loading to EDIT state or do I need to setup anything additionally in the column section.Thank you in advance

Hello Ataccama community 😀Has anyone previously used the USERNAME column type in the RDM Importer or RDM History Importer? I want to specify the [ Username ] on RDM, indicating who made changes to each record in an automated fashion.However, I got an error telling me that unknown column 'username'; I tried using “USERNAME” instead of “username,” but still had no luck.Could anyone familiar with this help me please?