Aperture Data Studio
Discussion List
-
Data profiling showcaseEver since Aperture Data Studio’s pre-curser, Pandora, one of our most used features and most loved…
-
The HTTP Request (REST API) stepThis post is to raise awareness of an additional workflow step, that is increasingly being used to …
-
Use of If-Then-Else logic in Aperture Data StudioImagine you are asked to use Aperture Data Studio to generate a new field for your sales data. You…
-
Documenting what data is available in Data Studio (to users who don't have access)A question that cropped up earlier today was: 'how can we avoid different users connecting to the s…
-
Upgrade Issue, Aperture data studio , Find Duplicates latest versionsHi Ian, Looks like after the recent upgrade we have an issue that experianmatch path got changed t…
-
Low Disk Space issue.Hi, We have the disk space issue once more for our data drive. We changed the index expiry setting…
-
🦸♂️ Data Management User Group event summaryLast week we welcomed over 40 customers to our latest Data Quality User Group. Held in our London o…
-
Standardise Country 🌎Standardise Country The function uses reference data (contained within the .dmxd file) to standardi…
-
📣 Join us at our next User Group - 9th November 2023 📅I am pleased to confirm that our next User Group event for Aperture Data Studio users will take pla…
-
Workflow is not in an executable state but no errors existHi DQ Community, I have a workflow that I can't run or publish because I get error messages telling…
-
Autonomous REST connection SQL queryHow can I get a simple SQL running when everything is set up . the Autonomous REST connection is su…
-
♻ Reusable workflow example – calculate word frequencyToday I’d like to share with you a reusable workflow that I built a little while ago not only as a …
-
Handling data from Experian Aperture Data Studio jobsWe are getting error in the execution of Experian scheduled jobs as "There is not enough spac…
-
How is true / false field stored in Aperture?Note that the data below is business data and not PII. Issue: When I import the CSV file created in…
-
Want to pass certain input from API to the workflowi am trying to call an API from an external website my agenda is to pass some IDs that will be take…
-
Copy of FiServ Files uploaded into DA & use of the Metro2 ParserDoes anyone use Data Arc with a copy of a FiServ Metro2 File? We are setting this up as net new an…
-
Stored Procedure invoked from PostSQL of Export step is not processing all recordshi, In my workflow, I am connecting to SQL server 2012 using Custom JDBC jar (Microsoft JDBC Jar 12…
-
Date formats...Earlier today I received the below email from a customer which I wanted to post on here in case the…
-
Error while connecting to Embedded Duplicate StoreHi, I am getting error as below when I am trying to connect to the Embedded Duplicate store in my D…
-
Error attempting to delete match storeHi, In my project, we are using Experian Aperture Data Studio(2.10.10) to connect to a Remote Find …
-
Error while invoking stored procedure from Experian Aperture Data Studio using custom JDBC driverHi, I am using the Experian Aperture Data Studio (2.10.0.80) and have configured a custom JDBC Jar …
-
shutdown due to heartbeat?2023-04-13 08:57:06,646 INFO c.e.d.b.BatchService [Thread-0] Shutdown due to heartbeat timeout 202…
-
ADS, not enough permissions for page.user is admin to the workspace. what could possibly be the reason for her not to see the dashboard …
-
Aperture Data Studio - Find Duplicate ServersHello Community, Our organization has recently decided to use ADS for Data Quality tool and we are …
-
Keyword: Community - Data Management User Group Material 09th March 2023It was great to meet the Experian Aperture Team and fellow users last week. Just wondering if and w…
-
Future Date Check 📅 (Dynamic)Summary This package contains 2x rules: “Is a future date” and “Not a future date” (compared to cur…
-
📋 Index of reusable Functions! 📇This post simply acts as an index for all the functions shared in this library. If you would like t…
-
⌚ Convert Epoch Date/Time to Standard Date/Time⌚ Convert Epoch Date/Time to Standard Date/Time This function was inspired by this post and creat…
-
📣 Join us in person at our next UKI Data Management User Group I 9th March 2023 📅I am pleased to confirm that our next UK Data Management User Group will take place on Thursday 9 M…
-
Enabling custom category in DataArc 360 under validation stepsI use this for my Metro2 reporting. I created a new category called Custom Rules. I created new f…
-
Java pid hprof crash files.Facing the issue in our dev server for Aperture Data Studio and Find Duplicates. In log I have foun…
-
Java Update - Vulnerability detected on our Experian Dev/Prod ServerThis version has been detected as vulnerable by - OCPU-2022-JUL: Oracle Java Critical Patch Update …
-
Join us Online for our next Data Management User Group | 15 September 22 !I am pleased to confirm that our next UK Data Management User Group will take place on Thursday 15 …
-
Aperture Data Studio backups@Henry Simms , what would be the equivalent link to this according to current version. https://www…
-
Quick Actions menuSince v2.8 Aperture Data Studio has had a command palette that makes shortcuts and access to freque…
-
Challenge 5 – Fibonacci Sequence to XThe Fibonacci Sequence is the series of numbers 0, 1, 1, 2, 3, 5, 8, 13, 21, 34,.... The next numbe…
-
Does Aperture have the "treat leading zeros as alphanumeric" option that Pandora hadOne a a global setting that instructed Pandora to treat any input field with leading zeros as alph…
-
Repeating Characters 🔁Check for same character repeated This function uses a regular expression to identify records where…
-
How to copy dataset header to a row within the same dataset?Hello, I want to create an additional row on my dataset which would contain a copy of the header na…
-
Extract First Word 🥇📝This function extracts the first word in a string, in which all words are separated by space. The f…
-
Replace the word ‘NULL’ or any non-null space values with null 🔄👻This function replaces the word ‘Null’ (case insensitive) with a null value. For example, if the va…
-
Extract Last Word 💬🥉 Extract Last Word Version I This function extracts the last word in a string, in which all words a…
-
Challenge 5 SolutionsSo did you figure it out? What approach did you take? Something like this - what was your route to…
-
Aperture data studio log file locationHi, I have noticed something now in our prod servers. The log file generated for aperture data s…
-
Word FrequencyEvery now and then a scenario crops up where it'd handy to know how often a given word occurs withi…
-
Challenge 4 SolutionsSo did you figure it out? What approach did you take? You know what the results should look like, …
-
Parse Date 🧽📅Parse Date This function is designed to have flexibility to accommodate all sorts of different dat…
-
Huge HPROF file in installation folder.java_pid2376.hprof What is an HPROF file and what is it doing in my ADS installation folder. C:\Pro…
-
Challenge 4 - Cleaning product (data)Want to test your Aperture Data Studio skills a little more? This next challenge requires you to an…
Upcoming Events
-
EDQ UK Data Validation User Group (DVUG) December Virtual Meetup
Join us for our upcoming festive Data Validation User Group! This particular user group caters exclusively to Experian Data Validation Solutions users. We are posting this within the Data Quality Community, as we acknowledge that certain clients also use data validation. As such, this user group may be of interest to those…
Share your thoughts on Aperture Data Studio
Your feedback will influence how we improve our products.