Learn & Share

According to the documentation multiple listeners are allowed to be configured - Trying to configure mdm to listen at more than 1 port results in the following error on the first defined listener with only 1 other working :HTTP ERROR 500 org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'keycloakSecurityConfigurer': Unsatisfied dependency expressed through constructor parameter 0; nested exception is org.springframework.beans.factory.NoSuchBeanDefinitionException: No qualifying bean of type 'com.ataccama.server.http.security.keycloak.KeycloakSecurity' available: expected at least 1 bean which qualifies as autowire candidate. Dependency annotations: {} Am I doing something wrong? 

According to MDC 12.7 Documentation , we are allowed to define multiple listeners in the HttpDispatcher on different ports.When I try to do that, I get the following error trying to access one of the ports (the first one defined in order top to bottom in the serverConfig) , leaving me with only 1 working listener HTTP ERROR 500 org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'keycloakSecurityConfigurer': Unsatisfied dependency expressed through constructor parameter 0; nested exception is org.springframework.beans.factory.NoSuchBeanDefinitionException: No qualifying bean of type 'com.ataccama.server.http.security.keycloak.KeycloakSecurity' available: expected at least 1 bean which qualifies as autowire candidate. Dependency annotations: {}Is there are workaround for this?  

We continue with our series - today’s topic is Detection rules.👉 Get Certified with Ataccama article series#1 Adding Data Sources#2 Add a Data Source to the Catalog#3 Business Terms🔎 LET’S TEST YOUR SKILLSUsing the ONE Web App, in the ONE Data Quality module, create a Detection Rule for 'Blood Type', if the value in the input column is one of the following 4 values, then Detect Term A B AB O  💡 How to do it? Navigate to Data Quality - Detection Rules and click on CreateFill in Name and other information if needed and Save itGo to tab Implementation and fill in Input Attributes - always make sure you follow best practices for naming conventions In the section Rule Logic, select DetectionSwitch to Advanced Expression, write a condition and Test RulePublish the rule Do you have any question or tips&tricks? Let us know in comments section! 

I am doing POC to adopt ataccama, please help me out on this requirementRequirement:Previous and current run data validation.For example:what is the threshold of yesterday sales or one week back sales and todays sales 

Is there a best approach to have LKPs updated via a webservice so that other web services can consume the updated lkp without restarting DQS? I have Web Service ‘A’ which builds a dictionary file. I also have Web Service ‘B’ which uses the dictionary built by Web Service ‘A’.I would like to run Web Service ‘A’ so that Web Service ‘B’ is able to immediately use the updated dictionary without restarting the DQS service.   Currently when i run Web Service ‘ A’ I get a locked file issue:26.07.2022 12:43:56 [FATAL]   [OnlineServicesComponent][buidTestDictionary.online][buidTestDictionary][buidTestDictionary.comp] [40] Internal error occurred during run of the plan: java.nio.channels.OverlappingFileLockException[STEP Lookup Builder[Lookup Builder]]java.nio.channels.OverlappingFileLockException    at sun.nio.ch.SharedFileLockTable.checkList(Unknown Source)    at sun.nio.ch.SharedFileLockTable.add(Unknown Source)    at sun.nio.ch.FileChannelImpl.tryLock(Unknown Source)    at com.ataccama.dqc.i

Hi all-- Please find below an introductory primer for the Ataccama Expressions language, for those familiar with Excel formulae (which are deliberately very similar in structure and use to the way we’ve designed the expression language)… IntroductionOverviewOne of Ataccama’s core values when developing Ataccama ONE is to create a user experience which simplifies as far as possible the technical complexities of data manipulation and data quality, and to put as many capabilities into the hands of business and non-technical users as possible.With this philosophy in mind we have created a powerful expression language, which moves away from the complexity of development languages such as scripting/python/SQL. Despite containing powerful and extensible functionality for complex data challenges, the design of the expressions have been made as simple as possible, and can be easily learned by anyone with a familiarity in MS-Excel formulas and features.This expression language is used throughout

When you start the workflow, in the last step, emails are sent using SMTP. When executing a task, the process throws the error java.net.SocketTimeoutException: Read timed outI suspect this is due to the fact that too little time is allotted for the connection, which is why the SMTP server does not have time to return a response. Is there a configuration file somewhere in ONE desktop where you can manually set the time on timeout ?  

Is there a way to ingest data from a kafka topic as a connected system in ataccama?

I am working on 12.9 at my company, where I can see the data classification ?I do not see that, please help me out if this version support. Thanks & regards,Mukesh

Hi,I am creating an export operation, I have an entity 01, with a list of users and an entity 02 with email addresses:Entity structure I need to convert this to an export file with the next structure: Export file layoutI would to know if there a step to help me grouping the data for this purpose. Thanks in advance,Alejandro

It is worth immediately clarifying that I have admin rights. I create a policy and after creation there is no block for creating conditions. Are there any guesses? Policy Managment Block 

How to change  environment in ataccama web interface?

Will ataccama support vault model? For example on Day 1 - My name is entered as “Karthika” day 2 - “Kar” Day 3 corrected as “Karthika”. 

I did full profiling for data catalog and it finished successfully, but “Error” occured after when we want to see data. Where there may not be access for source/table?

How to Check whether the target column has only DATE values or not.?

In the second article of Get certified with Ataccama series, we will focus on Adding a Data Source to the Catalog. 👉 First article of the series - #1 Adding Data Sources 🔎 LET’S TEST YOUR SKILLSUsing the ONE Web App, in the ONE Knowledge Catalog module, add your database as a data source. Using the ONE Web App, in the ONE Knowledge Catalog module, add the table you created in ONE Desktop application to the Catalog Items. 💡 How to do it? Go to ONE Web App - Data Catalog - Sources and click on CreateFill in Name and Description (if needed)Fill in Connection details - Select connection type, Name and JDBCAdd Credentials, select Credential type, fill in required information and Test ConnectionSave and publishNavigate to Connections in and click on BrowseSelect your tableFrom Profile menu select ProfileAfter the profiling is done, check that your table is in the Catalog items list Do you have any question or tips&tricks? Let us know in comments section! 

Has anyone successfully connected to Salesforce environments (prod/test/dev etc.) thru One Desktop (13.7.1).  Thanks

We are having a difficult time connecting a MS SQL database to Ataccama

What makes manual data quality so hard to scale in large organization? Is there a step by step approach to automating data quality? Why is an automated DQM system the future of enterprise data quality?You can find an answer to all these questions (and many more!) in our latest whitepaper.👉 Download it here

My organization runs McAfee antivirus.  I’ve just tried out the DQ Analyzer 11 tool and really like it, but it takes forever to start up or perform any actions.  Just starting up, the antivirus pegs 1 CPU for about 30 minutes before the application starts.  And then various actions like starting a new profile or clicking a menu item will also be delayed by several minutes at least.We’ve tried excluding the install directory, but it hasn’t helped.  Any ideas?  Has anyone else run into this issue before, and how did you solve it? 

This is needed when a user would like to go directly to the platform and skip the “login with Azure AD SSO or OKTA” page. This can be turned on (or off) by following the below directions: Login to the Keycloak Administration Console Ensure the Ataccamaone Realm is selected In the left-hand-menu, Click on Authentication Under Flows select Browser  On the Identity Provider Redirector line, click on Actions and select Config a. If you would like to disable (turn off) the auto login - we can select the ‘disabled’ radio button on the Identity provider redirector line Enter the name of the Identity provider, e.g. saml, in both the Alias and Default Identity Provider boxes Select Save

Hi,I am wondering to know if is good idea:use MDC Reader step for delta export operations where we need to complement data from entities of other layer   oradd another Data Sources with full mode of this other entity, then use a Join step to get the information required.  Both are feasible, not sure what is better talking about batch processing, performance, etc.

Hello Ataccama gurus--- Has anyone here integrated with OneTrust before? It’s something that’s come up at 2-3 potential projects at different customers recently, and I’m curious of any previous experience people may have nad, or not with this? (What type of data would be kept at each side, methods of synchronisation (assuming API & metadata readers/writers. Any re-usable components available?)Cheers! 

Can we create custom check on data as per our need and get stats out of it ??for example.. I want to check whether colA has values between list [‘A’,’AB’,’O’,’B’] and stats about the values that are present in data.

I was thinking that this should be possible with a hack to the postgreSQL jdbc configuration using the redshift jdbc driver. Does anyone know if this is possible or if there is another avenue?Edit: I found the connection after the install and properly configured the Redshift driver and connection settings.