Learn & Share

Is there any way that we restrict accessing the data that are imported to Ataccama Thin client ?, as we do role based access , we are able to see all others catalogue items imported into Thin Client.Such catalogue item view breach the data classification compliance which is managed in main data factory where we store the data.Anyone suggest here your thoughts to how restrict the data by giving right access / restriction while we importing the catalogue item or any measure we can take to restrict in viewing the catalogue items within Thin client w.r.t catalogue item import owner?  

Hi Team,When trying to login in ataccama web URL, receiving below error:Could you please help me here?As all compeonts like DB, leyloack, MDM server, MDM are up and running successfuly.-----------------------------------------------------------Error in MDM server ------------------------------------------------------------------WARNING: An illegal reflective access operation has occurredWARNING: Illegal reflective access by retrofit2.Platform (file:/D:/Ataccama/mdm/lib/retrofit-2.9.0.jar) to constructor java.lang.invoke.MethodHandles$Lookup(java.lang.Class,int)WARNING: Please consider reporting this to the maintainers of retrofit2.PlatformWARNING: Use --illegal-access=warn to enable warnings of further illegal reflective access operationsWARNING: All illegal access operations will be denied in a future release2023-08-07 15:26:23,797 ←[34mINFO ←[0;39m [][][restartedMain] ←[36mn.r.s.b.l.a.LogbackAccessContext:149←[0;39m - Configured the Logback-access: context=[default], config=[classpat

How can we implement concatenation of the last 10 rows in a column?I am looking for a way of storing previous values in a variable and adding the current row value to the variable like that.

As per requirement I want to read a marker value from a file and pass that value as parameter in select SQL of a JDBC reader to pull only delta records. Is this possible in 13.9.1 version? Please advise with documentation link if available.

Howdy all!I said in another post today that it was going to be short. It turned a little longer than I expected. This one might be a little shorter.Question: How do I find the XML that makes up my “.online” files for Enrichments?Steps:Start all your services, and ensure you have deployed your Configuration in the Admin consol (localhost:8060/admin) Go to localhost:8061 Under Server, select Applications Click on the Application “.online” file you are wanting to see the XML for Click the service you want to view the XML for in the next screen Then select the link for the XML SchemaThe data in here can help to find errors in the setup of the service! Enjoy!Jason R.S.

Hi All,Receving below error when trying to login in ataccama URL: Need help on this? WARNING: An illegal reflective access operation has occurredWARNING: Illegal reflective access by retrofit2.Platform (file:/D:/Ataccama/mdm/lib/retrofit-2.9.0.jar) to constructor java.lang.invoke.MethodHandles$Lookup(java.lang.Class,int)WARNING: Please consider reporting this to the maintainers of retrofit2.PlatformWARNING: Use --illegal-access=warn to enable warnings of further illegal reflective access operationsWARNING: All illegal access operations will be denied in a future release2023-08-07 15:26:23,797 ←[34mINFO ←[0;39m [][][restartedMain] ←[36mn.r.s.b.l.a.LogbackAccessContext:149←[0;39m - Configured the Logback-access: context=[default], config=[classpath:logback-access.xml]2023-08-07 15:26:25,274 ←[34mINFO ←[0;39m [][][restartedMain] ←[36mc.a.l.s.s.e.KeyProvidersSpringBootAutoConfiguration:41←[0;39m - messageId=createDefaultKeyProvider encryption=INTERNAL, reason=the 'internal.encryption.keyst

How to implement a DQ rule to check if an attribute's value is present in another attribute (for eg. Attribute1 'Product' value is present in Attribute2 'Quantity' field) using Thin client

Hi All,Require quick help on ataccama IDE, I am not able to see .metadata folder in IDE. What is issue here?Please find attached screen shot ?Please help me here? 

Hi everyone! In the last part of Monitoring Projects Configurations, we will talk about how to easily import configurations from one monitoring project to another, making your data quality monitoring more efficient. If you’ve missed Part 1&2 you can find them below:Import the Configuration Instead of creating a new project from scratch, you can copy the configuration of one monitoring project and apply it to another. This is particularly useful when you want to replicate settings from a testing environment to a production environment. The copied configuration includes all checks, invalid samples, reports structure, and DQ filters.To import the configuration:Navigate to the project where you want to apply the configuration.   Expand the more options menu and select Import configuration. Choose the monitoring project from which you want to copy the configuration, from the list provided. Check if the preselected catalog items are correct. You can modify the list by deleting items or

The source csv file has splitted into 13 rows for each actual row in target.By using Ataccama one desktop we would like to pivot the data by sending source 13 rows into one row in target. I am trying to implement the logic below in the Text file reader step but it's not working . v_RowNum =  iif(v_RowNum IS  NULL,0,v_RowNum+1)                    -------- Initialize v_RowNum to 0 if NULL; otherwise, increment it by 1 for each row.v_CurrentNumber =  iif(v_CurrentNumber%13= 0, v_CurrentNumber+1,  v_CurrentNumber  ).    -- Increment v_CurrentNumber by 1 for every 10 rows.GENERATED_NUMBER= v_CurrentNumber GENERATED_NUMBER INTEGER   Please  help us  to make it work in Ataccama one desktop .

Hi everyone! In this continuation of our best practices post on Monitoring Project Configuration, we will explore additional settings and actions to ensure seamless data quality monitoring.Check out the part one of the series if you’ve missed it:Disable Rule SuggestionsPower users can disable rule suggestions in monitoring projects. For more details, refer to the link provided in the text. Set Partition DefaultsFor partitioned tables in monitoring projects, identify them with the provided icon. Define default analysis for partitioned tables using the more options icon and selecting either Last partition analysis as default or Full analysis as default. These settings will be applied when running the monitoring project. See the link provided for more information. Anomaly DetectionWhen running anomaly detection during monitoring projects, choose between the time-dependent model or time-independent model. Configure the sensitivity of the detection as well. For further details, check out th

My input file is in the below structure and looking to pivot all rows into columns. No name 1 value1 2 value2 3 value3 4 value4 5 value5    Expecting output should be like  Col1 Col2 Col3 Col4 Col5 value1 value2 value3 value4 value5   What will be the best approach in Ataccama One desktop? Looking for support and help..

Json : [   {      "Headers":[         "Empid",         "Name",         "dept",         "EMAIL"      ],      "ID":"Table_112",      "Rows":[         [            "100",            "John",            "Finance",            "John@gmail.com"         ],         [            "101",            "Smith",            "HR",            "Smith@gmail.com"         ],         [            "102",            "Derek",            "Marketing",            "Derek@gmail.com"         ]      ]   }] Expecting the output in below format:Empid Name dept EMAIL ID 100 John Finance John@gmail.com Table_112 101 Smith HR Smith@gmail.com   102 Derek Marketing Derek@gmail.com      I have created a plan with below details:After running a plan with JSON CALL step below response file got created.   Based on response file i have given below columns in Data Streams    I am not getting the out put what i expected. Appreciate your help and support . 

The EXTRA_DATA error/warning was a thorn in my side for the last couple of days. I added a column to a dataset I was loading to a model from a Text File Reader, and I could not figure out for the life of me what I was doing different from before the column add. It turned out, where I was trying to unselect data was too early.Problem: Suppose you are bringing in a delimited file to use in a Text File Reader that has an extra field at the beginning, which you don't want to have in your output. Finding the correct place to disable this data can difficult. If you disable it before your Text File Reader, or simply don't bring it into your Text File Reader, then you run the risk of getting an error or warning that states EXTRA_DATA for every row you try to bring in, as seen below.I have seen the EXTRA_DATA error in 3 scenariosDeselecting the “Use” box in the Metadata definition on columns you don’t want. Selecting all columns in the Metadata definition, but not bringing the column into your

Hi Community!In the next few days, we will discuss Monitoring Projects, a powerful tool to evaluate and monitor data quality over time for selected catalog items. Monitoring projects use DQ checks, automatic anomaly detection, and structure checks to maintain data quality. We also have a short video introduction to Monitoring Projects, go check it out here 👇 If you are ready, let's dive in 🤿 Accessing Monitoring ProjectsTo access Monitoring Projects:Go to the left-hand menu and select Data Quality. Choose Monitoring Projects.     In this section, you'll find all configured projects. If you want to start a new project, click Create.Each project listed will show the following information:Name: The project's name. Terms: The glossary terms associated with the project. Items: The number of items monitored within the project. Latest run: The date of the project's last evaluation.   The current state of a project is indicated through row highlighting, showing if it's published, recently ad

I would like as an example to have one ‘MS Teams’ channel for one DQ Monitoring to reach out different groups of people tus set up diffirent Teams connections  Is there any option to set it up in the current version? cheersPiotr 

Hello Community! In this second part of the lookup best practices series, we'll cover how to schedule automatic rebuilds of Lookup Items and provide some useful tips for managing your Lookup Files effectively. If you’ve missed the first post you can check it out here: Scheduling Lookup Item RebuildsAutomating the rebuild process of your Lookup Items can save time and effort. To schedule automatic rebuilds, follow these steps:In the Lookup Item, select the more options icon, and then click Schedule.   In the sidebar, choose Add scheduled event.   Set up the scheduled events for the rebuilding of lookups. For more details, refer to the Scheduler documentation.Managing Lookup FilesEditing Lookup FilesOnce Lookup Items have been uploaded, you can edit them manually or reupload the files if necessary. To edit the lookup manually: Select the required item. Click the more options icon, then choose Edit.   To reupload the lookup item: Select the required item. Click Upload new version

Hi guys, I'm doing the dq foundation course and I'm stuck.I have tried to look it up, but no result.This is on an environment in the portal.When I'm doing, with AVG or avg, this:It says:How do I make this work? Kind regards,Marcel

I have a legacy database without primary keys.  I know how to evaluate a single column for uniqueness, and thus a primary key. How do I evaluate multiple columns which together would be unique and thus be a composite primary key?

Hi,   How do I present a selection of values in a drop-down in the RDM create/edit screens.E.g. I have an entity called Door with a column called state that can have a value of either Open or Closed. Can this be presented as a drop down to a user?baz

HiI’m running your free version of DQ Analyzer, but when I want to run my profiles this can’t be done.   As I understand it, it is due to a needed version update.Can you advice how I get my license key updated and not losing my existing profiles and still running the free version?I do not want to install Ataccama One.

Hi Community!We are starting the week by exploring best practices for effectively working with Lookup Items and integrating them into your Data Quality (DQ) rules. Lookups are essential in ONE Web Application as they provide a list of predefined values for attributes, enhancing data validation and detection capabilities.If you remember we have previously covered how to create Lookup files in rules in our Working with DQ Rules series, today we will expand on the lookup items feature. Overview of Lookup ItemsLookup Files in ONE Web Application enable you to use reference data, offering a catalog of predefined values for an attribute. You can utilize Lookup Files in both DQ Evaluation rules and Detection rules. To find Lookup Files, go to Data Quality → Lookup Items.  Uploading and Creating Lookup FilesCreating Lookup FilesTo create a Lookup File, follow these steps:In Knowledge Catalog, navigate to Data Quality. Select Lookup Items and click Create. Provide the required details, such as

Dear Community,I require your assistance with a specific scenario in RDM (Record Data Management).We have a table in RDM that allows users to create, edit, and delete records, which are synchronized back to the database. This table contains a primary key ID column. During the creation of a new record, the user provides the Primary key value. However, the challenge we face is that this primary key column should not be editable afterward to maintain its uniqueness as a key.We attempted to restrict column-level permissions, but this resulted in the Primary key column not being visible even during the creation of a new record.I would appreciate your guidance on this matter.Thanks very much.Ojaswini

Hello everyone, Anna here! I work as a projects consultant in Ataccama and today I put together a guide for you on how to migrate permissions after upgrade of v13 to v14. In v14, we introduced a fresh new permissions model introducing Groups and Stewardship. The downside is, though, that after the upgrade the old permissions model cannot be automatically migrated into the new setup.Attached to this guide is a migration package – a set of plans that you can use that will help you through the process of migrating the old permissions into the new setup in more automated way. It is not meant for fresh v14 installations.The article is split to two parts:Preparation phase – steps you need to do BEFORE you upgrade your environment to v14. Post-upgrade phase – steps you need to do AFTER the upgrade, meaning in your new v14 environment.Preparation phaseFollowing steps should be run on version 13 prior running the migration scripts and upgrade of the environment.1. Create server connection in ON

Receiving error when trying to start ataccama server: Description:Parameter 1 of constructor in com.ataccama.mdm.core.SpringServerConfig required a bean of type 'com.ataccama.dqc.server.config.ServerConfigImpl$IServerConfigConfigBeanProvider' that could not be found.Action:Consider defining a bean of type 'com.ataccama.dqc.server.config.ServerConfigImpl$IServerConfigConfigBeanProvider' in your configuration. Need help on this please?