Learn & Share

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?

Happy Tuesday Community! We started this week by sharing best practices on Monitoring Projects, and today we’ll be continuing with how to configure Monitoring Projects. If you have missed the first post you can find it here:Let's explore the best practices for configuring Monitoring Projects to ensure robust data quality checks and anomaly detection.Select Catalog ItemsGo to the Configuration & Results tab. To add catalog items: For a new project, select Add catalog items.   To add more items to an existing project, select +Add under Items to Monitor.   To remove an item, use the more options icon and select Delete. The listed catalog items will display a summary of: Structure: Aggregated results for structure checks on attributes. Anomalies: Detected anomalies on attributes. DQ Checks: Results of data quality checks assigned to attributes. Overall: Aggregated quality based on assigned DQ checks contributing to overall quality. Individual DQ dimensions, listed with the

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

Any one who has worked on Time series analysis option in V13.9 and successfully got the required results

Hello Ataccamer,I have a question regarding the "onPublishHandler.plan" file. This file contains components and steps for on-publish synchronization for all the RDM tables, which results in numerous components corresponding to each RDM table. As the project progresses, the number of RDM tables keeps increasing, causing this file to continuously grow in complexity.I'd like to inquire whether it's possible to segregate these components based on projects example diff file for domain or any other way. Is there a way to create separate "onPublishHandler.plan" files for different project domains? This could help reduce confusion, especially when multiple developers are working simultaneously. Just a thought. Thanks and regards,Ojaswini

Hello,I have a requirement to append the records in parquet file in the event of RDM on-publish synchronization. Does anyone know, how can we append data into Parquet file in RDM on-publish event?I believe parquet file writer will write data in the file, but if the new record created in the RDM, will it append the data in the same file or will replace the file completely and create new one.Thanks for any help.-Ojaswini

Hi ,I want to know what was the input to be given in root object for JSON writer  

Hello Ataccamer,I am dealing with Parquet file writing in on-publish mode. Could you please suggest how to write data to Parquet file when it is a record deletion event on RDM UI (in on-publish) . As in case of Parquet file it is always first delete the file and then created the file again.How the CHANGE_TYPE is in {'DELETED'} will work in this case. Any suggestions, please share.Thanks and regards,Ojaswini

Eventually, you might need all your data quality results evaluated in One monitoring projects or within regular catalog items (via business terms and related DQ rules) exported to some reporting system or into excel. And it would be nice if it looked like this:  TLDR; There are 2 components attached you can use to export DQ results, one for monitoring projects, another one for regular catalog items. Monitoring ProjectsThe idea is to read all monitoring projects metadata, join it with their check results as well as rules names, catalog item names and voilà, we can save it to excel/csv or to some database table.It sounds like something very simple, and indeed there is no black magic, but nonetheless component looks a bit more elaborated: Catalog Items DQ (based on Term evaluations)The idea is to find all catalog items that have aggregated overall data quality and join them with the DQ rules results:This component has a bit simpler implementation:  Of course, the output of the components

Hi,I am wondering if the following is possible. On the glossary's term screen not all properties/metadata will always be filled. For instance in most occasions there will not be an abbreviation for a term.Is there a way, on the view screen only, to hide this abbreviation field when it contains no value?Thanks for your time!Kind regards,Albert de Ruiter

Hello Ataccama Community,I'm currently using Ataccama One Desktop version 13.9.1, and I'm encountering an error while trying to execute a plan that involves a Kafka Reader component. I have configured a Kafka server(kafka integration) with the following properties:ssl.truststore.location=LOCATION_TO_TRUSTSTOREssl.truststore.password=TRUSTSTORE_PASSWORDssl.protocol=TLSsecurity.protocol=SASL_SSLsasl.mechanism=GSSAPIsasl.kerberos.service.name=kafkasasl.jaas.config=com.sun.security.auth.module.Krb5LoginModule required \        useKeyTab=true \        storeKey=true \        keyTab="LOCATION_OF_THE_KEYTAB" \        principal="USERNAME_HERE@EUROPE.XYZXYZ.CORP"; The error message I'm seeing is: "Property with name 'KafkaResources' doesn't exist in com.ataccama.dqc.streaming.KafkaProviderComponent!"I've reviewed my configuration, but I'm still unable to resolve this issue. Can someone please provide guidance on how to troubleshoot and resolve this error? Any insights or suggestions would be gre