Solved

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

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?

What does the id mention in invalid_rules column in Monitoring Project Export refer to?the alphanumeric term within() after rule name as in the image belowIs this the ruleId of the rule? If not, what does this refer to?Is there a way I can configure Metadata Export step to give rule id?

The idea is to divide the invalid_rules column as obtained in export for Monitoring Project into two columns- one containing the rule name and the other containing the explanation; and implement this for all the rules mentioned in a cell.For example, The below cell would be divided into invalid_rule_name column containing two records-validation [USA] State and calidation[Noth America] Phone Numbers, and invalid_rule_explanation column containing explanation for the respective rules.The challenge I am facing here is that the rule ID mentioned in Monitoring Project report export is not the same as the rule ID mentioned in the list of rules I export; which I am trying to use to identify the rule in invalid_rules column from Monitoring Project report.Please help me find a solution for this

Hello, I have a speed of profiling data for using Oracle DB of about 4000-7000 rows per minute.I use Ataccama DQ Analyzer (Version: 11.1.1.ga-2017-06-14).  Please, can you take me to advise me on how to increase the speed of profiling data for using Oracle DB?I hope to take the profiling speed to about 100 000 rows per minute...  Connation config:   Log:17.03.2023 12:56:04 [INFO] Switching to logging setup from C:\Users\ECHERN~1\AppData\Local\Temp\loggingConfig3307204922660014311.tmp17.03.2023 12:56:04 [INFO] Using following licenses:17.03.2023 12:56:04 [INFO] C:\Ataccama DQ Analyzer 11\runtime\license_keys\license.plf17.03.2023 12:56:04 [INFO] Using DQ Analyzer configuration file C:\Ataccama DQ Analyzer 11\workspace\sqb_prof_pilot\data\out\sqb_all_table.plan17.03.2023 12:56:04 [INFO] Using runtime configuration file C:\Users\echernoskutov\AppData\Local\Temp\runtimeCfg1065525328424309714.tmp17.03.2023 12:56:04 [INFO] Changing CPU affinity to 4 CPU(s).17.03.202

What kind of MCQs are asked in Certification exam?

How are NULL’s considered? I have a case statement which gives the right value matching measure -used debug to test. But when it comes to matching rules, it skips the rule. Example:Name      NPIRamona  12345678NULL       12345678the 2nd row should match the 1st on NPI value and considering on of them is null.Even the scenarioName      NPINULL       12345678NULL       12345678these two should match together based on NPI. I do not see a special character. If I replace NULL with a value ‘A’ , they match with rule Matching on NPI. but does not work for NULL.  Any thoughts or suggestions appreciated. 

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?

Hello, I’ve got a question while using DQ evaluation rules.I have been creating rules with valid and invalid messages but just the invalid message at the end does not display as intended. But when I view this in the results tab it just says OTHER as the explanation.    Is there a workaround to this problem? Should I edit my rule logic to include some specific condition and leave the rest to fall under the ‘IF none of the conditions above apply THEN’ TIA for the replies.  

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 Team, Is there anyway that we can export the result of profiling in ataccama? Thanks, Ellie

Hi,We are using Ataccama one 12.6 version. We have a project containing 40+ models with 90 + rules. I am looking for an options to get the detailed invalid/failed records for each model. Like all the attributes from the model along with invalid rule instance names.The idea is to get the whole failed dataset to automate the remediation process. We already have automated process to remediate the data using other technologies.I don’t want to use the download results in csv option, because we are transitioning to latest version of Ataccama.I am looking for couple of optionsExtract the detailed failed records from backend tables using sqls (where Ataccama stores the results) or would like to understand how those csv files are generated in backend and use the same way to get the data and store in  db. Reading data through Ataccama inbuilt API’s and loading into a db. I am  going through the GraphQL options. Could you please let me know, If there is way to get the similar data through GraphQL

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

During bundle deployment I see this error. I have tried different combination ofUpdate to old bundle. Manually update the component again on the existing old bundle and upload Copying extended unification Updating OmnigenServer folders (bundle,cmd,dbms) with the backup. restarting services as needed.Any thoughts or suggestions? Thank you.

The matching component is slow at the extended unifications step for a incremental load. When a record like ‘WALGREEN%’ is loaded and there are 20K records with similar name on the instance, the records are all considered through the process of matching. Hence the process is slow when processing the increment and even if the incremental load has 11 records to process 30K records have the transaction Id and omni_modified date updated with the work order related on the instance table.  When I check history, nothing changes on these records except the omni_modified_date and transaction_id to that of the work order. Tweaking the union keys to create combination of name and key factors or adding separate groups for the high count records is not helping. Any thoughts or suggestions?

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?

Hello everyone,I created a profile of my catalog item using ONE desktop and I would like the output(.html) to be accessible to business analyst with read access. The html is only accessible on my local computer. Where’s the best / secure location to store output reports of profiling? Please chime in with any thoughts. Thank you! 😀     

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'

Hello everyone!I have an interesting task related to the desktop, we have a table combined with certain attributes and with full names, full names are divided into columns (firstname, lastname, midname) and they need to be compared with other columns (firstname1, lastname1, midname1) it is necessary to output non-matching full names. I can't compare one table between columns, I need your help. Do you know how to implement this?I will be very grateful for your help

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!

Is it possible to Set up the detection rule, which would allow to detection of new table(s) within the Snowflake schema and trigger the required potential alerts

I have a sql select where in I wanted to pass multiple data source names. how to make it dynamic or parameterized so that It can read all the names one by one.

Hi,I’m trying to modify our view of our business terms - currently we have a lot of information showing in the default view that our end users may not care about.  What I really want to do is modify the view, so that it only shows Name, Abbreviation, Description and Synonym.  I have figured out how to add the columns, but I can’t figure out how to remove unwanted columns.  For reference here is the default screen layout in Ataccama One via the Debugging Tools. {"_type": "entity.page.listing","children": {"_type": "relationships.hierarchyListing","enableSelection": true,"columns": {"type": {"dataPath": [],"name": "Type","after": "name","renderer": {"_type": "glossary.termType.tableCell"}}}}}