Learn & Share

Hi , Could someone guide me on creating rules for Name field. Rule : Name should not have any special characters but can have numbers and spaces. Ex: Jhon Leo - Valid Jho1 Leo - Valid Jho( Leo* - Not Valid Regards, Bhuvi

Hello all,I’m using the Ataccama v14.5 there we have created the custom entity for classifications and created the classification types (Internal, Public etc) and added them with tables and attributes through the One Desktop plan. But when i am using the same plan to delete it from table or attributes just by changing the One Metadata Writer property in General tab “workflow state as deleted” and in the Columns tab providing the “Id Column Name as table_id” then it is not deleting anything. Any guidance or suggestions is really helpful. Thanks. General tab Screenshot: Columns tab screenshot:

Hello, i have a report that we usually saved to hard drive that i would like to bring into Ataccama, the report is in semi structured format . does ataccama accept or work with semi structure data ?or do i need to convert the report first before connecting to source ?

Hello, does anyone faced with issue when primary key/ nullable/ column size fields are gone after refreshing catalog item and rerun data select? I use ONE Web app v14, after setting attribute as primary key, nullable or defining column size then it disappears after rerunning query. How did you solve this issue?

Hello guys, does someone know where I can find the information about all functions list that are available from Advanced builder while creating DQ rules? Will appreciate any help or advice, thanks.

Hi , Kindly share your inputs on below scenario. I am trying to place the “Monitoring Projects” export “.csv” file in a shared path/folder with in the organization. Purpose of this “Report need to accessed by different set of stakeholders who do not have Ataccama access” Is there a way to access this export file by any API calls or we can directly configure the shared folder path for example “S:/SharedPath/Ataccama/Exports” in output location field ? Note : This is on Ataccama ONE 14.4 version. Any input is appreciated. Thanks, Bhuvi

Hi, Could anyone help me on below scenario. I am using Ataccama ONE web 14.4. Millions of records are populated in testing environment from Production real time data. However , for testing purpose manipulated few 1K records. Is there any way in Ataccama where we can apply rules and perform “Monitoring Projects” only to the new records 1K created by giving any date created filter? Regards, Bhuvi

In the above image I want to clear all special characters expect .(dot) As their can be any thing in place of ! number may have *, &, %, $, etc. I tried it using trashnondigit() function but it will remove all the characters from the number, Is their a way to do it?

Hi everyone Could you please advice if there is any instruction how smpt server can be configured for e-mail notifications? Where we can perform this configuration? Is there any option in Ataccama ONE web? I have checked this part of documentation MMM Configuration :: Ataccama ONE but it is still not clear where mmm configuration can be done

Hello all, I am on v14.5.3, so I haven’t seen the Data Slice feature hands on yet. Been reading the documentation on the Data Slice and its use in the monitoring project. Say for example, I have a table of transactions, and I have some statuses: Pending Active Inactive Cancelled Let’s say I have the following rules and the respective slices they need to be applied on: Rule 1 Status = ‘Active’ Rule 2 Status in (‘Active’, ‘Pending’) Rule 3 Status = ‘Pending’ Is it then possible to create an ‘Active’ slice, and a ‘Pending’ slice? And then in my monitoring project, I add my catalog item, then I apply my Rule 1 to the Active slice, Rule 3 to the Pending slice, and Rule 2 to both the Active and Pending slices? Or something like that? Trying to gauge how we can use it, how much maintenance overhead there will be and the effort to try and start using this feature. Any insights from people who’s already using v15 much appreciated!

Hi everyone, Sometimes I'd like to select a large number of checkboxes in Ataccama, for example to profile a large number of Catalog items. Of course creating a plan is also an option, but not always the least time consuming. How do you do this with many checkboxes involved? There are browser extensions available for many browers, but not sure if those are secure enough. Any recommendations or tips?

Please advise if “BOX.COM” is a data source that is supported out of the box, being that ONE can integrate with “BOX.COM” using an existing JDBC or API connector.

Use Case: For our Data Lose Protection initiative, we are profiling and classify OneDrive, SharePoint, etc and we have a requirement to write the “security term (data classification - restricted, confidential, etc)” to the asset sensitivity labels (metadata)

Hi Community,Is it possible to have a email notification to a group of people in case of an update in the existing policies in One Web?

Hi Team, I am trying to json call to read the response of api and process it for further results. This is my example response { "Data": [ { "Name": "Amount", "Id": "12345", "ValueListAttribute_5d": [ { "term": "Attribute", "term_Id": "67" } ], "StringAttribute_00": [ { "definition": "Dollar amount", "definition_id": "5" } ], "BooleanAttribute_18e": [ { "indicator": "true", "indicatorid": "6" } ], }, { "Name": "Amount", "Id": "12345", "ValueListAttribute_5d": [ { "term": "Attribute", "term_Id": "67" } ], "StringAttribute_00": [ { "definition": "Dollar amount", "definition_id": "5" } ], "BooleanAttribute_18e": [ { "indicator": "true", "indicatorid": "6" } ], }, ], "DisplayRecords": 2, "Records": 2} I am trying to read these values using Json call and use them for further processing in my component. But I am not sure how i can read the values. For e.g.: If I need to get indicator how can I get that using Json call.

How would I validate a string in the format YYYYMMDD is a valid date? I assume the range of valid years is 1940 to 2050.

I am trying to create a SQL catalog item to filter out the inactive records. When I create the SQL catalog item I get the following error message: SQL compilation error: Object 'DEV_SOURCE.SAPMDG.VTLFA1' does not exist or not authorized. I can see the data tab for this table. I can run profiling/DQ insights tab so I’m not sure what is happening. I have created the query with the schema name and without the schema name. Shouldn’t the credentials be the same to create the SQL catalog item?

Hi, How can I send a file to SFTP folder using below task item? I am using Desktop version. Can someone help me how to get the required fields from the below screenshot? I have the location where I want to drop the file.

Hi, I am trying to validate the date given between 100 years ago and 15 years ago are valid , everything else is invalid. I am able to achieve this validation in YEAR part. I am looking for validating complete date instead of only Year part. Below are few screenshots.

Hi Community,Is it possible to fetch the policy creation or last update date for Policies, in order to make a DQ rule around it in Ataccama One? My use case is to build a DQ rule which will notify the stakeholders based on a timeframe after which the policy has been created or last updated, but unfortunately i am not seeing any property to fetch the Created or Last Update date.

Glossary terms are used to add more metadata to different assets in the Ataccama ONE, they are necessary for data quality evaluation of Catalog Items after profiling. 👉 Get Certified with Ataccama article series #1 Adding Data Sources #2 Add a Data Source to the Catalog 🔎 LET’S TEST YOUR SKILLS Using the ONE Web App, in the ONE Business Glossary module, create business terms for '<your_name>_Blood Type', '<your_name>_Rhesus Status', '<your_name>_Blood Group'. Using the ONE Web App, in the ONE Business Glossary module, configure the business terms '<your_name>_Blood Type' and '<your_name>_Rhesus Status' as child terms of the parent term '<your_name>_Blood Group'. 💡 How to do it? Navigate to Business Glossary in the left navigation menu and click on Create in the top right menu Select Type - Business Term, fill in Name and Save You will see that your business term has been successfully created, repeat the same process for remaining business terms Once you have all terms created, open