The place for most Aperture Data Studio discussion
The Data Quality Community is a great place to collaborate, seek answers, and learn Aperture Data Studio. Register for free to join in with discussions.
hi, I am performing bulk data profiling on datasets using API automation where my steps are as below list all datasets to be data profiled in a csv file process csv for each row trigger dataset refresh and capture job id wait for job to get completed or for max 30 mins. if time elapsed is more than 30 mins then skip next…
Hi, Was hoping fellow-customers or Experian staff would be able to give their experiences with this one. Wanting to update data in the DB directly using Aperture (thru the Export step - JDBC), but the DBA wants updates done via SQL scripting (is hesitant to use Aperture). I am pushing for Aperture as it is a controlled,…
Hi, We are using Experian Aperture Data Studio version 2.14.14.40 and have changed the settings to accept csv delimiter to pipe (|) But there is a requirement to delimit csv files based on runtime configurations. Is there a way to define the delimiter in the export step while writing datasets as csv likely from a parameter?
Waiting to get an external system set up to allow updates via JDBC - in the meantime, if I select mode = UPDATE in the export step, does a full SQL statement get generated (to allow our DBAs to verify and QA the process). Thanks
Hi, I am starting a data migration/cleansing project and as each entity is analyzed and validated with data quality rules, any failing rows are sent to an issue list. That issue list is then shared with business leads to determine best approaches to fixing the data. There will be approx. 70 entities that we will working…
Hi, I am using the above function and the result for checking this site "www.californianotary.academy" comes back as bad, even though it can be accessed in a browser. Does that function expect something like ".com" rather than ".academy"?
Hi, is it possible to update an issue once it has moved to 'Resolved'? For example, a set of data gets manually updated, and after resolution we want to reflect that via the 'External ID' (e.g. a ticket number). Thanks
I wonder if there is any way of setting up in an automation the Take Snapshot step with the date information on it. Like for example: ADSExtrac_20241113.csv
Can Aperture Data Studio integrate with device configuration system with NETCONF Protocol
hi, So I have a workflow that I use an 'Issue list' as my source - the issue list has 29 rows. If I add a step to sort on the 'Failed Rows' column, my output for that is now 22 rows. No other filtering going on. Tried it on 2 different issues with the same result. However, if I remove the sort on the 'Failed Rows' column I…
