Solved

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.

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 450ml 2L 5galon 2.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 Found URI: /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 Desktop I 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!

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 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:25:21 [ER

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 string Example : Input: BeWhoYouAre Splitter output - ‘e ho ou re’ - skipping the first letter as ‘Upper case’ is the separator Desired 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’

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!

Is it possible to mask data for some users, for example out of privacy reasons? I know masking was a feature in version 1 and for some reason was removed in Gen 2, but how could this still be achieved as it is a much asked requirement, that certain users should not see certain attributes and no, I don't want to create a VCI copy of each asset that has such columns and replace that column with some dummy value, that's not masking.

Hello, We are trying to give access for invalid samples in our monitoring projects to our colleagues. The coleagues are in a role that they have data access to the Catalog items, and data access in the monitoring project, but they still are not able to see the invalid rows. Which access type should be granded for invalid samples in monitoring project ?

Needed to know how to create a rule having an attribute of STRING datatype for extracting current date and past date in One Web. Tried using date functions in string using advanced expression (today() is ATTRIBUTE) ..showing error in testcase. But when tried using same functions for DATETIME datatype working fine. Can anyone help?

How I can use create sql catalog on s3 files (csv, parquet) in Ataccama One Web Knowledge Catalog. Do Ataccama use AWS S3 CData drivers

Whenever I run the plan file the output file get updated and the older output file data get lost . Is there any way ataccama can keep the files that is generated for all the time the plan file ran ?

Hi, we need to see if for terms (or other entities) certain roles have viewer rights. (...and if not set them) Below is a GraphQL, but I need to filter only the term.assignedIdenties.capability.OperationSet where the name is "viewer”. How would I go about doing this? (outside filtering in ONE Desktop of course) query GetCapabilities_term($gid: GID!) { term(gid: $gid) { gid assignedIdentities { grantingStrategy capability { name id operationSets { name displayName id } } identity { ... on Role { name __typename ... on GroupRole { name numberOfUsers gid } } } } }}

For a use case we need to run DQ on CSV's loaded into HDFS (only). So no hive externally managed tables are available. Our use case is much like the desktop tutorial Hadoop (01.0.0 Read whole folder - MAP.plan), but we'd like to create VCI's and update them once a day for profiling, DQE and sample data. Two Q's: How do we connect tot HDFS? (Simple JDBC we use in DBBeaver doesn't work) How do we update the VCI's?

Hi,I need to create one rule which is used to check whether last date of current month is available in that column or not. For that I need expression to get the last day of current month. Note: Today is 2023-10-11. So I need to get 2023-10-31. or if today is 2023-09-04 then I should get 2023-09-30 as output. Can anyone provide a solution for this? Thanks Anagha K