Learn & Share

Hello, I’ve got a question while using DQ evaluation rules.I have been creating rules with valid and invalid messages but just the invalid message at the end does not display as intended. But when I view this in the results tab it just says OTHER as the explanation.    Is there a workaround to this problem? Should I edit my rule logic to include some specific condition and leave the rest to fall under the ‘IF none of the conditions above apply THEN’ TIA for the replies.  

METADATA MODELThe metadata model is used to configure the application entities and their properties. The Metadata Model describes the entities and their properties in the application.  Web Application) use the Metadata Model to create the frontend user interface. The metadata model is also responsible for the configuration of the left navigation menu of the application.ONE METADATA PROPERTY REFERENCESEntities consist of properties of Simple types, such as strings and integers, and Object types, which link the entity to other entities.ADDING NEW ENTITY TO MMM MODELIf you are creating an entity using the user interface, you must then add it as a property of the root entity metadata and then publishFor example, if we need to add a new entity under Business Glossary named (TestEntity) to the MMM modelClick on the Global settings on the left panelChoose Metadata Model under Maintenance CenterWe must create a new entity under Term so click on create entityFill in the name of the Entity, and

Is there a way to connect ataccama One Web to a private Redshift? 

Hello, I’m trying to demo the RDM Banking Example. However, the flag images in the Country table are not showing properly (as shown in Picture1.png).I have fixed the source CSV file to point to an online website with corresponding flag images (shown below) and run its loading plan to update the data on RDM, but those images are still not showing on RDM. (as shown in Picture2.png)

Hi Team, Is there anyway that we can export the result of profiling in ataccama? Thanks, Ellie

Hi,We are using Ataccama one 12.6 version. We have a project containing 40+ models with 90 + rules. I am looking for an options to get the detailed invalid/failed records for each model. Like all the attributes from the model along with invalid rule instance names.The idea is to get the whole failed dataset to automate the remediation process. We already have automated process to remediate the data using other technologies.I don’t want to use the download results in csv option, because we are transitioning to latest version of Ataccama.I am looking for couple of optionsExtract the detailed failed records from backend tables using sqls (where Ataccama stores the results) or would like to understand how those csv files are generated in backend and use the same way to get the data and store in  db. Reading data through Ataccama inbuilt API’s and loading into a db. I am  going through the GraphQL options. Could you please let me know, If there is way to get the similar data through GraphQL

Hi All, We are getting the below error while adding an oracle database from add datasources in One web app. we give jdbc connection string, username and password(doesnt matter/validate if it is right password/username). Please check and let me know how can i troubleshoot/debug the issue. Some browser component is throwing the error. jdbc - format - jdbc:oracle:thin:@<jdbcHost>:1521:<jdbcDatabaseName> error when we try to connect the first time after a restart of one-tomcat servicejava.lang.RuntimeException: java.lang.ExceptionInInitializerError        at com.ataccama.one.browser.database.AbstractDatabaseDatasourceClient.retrieveConnectionWithTimeout(AbstractDatabaseDatasourceClient.java:119)        at com.ataccama.one.browser.database.AbstractDatabaseDatasourceClient.handleRequest(AbstractDatabaseDatasourceClient.java:353)        at com.ataccama.one.browser.database.AbstractDatabaseDatasourceClient.<init>(AbstractDatabaseDatasourceClient.java:92)        at com.ataccam

During bundle deployment I see this error. I have tried different combination ofUpdate to old bundle. Manually update the component again on the existing old bundle and upload Copying extended unification Updating OmnigenServer folders (bundle,cmd,dbms) with the backup. restarting services as needed.Any thoughts or suggestions? Thank you.

The matching component is slow at the extended unifications step for a incremental load. When a record like ‘WALGREEN%’ is loaded and there are 20K records with similar name on the instance, the records are all considered through the process of matching. Hence the process is slow when processing the increment and even if the incremental load has 11 records to process 30K records have the transaction Id and omni_modified date updated with the work order related on the instance table.  When I check history, nothing changes on these records except the omni_modified_date and transaction_id to that of the work order. Tweaking the union keys to create combination of name and key factors or adding separate groups for the high count records is not helping. Any thoughts or suggestions?

Hi All, we have Ataccama version 12.8.0 version in our one web. Is there a connector available or how can we connect to a https url which points to a csv file? how do we configure https get method using security like oauth in Ataccama?

Hello everyone,I created a profile of my catalog item using ONE desktop and I would like the output(.html) to be accessible to business analyst with read access. The html is only accessible on my local computer. Where’s the best / secure location to store output reports of profiling? Please chime in with any thoughts. Thank you! 😀     

Hi, I’ve been trying to create a SQL catalog item in the UI using the query below. It’s basically joining the same table twice. The query ran successfully in IDE but it’s giving me an error: Attribute '3' is duplicated. Please make sure that attributes have unique names. Can anyone help?select x.1, x.2, ax.3 as SSN, aze.3 as EIDfrom table1 xinner join table 2 ax on (x.a = ax.b) and trim(ax.c) in ('1','S','Social Security Number US')left join table 2 aze on (x.a = aze.b) and trim(aze.c) in ('E','EMPL_PROVIDED_ID','Employee ID')where x.last_update_date > '2023-02-08 00:00:00.000'

Hello everyone!I have an interesting task related to the desktop, we have a table combined with certain attributes and with full names, full names are divided into columns (firstname, lastname, midname) and they need to be compared with other columns (firstname1, lastname1, midname1) it is necessary to output non-matching full names. I can't compare one table between columns, I need your help. Do you know how to implement this?I will be very grateful for your help

Use Case: Send records from Kafka to Ataccama IDE for parsing and other transformations and send this data to database tables Beginning set up for Kafka with MDM: ⦁ The first thing you would need to do is add the Kafka configuration to the runtime configuration file, for usage in the server  The configuration should be in this format as in the picture above, where you provide the connection string, key, trustore, and keystore passwords You will also need to add this information into the serverConfig file as well, naming the server as you would like between the string tags   Once the file configurations are ready for you to connect to Kafka, you can then start adding your streaming information into the model explorer The first step would be to right-click on the STREAMING button in the model explorer From there you would need to click New Consumer You would then click Kafka Stream Source, to create a new kafka streaming source and configuration  Above is the screen you should see

API/Python code for onboarding (connections) the Databases into Ataccama:-We are trying to create Database connections into Ataccama by using Python. Is there any way to do the same. It would be really great if you can share us with any reference links or docs.Thanks in advance!

Is it possible to Set up the detection rule, which would allow to detection of new table(s) within the Snowflake schema and trigger the required potential alerts

Imagine the scenario where you have Ataccama ONE Data Quality Monitoring Projects running regularly. Any Data Quality (DQ) issues are already exported to our DQ Issue Tracker (DQIT) module. You can also see trends of DQ over time within the Ataccama ONE Web application.You start noticing that the score for some DQ rules has had a sharp drop in quality, and you want someone to investigate this.One of our customers decided that they want to integrate Ataccama with Jira at this point. Have Ataccama raise a ticket into Jira when this happens automatically.In this article, we will explore:Preparing to integrate with Jira The Json Call stepPreparationsBusinessUnderstand your end users. What do they expect to see in their Jira ticket? Know which fields in the Jira ticket are mandatory Have an idea of what extra information you should supply in the detailed description of the ticket. Think about formatting and presentation. Good to understand Jira markdown notation (link)JiraKnow which version

Hi Team,Our Aim is to Avoid duplication of the same data coming from different requirements (project trains) - in case of identified duplication DQ Brach alert should be reported.      1.How to identify if Somone ingested the same table in a different Snowflake schema ?Is it possible to detect duplicate table through ONE web application or ONE Desktop by creating a rule?Thanks in Advance!

I have a sql select where in I wanted to pass multiple data source names. how to make it dynamic or parameterized so that It can read all the names one by one.

Hi,For our monitoring projects  post processing we use fairly standardized (sub-) components. Now for every MP / CI combination these sub-components are all the same. If an MP Postprocessing is published these components get published also, right?Is there a way to have a single version of a component stored?This would make maintenance and life-cycle-management on these components a lot easier. In stead of having to go in the PostProcessing main component, we'd just have to change one.A plausible solution would be to split things and do things asynchronously, maybe. But that is a more of a workaround.Any ideas?

Hi,I’m trying to modify our view of our business terms - currently we have a lot of information showing in the default view that our end users may not care about.  What I really want to do is modify the view, so that it only shows Name, Abbreviation, Description and Synonym.  I have figured out how to add the columns, but I can’t figure out how to remove unwanted columns.  For reference here is the default screen layout in Ataccama One via the Debugging Tools. {"_type": "entity.page.listing","children": {"_type": "relationships.hierarchyListing","enableSelection": true,"columns": {"type": {"dataPath": [],"name": "Type","after": "name","renderer": {"_type": "glossary.termType.tableCell"}}}}} 

Use Case:  As part of the Data Governance Program KPIs reporting, we need to report on unique user usage count and details of who within the Ataccama Web on a monthly, month-to-date, and year-to-date.  Can this be easily captured using OpenSearch Dashboards historically or elsewhere?  

Basic Auth headers are frequently used as part of communication between applications, e.g. as part of API calls.Common use cases in the Ataccama context include (and not limited to):Graphql call to ONE application API call to an online service set up on a DQC / runtime / orchestration serverOption 1: Do it in a ONE Desktop plan Create a new plan Create a step that evaluates expressions, e.g. Alter Format Go into the expression window and put this expression in. The username and password are separated with a colon: coding.toBase64('username:password') Click Evaluate Copy the result string Your header is going to be Basic dXNlcm5hbWU6cGFzc3dvcmQ=Option 2: Use an online base64 encode websiteIf you are building something to integrate with Ataccama but you don’t actually have Ataccama ONE Desktop installed…. Go to a website that offers this conversion (e.g. link. Warning: this site is not affiliated with Ataccama) Put in your username and password in this format: username:password, se

I’ve been working on a use case recently which I think may be of interest to the community here.Some reference data is stored in a single table DATA_KEY_ID column tells us what reference data set it is DATA_VAL column stores the actual reference data in the format of a json array Goal is to extract the values from the json array, and use it as a lookup item in Ataccama ONE, which in turn is used in Data Quality Validation rulesTo start with, you need to have some preview access to the data and understand the schema of the json. For the example in this post, I have very simple “id” and “name” properties for my json. You will need to analyse that data before starting this, so you know what to put into the Json parser, or which values you want to get out from the json object.  Solution 1: Virtual Catalog Item (VCI)Bring the reference data table into Ataccama ONE Build a VCI, with a Catalog Item Reader of the reference data table Use a filter step to filter the exact set I need (it will al