Master Data Management & Reference Data Management 🛰️

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?

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

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 😀

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?

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

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)

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

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?

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'

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

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!

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

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

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?

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

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

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

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.  

Hi All, I have a question about the connection in JSON Call.I had given the url (GraphQL url )to connect in the url section,and in the http headers section, I had given the Authorization in Name and credentials in value.The same thing works in Postman but not in JSON calls.Please make any suggestions. ThanksAvi

 While working in a live project, there might be a requirement to close or change the status of existing issues in the MDM Administrator (MDA) interface in bulk or on ad-hoc basis automatically whenever certain criteria are met.Some example scenarios when MDA issues require closure could be: Close a split proposal whenever matching attributes of instance records become the same Close all issues with specific data quality criteria that is no longer relevant for client. Example – Company Established Date data quality checks are not required, and client wants to close issues raised for Company Established Date. Close all resolved issues To implement a solution to close issues, certain information is required: The database and tables where issue information is stored:Key Issues details visible in MDA UI are stored in “dqit_issue” table in “it_db” default databases for MDA. Note: Details of configured database can be found in the runtimeConfig file. Key fields in the dqit_issue database:

I am using version 13.7 and trying to import two table that consists binary values in two different columns and as a part of check I need to check if the two columns have same values. However, there is no option to import binary values and they are getting imported as string by default. Please help me if there is a way to convert the values into binary or they can be converted back to their original binary values

I am writing custom steps in Java. the help has some examples. I am wondering to know if the are any javadoc about the ataccama core classes. I would like to test my new custom step using junit. Any reference will help a lot.

Hi,  I am using a parquet file writer and I would like to set the size of the file, how can I do that? 

Hi Maksim,Can anyone help me view the broken new_database_connection image at MS SQL Connection error - DQ Analyzer - Ataccama Community? The png image’s status is 'Page not found.'I couldn't connect DQ Analyzer to an Azure SQL database using jTDS- MS SQL. I am using Active Directory - Universal with MFA support authentication.Thank you very much for your time and assistance!JP

imagine we have 100 views for which we need to find the count difference in 2 different db’s .we need to create a dynamic query in a while loop which looks up view names one by one and runs until the requirement is met.  I have a few questions to ask :Can we have a “JDBC Reader” which can read dynamic queries? For example, using a “Global Variable” in the JDBC Reader query to pick up view_names for every iteration. As per the solution above, we need to create a while loop to cater multiple iteration. Is there any method/function in Ataccama to achieve this?