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.
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?
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
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
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.
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!
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!
We have just publicly released version 13.7.1 of the Ataccama ONE Gen2 Platform.This is a bugfix release. See Ataccama 13.7.1 Release Notes for the full list of fixes.DownloadsDownload the latest version of your products at our Downloads page.UpgradingONE RDM and MDMAs part of this release, we are also sharing upgrade and installation guides. The support team is ready to help with installation and upgrade issues.Installation and upgrade services for your solution are not covered by the support or maintenance contract, but our experienced team is ready to help with remote upgrades. Contact us to get a quote and expected timing.ONE Data Quality and Data Governance SuitesIf you wish to migrate to the new generation, or if you wish to upgrade to a new release of v13 of the Ataccama Data Quality and Governance suites, an upgrade path will be provided for all existing customers. Please contact your account manager to discuss details.
Hello,My name is Ben Lopez, I’m new in the community.I'm holding a bachelor's degree in Business Administration. My work experience is in Finance and Digital Marketing, I worked and developed a lot of projects for different industries.A couple of years ago I decided to move in deep into the Tech Industry. I started taking a few courses through (LinkedIn Learning, Coursera, Google, IBM, etc.), and right now I'm enrolled in the University pursuing a second degree in Computer Science.I gained a lot of new tech skills but, I need to apply them to real projects to fulfill my career in the tech industry.What do you think? can you share some personal experiences?Have you experienced a career change?Excited to learn more from this amazing community!Keep in touch by LinkedInwww.linkedin.com/in/benlopezra
We have just publicly released version 12.9.1 of the Ataccama Platform.This is a bugfix release. See Ataccama 12.9.1 Release Notes for the full list of fixes.DownloadsDownload the latest version of your products from our Downloads page.UpgradingAs part of this release, we are also sharing upgrade and installation guides. For more information, refer to the respective Installation and Upgrade Guides for your particular products.
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!
I opened the on-prem AtaccamaONE environment this morning and was looking at recent (auto) profiled catalog items. A majority of them are not found - the error is “Catalog item not found” and the provided explanation is “This catalog item doesn’t exist anymore or someone has revoked your access”. Neither of these cases should be true as I am the only one who currently works in the environment and I’m the one who launched the data discovery on 3/09. This is a recent error - I have not seen this before. Any help you could provide would be appreciated.Thanks.
Hi, is there a method to make a “wait n seconds” between 2 steps?Thanks
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..
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.
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?
Read how other companies use Ataccama
Read our original content
Already have an account? Login
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.
