Discuss data, share best practices, learn, and grow with Ataccama's Community.
Recently active
What is the difference between ataccama one desktop and ataccama ONE?Β
Hi we are trying to connect to a AS400 source using JT400 jdbc driver for a customer and keep getting "Unable to initialize pool" is there any specific configuration we are missing in DPE? If anyone has done a similar connection in the past then please do share some inputs. Will be highly appreciated.
Hi everyone!Β In this post, you will find a curated journey to become a Monitoring Projects expert. Be sure to read all the way to find the community best practices & short videosΒ π₯Β First things first πͺΒ Β Watch & learn under 2 minutes β¬ οΈΒ If you have the basics, letβs move on ποΈΒ Β Β Watch & Learn under 2 minutes: Scheduling Monitoring ProjectsΒ More best practices from the communityΒ What are your best practices or use cases creating Monitoring Projects? Let us know in the comments π
I have a use case to use the JDBC writer step to write some data into a MS SQL db.I will need to use the Before and After script feature. (Truncate the table in the before script, then I need to call a stored proc in the after script).And in the after script, I need to construct that based on some value that I calculate in the plan. So it is different every time I run the plan, but I need to keep it consistent.Does this after script support some parameterisation? I have a feeling it wonβt but wanted to double check.
Hi Team,I need to upgrade my ataccama 13.8 to new latest oneβ¦. request you to please provide upgrade version download path or URL's.Β As I am facing some issue on current repository-Β Β ";Cannot instantiate class: com.ataccama.dqc.jms.sqs.SQSInitialContextFactoryβ
Hi everyone,Β Β Ever thought about where to start with DQ in Ataccama? Worry no more. Follow the journey we have created for you to take your first steps into becoming a DQ wizardΒ Β πͺΒ First things first -Β Start with reviewing our Beginnerβs Guides π§ Β Β Letβs try a few rules βοΈββΒ Β Β Explore some use cases and best practices from the community πΒ Donβt forget to check out our Training Resources page to access video resourcesΒ under 2 minutes on how to create a Detection Rule to Creating DQ Validation RulesΒ π₯Β Next up isβ¦Β Monitoring Projects - so stay tuned.Β Subscribe to our forum to not miss out on the latest articlesπΒ Β
Happy Friday everyone!Β We are here with the newest issue of the Data News Digest ποΈΒ This week on the news is a new researchΒ by Joseph McKendrick βTaking on the Data Quality Challenge in the Age of AIβ produced by Unisphere Research.Β New analytics and AI technology have been one of the highlights in 2023, if not the main discussion topic.Β There is a rising interest and high levels of investment from companiesΒ and while this research touches upon anΒ important conversation it feels like itβs just the beginning. What are your thoughts?Β Any news youβd like to share? Your take on the latest news? What would you like to see more of? Post it in the comments below π
I am working on template project for MDM and i am not able to run the pgsql script in it and i did followed the steps mentioned in thisΒ Β MDM Example Project - Ataccama ONE Gen2 Platform LatestΒ Kindly let me know if you have any solution for this.Β Β Β
When working with Reference Data table there may be a business requirement to control what kind of values can be input into a given attribute which are checked whenever a user creates or edits records within the RDM application. There are two kinds of validations:Β Β The first kind are called Instantaneous validations.Β These conditions, e.g., regular expressions or string size are checked automatically when you enter an attribute value. When the input value fails to meet these condition, an INVALID message appears next to the attribute field.Β The second kind are called Online validations.Β These are more complex conditions, which are triggered by clickingΒ ValidateΒ in theΒ Create detail/Edit detailΒ dialogue or upon closing them. Such validations are performed by DQC plans (using, e.g., phone number or address lookups) or SQL queries in RDM. When the input value fails to meet these condition, aΒ WarningΒ message appears next to the attribute field.Records which do not satisfy online conditions
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
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.