Learn & Share

The performance of one of the subject is bad. This what is happening.A new or existing records loaded and it runs matching against 1000 records (one master and 999 slaves) because they are similar and have same master_id 123. So if we think of overall if 500 records are loaded during an incremental load and each have similar conditions, its ending up touching 500000 records and taking several hours. IS there a way to make the record only try to match against the Master record? or other ways to improve the performance? Please suggest. Thank you.

Hi Team ,Can anyone please help me setup my MDM environment locally .Please help me with the plugins and folder structure .Regards,Kundan 

One of the most common data sources that our users connect to are relational databases, e.g. Oracle, MSSQL, PostgreSQL, etc. For those sources, we usually recommend using JDBC drivers to connect, and use JDBC Reader and JDBC Writer steps to work with the data.But for big data sources, e.g. Databricks, within the Ataccama ONE Desktop environment there are a few different steps available. Ever wondered which one you should choose? Hive Reader and Writer:Hive Reader and Writers are the simplest to configure, but also offer the least options. You will need to specify the exact database, table and column names you want to read from / write to. For the Reader step you can provide some simple where clause in the Filter. Spark SQL Reader:For more complex SQL queries, you can use the Spark SQL Reader. This

Ataccama detail document on what all can be done related to snowflake like can we pull tags from snowflake connect to snowflake console from Ataccama?is there any blog or document available on the same. Any limitation related to that

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.

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”

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

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 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. 

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!

Н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!

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. Use