Master Data Management & Reference Data Management 🛰️

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 fil

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

Hi,When importing a flat file, if the data has double quotes or single quotes or some special characters then they are automatically being replaced with ‘?’s. This is not as expected. This is the same issue for all encoding formats. Could you please suggest how to fix this? Thanks,Kranthi 

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 w

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?

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-

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

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/tra

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.

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

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 

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

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

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

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. 

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=compan

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 Bankin

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

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

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 - 

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