Master Data Management & Reference Data Management 🛰️

Hello, how to run the plan below (created using ONE Desktop) on Ataccama Web ?

Hi, I have a .csv file containing country codes that looks like: countrycode.csv I want to use this file as a lookup. In ONE Web it is possible to use a .lkp file as a lookup (why not just import an excel file there is beyond me). In order to do this I understoond I had to create a lookup builder: Lookup builder​​ In the Text File Reader I selected the documented with the encoding (I hope this is the right one?). As for the columns I created nm_lnd and kd_lnd (both string). Text File Reader - General Text File Reader - Columns As for the Lookup Builder: Lookup Builder When I run it a .lkp is created but also a rejected.txt with everything that is inside the .csv meaning I'm not able to create the desired .lkp file. What can I do to resolve this? Is there also documentation on how to create lookup using .csv somewhere? I can't find it.

I need to understand the difference between Full and Complex Delta Load in MDM.As per this document on Complex Delta Load, Delta Dependency Mode needs to be setup for each entity. I see there are two options for it -Autonomous and Central. Can someone please explain the difference between these and in what scenario these should be used?I also see that The engine expects an additional column in the input interface denoting the type of record change (change_type: I - insert, U - update, D - delete). Where shall we define these and what how can we identify which records needs which change_type? TIA 😊

Hi all, is there any configurations we can edit in the page template and/or the metadata model, so that we can (best having a hyperlink or button to) export the content from e.g. the access, data structure or profile tabs of the catalog items? Thanks a lot.

Hi all, I am in process of learning ONE Desktop and was curious if there any documentation or best practices on integrating GIT. I have searched and found a related topic that was helpful. Thanks for any help.

Checking to see if there is a way to create a “current values only” table in RDM, with no historical records to be kept? I don’t see any option for this in the documentation or One Desktop dialogs.

Hello community, I’m working on an RDM project and have a question regarding the security configurations. I find that if I tick the Fixed Permission checkbox in the Security config. node, the roles permissions I have setup in the IDE will get uploaded onto the web app., but it won’t be editable later there. However, if I don’t tick this checkbox, none of the permissions will get loaded on to the web app., but I will be able to fully customize the roles permissions on the web app. Is there a way to have the initial roles permissions loaded from IDE, but also editable later on the web app.? Thank you in advance

Is anyone able to confirm if One Desktop version 13.3.2 is compatible with with MS Windows Server 2022

Hello all A basic (and rookie) question, but I couldn’t find the answer in the manual or tutorials, or on this forum. After I’ve loaded source data into Ataccama ONE Desktop, I’m looking to create a new column and fill it with the concatenated content of some other columns (two or more), maybe with a bit of text in between. In Excel I’d use the Concatenate function... Example from Excel As you can see, I can then lookup information based on Column D and use that for bringing in various lookup values (the real use case is not name-based, this is just to create a simple example) Note - I’m not looking to merge different tables (with join, union, or representative creator - unless those tools can do what I’m looking for) - this is simply creating a new column/field which is a concatenation of two or more other fields Context: I’m building a lookup based on multiple attributes - I’ll combine them into a single attribute to give me a single lookup key and then I can use that for various oth

Hello I am trying to start the MDM Sever and I am facing the below issue. I have cleared the database and started the database and key-cloak. Database and key cloak started successfully. After that I am triggering the start-mdm-server.bat file and its causing the below issue. Did anyone face similar issue while starting the MDM server? Could you please let me know how to resolve this issue

We recently had a glitch in our Test MDM load, and only 1,000 of the 4 Million+ records came into the MDM from our source system. MDM inactivated most of the 4 Million records (appropriately). However, now that we have fixed the glitch and are pulling all 4 Million into MDM from our source system, it is is not reactivating the ones it had previously inactivated… how can I force a re-activation of those records?

Say now we have an term with more than 10 properties to display at the same time. Is it possible to (configure the metadata model so once we click the term it will) show all the properties without having to click this Show all button? Thanks in advance.

Let’s say a data consumer in my workplace is getting familiar with a data element (as term), and he/she want to know who the data owner is. Since we set the person reference for the roles in stewardship, the consumer need to 1. click the display name of the data owner, see the username of the referred user, and then 2. click that username to see the detail of that user, namely his/her user ID and email address. (1) Is it possible in any way the data consumers only need to click once from the display name of the data owner to his/her user detail? (2) Is the above workaround applicable for other reference objects (e.g. the policy reference)? Thanks a lot.

Setting permissions for groups via the IDE. Ensure your groups exists in KeyCloak first In the IDE go to your RDM Project and complete the following under "Security" Right click on Roles Select New role Add the name and description of the role (be sure to use the same names that you setup in KeyCloak) then click Apply and OK Expand the new role, and right click on Entities then select Edit… Add the Tables and the Table level permissions in the next window NOTE: Table permissions do not give column level permissions. Double click the number next to the table that you wish to setup permissions for Notice that there are options for "View for All Columns" and "Modify for All Columns." However, if you want to select only certain columns, you can do that below with the following steps. Add the column names you want permissions to be given for, and select View and/or Modify for the given column When complete, click Apply then OK To ensure these permissions are applied to the Web Admin double

Let‘ say you have a graphQL query that works in a Postman or in Ataccama playground, and you want to use it in a plan in ONE Desktop. How to do it? You cannot simply copy and paste the JSON body into JSON call step. You have to reformat it. You can use the COPY CURL button in Playground (in the upper right corner) or similar button Code in Postman. That will create a curl command that also contains the body: Playground Curl command This body can be then pasted into JSON call. The query method needs to be set as POST. JSON call step configuration Want to learn more about the graphQL API? Check out the documentation: https://support.ataccama.com/home/docs/aip/latest/development-guides/one-development-guide/one-api

We are on RDM v14.5.1, on PaaS, so underlying db is postgres. I need to query a table using the RDM Extended Reader step with a filter. The volume of this table will grow, so I much prefer to filter at the reader step, rather than bring the whole table into the plan and then filter, to manage performance. I have a column, from_date, that is datetime type. I have from_date in my data flow, and I want to query RDM for a day prior. Expecting that this is an SQL where clause, I tried to put in syntax compatible with Postgres So I created a column called “row_filter”, with type string. Using postgres to_timestamp function day_prior:=dateAdd(from_date,-1,'DAY');day_prior_string:=tostring(day_prior,'yyyy-MM-dd HH:mm:ss'); "from_date=to_timestamp('"+day_prior+"','YYYY-MM-DD HH:MI:SS')" This one gave an error of: 13.05.2024 13:10:00 [INFO] Ataccama DQC engine initialized.13.05.2024 13:10:00 [INFO] Creating runtime...13.05.2024 13:10:00 [INFO] Starting runtime...13.05.2024 13:10:00 [INFO] Runnin

I have a data set created and the query runs fine in a sql editor against my local database. I can deploy the configuration with no errors, but when I go to look at the data in Ataccama One I get Fatal error occurred and click on Details just gives me Internal error. The only thing I can think of is the query is rather long. Is there a max for data set sql? What is the best way to try to troubleshoot this? The error messages are not at all helpful.

Hey All! I am aware that only Stewardship owners have the ability to use the “Document” button on a data source level, but is there a way that we can disable this button all together? If a user accidentally uses this feature, it eats up a lot of processing to import the metadata, and is a best practice that we are telling everyone not to use. Is there a way within the admin console to do this? Thanks!

Is there a way to put columns in a view with a static value? Like you can in a sql statement, such as SELECT col1, ‘this is a static value’ AS col2

Is there a way to create views in RDM that contain union statements combining queries to different tables?

Hello Ataccama team I would like to know if there is a reference about how to configure an external dpe using databricks on azure. Thank you

The response message was:null and response error was 'errorMsg:java.net.NoRouteToHostException: No route to host at java.base/sun.nio.ch.Net.connect0(Native Method) at java.base/sun.nio.ch.Net.connect(Net.java:579) at java.base/sun.nio.ch.Net.connect(Net.java:568) at java.base/sun.nio.ch.NioSocketImpl.connect(NioSocketImpl.java:593) at java.base/java.net.SocksSocketImpl.connect(SocksSocketImpl.java:327) at java.base/java.net.Socket.connect(Socket.java:633) at org.apache.http.conn.scheme.PlainSocketFactory.connectSocket(PlainSocketFactory.java:121) at org.apache.http.impl.conn.DefaultClientConnectionOperator.openConnection(DefaultClientConnectionOperator.java:180) at org.apache.http.impl.conn.ManagedClientConnectionImpl.open(ManagedClientConnectionImpl.java:326) at org.apache.http.impl.client.DefaultRequestDirector.tryConnect(DefaultRequestDirector.java:605) at org.apache.http.impl.client.DefaultRequestDirector.execute(DefaultRequestDirector.java:440) at org.apache.http.impl.client.Abst

I have an xml file with a structure like this: <model xmlns="http://www.ataccama.com"> <entities> <entity name="table1" /> <columns> <column datatype="varchar(100)" name="abc" required="false" /> <column datatype="int" name="xyz" required="false" /> <column datatype="datetime" name="123" required="false" /> </columns>... I want to produce a data stream that combines the column name and data_type with the name from the parent entity node. If I define the columns using xpath nm:model/nm:entitles/nm:entity/nm:columns/nm:column then I cannot access the entity name using ../../@name (or any xpath expression for that matter). If I define the columns using entity level xpath epxression nm:model/nm:entitles/nm:entity and the columns with xpath nm:columns/nm:column/@name then I only get 1 record per entity with the first column only. How can I get the entity name, column name, and column data_type on each line?