-
Add a delay in automation between when a trigger is triggered and when the action is carried out.
Hi, I currently have a number of schedules and automations running in order to run some sequential steps in a find duplicate process. I have an initial schedule that refreshes data and then an automation that detects the datasets are refreshed and kicks off a workflow that validates that the date stamp on the data is…
-
'Time period for all events to occur' box within automations
Hi, Is anyone able to explain what the : ''Time period for all events to occur' does? within the automations part of ADS If i set this to 1 and it takes more than 1 min for the above actions to finish what will happen? likewise if i set it to 10 mins and it finishes in 5 will that 'pass'? Many thanks,
-
Custom email notifications to include failing validation rules
Hi, I am wanting to set up email notification that fire when a data quality workflow validation step returns failures. I have been able to set up the email notification itself but i want to include the actual rule and number of fails in the body of the email so it gives some context as to where to investigate. a simple…
-
Why do I still see a warning even after the license is refreshed successfully?
Hi, I upgraded Experian Aperture Data Studio from 2.14.14 to 3.1.12 and Find duplicates from 3.12.1 to 3.14.7. We already had upgraded to cloud licensing and added necessary changes to connect to the license entitlement that enabled to refresh the license successfully before the upgrade. However, post upgrade I am seeing…
-
Validating Bank account details
Good morning, We know that Aperture already has built-in functions to check the format of bank account details. What we’re wondering is if there's an additional feature or method we can use to verify whether a bank account is actually a real account beyond just format validation. Basically, do we have a tool in Aperture…
-
Pushdown Processing on a pivot
Hi, In testing Pushdown Processing today, I hit a couple of errors. The first is simple to workaround by removing it (but would be awesome if the generation understood to omit) - the dataset query had a semi-colon at the end, which pushdown processing then put it's "as R0" after: The second I'm still at a bit of a loss. I…
-
Automation Email Trigger Works for Individuals, Not Distribution List(DL)
Hi Aperture team, I’m currently using the Automation feature to trigger email notifications. Since our team uses a distribution list (DL) to keep the recipient list up to date, I tried adding the DL as the recipient. However, emails are not being triggered when using the DL, whereas they work fine when listing individual…
-
Is there a way to generate Univeral Unique ID for each row?
I want to create a new column that has Univeral Unique ID for each row. Is there a way in ADS to generate it?
-
Find Duplicates - Ignore a value
Hi, I am attempting to use the find duplicates module. In one of my unique data fields I have dfound that a dummy value has been used for cases where data is not easily obtainable. Is there a way to direct the matching criteria to ignore this value when trying to match rows? Column name in Data is 'UniqueID' TIA.
-
Cloud licensing
Hi team, We have deployed ADS production server and when we tried to apply the cloud license, we are getting the below below error. We have applied the SSL certifications and still the cloud license is not working. Error: Unable to find a valid certificate. Please ensure the Java installation has all certificates required…
-
Workflow failure
Hi everyone, I am getting this error on one of my workflows. Can anyone help?
-
Hi, I'd like to add a column to my data that counts how many times a cell appears in a given column.
-
Drop Zone Configuration - Occasionally dropped files are not picked up
Howdy, I have been dealing with a slight issue with a server drop zone setup we use for a specific workflow. Most times we have no issues… but then randomly a file will be dropped and it will just sit - it is not being read at all as it just stays in the root directory (doesnt trigger an error and create the error…
-
What is the cause of an error message that says "4058: Unable to rollback" and how can it be fixed?
This error occurs on the Export workflow step.
-
Need to connect databricks
Hi Team, We need to connect data bricks workspace(pre-prod and prod) from our aperture pre-production server. Could you please check and confirm that whether we can be able to connect data bricks from Aperture data studio. Also please let me know if we need to be installed any JDBC driver. Regards Uma
-
UX Improvements / Suggestions - Jobs Page
We had a recent scenario where 1k jobs were sent to the queue, which did flag up a couple of UI/UX suggestions for the 'Jobs' page: Is it possible to multi-select to cancel jobs? We could only see the option to delete one job at a time in the queue? I.e. would be good to be able to select all jobs, multiple jobs or single…
-
Aperture using workflow to export via JDBC - Issue
Hi, Please can you help/advise? I am trying to export dataset containing 79k records (83 columns) to HDI table, which is failing. However, if we limit the record to 4 or 100 the export to HDI works perfectly fine. Also, please find below error: Unexpected errors have occurred during Workflow execution: 9003: An unexpected…
-
Import from Sharepoint list
Hi, Is it possible to connect Aperture to a SharePoint list without having the export to excel and then re-import? If it is please could someone walk me through how? Thanks!
-
Error message
When trying to access details of Monthly Validation Results Summary Interactive_CAIS2007, an error message appears: 6029Â - An unexpected error occurred. Please try again or contact whoever manages Data Studio in your organization. Can someone please advise, is it something I'm doing wrong? Thank you
-
Unable to connect Amazon redshift database
We are trying to connect Amazon redshift database from aperture, and we are getting the below error while trying to connect. Failure com.experian.aperturedatastudio.redshift.jdbc.base.fv: [ApertureDataStudio][Redshift JDBC Driver]Error establishing socket to host and port:…
-
Adding Microsoft SQL Server to an ADS server
Has anybody got any experience in having Microsoft SQL Server and data tools installed on the same server as ADS is installed on which uses SQL Lite, we were wondering if they would interfere with each other?
-
Support for VARBINARY(MAX) field type in ADS
Hello I have a user case that requires migrating Salesforce objects that contain attachments such as HTML Body, PDF's, Word, Excel and jpg's attachments to another instance of Salesforce. These are normally stored as a VARBINARY(MAX) in a MS SQL database and I think would be a Blob in SQL Lite. Given these data types are…
-
Rule Question (DataArc360)
Hello, Can someone help me understand a rule and why certain criteria is listed? Rule name- The DOFD is more recent than normal on a derogatory account Why did they select those Account Statuses? For instance, Account Status 95 can be reported if an individual is not 120 late since the member is voluntarily surrendering…
-
Rows to Columns
Hi, I have been testing out the Rows the Column function. However, it seems to be not pulling through all the columns. In the DEV data set, I currently have 62 rows which I would like converted to columns. When using the Rows the column, it automatically only finds around 56. Wondering if anyone else has had a similar…
-
Flattening out / Pivoting / Transforming results
Hi, I'm having an issue flattening out results. Essentially, I have multiple rows for the same customer because they have different PII's. Is there any way of transforming / pivoting / flattening out the results to have one row for each customer? I have left a screenshot of mock-up data below to help people understand. I…
-
OUTPUT step in a workflow
Hello, rookie here again. I'm trying to understand the output step but the only thing I can find in documentation is below. When do you use an Output step? Where is the output located? how do you use the output step in another workflow, view, etc.? When a re-usable Workflow is using the Output step, the step's data will be…
-
How do I select a reference data to use in Validate Addresses?
Hello, Our Automated Workflows have stopped working recently, and I've tracked the issue down to a broken Validate Addresses step in our cleansing workflow. As you can see "the Reference data:" option is greyed out and I cannot edit it. When I scroll over the exclamation icon the help text says "No reference data…
-
No JDBC option for external system
Hi, any reason why I would not have a JDBC option in the drop down for creating an external system?
-
Automations - License Expiring Event
We have been unable to trigger the License Expiring Event for 'License Days Remaining Less than 365' with a Notification to users. License Expiration is Aug 2, 2025. What needs to happen to trigger this event? We've had a dataset load, complete workflow and waited overnight. We were only able to generate an notification…
-
What is the best way to deploy through different Aperture Environments, dev -> uat -> prod?
We have the following structure for some of our processes (there will also be a prod but the structure will be identical to below): The idea is that we have a space where all of the core datasets reside - from these, views are created. And these views are shared and used within any workflows we create in different spaces.…
-
Import
Can we import Excel or csv file into Aperture. TIA
-
Zuora Source Timeout
We are using a JDBC Driver from cData to extract data from Zuora to a Dataset, some of the tables are 20 million rows. Aperture sends the query command to Zuora which produces a download file but it can take 10 minutes by which time Aperture has fallen asleep and the data is not imported. Does anyone know if there a…
-
Data Bleeding from one filed to another
Good afternoon, We are encountering an issue where data from one field is "bleeding" to another one (see image below) Is there a setting that we can apply to stop this behaviour? Many thanks in anticipation.
