Ataccama Community

Talk about data, share your best practices, engage with Ataccama teams

60 Topics

ahmingNew Participant

Default template

Any one can help to create this template using version 13.6? It show the items clearly. Our users can know the data presentation without explanation. However, I can find this template in our current version.

3 days ago

RoberTallitschNew Participant

asked in Discuss data

Creating flat file using Ataccama One Desktop where records failed business rule

We created a number of data quality business rules that will fail records from the source file we are reading. 1.5 Million records.How do you port the failed records to a flat file? There is no drill down in One Desktop so we are having issues getting business users approval on code without seeing the failed records?

3 days ago

vickylau32New Participant

asked in Discuss data

How to add now column on term level page?

I would like to add new column e.g. Description to the column bar, next to Abbreviation, but not familiar how to achieve it? current layout syntax

4 days ago

Adela SotonovaCommunity Manager

published in Discuss data

Data Type Conversions in DQCF.A.Q.

Data type conversions occurrences when working with databases are the natural behaviour of DQC. When reading data from a database (e.g. using JDBC Reader step), the data type is read from the database and transformed into DQC data type.DQC internally works with its own data types. When writing the data back to the database (in such case, JDBS Writer step is commonly used), data type alternation takes place. The rules for data types conversions are defined in SQL Transformation Rules. There is a possibility to change from what exact database types there will be a conversion to DQC types. To redefine the database types from which DQC will transform data into its own data types:Go to Window > Preferences Select Ataccama DQC > Database > SQL Transformation Rules Modify SQL transformation rules of the specific database product you use

6 days ago

Adela SotonovaCommunity Manager

published in Discuss data

How can I find and replace all values without opening the plans?F.A.Q.

You can find and replace using the Search option in the upper panel of DQC.Click on Search and enter the text you would like to replace. Click on Replace, and enter the new text you wish to use as a replacement. Clicking on Preview will display a dialog showing where text was found, and a preview of the XML representation of the plans, before and after the change. You may want to uncheck some of the locations. Click OK.

100

10 days ago

Adela SotonovaCommunity Manager

published in Discuss data

Should I ask in Community or raise a ticket to Support?

Are you wondering if you should ask in Community or raise a ticket to our Support team?No worries! We have summarized the purpose of each platform for you. Ataccama Community is a place where you engage directly with your industry peers and Ataccama product teams, have the opportunity to influence the development of Ataccama ONE platform by voting on and raising feature requests, find out more about upcoming events (both conferences and webinars), ask questions about products and features and learn more about new product releases and tips & tricks. Ataccama Support provides general guidance on implementation and configuration of Ataccama products, root-cause analysis of technical issues that arise during standard usage of Ataccama products, during installation, upgrades and integration of Ataccama product and acknowledging bug reports, providing fixes and/or suggesting workarounds. Don´t hesitate to ask questions in the comment section, we will be more than happy to answer them!

120

10 days ago

jdc122New Participant

asked in Discuss data

How best to use the Purpose function in Ataccama?

Any best practices for using the Purpose function in Ataccama One (webapp)? I see that it is recommended for monitoring projects but when I create a monitoring project I want to be able to search for that tag. Any tips for searching just based on the purpose tag? I’m very new to Ataccama so any and all tips would be appreciated!

10 days ago

jhoppeschNew Participant

asked in Discuss data

Operate on File: INFO Operation

I’m trying to read the file name of a file so I can write it in an email within a Workflow. I’m using the “Operate On File” task. The Operation I selected is “INFO”. I then point to the Source File. Next I’m trying to determine which variable I use to supply to the Send Email task. The Operate On File Documentation says you can use task variables and the example they give is “name”, “localName”, “size”, and “timestamp”. When I try using these variables in the Send Email task they just come across as blank in the email (variables appear to be null). Here is the body of the email I’m using: Name = ${name}localName = ${localName} Two questions:Does any one happen to know what I’m doing wrong in above?Additionally is there a way to pull out a file name within a Plan. I’m using the “Excel File Reader” step. I want to pass along the file name in the flow so I can use it later on. Thanks!

1 month ago

Jan BalataCommunity Manager

published in User Research

Let's shape the future of Ataccama together

At Ataccama we value feedback from our users as we strive to bring them the best solutions to their data challenges. We want to understand how they use Ataccama in their work and what they want and need—and your feedback helps make us better. What you get See new features and prototypes before everyone else. Share your Ataccama experiences with our friendly researchers. An opportunity to shape the future of new products. Gifts and vouchers for your time and participation. Join User Research at Ataccama! How to get startedFirst, join the User Research at Ataccama. When you’re a match for a study, a user researcher will send you an e-mail invitation for 1:1 research sessions, usability testing for new features or with a short online survey. You will then select a time slot that best fits your schedule. Finally, you will join the session with a user researcher. We promise we won’t contact you more than once a month. We value your privacyDon’t worry—we will never ask you to share any

1020

1 month ago

mehalrathodNew Participant

asked in Discuss data

Error on Edit Transformation

I am getting the error “Column Name cannot be empty” under StringValue. When I click on the drop down, there’s no options available.

1 month ago

Daniel MEmployee

posted in Discuss data

LDAP Integration with Keycloak

What is LDAP?LDAP is directory that stores companies usernames, passwords, email addresses, connection information and much more. It is usually used due to it's ability to allow hundreds of active connections at any given point.In terms of configuration and connectivity, in Ataccama we authenticate/authorize through a 3rd party tool called Keycloak. Items to consider prior to connecting to LDAP - Best PracticeYou first need to understand how your organizations Active Directory is setup. Some pre-requirements needed can include things such as:Do you have a list of groups you need to import? If the answer is no, you may want to speak to your engagement manager from Ataccama to discuss in detail. In short, LDAP groups is a way where we can map Ataccama Roles to a single group. This will heavily assist in ease of maintenance going forward and not leave your devops team stuck doing manual work such as adding/removing new users each time someone is added/removed from LDAP. Once you have dec

1 month ago

onipledNew Participant

asked in Discuss data

Wait step 2

Hi, is there a method to make a “wait n seconds” between 2 steps?Thanks a lot

1 month ago

lumir.studnicka

published in Discuss data

ONE Desktop Git recommendationsTutorial

GeneralIt is strongly recommended not to place an Eclipse Project directly inside the git repository.That means, avoid having .git directory and .project file at the same level - instead, place the project into a sub directory.On the other hand, there are particular config files which you typically keep at the same level as .git directory: .gitattributes and .gitignore. We use them to control some processes when working with Git. Note: settings in these files will override any git global settings on your computer.Example of recommended setup is as follows: .gitattributesThe file provides a possibility to control certain operations in the git repository. Especially it is important to keep the line endings (prevents Git from normalizing them) as provided in the Ataccama default Eclipse Project content because:Prevents the "The project signature is invalid" issue resulting into a state when you are not able to see/work with the Project at all (entire project tree is not visible). Prevent

810

1 month ago

kumaritarNew Participant

asked in Discuss data

For or while loop in detection rule

How can we use functionality like ‘for’ and ‘while’ loop in detection rule field while writing/creating rules for capturing data/records.

1 month ago

onipledNew Participant

asked in Discuss data

JSON Call. Get Method dynamic parameter

Hello, I’m new with Ataccama and I have a simple problem. I want call a Rest service:https://api.bulkemailverifier.com/api/a/v1?key=xxxxxxxxxx&email=myemail.comI’m using the JSON Call step and If I put the full URL with my email it’s working, but now I want read the emails forma txt file and I don’t know how to make the url dynamic.In the step I have 3 parameters: URL: Resource I set it as https://api.bulkemailverifier.com/api/a/v1?key=xxxxxxxxxx&email=Method: GETURL: HERE IS WHERE i DONT KNOW WHAT TYPE. I have tried a lot of combinations without successThe input file has one column with the mail: src_mailThanks

1 month ago

mcvinothNew Participant

asked in Discuss data

Multi Language support

Hi,Am exploring Ataccama MDM and would like to know if Ataccama MDM supports Multiple language in matching and data maintenance. Appreciate your help. Thanks.Vinoth

2 months ago

srikanth.gurramNew Participant

asked in Discuss data

Looping record by record in Ataccama One Desktop

We have one use case where we are looking for a feature of looping the records and reading it record by record .. Can you please share any template plan for the same..

2 months ago

Siva_MadhavanNew Participant

asked in Discuss data

How to Execute SQL Query using Components

Hi Team, I have bunch of queries sitting in my Oracle tables(queries in one of the column). I am trying to see if I can read the oracle table as source and use the column values(which has sql queries ) to be sent to database & get return value. Is there a component that can help me achieve that? jdbc reader, sql execute components expect you to hard code the query. But in my case the query will come as value from one the table. eg) Col1 Col2 1 select count(*) from tab A 2 select count(*) from tab B In the above example I wanted to use col2 as input and pass the values from Col2 to DB and assign the output to next transformation. Hope its clear.

2 months ago

Anna_NebesovaCommunity Manager

published in Discuss data

How to use graphQL queries in ONE DesktopTutorial

Let‘ say you have a graphQL query that works in a Postman or in Ataccama playground, and you want to use it in a plan in ONE Desktop. How to do it?You cannot simply copy and paste the JSON body into JSON call step. You have to reformat it. You can use the COPY CURL button in Playground (in the upper right corner) or similar button Code in Postman. That will create a curl command that also contains the body:PlaygroundCurl commandThis body can be then pasted into JSON call. The query method needs to be set as POST.JSON call step configuration Want to learn more about the graphQL API? Check out the documentation: https://support.ataccama.com/home/docs/aip/latest/development-guides/one-development-guide/one-api

360

2 months ago

ashpoghoshNew Participant

asked in Discuss data

Copy File from remote location

How can we download files from remote path ( connected through vpn) on to local?I tried with Operate on File component but it is not working.Is there any work around for it?

2 months ago

LucaEmployee

posted in Discuss data

Data Governance & why we need it

Enterprise Data Governance as the management of data across its pipeline - from production to consumption (and retirement). How to enable our “data fellows” to leverage on data to save money, save time and reduce risk?What are the key elements to success? What are your thoughts?

2 months ago

anu1237New Participant

asked in Discuss data

Rows to Columns

I was wondering if there is a way in Ataccama that I can move my rows data into columns?I’ve data as such:Element: Dimension: Values: Code: XYZ Validity 200 678XYZ Completeness 250 678 YUP Completeness 300 555 HIO Accuracy 400 100 I’d like it to look like:Element: Validity: Completeness: Accuracy; Code: XYZ 200 250 250 678 YUP 500 300 300 555 HIO 200 450 400 100 Thank you!

2 months ago

DannyRyanCommunity Manager

published in Discuss data

What is Reference Data?Reference Data Management

Simply explained, reference data is data that serves as the model for all other data throughout an organization. It is contained within tables and databases, which help bridge one source system to another, and provides the foundation for the entire data architecture. Together with the initiative set forth by the overall data governance program, reference data maintains consistent data across all departments and allows for source system inter-communication. Reference Data tables are entities that compose the framework of the reference data architecture, providing lists of values for each department and the company as a whole. They contain either the backbone data in its base form (central authority) or data that is a derivative of the base-form data (tables used in the various branch systems throughout the enterprise).Each department within a company works with table data fields in a particular format that suits their processes. Although department A might deal with the same product as

401

2 months ago

Neeraj SinghNew Participant

asked in Discuss data

Use of Joiner in component rule

I am trying to build a component rule where I can compare primary_id from catalog table A to another table B using join and send primary_id existing in both tables, existing only in catalog table A and existing only in B table in the one report. Also checking if that is possible through Lookup

2 months ago

PCappNew Participant

asked in Discuss data

Problems connecting to a MS SQL Server

We are having a difficult time connecting a MS SQL database to Ataccama

2 months ago

Page 1 / 3

Ataccama Community

Data Type Conversions in DQCF.A.Q.

How can I find and replace all values without opening the plans?F.A.Q.

ONE Desktop Git recommendationsTutorial

How to use graphQL queries in ONE DesktopTutorial

What is Reference Data?Reference Data Management

Badge winners

Let's shape the future of Ataccama together

Sign up

Login to the community

Scanning file for viruses.

This file cannot be downloaded