Ataccama Community

How to Store Scheduler Job Execution History into Apache Derby?

I'm working on workflows on my local machine and have set up a scheduler to trigger every 10 minutes. Each time the workflow runs, I would like to capture the following details from the job execution history, such as: Execution Date, Execution State, Executed Action ID, Details. I am using Apache Derby as my database and would like to store this information there. Please let me know if there is a way to retrieve the above-mentioned details and store them in my database. Thank you for your assistance. Best regards,Dhaval

203

4 hours ago

Albert de RuiterRocket Pioneer L1

How to find and restore faulty page layout in OneWeb

Hi Community, Don't know if you ever have made changes to the page layout in OneWeb, but sometimes it can be an uncomfortable task: while often there is a preview option, for ‘create’ and ‘edit’ pages this is not the case. So after having made the changes and pressing Ctrl-s to save them, if you made a mistake it can turn out your screen will go white, without option to make a correction afterwards (yes, speaking from experience). Lately we had a bit of an awkward situation, that the System Changes screen in the Global Settings area was no longer accessible, showing an error message about a screen layout error. But we never applied any layout changes to the System Changes screen, so we were rather puzzled. I consulted Ataccama Support about this and I would like to share their solution. First conclusion by Support was that this was caused by an erroneous page layout from another page. Indeed we had done quite some development and experimenting (dev environment), so finally we figured o

5 hours ago

akshayl09Data Pioneer

Group by while creating the rule

Is there any option to group can be implemented at two different level? For example: I want to create rule which count number of districts for which has total revenue zero by each state. Such district Count should not more than 10. Hierarchy country > state > district > Territory. Kindly suggest how to create a rule for this using Ataccama Web one.

132

18 hours ago

Ayush kumarData Pioneer

Erro while opening Ataccama desktop

I am using Ataccama 14.5.3, everytime I open it, I get an error - The One-desktop executable launcher was unable to locate it's companion shared library. What could be the reason for this?

191

Hanish NData Voyager

Load 'Failed records' to ONE Data via API

In catalog item DQ evaluation, we are trying to run the DQ evaluation via API and it is working fine. Do we have an API to load the failed records to ONE data via API?

111

GersonData Enthusiast

Why can’t I select multiple schemas under a single source with multiple connections in Data Observability?

I'm facing an issue with selecting schemas to observe for schema change detection in Observability for one of our sources(Sybase). Context: In our SQL database source setup, we have a single connection that includes multiple schemas, and Observability allows us to select multiple schemas without issue, as shown below. However, for the Sybase source, we're unable to select multiple schemas under a single connection. I only get the option to choose one connection and one schema from the dropdown. (See screenshot below.) Ideally, I’d like to select all dbo across all connections to monitor for structural changes. Question: Has anyone experienced a similar limitation?Is there a recommended approach for configuring Observability for schema checks on sources that have multiple connections and schemas under a single source — especially in cases like a Sybase database, where multiple connections are used? Any guidance or best practices would be greatly appreciated.

373

22 hours ago

Ayush kumarData Pioneer

Getting values from previous ataccama run (for monitoring project or profiling runs) and comparing them

I am working on a requirement where I have to check that any values which were present in previous profiling/monitoring project run inside column_A of table_1 should not be absent in current/latest run of column_A table_1 if those are present I have to highlight those, requesting community to help me with this.

sumishaData Pioneer

Parquet File output

Hi, I need to extract metadata using One Desktop and store in Parquet file format in ADLS. Do we have any recommendations on how this can be achieved in One Desktop?

onufryUniverse Traveller

Migrating Production Environment to Development

Hello Ataccama Community, We currently operate two Ataccama ONE environments: dev (for testing and experimentation) and prod (for business use). Our goal is to ensure that the dev environment closely mirrors prod, especially for configuration and metadata, so that testing is as realistic as possible. Ideally, we would like to perform a weekly migration from prod to dev—essentially overwriting the dev environment with the latest prod state. However, as I understand it, there is no automated way to fully clone the prod environment to dev, and migration of certain elements (like metadata model changes or monitoring projects) is either limited or requires manual intervention. Questions: Migration Feasibility: Is there any way to automate or script a full environment migration from prod to dev, or are we limited to manual processes for specific components? What are the main obstacles or unsupported features when trying to migrate Ataccama ONE environments? Best Practices for Environment Syn

201

onufryUniverse Traveller

Best Practices for Searching JSON/XML Values in Database Columns Using Regular Expressions

I'm working with a database table that contains a column storing complicated JSON/XML data structures. I need to implement data quality rules that will search for and validate specific values within these structures and compare them with values in other columns. My specific requirements: Need to search for particular patterns and values nested within JSON/XML structures Considering using regular expressions for this search capability Concerned about the performance impact on database resources Want to ensure this approach is sustainable as data volume grows Has anyone implemented data quality rules for searching/validating values within JSON or XML columns? Are regular expressions an appropriate approach, or are there better alternatives within Ataccama (Desktop?) for handling hierarchical data structures? I'm particularly concerned about performance impacts and would appreciate insights from those who have solved similar challenges.

231

DhavalMUniverse Traveller

How to Store Scheduler Job Execution History into Apache Derby?

203

4 hours ago

Ayush kumarData Pioneer

Erro while opening Ataccama desktop

I am using Ataccama 14.5.3, everytime I open it, I get an error - The One-desktop executable launcher was unable to locate it's companion shared library. What could be the reason for this?

191

Hanish NData Voyager

Load 'Failed records' to ONE Data via API

In catalog item DQ evaluation, we are trying to run the DQ evaluation via API and it is working fine. Do we have an API to load the failed records to ONE data via API?

111

GersonData Enthusiast

Why can’t I select multiple schemas under a single source with multiple connections in Data Observability?

373

22 hours ago

Ayush kumarData Pioneer

Getting values from previous ataccama run (for monitoring project or profiling runs) and comparing them

sumishaData Pioneer

Parquet File output

Hi, I need to extract metadata using One Desktop and store in Parquet file format in ADLS. Do we have any recommendations on how this can be achieved in One Desktop?

onufryUniverse Traveller

Migrating Production Environment to Development

201

tyler manawesData Voyager

How to create a column on the Terms overview page to display a referenced object array

Hello! My org wants to create a new column on the Terms overview page to display items from a referenced object array. Specifically, we want to display Data Protection Classification information there on the overview page in a column. At first, we were told this was not possible, but we have seen this done on another one of our overview pages that displays Policies, which is also a referenced object array. This was created for us, and the json from the “Edit Page” screen looks like it is inherited from another entity. { "_type": "entity.page.listing", "children": { "_type": "entity.listing.v2" }} Here is what our current Terms overview page layout looks like: And the JSON behind the layout: { "_type": "entity.page.listing", "children": { "_type": "relationships.hierarchyListing", "enableSelection": true, "columns": { "type": { "dataPath": [], "name": "Type", "after": "name", "renderer": { "_type": "glossary.termType.tableCell" } } }, "flatListingRenderer": { "_type": "entity.listing.v2

120

3 days ago

OjaswiniStar Blazer L1

Master Data Management & Reference Data Management 🛰️

Is self joining possible in RDM tables ?

Hello, Is it possible to self-join tables in RDM to populate some information? I would like to try something like shown in the screenshot. Attribute 4 and 5 values are selected from RDM UI. So, dropdown should only show values from the same table where att2 = CAT2 for Att4 and att2 = CAT3 for Att4 Table1 Selection from RDM UI Att1 Att2 Att3 Att4 (where att2 = CAT2) Att5 (where att2 = CAT3) ID1 CAT1 val1 ID3 ID5 ID2 CAT1 val2 ID4 ID6 ID3 CAT2 val3 ID4 CAT2 val4 ID5 CAT3 val5 ID6 CAT3 val6 I somehow tried to create self join in relationship like below. I was able toi upload configuration successfully on RDM with these relationships. However, when edit the record on RDM the lookup is blank. it does not show any value although table is populated. (this can also be understood as employee info vs manager info relationship. Both info are available in the employee table) Thanks in advance. Ojaswini

5 days ago

JTHData Pioneer