Solved

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:2

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 stringExample : Input: BeWhoYouAreSplitter output - ‘e ho ou re’ - skipping the first letter as ‘Upper case’ is the separatorDesired 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!

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?ThanksAnagha K

I am working on version 14.3 and I am trying to export the profiling results from the Web App, but when I go thru the process I only receive the attributes with records. I am wanting to export the profiling and not the records since they hold PHI. Is this possible in the web app or only in desktop?

Hi Community,Is event based trigger possible in Ataccama Thin client (web version)? If so, how to implement it?Thanks!

We turned on the email notifications in order to get the Monitoring Project emails.  But now all the users are getting emails each time a Term is created / sent for approval / and approved.  How can I throttle the email notifications to allow the monitoring projects but not Term approvals ? Sample Email  Dear colleague,Approval request was published. 

When I use Monitoring Projects and try and apply a rule to a DATE or INTEGER it is not allowed.  For Date Rule, I want to check for NULL or a DATE range.  For Integer, I want to check from a referenced lookup table.     Why is this check only allowed for Strings ?  Will DATE and INTEGER be added at a later time ? Rene Requenes

Is there a way I can get the anomaly detection configured and notified when there is a anomaly in the counts in more than one attribute?eg:SELECT CALENDARDAY, COMPETITOR, COUNT(*) as count FROM TablenameGROUP BY CALENDARDAY, COMPETITORA notification whenever there is drop or increase in the count based on CALENDARDAY, COMPETITOR

Hi Everyone,  I have postman REST API call that retrieves CSV as output. The API call uses Bearer token, I am not able to use JSON call (output is CSV format) , Https GET (doesnt accept bearer token) . Is there any other way to use the REST API → CSV(output file)?

Good day! I would like to find the completeness of the descriptions for all the tables and their attributes in Ataccama Web. Is it possible to do this in AtaccamaWeb using Rules? There are approximately 700 tables in the system.  I will be very grateful for your helpThank you!

Hi all,I have created a new entity in the metamodel, let's say with properties A, B, C and D (in that order).In the user interface the overview screen of this entity is a list-overview, showing the properties in the same order as defined in the entity.I would like to be able to adjust this lay-out, like D, B, C and not showing A. Refer to the example in the attachment for more clarity.How can I accomplish this?In addition, how can I define a filter on one of the property columns?Kind regards,Albert de Ruiter

Hi community,In the metamodel, when defining a relation to another antity of type embedded object array, in the user interface it appears as a very large white area containing one button. We feel that this feature is not in line wth proper user interface design. Therefore I am looking for a way to have this button shown in a way more minimal format.Does anyone knows if this is possible? A trait or a specification in the page lay-out definition or…?Thanks in advance!Kind regards, Albert

I have a workflow which does an HTTP GET to download an HTML page. I then use a DQC plan to filter and alter the data in the HTML file to get a “new” URL. I now have this “new” URL in a column at the end of the plan. I’m wondering, is it possible to use this “new” URL column from the DQC in the same workflow to perform another HTTP GET of the “new” URL? 

Hi,There is a lot about GraphQL and JSON-call. But I have question on how to process nested GraphQL in a JSON and maintain integrity when using (nested) datastreams) in the JSON Call step in Ataccama (v13.x).Below an example. There are profiles with path ($.data.catalogItem.publishedVersion.profilingConfigurationInstances.edges.node.publishedVersion.profiles.edges.node.@). And then a nested data-stream, which continus from this path (publishedVersion.attributeProfiles.edges.node). Each stream will give an output for the JSON-caller step. Now how do we maintain integrity between the streams/output files? So how can I refer from a sub-stream to a parent key, so I can later join the JSON-call output streams?    

Is there a function or custom ways to convert strings into camel case on DQS - Data Quality services?

We successfully connected Workday from Atacccama one web by using CData drivers.Now we are trying to do the same from One Desktop.How do we connect Workday objects  from Onedesktop by using CData drivers?We were able to connect Workday  through  the API's  but our requirement demands CDATA drivers connectivity.Thanks,Mahesh Arigela