Skip to main content

Learn & Share

Discuss data, share best practices, learn, and grow with Ataccama's Community.

833 Topics
Luca
Ataccamer
LucaAtaccamer
posted in Data Quality & Catalog ⚙️
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? 

1553
D
Data Voyager
A
Data Voyager
anu1237Data Voyager
asked in Data Quality & Catalog ⚙️
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!  

1041
T
Ataccamer
DannyRyan
Ataccamer
DannyRyanHead of Technical Training
published in Master Data Management & Reference Data Management 🛰️
What is Reference Data?Blog

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

921
Luca
Ataccamer
hoo
Ataccamer
hooAtaccamer
posted in Data Quality & Catalog ⚙️
Why Pie charts are evil?

Data Stories provides a wide range of charts, it includes also Pie and Donut ones, even though I do not recommend using them, and the same applies to a Gauge chart. Let's look at the reasoning why and why I'd recommend using a (stacked) bar chart instead.Space usageIn data visualization (reporting, data storytelling) you have limited space you can use. Your task is to fill the limited space with the most value for the end viewer/user. Note, most value does not necessarily mean most charts, sometimes one curated chart is far better than five. The problem with Pie, Donut and Gauge charts is that they use more space in comparison to an alternative that provides the same value - a bar chart. Sales distribution on a Pie ChartMore space is used due to 2 reasons:Pie and Donut charts use Area to give value to a single category. Bar chars use just distance. An Area just takes more space All these charts are circular, which creates unnecessary space around the chart objectBellow find a better al

1524
hoo
Ataccamer
N
Data Voyager
Neeraj SinghData Voyager
posted in Data Quality & Catalog ⚙️
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

400
N
Data Voyager
M
Data Voyager
mehalrathodData Voyager
asked in Master Data Management & Reference Data Management 🛰️
How to create user groups

We would like to have a user group in AtaccamaOne so that when new people join, we do not have to manually add them for access of rules, catalogs or projects. Simply adding them to a user group should give them all the necessary access. How to create such a user group?

1271
A
Data Voyager
konstantinos.patikas
Ataccamer
konstantinos.patikasAtaccamer
published in Master Data Management & Reference Data Management 🛰️
Setup/Tuning Kafka streaming in MDMBest Practice

IntroductionWe did an internal performance PoC for Streaming. We are reading messages (“msg”) from Kafka or Java messaging service. Parameters In order to tune the performance of the streaming we need to modify 2 main parameters on MDM side:settings.count = how many messages we need to consume in one single batch settings.timeout_s = what is the maximum timeout to wait for this number of messages Average duration of the task vs Records per second We are not aiming for the throughput (records per second) but we are aiming for the average duration of the task. The goal is to run it under 1 sec (1000ms). In various scenarios we have to increase the settings.count parameter starting from 1, 20, 30 etc. Scenarios Below are the different scenarios of using different settings for various tasks/transactions in MDM within 10 mins (600sec)For example of timeout of 1 sec and settings.count = 1000 (scenario , that means that we try to consume 1000 msg at once within this 1 sec. We will consume wha

2700
konstantinos.patikas
Ataccamer
konstantinos.patikas
Ataccamer
konstantinos.patikasAtaccamer
published in Master Data Management & Reference Data Management 🛰️
MDM model Pros/Cons of splitting Entity based on TypeBest Practice

1 entity Party→ 2 entities (Person/Organization)or 1 entity Contact → 2 entities (Phone/Email) etc Pros Clean Data Model (on attribute level)In general, we have only columns that are needed for a particular entity (Person) or (Organization). This means that, for example we do see the company_name attribute on the Person records, etc. So in general we have fewer columns in the tables. This could be especially important for the generated MDM native services format (WSDL in SOAP, or all attributes used in the REST API). The consumers of the web services only see attributes per definition of the given model entity and don’t see any irrelevant attributes (similar to the data hiding/encapsulation principle in the Object-Oriented approach).This can also help minimize the area of impact in case of a required model change (the impact to online API change can be countered with custom .online services exposed as wrappers to the MDM native services keeping the API stable with a fixed set of attrib

5131
S
Data Enthusiast
Martin Danek
Ataccamer
Martin DanekAtaccamer
published in Master Data Management & Reference Data Management 🛰️
MDM Implementation StylesBest Practice

Multiple ways to implement your MDM solutionThere are several ways to handle and manage data when deploying a Master Data Management solution. Depending on the approach, we recognize the following styles that can be implemented: Overview of MDM implementation styles REGISTRY StyleIn this style, the various source systems publish their customer data and the subscribing hub stores only the source system IDs, the Foreign Keys (record IDs) and the key data values (needed for matching). The hub runs the cleansing & matching algorithms and assigns unique global identifiers to the matched records, but it does not send any data back to the source systems.Master data distribution is performed downstream by federating the source data. The transformation and consolidation process for building the golden data is performed on demand.This approach is completely non-intrusive and maintains data exclusively in the source applications. This style allows read-only access to the golden data via feder

13541
DannyRyan
Ataccamer
DannyRyan
Ataccamer
DannyRyanHead of Technical Training
published in Master Data Management & Reference Data Management 🛰️
Connecting Oracle Database to ONE DesktopBest Practice

If the ONE Desktop application hangs when connecting to an Oracle database.Adding the following two Java Runtime Parameters to the one-deskop.ini file in the root of your ONE Desktop installation folder.-Djdbc.oracle.useDriverQueryForSchemas=true-Djdbc.oracle.disableListingProcedures=truePossible causes of the delayed, hang or errored Oracle Database connection.When the ONE Desktop application first connects to the Oracle Database we try to retrieve all the metadata beforehand, so we don’t have to connect to the database later (every time). If the Oracle Database contains many Procedures this retrieval process can be extremely slow thus the ONE Desktop gets stuck on this request.Adding the -Djdbc.oracle.disableListingProcedures=true Java Runtime Parameter disables the retrieval of the procedures during the initial connection and you can now connect to the database quickly.In addition adding the -Djdbc.oracle.useDriverQueryForSchemas=true Java Runtime Parameter instructs the connection

1330
DannyRyan
Ataccamer
A
Data Voyager
Akash_SinghData Voyager
asked in Master Data Management & Reference Data Management 🛰️
Group and calculation

Hi,I am creating a plan under IDE to group the records on the basis of two column values and then to calculate the sum of all common records having sales value column. I was using Group aggregator step but no luck. Could you please suggest any help. Thanks 

2021
M
Ataccamer
N
Ataccamer
nathaniel.reid-smithAtaccamer
published in Data Quality & Catalog ⚙️
Reorder Columns in ONE ListingTutorial

Did you know that you can reorder or add custom columns to Listings within ONE? Here is an example where we move the validity score to be the second column. You could also disable various columns here if you would like. To do this, you would add the following in Debugging Tools, for more information, please see our documentation. { "_type": "entity.page.listing", "children": { "_type": "relationships.hierarchyListing", "enableSelection": true, "columns": { "name":{ "name": "Name" }, "dqEvalTermAggr": { "name": "Overall Validity" }, "type": { "dataPath": [], "name": "Type", "after": "dqEvalTermAggr", "renderer": { "_type": "glossary.termType.tableCell" } }, "abbreviation":{ "name":"Abbreviation", "after":"type" } } }} 

801
S
Data Enthusiast
J
Universe Traveller
jfbaroUniverse Traveller
asked in Master Data Management & Reference Data Management 🛰️
Can we get the MasterID (Unique, deduplicate) for a NEW person in real time/ online?

Hi there,Imagine Ataccama is the primary source of truth (transactional) for PII information inside a Financial Service company. Now, we would have different ONBOARDING systems (one for each Financial Line of Business that we offer). When a new person tries to create a profile, the Onboard system would (while the user is still looking into the APP) SYNCHRONOUSLY call an Ataccama API with meaningful data that we collected from this person, say: (Full Name, DoB, Insurance Number / Any other ID document, Email(s), Phone(s))m then Ataccama would quickly do the “Match” and return if this person (according to the information we provided) is likely to ALREADY exist. If the probability is higher than some threshold (Ie. 95%), it would also return the MASTER UUID for this person in Ataccama (Lookup key). Then the onboarding would ask this person to log in, as this person ALREADY exists in our Ataccama Database.Can Ataccama do the MATCH and return the % probability in near real-time? Instead of

2163
J
Universe Traveller
A
Data Voyager
Akash_SinghData Voyager
published in Master Data Management & Reference Data Management 🛰️
Could you please let me know how we can create a connection to Hadoop environment in IDEONE Desktop

I am not able to open the documentation for the linkhttps://support.ataccama.com/home/docs/aip/13.2.0/big-data-engine.It showing error. Could you please share the link

451
M
Ataccamer
DannyRyan
Ataccamer
DannyRyanHead of Technical Training
published in Data Quality & Catalog ⚙️
How to monitor the current execution of a plan?Tutorial

DQA offers a way to monitor the processing visually, providing counts of processed records, percentages on completion of the different operations (steps) and visual cues to the flow of data to identify bottlenecks. This can be achieved by opening a special view of any plan being executed, which will mirror the original plan, showing the processing of records and other aforementioned visual features.To open the monitoring, click the Show progress button, which appears in the Console when the plan is being executed.You can also configure this monitoring window to be opened automatically whenever a plan is executed. The default configuration for the monitoring can be changed by:Open Window > Preferences Navigate to Ataccama DQ Analyzer > Launching > Progress Viewer. Change Automatically open progress viewer for launched plans to Always. You can also change how the Progress Viewer should behave once the execution finishes. 

370
DannyRyan
Ataccamer
DannyRyan
Ataccamer
DannyRyanHead of Technical Training
published in Master Data Management & Reference Data Management 🛰️
What is the maximum number of rows and columns provided in one input to the profiler with drill through on?F.A.Q.

There is no limit on the number of rows written to the drill-through table. If not specified, all rows will be written.The maximum number of columns is not a specific number and depends on the DB. See this Wikipedia page for detailed information by DB type. 

330
DannyRyan
Ataccamer
DannyRyan
Ataccamer
DannyRyanHead of Technical Training
published in Data Quality & Catalog ⚙️
Is it possible to automate table profile creation?F.A.Q.

Table profile creation can be automated after buying the more advanced Data Quality Center (DQC) software.Schedule a call | Ataccama On the other hand, with Data Quality Analyzer (DQA, free software), the automation is not possible.  

360
DannyRyan
Ataccamer
DannyRyan
Ataccamer
DannyRyanHead of Technical Training
published in Master Data Management & Reference Data Management 🛰️
How to connect to an SQL Server using Windows Authentication?F.A.Q.

There are two ways to do this, using two different driversRight-click Databases > New Database Connection. Connect via the JDBC driver:select MS SQL in the Database type fieldadd integratedSecurity=true to the end of the connection string.For example jdbc:sqlserver://localhost:1433;databaseName=test1;integratedSecurity=true  Connect via the jTDS driver:select jTDS - MS SQL in the Database type fieldspecify a connection string in the following formatjdbc:jtds:sqlserver://localhost:9876/test1;domain=companyfill in Username and Password 

4860
DannyRyan
Ataccamer
DannyRyan
Ataccamer
DannyRyanHead of Technical Training
published in Data Quality & Catalog ⚙️
How to configure the temporary folder used by DQA (permissions error)?F.A.Q.

You might experience problems when installing DQA on a computer with limited permissions or high restrictions. Even if the installation is done in a folder where you have rights for installation, DQA might fail to execute plans. The reason is that DQA makes use of a temporary folder (usually in the path to the user cache folder) for placing instances of executed plans. This folder is the default Java temporary folder. The execution might throw an exception due to being unable to create a temp plan file.You can override the path to this folder by passing its chosen value as part of the special environment variable JAVA_OPTS , which serves as the Java Virtual Machine arguments. This should be created as follows:Open for editing the dqa.ini file placed in the root folder of the DQA installation, using an editor sensitive to End Of Lines (EOLs) in Windows, WordPad is an option, Notepad++ is another option. Add the variable java.io.tempdir . The variable must be passed using the -D notation

380
DannyRyan
Ataccamer
DannyRyan
Ataccamer
DannyRyanHead of Technical Training
published in Data Quality & Catalog ⚙️
How to reserve more memory for the DQA IDE?Best Practice

If you experience out of memory errors when processing a large dataset. You can increase the amount of system memory that is available to the Ataccama DQA application.Open dqa.ini located in the root folder of the DQA installation. This file contains the JAVA_OPTS that will be used by the virtual machine on start.Edit Xmx and substitute the number (256 by default) by a higher number for reserving more memory, e.g. -Xmx1024 

410
DannyRyan
Ataccamer
DannyRyan
Ataccamer
DannyRyanHead of Technical Training
published in Data Quality & Catalog ⚙️
How to reserve more memory for executing plans?Best Practice

DQA plans store data while processing it. This means the more input data there and the more the plan logic multiplies this data to produce desired outputs, the more memory needs to be reserved it.Some of the most memory-intensive steps are Profiling and JDBC Reader.There steps to change the default settings are:Open Window > Preferences > Ataccama DQ Analyzer > Launching. Change the value of the Default memory for launch configuration (MB) to 1024, which is recommended for modern for modern machines. 

520
DannyRyan
Ataccamer
DannyRyan
Ataccamer
DannyRyanHead of Technical Training
published in Data Quality & Catalog ⚙️
DQ Analyzer for Windows can help you gain valuable insights into your data.Tutorial

Did you know our DQ Analyser for Windows (32 or 64bit) can help you to gain valuable insights into your data, and the application is free to use.Visit https://www.ataccama.com/download/dq-analyzer Some of the features include;Duplicate count Pattern & mask analysis Business rule analysis Numeric statistics Ability to drill down into the data on a per record basis Foreign key analysis Dependency analysis Primary key analysis Concerned about duplicate values in your datasets?Frequency Analysis can tell us that we have a value ‘SYSTEM MIGRATION’ in the customer name column 4551 times. It is clear that these customer names were not transferred into the current system correct - supposedly during previous migration activity.One of my personal favorites for the identification of duplicate records is Group Frequency analysis.Here we can see the same value of 4551 as a group size, with a group count of 1. We can interpret the group analysis as there is 1 value that appears 4551 times.Or usi

730
DannyRyan
Ataccamer
DannyRyan
Ataccamer
DannyRyanHead of Technical Training
published in Master Data Management & Reference Data Management 🛰️
Ataccama ONE Free ProfilerTutorial

Disruption starts with good data. We believe good data empowers your company to innovate and grow. It’s easy to start—offer a suite of free software for the data people.Ataccama ONE ProfilerProfile a whole database schema with a few clicks or simply drag and drop a file. Profile data directly from your browser.Start profiling data We also have a collection of example data sets and a PostgreSQL database (loaded with example data) for you to explorer in the free profiler.https://app.ataccama.com/welcome/example-datasetsWe have example data sets for various industries including;Automotive Banking Biotechnology Consulting Education Government Healthcare Insurance IT Services Retail / E-commerce Transportation Telecommunications.Lets try the PostgresSQL database as a connection source from the Education example data set.After clicking the Connect to the database button, we are directed to the Data Sources section of the free profiler. Here we can see I can the education_datasource in my lis

880
DannyRyan
Ataccamer
DannyRyan
Ataccamer
DannyRyanHead of Technical Training
published in Data Quality & Catalog ⚙️
Data Quality Analyzer Tutorial - 4. Email AnalysisTutorial

Learn how to standardize and extract email addresses from a customer data set. Used functions are regex matching, conditions to separate data flows, and merging data flows. 

460
DannyRyan
Ataccamer
DannyRyan
Ataccamer
DannyRyanHead of Technical Training
published in Data Quality & Catalog ⚙️
Data Quality Analyzer Tutorial - 3. Advanced ProfilingTutorial

Learn how to configure custom mask analysis, enable and configure drill-through, check your data against business rules, and configure primary key analysis. 

380
DannyRyan
Ataccamer

Badge winners

Show all badges

Let's shape the future of Ataccama together

Join User Research at Ataccama!
See new features and prototypes before everyone else, and have an opportunity to shape the future of new products.

Read more
Community Terms of Use & ConditionsCookie settings