Discuss data, share best practices, learn, and grow with Ataccama's Community.
Recently active
Hi everyone,Β Β Are you just starting out with Data Governance or would like to brush off some of your skills? Check out our learning journey below and follow along to improve your Data Governance skills one article at a timeβ‘Β First things first:Β Letβs start with the basics πΒ Continue with the essentials πΒ Advance your skills πΒ Need some brainstorming? Check out our digest issueΒ π§ Β
I need toΒ standardize volume data in ml .Β Β I have data in galons,liters and mililiters . Can anyone please help me in this .Β Sample Volume DataΒ 450ml2L5galon2.8LΒ Β Thanks in advanceΒ Β Β
Hi, Iβm Oliver. a Solutions Consultant here at Ataccama.Workflows and governance are integral to any form of modern data management, be it MDM or RDM. But with so much to do in a typical workday, how do you respect the time of your end users and ensure they are informed when their input is required?Out of the box, Ataccama MDM and RDM include useful functionality to send emails to defined roles (i.e. groups of users) whenever records are moved through C(R)UD workflows. But what if we need to:Create consolidated, routine summaries for cases where data changes often and frequently? Allow users (e.g. project managers) who are not directly involved in the workflow to see progress? Notify users in different ways (e.g. Microsoft Teams, Slack, or Amazon SNS)? Create dashboards of daily workflow progress to report against?Once again, we can turn to Ataccama Plans & Scheduled Workflows!Β Notification WorkflowsIn this example, consider a pretend client using RDM, with a custom workflow whenev
Hi Team,In Ataccama IDE, while connecting to database we need to provide connection string. Also, username and password. In other tools like SQL server, we can use windows authentication to login so no need to enter username and password.Could you please help me how we can achieve the same integrated login for database connection.Β
Hi everyone,Β Β Learning new skills or starting something from scratch can be daunting sometimes. We may feel a bit lost in all the information coming at us or scroll endlessly in the search results. Thatβs why in this post, I want to create a how to get started with ONE Desktop journey, compiling all the articles we have published in the last months.Β According to your experience, you can jump a few articles or click on the one you find the most challenging at the moment. Please also do share yourΒ feedback and questions in the comments section ππ»Β Beginner Friendly - Learn the essentials:Β How to work with plans? akaΒ your canvas on ONE Desktop:Β Β Main elements of ONE Desktop π₯ππ§π¨Β Tips & Tricks:Β Β If you got the basics letβs move on..Β Β Integrations ποΈΒ Best Practices from the community πͺπ»Β Β Β Β Β Β
HTTP ERROR 404 Not FoundURI: /rdm STATUS: 404 MESSAGE: Not Found SERVLET: com.ataccama.server.http.ServletContextDispatcher-5eefa415
Hello everyone!I need to find all tables of attributes with no associated terms from the business term group: "FCB 360 Data attributes." The term "FCB 360 Data attributes" has multiple child terms.Is there a way to find tables that have no attribute of an unrelated term from the group of business terms: FCB 360 Data attributes. if it is possible to find at least with DesktopI will be very grateful for your helpπ€Thank you!
Hi all!In todayβs post, we will go a step further and briefly touch on the main features of the RDM. RDM and itsΒ features are without a doubt much more layered so Iβll be sharing links to further reading on each of the features mentioned ποΈBefore starting, I suggest you take a look at the first two posts of our RDM Best Practice series to get familiar with the solution if you arenβt already πΒ Β 1. Model and Metadata ConfigurationThe RDM metadata is the core configuration of the RDM project.Β The central reference data model swiftly configures critical processes, from integration interfaces to synchronization processes and relationships.Through the metadata model it defines all entities, structures, workflows, synchronization jobs, and more.Β For detailed instructions, refer to RDM Configuration.Β 2. Data ManagementΒ RDM seamlessly supports the complete lifecycle of reference data. It serves as the central authority for changes, ensuring consistency across diverse systems. Create, modify,
Πello,Β everyoneI need to find attributes that are not linked business terms specifically with the name of tables and attributes. Using the "Filter" tab, I wrote such a queryΒ schema is 'cli_dwh' and attributes.any(termInstances.count() == 0) using stepΒ ONE Metadata Reader, but it seems it takes only the schema but skips the business term, gives a list of attributes that are already linked to the business term. Can you give advice on this problem?I will be very grateful for your helpπ€Thank you!
Hi everyone!Β We are back with the second part of the introduction to RDM series. If you missed our first post you can find it here ππ»In this post, we'll delve into the fundamentals of RDMβcreating new reference data, editing existing records, publishing changes, and exploring advanced features like viewing modes and hierarchies. Let's get started ππ»ββοΈΒ How to Create New Reference DataLetβs go through a quickΒ example to demonstrate. Navigate to 102: Branch Table: Open the DATA section in the left menu. Choose Tables and open the 102: Branch table, showcasing a list of banking branches. Β Create New Record:Hit the Create button, unveiling an empty form. Fill in required fields, leaving Code blank. Validate your entries, correcting any issues. Hit Enrich to auto-populate certain fields based on predefined logic. Before saving, ensure your Address lacks the number 9. Save the record, acknowledging the warning prompt. Explore the option to create a new record from an existing one for ef
Happy Thursday all!Β In this post, we will break down and go through all the how-toβs of a functionality we all frequently use in Ataccama - access & sharing.Β Sharing access is an essential feature that allows you to provide access to other groups and users at the asset level. By default, only admins or users with the appropriate rights can manage access to data assets. This can be configured through theΒ manageAccessΒ operation settings for each node for each access level.Β Understanding How Sharing WorksΒ When you share access to assets with other groups and users, it's important to understand how sharing functions based on group hierarchy, user roles, and node inheritance. Here are some key points to remember:Notifications: When you share a data asset or make changes to shared access levels, users or groups involved will receive notifications about the access changes. User Access: Sharing access with a user or group grants access to all data assets shared with that group. The access
Hi everyone, and happy Monday!Β In this post, we will cover Ataccamaβs Reference Data Management solution with a short introduction, follow us for part 2 and check out our MDM Series below ππ»Β First things first.Β What is RDM?Reference dataΒ is data that defines the values that are used to classify and characterize other data. This is sometimes known - not always correctly - as Master Data, Golden Record, Golden Copy, or Single Source of Truth.RDM is an essential component ofΒ Master Data Management (MDM)Β that has evolved to become a mature data management discipline in its own right.Β Β Who's It For?At the heart of the RDM web application are three key player roles:Reference Data Stewards Analysts ManagersDesigned with precision, the RDM web application caters to these roles, ensuring a user-friendly and efficient experience.Β What Can You Do?The RDM web application empowers you with a rich set of features: View, Edit, and Manage: Seamlessly view, edit, and manage reference data, putting yo
Β Happy Tuesday community πββοΈΒ This week we have a series of best practices on all things components on ONE Desktop. Component steps, often referred to as simply "components," are instrumental tools that come with unique capabilities. Here, we'll explore what makes components special and how to make the most of them in your data projects.Β What Sets Components ApartComponents are akin to plans but with distinctive attributes: Reusable: Components can be employed repeatedly, functioning like steps within other plan files. Parameterization: Components can have properties within their constituent steps mapped as parameters, allowing external plans to interact with them (learn more in the section on "Mapping Properties as Parameters"). Console Launch: Components can be executed directly from the console, with parameters for added flexibility. Example: The Component in ActionComponent files are identifiable by their ".comp" extension and can play pivotal roles within your data workflows.
WE are trying to do some HandsOn by ourself. As part of it, we wanted the Atacama free version to be installed in Azure and our team can access it. Not sure whether it is possible and how to Install.
Hello folks,Β I am new for working atacccama tool. we are planned into data migration from ataccama 12.4.1 into 12.9.0 version. If anyone please guide me for tool upgrading
Hi everyone,Β Welcome back to our best practice series onΒ MDM. In this post, we're diving deep into theΒ features that make MDM - so buckle up πΒ MDMβs primary featureΒ is its model-driven architecture. It's a domain-agnostic MDM that empowers developers to craft domain-specific MDM models. Let's break down its high-level features by type.Β Model-Driven ArchitectureMDM's domain-agnostic approach is complemented by vertical models (metadata templates) designed to be domain-specific. These models are not cast in stone; they are customizable and extendable to meet the unique needs of your project. To delve deeper into this model-driven marvel, check out the Model.Β Internal Workflow and Processing PerfectionMDM boasts a remarkable set of features:Out-of-the-box change detection on load: MDM is a keen observer. It can detect changes in source instance records by tracking their unique source IDs. If a record has changed, it triggers the MDM process for that specific record. The granularity of de
Hi everyone,Β In this post, we will continue our introduction to Master Data Management (MDM), if you have missed our first post you can find it here ππ»This article will focus onΒ the architectural details of MDM, breaking down the components, dependencies, and practical management tips β¨Β The Pillars of MDMAt the heart of MDM, we find four essential components:Keycloak: Our third-party identity management tool. MDM Server (formerly known as MDC): The robust Ataccama MDM processing engine. MDM Webapp (formerly known as MDA): The user-friendly Ataccama MDM web application. Relational Database: The sturdy backend database, supporting PostgreSQL, MS SQL, or Oracle.Each of these components is configured as a Linux service, allowing independent restarts and individual log access for issue identification.Β The Backbone of DatabasesMDM is compatible with PostgreSQL, MS SQL, and Oracle relational databases. However, it's important to note that Ataccama officially supports only PostgreSQL Standal
Hi everyone, happy Monday ππ»Β After publishing more than 20 articles onΒ ONE Desktop best practices, Iβm happy to share that we are ready to take the next step into Ataccama's Master Data Management (MDM), a robust, scalable, and highly available platform designed to simplify and enhance your master data management tasks. Letβs start with the basics β‘Β Β What is MDM and how is it different?Β Unlike the traditional "data flow driven" Data Quality Center (DQC), Ataccama MDM stands out as a fully metadata-driven data processing system. It incorporates an array of powerful tools, including the Advanced Metadata Editor (AME), a cutting-edge data processing engine (NME), and the DQC Plan Executor (complete with its steps and components).By doing so, MDM naturally extends the capabilities of the DQC, offering comprehensive data quality management functionality. In essence, MDM combines Master Data Management with a strong emphasis on Data Quality as a fundamental part of the process, providing a
HiΒ I am not able to configure Ataccama Server. Can anyone help me on this?Β I am getting below message when I double click on βstart-server.batβΒ Using java at: "C:\ataccama-one-desktop-14.5.0\jre\bin\java.exe"Using DQC Β at: "C:\ataccama-one-desktop-14.5.0\runtime"Using java at: "C:\ataccama-one-desktop-14.5.0\jre\bin\java.exe"Using DQC Β at: "C:\ataccama-one-desktop-14.5.0\runtime"Picked up _JAVA_OPTIONS: -Djavax.net.ssl.trustStore=C:\Windows\Sun\Java\Deployment\trusted.certsPicked up _JAVA_OPTIONS: -Djavax.net.ssl.trustStore=C:\Windows\Sun\Java\Deployment\trusted.certsWed Nov 01 16:25:19 IST 2023 : Could not listen on port 1529 on host localhost:Β java.net.BindException: Address already in use: bind2023-11-01 16:25:20 [INFO] Β Β com.ataccama.dqc.server.bin.OnlineCtl messageId=generic_msg message=Starting server on localhost2023-11-01 16:25:21 [ERROR] Β com.ataccama.dqc.commons.license.LicenseManager messageId=generic_msg message=DQC license not verified! Program will exit.2023-11-01 16:2
I am following the tutorial toΒ install and run the latest MDM example projectΒ onΒ Windows.When I am starting the MDM Server using start-mdm-server.bat, I am facing the below error:Β Can anyone guide me on how to add a user role to Keycloak for this ? Keycloak demo version is being used in this case (Β Keycloak 21.0.1)
Iβve created a basic workflow that utilizes the API to execute an existing project/plan.Β The project had an post process component that writes the invalids to an Excel spreadsheet.The other steps in the workflow wait for the file to be created and load it into DQIT.Β We can write directly to DQIT due to an issue with Databricks/Spark.Β The workflow works great, but I need to manually execute it.Β Iβd like to us Admin Center to βSchedulerβ to execute the workflow.How do I do that?The environment is Azure / Linux.Β Β
I am trying to use Splitter to transform the stringExample : Input: BeWhoYouAreSplitter output - βe ho ou reβ - skipping the first letter as βUpper caseβ is the separatorDesired output - βBe Who You AreβHow do I achieve this? Also if the string is all lower how to split it?Example: Input: βbewhoyouareβdesired output - βBe Who You Areβ
Hi everyone, happy Wednesday!Β In this post, we will walk you through Model projects! Model projectsΒ play a crucial role in configuring various Ataccama products like DQ Issue Tracker, ONE RDM, and ONE MDM. These model projects are structured based on model templates, which define a specific set of nodes, folders, and files during project creation or import. It's important to note that you cannot modify or remove nodes created by a template.The configuration within model projects is developed using the Advanced Metadata Editor (AME). In this context, metadata refers to the configurations made within the model project nodes, which are used to generate plans, components, web service configurations, XML files, and other necessary components for a particular solution.Developing solutions based on metadata is carried out in the Model Explorer view, and detailed instructions for each product can be found in the respective Developer Guides.Every Ataccama build includes a default model project
πΒ Links to the legacy documentation portal are no longer available.Β Read about the changes and how to access our documentation here.Hi community!In this post, we will discover how to create server connections in ONE Desktop for various tasks and workflow steps. Read on to find out more πΒ How to register a new server?To set up a new server connection, follow these steps:Right-click Servers in the File Explorer and select New Server. Β Choose the desired Environment. Learn more about Environments. Β Provide a unique server Name and select the appropriate Implementation. Configure the server connection according to your implementation, and click Finish.Once registered, the new server connection will appear in the File Explorer tree.Please note that, during development, right-clicking the server connection and selecting Connect is not considered a valid connectivity test, and it's not necessary for enabling step communication.Β Implementation TypesGenericUse this implementation to conn
Hello. i have a general material data csv file, and in that i have to check for duplicates based on material data. Currently i'm trying with the matching step by creating partitions and key rules but still i'm not sure about it. So is there anyone knows about solving this process?? Thanks!
Already have an account? Login
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.