Master Data Management (MDM)

Discuss, learn, ask, suggest, share 🔍

  • 26 Topics
  • 27 Replies

26 Topics

S
SathyaAtaccamer
posted in Master Data Management (MDM)

Permissions Model Best Practices

MAJOR CONCEPTS IN PERMISSIONSKeycloak, which us primarily used to manage Users and Roles as well as their assignment.  ONE web application, where it is possible to assign preconfigured permissions to Users and Roles. It is also possible to change the default configuration there and create custom permissions. Users (Persons) - identify people or services who have access to Ataccama ONE.  Role - the container for permissions that users can perform in ONE on entities in alignment with company organization chart. Role refers to roles defined in Keycloak, for example MMM_ admin. Users need to be mapped to Roles, which will determine their node permissions based on the operations allowed for that role on individual nodes. More than one role can be assigned to a user. Users and roles are managed primarily in the Keycloak service, then synced with ONE. Users and Roles access can be regulated by permissions, that are configured via different blocks: Capabilities, Operation Sets, Operations. P

0
S
11 days ago
B
bazSpace Explorer II
asked in Master Data Management (MDM)

Displaying a list in a drop-down

Hi,   How do I present a selection of values in a drop-down in the RDM create/edit screens.E.g. I have an entity called Door with a column called state that can have a value of either Open or Closed. Can this be presented as a drop down to a user?baz

3
M
12 days ago
M
MacarenaSpace Explorer
asked in Master Data Management (MDM)

ONE Web connection to amazon Redshift

Is there a way to connect ataccama One Web to a private Redshift? 

1
Cansu
18 days ago
O
OjaswiniRocket Pioneer II
asked in Master Data Management (MDM)

RDM Images by value presenters not working

Hello, I’m trying to demo the RDM Banking Example. However, the flag images in the Country table are not showing properly (as shown in Picture1.png).I have fixed the source CSV file to point to an online website with corresponding flag images (shown below) and run its loading plan to update the data on RDM, but those images are still not showing on RDM. (as shown in Picture2.png)

5
O
18 days ago
M
maneelloydsSpace Explorer
asked in Master Data Management (MDM)

Getting one browser error while connecting to oracle database

Hi All, We are getting the below error while adding an oracle database from add datasources in One web app. we give jdbc connection string, username and password(doesnt matter/validate if it is right password/username). Please check and let me know how can i troubleshoot/debug the issue. Some browser component is throwing the error. jdbc - format - jdbc:oracle:thin:@<jdbcHost>:1521:<jdbcDatabaseName> error when we try to connect the first time after a restart of one-tomcat servicejava.lang.RuntimeException: java.lang.ExceptionInInitializerError        at com.ataccama.one.browser.database.AbstractDatabaseDatasourceClient.retrieveConnectionWithTimeout(AbstractDatabaseDatasourceClient.java:119)        at com.ataccama.one.browser.database.AbstractDatabaseDatasourceClient.handleRequest(AbstractDatabaseDatasourceClient.java:353)        at com.ataccama.one.browser.database.AbstractDatabaseDatasourceClient.<init>(AbstractDatabaseDatasourceClient.java:92)        at com.ataccam

3
Cansu
25 days ago
M
maneelloydsSpace Explorer
asked in Master Data Management (MDM)

Ataccama connection to https endpoint

Hi All, we have Ataccama version 12.8.0 version in our one web. Is there a connector available or how can we connect to a https url which points to a csv file? how do we configure https get method using security like oauth in Ataccama?

1
A
30 days ago
B
bazSpace Explorer II
asked in Master Data Management (MDM)

RDM - Permissions to stop a role editing published rows

Hi - I need to set the permissions for a role in RDM that allows users within this role to create new rows, edit newly created rows and move them to publish. Once a row has been either Published or ‘Awaiting Confirmation’ the user should not be able to edit or delete the row.Is there a way of doing this in RDM? baz

3
B
2 months ago
M
mehalrathodSpace Explorer
asked in Master Data Management (MDM)

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?

1
Artem Setkin
1 year ago
konstantinos.patikas
konstantinos.patikasAtaccamer
published in Master Data Management (MDM)

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

1421
S
1 year ago
konstantinos.patikas
konstantinos.patikasAtaccamer
published in Master Data Management (MDM)

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

1130
konstantinos.patikas
1 year ago
Martin Danek
Martin DanekAtaccamer
published in Master Data Management (MDM)

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

1941
DannyRyan
1 year ago
DannyRyan
DannyRyanCommunity Manager
published in Master Data Management (MDM)

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

850
DannyRyan
1 year ago
A
Akash_SinghSpace Explorer
asked in Master Data Management (MDM)

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 

1
M
1 year ago
S
ShreeSpace Explorer
published in Master Data Management (MDM)

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

872
M
1 year ago
B
bazSpace Explorer II
posted in Master Data Management (MDM)

Multi Edit problem and work aroundReference Data Management

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!! 

3
D
1 year ago
A
Akash_SinghSpace Explorer
published in Master Data Management (MDM)

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

321
M
1 year ago
DannyRyan
DannyRyanCommunity Manager
published in Master Data Management (MDM)

RDM Record ValidityBlog

When working with Reference Data table there may be a business requirement to control what kind of values can be input into a given attribute which are checked whenever a user creates or edits records within the RDM application. There are two kinds of validations:  The first kind are called Instantaneous validations. These conditions, e.g., regular expressions or string size are checked automatically when you enter an attribute value. When the input value fails to meet these condition, an INVALID message appears next to the attribute field. The second kind are called Online validations. These are more complex conditions, which are triggered by clicking Validate in the Create detail/Edit detail dialogue or upon closing them. Such validations are performed by DQC plans (using, e.g., phone number or address lookups) or SQL queries in RDM. When the input value fails to meet these condition, a Warning message appears next to the attribute field.Records which do not satisfy online conditions

380
DannyRyan
1 year ago
DannyRyan
DannyRyanCommunity Manager
published in Master Data Management (MDM)

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. 

150
DannyRyan
1 year ago
DannyRyan
DannyRyanCommunity Manager
published in Master Data Management (MDM)

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 

480
DannyRyan
1 year ago
DannyRyan
DannyRyanCommunity Manager
published in Master Data Management (MDM)

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

400
DannyRyan
1 year ago
M
Maksim ZhelyazkovAtaccamer
published in Master Data Management (MDM)

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

750
M
1 year ago
DannyRyan
DannyRyanCommunity Manager
published in Master Data Management (MDM)

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

470
DannyRyan
1 year ago
DannyRyan
DannyRyanCommunity Manager
published in Master Data Management (MDM)

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.

360
DannyRyan
1 year ago
DannyRyan
DannyRyanCommunity Manager
published in Master Data Management (MDM)

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

300
DannyRyan
1 year ago
A
AkashSpace Explorer
asked in Master Data Management (MDM)

Integrated Login for database

Hi Team,In Ataccama IDE, while connecting to database we need to provide connection string. Also, username and password. In other tools like SQL server, we can use windows authentication to login so no need to enter username and password.Could you please help me how we can achieve the same integrated login for database connection. 

1
M
1 year ago

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
Terms & ConditionsCookie settings