Skip to main content

Learn & Share

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

811 Topics
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

800
DannyRyan
Ataccamer
2 years ago
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
2 years ago
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
2 years ago
DannyRyan
Ataccamer
DannyRyanHead of Technical Training
published in Data Quality & Catalog ⚙️
Data Quality Analyzer Tutorial - 2. Understanding Profiling ResultsTutorial

Understand and interpret the information generated in profiling results with the free Ataccama DQ Analyzer (DQA). 

290
DannyRyan
Ataccamer
2 years ago
DannyRyan
Ataccamer
DannyRyanHead of Technical Training
published in Data Quality & Catalog ⚙️
Data Quality Analyzer Tutorial - 1. Creating a profileTutorial

Get started with Ataccama DQ Analyzer (DQA) and learn how to create a data profile. 

510
DannyRyan
Ataccamer
2 years ago
S
Data Voyager
ShreeData Voyager
published in Master Data Management & Reference Data Management 🛰️
Instant trigger at database tables, if inserts, updates or deletes in RDM data.Reference Data Management

Hello all,I am looking for the live reflection of changes at rdm data and its corresponding tables in the database. As per my understanding from documentation the rdm acts as --    While installation RDM it configures RDM database as well, when ever the new table or any changes to the existing tables done in the data logical model it automatically reflects in database as well, for this process we define the database names while creating a table in data logical model.    RDM can synchronize reference data in its repository with any other defined databases. For this process it required to create separate plans/components, the workflow and need to be scheduled for regular runs by the Task Scheduler. In-fact it seems no mechanism for live updates to the table which is located in external data base. the red color shows the data is published in RDM and waiting to run the scheduling process to affect the changes in the database. The green color confirms the changes after running the schedulin

1242
M
Ataccamer
2 years ago
M
Ataccamer
Maksim ZhelyazkovAtaccamer
published in Master Data Management & Reference Data Management 🛰️
Configuring MSSQL Windows Integrated Security in GEN1 and Gen2Tutorial

Installing KerberosIn Linux MSSQL with Windows integrated security requires the installation of the Kerberos client. In terminal run the following to install Kerberos on your workstation: yum install krb5-server krb5-libs krb5-workstation Create a krb5.conf file. Below is an example, but be noted that yours may differ: [libdefaults]forwardable = trueticket_lifetime = 24hdns_lookup_realm = falsedns_lookup_kdc = falsedefault_ccache_name = /tmp/krb5cc_%{uid}#default_tgs_enctypes = aes des3-cbc-sha1 rc4 des-cbc-md5#default_tkt_enctypes = aes des3-cbc-sha1 rc4 des-cbc-md5[domain_realm][logging]default = FILE:/var/log/krb5kdc.logadmin_server = FILE:/var/log/kadmind.logkdc = FILE:/var/log/krb5kdc.log[realms][EXAMPLE.NET](http://example.net/) = {admin_server = 123.123.123.123kdc = [abc.example.net](http://abc.example.net/)} In terminal run:  kinit -V -c krb5cc firstname.lastname@EXAMPLE.NETEnter your password and wait for the message: Authenticated to Kerberos Authenticate to the SQL server Se

1740
M
Ataccamer
2 years ago
DannyRyan
Ataccamer
DannyRyanHead of Technical Training
published in Master Data Management & Reference Data Management 🛰️
How to count the number of source systems per master id?Tutorial

If we had the following Instance Data containing the source system and master id groups for each of the instance records and we would like to calculate the count of source per master id. Step by step guide. Create our input data as a text file. Create a new plan and add the following steps to the plan; 1x Text File Reader 1x Representative Creator 2x Text File Writer Connect the steps as follows Configure the Text File Reader to read from the input data we created in step 1. and add 2 shadow columns. These shadow columns could alternatively be added via an Alter Format step. The columns will hold our count per source system (A | B)   Double click on the Representative Creator step and click on the Group By tab. select the master_id as the column to group by.     Add a Rule to the Representative Creator step by clicking on the Add button or double clicking on the asterisk.  Double click on the newly created Attribute rule and then on the Representative Attributes tab

1390
DannyRyan
Ataccamer
2 years ago
DannyRyan
Ataccamer
DannyRyanHead of Technical Training
published in Master Data Management & Reference Data Management 🛰️
ONE Desktop Keyboard ShortcutsF.A.Q.

Below are Ataccama ONE Desktop shortcuts organized into categories by particular viewer or editor.A full list of keyboard shortcuts can be found and called by pressing Ctrl+Shift+L at any time.To edit shortcuts, go to Window > Preferences > General > Keys.Data Viewer SQL Editor Profile Viewer Plan Editor Search and Navigate Edit Layout Run Progress Viewer Online Service Editor Common ShortcutsData ViewerCtrl+F - Find - Opens Find dialog. Ctrl+L - Show Columns - Opens dialog where user selects which columns should be visible and which columns should be hidden. Ctrl+Home - Selects and reveals the top left cell. Ctrl+End - Selects and reveals the bottom right cell.SQL EditorCtrl+F - Find - Opens Find/Replace dialog if SQL query field has focus (from v8). Ctrl+Enter - Execute - Executes current query. Ctrl+R - Read Rest - Reads the rest of the query execution. Ctrl+B - Next Batch - Reads the next batch of the query execution. Esc - Stop - Stops the query execution.Profile View

840
DannyRyan
Ataccamer
2 years ago
DannyRyan
Ataccamer
DannyRyanHead of Technical Training
published in Master Data Management & Reference Data Management 🛰️
How to calculate Standard Deviation in ONE Desktop?Tutorial

The standard deviation measures the spread of the data about the mean value. It is useful in comparing sets of data which may have the same mean but a different range.For example, the mean of the following two is the same:18 19 20 21 22 = 18+19+20+21+22 / 5 = 2010 15 20 25 30 = 10+15+20+25+30 / 5 = 20However, the second is clearly more spread out. If a set has a low standard deviation, the values are not spread out too much. Lets do the calculations outside of ONE Desktop, so we know our expected result.ExampleFind the standard deviation of 4, 9, 11, 12, 17, 5, 8, 12, 14?First work out the mean: 4+9+11+12+17+5+8+12+14 / 9 = 10.222Now, subtract the mean individually from each of the numbers given and square the result. This is equivalent to the (x - )² step. x refers to the values given in the question.x 4 9 11 12 17 5 8 12 14 (x -  )2 38.7 1.49 0.60 3.16 45.9 27.3 4.94 3.16 14.3 Now add up these results (this is the 'sigma' in the formula): 38.7+1.

830
DannyRyan
Ataccamer
2 years ago
DannyRyan
Ataccamer
DannyRyanHead of Technical Training
published in Data Quality & Catalog ⚙️
How to setup email notifications for DQ monitoring projects?Tutorial

Did you know that you can setup email notifications when certain events occur in your DQ Monitoring Projects? There are 4 types of notifications that can be assigned to events; Notification + Email sends both an in-app notification and an email to the recipients in case of the event occurrence. Email sends an email to the recipients in case of the event occurrence. Notification sends an in-app notification to the recipients in case of the event occurrence. Leave the events notification options blank if you do not want to be notified of a particular event occurrence. Process Steps Configure the MMM Module for generating links in emails.Ensure the MMM Module has been configured for SMTP (There is a link to the documentation at the end of this post)Underneath your existing configuration for plugin.email.ataccama.one.addressAdd a new configuration line for plugin.email.ataccama.one.base.url which is the base URL for generating links in emails. The default value is http://localhost:80

5060
DannyRyan
Ataccamer
2 years ago
DannyRyan
Ataccamer
DannyRyanHead of Technical Training
published in Master Data Management & Reference Data Management 🛰️
How to stop a plan if certain condition is met?

In this Tips & Tricks post, I will show you how to configure a plan to evaluate your data and make a decision on whether to continue processing your data as planned or to stop processing data and exit the plan safely without the plan throwing an error.In this scenario we will generate a data set consisting of 1 column and 100 records. The column will have either a true or false value. We’ll have a business rule that checks the values of the 100 records and stops processing the data if at least one false value is found in the data stream.  Let’s prepare the data pipe initial so that we have input and output data flows.Starting with a blank .plan file we will add a Text File Reader step to store our results and a Random Record Generator step to generate the 100 records.We’ll configure the Random Record Generate step to create 1 column named value, and to create the values true 99 in 100 frequency and false 1 in 100 frequency. This configuration will ensure that when we run the plan 1

1490
DannyRyan
Ataccamer
2 years ago
B
Data Voyager
bazData Voyager
posted in Master Data Management & Reference Data Management 🛰️
Multi Edit problem and work around

Hi,   I’ve noticed an issue within RDM when attempting to update a foreign key values for multiple rows using RDM’s Multi edit functionality.If I attempt to enter a value the “Apply” button never enables and the usual selection list fails to appear If I click on the search magnifying glass  the Lookup window fails to list any values to select from The work around is to add anther non-key field to the multi-edit.. enter a value within it, then enter a new foreign key value and then delete the added non-key field before clicking Save to perform the update. Non-key field added Foreign Key field is now updatable Now delete the non-key field.. it works!! 

903
D
Ataccamer
2 years ago

Badge winners

  • First idea 💡
    Roman Tobisekhas earned the badge First idea 💡
  • First idea 💡
    keithjankehas earned the badge First idea 💡
  • First idea 💡
    Elliehas earned the badge First idea 💡
  • First idea 💡
    David Suenhas earned the badge First idea 💡
  • First idea 💡
    clyormzhas earned the badge First idea 💡
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