Solved

As per requirement I want to read a marker value from a file and pass that value as parameter in select SQL of a JDBC reader to pull only delta records. Is this possible in 13.9.1 version? Please advise with documentation link if available.

Hi All, Receving below error when trying to login in ataccama URL: Need help on this? WARNING: An illegal reflective access operation has occurredWARNING: Illegal reflective access by retrofit2.Platform (file:/D:/Ataccama/mdm/lib/retrofit-2.9.0.jar) to constructor java.lang.invoke.MethodHandles$Lookup(java.lang.Class,int)WARNING: Please consider reporting this to the maintainers of retrofit2.PlatformWARNING: Use --illegal-access=warn to enable warnings of further illegal reflective access operationsWARNING: All illegal access operations will be denied in a future release2023-08-07 15:26:23,797 ←[34mINFO ←[0;39m [][][restartedMain] ←[36mn.r.s.b.l.a.LogbackAccessContext:149←[0;39m - Configured the Logback-access: context=[default], config=[classpath:logback-access.xml]2023-08-07 15:26:25,274 ←[34mINFO ←[0;39m [][][restartedMain] ←[36mc.a.l.s.s.e.KeyProvidersSpringBootAutoConfiguration:41←[0;39m - messageId=createDefaultKeyProvider encryption=INTERNAL, reason=the 'internal.encryption.keys

How to implement a DQ rule to check if an attribute's value is present in another attribute (for eg. Attribute1 'Product' value is present in Attribute2 'Quantity' field) using Thin client

Hi All, Require quick help on ataccama IDE, I am not able to see .metadata folder in IDE. What is issue here? Please find attached screen shot ? Please help me here?

The source csv file has splitted into 13 rows for each actual row in target.By using Ataccama one desktop we would like to pivot the data by sending source 13 rows into one row in target. I am trying to implement the logic below in the Text file reader step but it's not working . v_RowNum = iif(v_RowNum IS NULL,0,v_RowNum+1) -------- Initialize v_RowNum to 0 if NULL; otherwise, increment it by 1 for each row.v_CurrentNumber = iif(v_CurrentNumber%13= 0, v_CurrentNumber+1, v_CurrentNumber ). -- Increment v_CurrentNumber by 1 for every 10 rows.GENERATED_NUMBER= v_CurrentNumber GENERATED_NUMBER INTEGER Please help us to make it work in Ataccama one desktop .

My input file is in the below structure and looking to pivot all rows into columns. No name 1 value1 2 value2 3 value3 4 value4 5 value5 Expecting output should be like Col1 Col2 Col3 Col4 Col5 value1 value2 value3 value4 value5 What will be the best approach in Ataccama One desktop? Looking for support and help..

Json : [ { "Headers":[ "Empid", "Name", "dept", "EMAIL" ], "ID":"Table_112", "Rows":[ [ "100", "John", "Finance", "John@gmail.com" ], [ "101", "Smith", "HR", "Smith@gmail.com" ], [ "102", "Derek", "Marketing", "Derek@gmail.com" ] ] }] Expecting the output in below format: Empid Name dept EMAIL ID 100 John Finance John@gmail.com Table_112 101 Smith HR Smith@gmail.com 102 Derek Marketing Derek@gmail.com I have created a plan with below details: After running a plan with JSON CALL step below response file got created. Based on response file i have given below columns in Data Streams I am not getting the out put what i expected. Appreciate your help and support .

I would like as an example to have one ‘MS Teams’ channel for one DQ Monitoring to reach out different groups of people tus set up diffirent Teams connections Is there any option to set it up in the current version? cheers Piotr

Hi guys, I'm doing the dq foundation course and I'm stuck. I have tried to look it up, but no result. This is on an environment in the portal. When I'm doing, with AVG or avg, this: It says: How do I make this work? Kind regards, Marcel

I have a legacy database without primary keys. I know how to evaluate a single column for uniqueness, and thus a primary key. How do I evaluate multiple columns which together would be unique and thus be a composite primary key?

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

Hi I’m running your free version of DQ Analyzer, but when I want to run my profiles this can’t be done. As I understand it, it is due to a needed version update. Can you advice how I get my license key updated and not losing my existing profiles and still running the free version? I do not want to install Ataccama One.

Dear Community, I require your assistance with a specific scenario in RDM (Record Data Management). We have a table in RDM that allows users to create, edit, and delete records, which are synchronized back to the database. This table contains a primary key ID column. During the creation of a new record, the user provides the Primary key value. However, the challenge we face is that this primary key column should not be editable afterward to maintain its uniqueness as a key. We attempted to restrict column-level permissions, but this resulted in the Primary key column not being visible even during the creation of a new record. I would appreciate your guidance on this matter. Thanks very much. Ojaswini

Receiving error when trying to start ataccama server: Description: Parameter 1 of constructor in com.ataccama.mdm.core.SpringServerConfig required a bean of type 'com.ataccama.dqc.server.config.ServerConfigImpl$IServerConfigConfigBeanProvider' that could not be found. Action: Consider defining a bean of type 'com.ataccama.dqc.server.config.ServerConfigImpl$IServerConfigConfigBeanProvider' in your configuration. Need help on this please?

Hi, I want to compare the number of not null records in source (custom sql using JDBC writer) and target (salesforce object) using a VCI. Is there any way to do that in Ataccama version 14.1.0. The aim is to get the records which are in source and not in target and records which are in target but not in source. Thanks.

In RDM web app, I see State column as waiting for confirmation as its not getting published due to data error. I am manually deleting record one by one by going to Problems section in web app. Can it be deleted in bulk and please tell me the procedure.

How to add a new table by uploading a excel file data in RDM web application which is already having a list of existing tables. Also, could you please help how to add a new business user in RDM web app via keycloak who will have access to RDM tables to edit records. @Cansu please help

I am using desktop app, and I want to schedule the workflow. Can anyone give some idea of scheduling workflows? I am trying to achieve the task ie. run the flows as per scheduled time(either weekly or monthly - like 5th day of each month) Below is the screenshot that I am having the file, but some how it is not working for me. Thanks in advance.

Hello all, i have a task of validating email with the help of api. I want to know is there any documentation which properly explains the integration of postman api to ataccama desktop? or is there any tutorial for working on with apis' using ataccama. Graphql is there but i'm in need of a very basic one to execute and practice. Thank you!

How to connect ONE DATA as a source ? What's the URL value that is required to connect ?

I am trying to parse an XML File that has data related to employees in the following format <TABLES> <DATA> <item> <WA>Emplyee1No Employee1Name Employee1PhNo Employee1Email</WA> </item> <item> <WA>Emplyee2No Employee2Name Employee2PhNo Employee2Email</WA> </item> …. …. </DATA> </TABLES> I am using XML parser to parse this but it does not give any result.I think the issue is with the same tag containing multiple records.As I am able to parse it when there is just one record i.e. one <WA> and <item> tag. Can anyone please help me with this?

Hi All, Our requirement is to use an api call for removing a cde term and adding another cde term associated to a rule. we thought of using PUT /rule-versions/{id} api. However some points we noted. in one webapp for the ruke, if we remove cde and add another cde, the rule gets created as a newer version. We just want to update the existing version Please let us know which api we can use?

Hello! My team and I are working on connectivity to be able to pull rules down from the web version into the Desktop version, make some minor tweaks, and then reupload them back to the Web version. Is this possible? We have our ONE platform connected to our desktop and can see all of our catalog items and rules, but when I try and drag a rule into a component / plan or make any changes, we get an error and we can only view the rule. Has anyone ran into similar issues? Or are we attempting to do something that the Desktop version does not support? Any answers would be appreciated, thanks!

Hi, In Ataccama web there's a way to set a certain treshold about validity when monitoring (default is 70% I believe). Is there a way instead of percentages to have it as raw number of records? Basically the idea is that I want to see the treshold met when (example) 100 records are met. The amount of records added to the dataset varies hence percentages might not work for me. Currently I have 1000 records. 100 are invalid. Treshold could be set to 10%.But if overnight 4000 records are added totalling 5000 records then 2% is invalid, assuming the invalid numbers stay the same. In the ideal world I want to be able to make a choice whether I want the treshold to be set through percentages or raw number. Because in this scenario I'd still like to be given a notice 100 records are invalid.

Hi All, I would like to map keycloak roles present in gen1(12.8) to gen2(13.9/14.3). Has anyone done this activity while migrating Ataccama 12.8 to 13.9/14.3 version? Thanks, Parvesh Soni