Skip to main content

Master Data Management & Reference Data Management 🛰️

Discuss, learn, ask, suggest, share all things MDM and RDM 🔍

  • 242 Topics
  • 528 Replies
242 Topics
B
Data Voyager
BenSData Voyager
asked in Master Data Management & Reference Data Management 🛰️
Rollback loading of configuration to DEV environment

I loaded a configuration with a new table to my organisations DEV PaaS environment and it dropped the existing tables in DEV. How do I rollback this transaction? Any help would be greatly appreciated

602
B
Data Voyager
1 year ago
P
Data Pioneer L2
pdanpoonkijData Pioneer L2
asked in Master Data Management & Reference Data Management 🛰️
Strange error during RDM publish with OnPublish

Hello community,I’m working on an RDM project which has the OnPublish implementation. However, I am encountering an error whenever I try to publish a record. The error message from the Action History states:The response message was:null and response error was 'errorMsg:Cannot get credentials for request.'I have checked all the database connections and the connection to the RDM web application on the runtime server, and there does not seem to be any issue in that regard.Is anyone familiar with this error and could provide assistance? Thank you in advance.

422
P
Data Pioneer L2
1 year ago
C
Data Voyager
chetan2784Data Voyager
asked in Master Data Management & Reference Data Management 🛰️
Atacamma APIs for RDM

Hi All,I am looking for the documentation around available Out of the box APIs in Ataccama which can be exposed to extract data out of RDM tables. Are there any available documentation or APIs provided by Ataccama to expose the reference data tables out of RDM via APIs.Looking forward for any directions here.Thanks,Chetan

3943
A
Ataccamer
1 year ago
B
Data Voyager
bazData Voyager
asked in Master Data Management & Reference Data Management 🛰️
RDM restricting publish rights based on the current user

Hi,   Is it possible to stop someone Publishing a row if they are the ones who “Moved it to Publish”? A team want the ability for all its members to create, edit and publish but restrict an individual team member from publishing a row they create or edit. Those rows would need to be published by another team member.  

523
A
Ataccamer
1 year ago
M_Fabianova
Ataccamer
M_FabianovaAtaccamer
published in Master Data Management & Reference Data Management 🛰️
How to resolve ONE Desktop error “The model project is not licensed for use on this machine”Best Practice

When you use in ONE Desktop application the project synchronization with Git, you can in some cases meet with the error “The model project is not licensed for use on this machine”, followed by warning “Project signature is invalid”.At first glance, it seems there must be an issue with the license. However, mostly it is not the case, and the issue is related to Windows line endings, as Eclipse utilizes Unix syntax line endings.How to resolve this?Follow the steps below:In ONE Desktop select your project name (as an example further we use the project Reference Data Manager - Banking example), and click in the top menu panel to choose:File => Convert Line Delimiters To => Unix.   Uncheck Show only text files option and click Deselect All.   Open .metadata folder in the "Select files to convert" menu, select meta.mmd and manifest.xml files.   Click on the small arrow next to the .metadata folder to display contents, and click on the checkbox beside the libs folder to select all

3330
M_Fabianova
Ataccamer
1 year ago
P
Data Pioneer L2
pdanpoonkijData Pioneer L2
asked in Master Data Management & Reference Data Management 🛰️
RDM Incremental load to CONFIRM state

Hello, communityI want to implement an RDM solution where we periodically load the data from a database and import them to RDM in the published state. Each load could contain new and updated records.So I set the RDM Importer step to load data to CONFIRM state in the INCREMENTAL fashion (which as description state: new records are imported, existing records not present in the input file are untouched, matched records are updated).However, I encountered an error indicating the “Key” is already exist when execute the plan.Could anyone help me on this please? I’m not sure the incremental option only works for loading to EDIT state or do I need to setup anything additionally in the column section.Thank you in advance

762
P
Data Pioneer L2
1 year ago
P
Data Pioneer L2
pdanpoonkijData Pioneer L2
asked in Master Data Management & Reference Data Management 🛰️
Import records with username to RDM

Hello Ataccama community 😀Has anyone previously used the USERNAME column type in the RDM Importer or RDM History Importer? I want to specify the [ Username ] on RDM, indicating who made changes to each record in an automated fashion.However, I got an error telling me that unknown column 'username'; I tried using “USERNAME” instead of “username,” but still had no luck.Could anyone familiar with this help me please?

545
P
Data Pioneer L2
1 year ago
S
Ataccamer
SathyaAtaccamer
posted in Master Data Management & Reference Data Management 🛰️
Permissions Model Best Practices

MAJOR CONCEPTS IN PERMISSIONSKeycloak is primarily used to manage Users and Roles as well as their assignment.  ONE Web Application - where you can assign preconfigured permissions to Users and Roles. It is also possible to change the default configuration and create custom permissions on the ONE Web Application. 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 the company organization chart. “Role” refers to the roles defined in Keycloak, for example, MMM_ admin. Users need to be mapped to Roles. This will determine their node permissions based on the operations allowed for that role on individual nodes. A user can have more than one role assigned to them. 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

3030
S
Ataccamer
1 year ago
P
Data Pioneer L2
pdanpoonkijData Pioneer L2
asked in Master Data Management & Reference Data Management 🛰️
Inquiry about RDM Merge Importer Step

Hello community,I am trying to implement the RDM database synchronization. However, the data from a database does not seem to be loaded back to RDM; thus, I checked the system_input plan, which is the plan that is supposed to load data back to the RDM. The key step is the RDM Merge Importer that loads data back, but after I ran the plan, there does not seem to be any data loaded to the RDM in any viewing perspective.I also notice that the column rdm_primary_key is null for every record not in RDM prior to entering the Importer step. I’m not sure if this is an issue either.Does anyone familiar with the RDM Merge Importer step? Could you please guide me on how to use this step properly?Thank you in advance 😀

362
P
Data Pioneer L2
1 year ago
P
Data Pioneer L2
pdanpoonkijData Pioneer L2
asked in Master Data Management & Reference Data Management 🛰️
RDM reverse synchronization not working

Hello community,I’m implementing the RDM synchronization to sync data with a database. However, the data seems to sync only one way, which is from the RDM to the database. Whenever I add an additional record to the database manually, it gets removed after performing synchronization, and they don’t appear in the RDM inputs view.I have “Use Reverse Synchronization” enabled and followed the steps from Configuring RDM Synchronization with External Databases - Ataccama ONE Gen2 Platform Latest.If anyone knows how to get this working, could you please guide me on this?

885
P
Data Pioneer L2
1 year ago
M
Data Voyager
MacarenaData Voyager
asked in Master Data Management & Reference Data Management 🛰️
ONE Web connection to amazon Redshift

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

501
Cansu
Community Manager
1 year ago
O
Star Blazer L1
OjaswiniStar Blazer L1
asked in Master Data Management & Reference Data Management 🛰️
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)

775
O
Star Blazer L1
1 year ago
M
Data Voyager
maneelloydsData Voyager
asked in Master Data Management & Reference Data Management 🛰️
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

1083
Cansu
Community Manager
1 year ago
M
Data Voyager
maneelloydsData Voyager
asked in Master Data Management & Reference Data Management 🛰️
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?

951
A
Ataccamer
1 year ago
Z
Data Voyager
zayarData Voyager
asked in Master Data Management & Reference Data Management 🛰️
Attribute Name Duplication Error for SQL Catalog Item Query

Hi, I’ve been trying to create a SQL catalog item in the UI using the query below. It’s basically joining the same table twice. The query ran successfully in IDE but it’s giving me an error: Attribute '3' is duplicated. Please make sure that attributes have unique names. Can anyone help?select x.1, x.2, ax.3 as SSN, aze.3 as EIDfrom table1 xinner join table 2 ax on (x.a = ax.b) and trim(ax.c) in ('1','S','Social Security Number US')left join table 2 aze on (x.a = aze.b) and trim(aze.c) in ('E','EMPL_PROVIDED_ID','Employee ID')where x.last_update_date > '2023-02-08 00:00:00.000'

601
Cansu
Community Manager
1 year ago
S
Ataccamer
Samuel MuvdiAtaccamer
published in Master Data Management & Reference Data Management 🛰️
Kafka Streaming Use Case ExamplesBest Practice

Use Case: Send records from Kafka to Ataccama IDE for parsing and other transformations and send this data to database tables Beginning set up for Kafka with MDM: ⦁ The first thing you would need to do is add the Kafka configuration to the runtime configuration file, for usage in the server  The configuration should be in this format as in the picture above, where you provide the connection string, key, trustore, and keystore passwords You will also need to add this information into the serverConfig file as well, naming the server as you would like between the string tags   Once the file configurations are ready for you to connect to Kafka, you can then start adding your streaming information into the model explorer The first step would be to right-click on the STREAMING button in the model explorer From there you would need to click New Consumer You would then click Kafka Stream Source, to create a new kafka streaming source and configuration  Above is the screen you should see

1850
S
Ataccamer
1 year ago
V
Data Voyager
vsoppa1Data Voyager
asked in Master Data Management & Reference Data Management 🛰️
API/Python code for onboarding (connections) the Databases into Ataccama

API/Python code for onboarding (connections) the Databases into Ataccama:-We are trying to create Database connections into Ataccama by using Python. Is there any way to do the same. It would be really great if you can share us with any reference links or docs.Thanks in advance!

1973
Maxim Kim
Ataccamer
1 year ago
M
Data Pioneer L2
MayKwokData Pioneer L2
published in Master Data Management & Reference Data Management 🛰️
How to generate a Basic Auth headerTutorial

Basic Auth headers are frequently used as part of communication between applications, e.g. as part of API calls.Common use cases in the Ataccama context include (and not limited to):Graphql call to ONE application API call to an online service set up on a DQC / runtime / orchestration serverOption 1: Do it in a ONE Desktop plan Create a new plan Create a step that evaluates expressions, e.g. Alter Format Go into the expression window and put this expression in. The username and password are separated with a colon: coding.toBase64('username:password') Click Evaluate Copy the result string Your header is going to be Basic dXNlcm5hbWU6cGFzc3dvcmQ=Option 2: Use an online base64 encode websiteIf you are building something to integrate with Ataccama but you don’t actually have Ataccama ONE Desktop installed…. Go to a website that offers this conversion (e.g. link. Warning: this site is not affiliated with Ataccama) Put in your username and password in this format: username:password, se

2222
Maxim Kim
Ataccamer
1 year ago
B
Data Voyager
bazData Voyager
asked in Master Data Management & Reference Data Management 🛰️
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

393
B
Data Voyager
1 year ago
S
Data Voyager
sxk020501Data Voyager
posted in Master Data Management & Reference Data Management 🛰️
Dynamically provisioning Ataccama environment for supporting automated unit testing capability

I’d like to implement a dynamically provisioning Ataccama environment for supporting automated unit testing capability. I.eBuilding a Container image of Ataccama software stored in a private cloud and. Developers can rapidly iterate code, commit in a repo, CI triggers application build, container image build and Automated unit testing of new features via Azure pipelines.And It seems Ataccama is working on a Containerized deployments soon according to their web site,Does anybody know the timeline of when this feature can be available to do the above goals? Also can we use it as a preview for unit testing environment?

620
S
Data Voyager
1 year ago
Maxim Kim
Ataccamer
Maxim KimAtaccamer
posted in Master Data Management & Reference Data Management 🛰️
What to do if Approval Requests page throws error with NodePath()

One of the customers had experienced the error upon entering Approval Requests page:And it happened after metadata changes that looked reasonably safe.So what happened?It turns out that if you have an entity that is a part of workflow (draft, approve, …, publish) and you already have published some of them -- deleting attribute which is an embedded array of other entities would lead to this kind of error.Luckily, there is a way to fix it if you have access to MMM database: delete from "mdArbitraryReference_r" where id in ( select id_i from "mdArbitraryReference_q" where "referencedNodePath_s" not in (select id from "_MmdDictionary" where type = 'PATH')); delete from "mdArbitraryReference_q" where "referencedNodePath_s" not in (select id from "_MmdDictionary" where type = 'PATH');These SQL queries fix DB inconsistency removing invalid records from arbitrary references tables.I would still suggest to consult with support if you encounter such an error first, though. :)

190
Maxim Kim
Ataccamer
1 year ago
L
Ataccamer
lumir.studnicka
published in Master Data Management & Reference Data Management 🛰️
Git: how to deal with an unwanted merge of branches

IntroductionSometimes you realize you just performed an unwanted merge & push to origin/remote Git repository. E.g. you made a mistake in selecting "target" and "source" branch and merged the "env" branch to some "feature" instead the other way round. And most probably you want to remedy this as soon as possible and before other team members use such "broken" branch any further.One of the options can be a revert commit but that would undo a previous (or selected) commit, i.e. undo a single commit. But you might have merged a series of commits which you would like to undo at once and set the git branch to a certain state in the past. On top of it, you can even add (cherry-pick) any individual commits that happened after (contributions of your colleagues you want to keep). ProcedureDisclaimer and preparationFollowing procedure uses a “hard” reset; it is recommended not to perform this in the project phase when rapid development is happenning and/or to communicate your intention with

1010
L
Ataccamer
1 year ago
john.efechaobor
Ataccamer
john.efechaoborAtaccamer
published in Master Data Management & Reference Data Management 🛰️
Connecting Azure AD to Keycloak (SAML)Best practice

Security Assertion Markup Language (SAML) allows users to use one set of credentials to log into many different websites. It is an open standard that allows identity providers (IdP) to pass authorization credentials to service providers(SP). SAML transactions use Extensible Markup Language (XML) for standardized communications between the identity provider and service providers. SAML is the link between the authentication of a user’s identity and the authorization to use a service. Items to consider prior to connecting to SAML- Best PracticeIt is important to understand how your organization’s Active Directory is setup. Some pre-requisites needed can include things such as:Do you have a list of groups you need to import? If the answer is no, you may want to speak to your engagement manager from Ataccama to discuss in detail. In short, with AD Groups we can map Ataccama Roles to a single group. This benefit of doing this is, your internal dev-ops team won’t have to manually add/remove u

76622
D
Ataccamer
1 year ago
S
Data Voyager
srikanth.gurramData Voyager
asked in Master Data Management & Reference Data Management 🛰️
Looping record by record in Ataccama One Desktop

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

2427
M
Star Blazer L2
1 year ago
A
Universe Traveller
Ajeesh_GUniverse Traveller
asked in Master Data Management & Reference Data Management 🛰️
Connect Ataccama to Azure data lake

I am trying to connect Ataccma to Azure Data lake. Can someone help me on this?I know the container name & Storage Account.. but unable to find Client ID, Authentication token endpoint & client key.  

2152
Catherine
Data Pioneer
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
Community Terms of Use & ConditionsCookie settings