Aperture Data Studio

Discussion List

• Data profiling showcase

  Ever since Aperture Data Studio’s pre-curser, Pandora, one of our most used features and most loved…

  8 views 0 comments 0 points Started by Danny Roden December 1 Feature demos
• The HTTP Request (REST API) step

  This post is to raise awareness of an additional workflow step, that is increasingly being used to …

  12 views 0 comments 1 point Started by Danny Roden November 29 Feature demos
• Use of If-Then-Else logic in Aperture Data Studio

  Imagine you are asked to use Aperture Data Studio to generate a new field for your sales data. You…

  20 views 0 comments 1 point Started by Seamus Kyle November 29 Tips and tricks
• 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…

  106 views 7 comments 2 points Most recent by Danny Roden November 14Tips and tricks
• Upgrade Issue, Aperture data studio , Find Duplicates latest versions

  Hi Ian, Looks like after the recent upgrade we have an issue that experianmatch path got changed t…

  37 views 4 comments 0 points Most recent by HussainSyed November 14General
• Low Disk Space issue.

  Hi, We have the disk space issue once more for our data drive. We changed the index expiry setting…

  18 views 5 comments 0 points Most recent by HussainSyed November 14Administration
• 🦸‍♂️ Data Management User Group event summary

  Last week we welcomed over 40 customers to our latest Data Quality User Group. Held in our London o…

  Pinned post 27 views 0 comments 1 point Started by Danny Roden November 13 Event recaps
• Standardise Country 🌎

  Standardise Country The function uses reference data (contained within the .dmxd file) to standardi…

  295 views 8 comments 0 points Most recent by Henry Simms November 13Functions library
• 📣 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…

  21 views 0 comments 0 points Started by Danny Roden October 27 General
• Workflow is not in an executable state but no errors exist

  Hi DQ Community, I have a workflow that I can't run or publish because I get error messages telling…

  Answered ✓ 52 views 7 comments 0 points Most recent by Ian Hayden September 18General
• Autonomous REST connection SQL query

  How can I get a simple SQL running when everything is set up . the Autonomous REST connection is su…

  142 views 18 comments 0 points Most recent by Henry Simms August 13General
• ♻ Reusable workflow example – calculate word frequency

  Today I’d like to share with you a reusable workflow that I built a little while ago not only as a …

  29 views 0 comments 2 points Started by Danny Roden August 10 Tips and tricks
• Handling data from Experian Aperture Data Studio jobs

  We are getting error in the execution of Experian scheduled jobs as "There is not enough spac…

  Answered ✓ 22 views 2 comments 0 points Most recent by Josh Boxer August 7General
• 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…

  Answered ✓ 35 views 5 comments 0 points Most recent by JRowe July 25General
• Want to pass certain input from API to the workflow

  i am trying to call an API from an external website my agenda is to pass some IDs that will be take…

  Answered 11 views 1 comment 0 points Most recent by Josh Boxer July 18General
• Copy of FiServ Files uploaded into DA & use of the Metro2 Parser

  Does anyone use Data Arc with a copy of a FiServ Metro2 File? We are setting this up as net new an…

  Answered 62 views 6 comments 0 points Most recent by Josh Boxer July 14General
• Stored Procedure invoked from PostSQL of Export step is not processing all records

  hi, In my workflow, I am connecting to SQL server 2012 using Custom JDBC jar (Microsoft JDBC Jar 12…

  Answered 42 views 4 comments 0 points Most recent by Shreya July 5General
• Date formats...

  Earlier today I received the below email from a customer which I wanted to post on here in case the…

  22 views 1 comment 0 points Most recent by Danny Roden July 4General
• Error while connecting to Embedded Duplicate Store

  Hi, I am getting error as below when I am trying to connect to the Embedded Duplicate store in my D…

  Answered ✓ 62 views 2 comments 0 points Most recent by Shreya May 31General
• Error attempting to delete match store

  Hi, In my project, we are using Experian Aperture Data Studio(2.10.10) to connect to a Remote Find …

  Answered 23 views 1 comment 0 points Most recent by Josh Boxer May 30General
• Error while invoking stored procedure from Experian Aperture Data Studio using custom JDBC driver

  Hi, I am using the Experian Aperture Data Studio (2.10.0.80) and have configured a custom JDBC Jar …

  Answered 41 views 3 comments 0 points Most recent by Shreya May 12General
• 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…

  Answered 52 views 7 comments 0 points Most recent by HussainSyed April 13General
• 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 …

  Answered 31 views 4 comments 0 points Most recent by HussainSyed April 3General
• Aperture Data Studio - Find Duplicate Servers

  Hello Community, Our organization has recently decided to use ADS for Data Quality tool and we are …

  Answered 53 views 1 comment 0 points Most recent by Josh Boxer March 24General
• Keyword: Community - Data Management User Group Material 09th March 2023

  It was great to meet the Experian Aperture Team and fellow users last week. Just wondering if and w…

  Answered ✓ 11 views 1 comment 1 point Most recent by Josh Boxer March 20General
• Future Date Check 📅 (Dynamic)

  Summary This package contains 2x rules: “Is a future date” and “Not a future date” (compared to cur…

  135 views 1 comment 0 points Most recent by Josh Boxer February 15Functions library
• 📋 Index of reusable Functions! 📇

  This post simply acts as an index for all the functions shared in this library. If you would like t…

  Pinned post Read only 853 views 5 comments 6 points Most recent by Danny Roden February 10Functions library
• ⌚ 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…

  34 views 0 comments 2 points Started by Danny Roden February 10 Functions library
• 📣 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…

  72 views 3 comments 1 point Most recent by Josh Boxer February 6General
• Enabling custom category in DataArc 360 under validation steps

  I use this for my Metro2 reporting. I created a new category called Custom Rules. I created new f…

  Answered ✓ 1 view 2 comments 0 points Most recent by Valori December 2022Credit data reporting
• Java pid hprof crash files.

  Facing the issue in our dev server for Aperture Data Studio and Find Duplicates. In log I have foun…

  21 views 2 comments 0 points Most recent by HussainSyed December 2022General
• Java Update - Vulnerability detected on our Experian Dev/Prod Server

  This version has been detected as vulnerable by - OCPU-2022-JUL: Oracle Java Critical Patch Update …

  51 views 7 comments 0 points Most recent by HussainSyed November 2022General
• 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 …

  111 views 4 comments 5 points Most recent by James Sidebotham November 2022General
• Aperture Data Studio backups

  @Henry Simms , what would be the equivalent link to this according to current version. https://www…

  Answered 21 views 1 comment 0 points Most recent by Josh Boxer November 2022General
• Quick Actions menu

  Since v2.8 Aperture Data Studio has had a command palette that makes shortcuts and access to freque…

  21 views 0 comments 3 points Started by James Bate October 2022 Tips and tricks
• Challenge 5 – Fibonacci Sequence to X

  The Fibonacci Sequence is the series of numbers 0, 1, 1, 2, 3, 5, 8, 13, 21, 34,.... The next numbe…

  42 views 2 comments 1 point Most recent by Henry Simms September 2022Challenges
• Does Aperture have the "treat leading zeros as alphanumeric" option that Pandora had

  One a a global setting that instructed Pandora to treat any input field with leading zeros as alph…

  Answered ✓ 32 views 2 comments 0 points Most recent by Charles Thomas August 2022General
• Repeating Characters 🔁

  Check for same character repeated This function uses a regular expression to identify records where…

  134 views 5 comments 0 points Most recent by Juan_NFCU August 2022Functions library
• 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…

  Answered 57 views 3 comments 0 points Most recent by Josh Boxer August 2022General
• Extract First Word 🥇📝

  This function extracts the first word in a string, in which all words are separated by space. The f…

  23 views 0 comments 1 point Started by Fatme Kungyova August 2022 Functions library
• 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…

  24 views 0 comments 0 points Started by Fatme Kungyova August 2022 Functions library
• Extract Last Word  💬🥉 

  Extract Last Word Version I This function extracts the last word in a string, in which all words a…

  11 views 0 comments 0 points Started by Fatme Kungyova August 2022 Functions library
• Challenge 5 Solutions

  So did you figure it out? What approach did you take? Something like this - what was your route to…

  1 view 0 comments 0 points Started by Danny Roden July 2022 Solutions
• Aperture data studio log file location

  Hi, I have noticed something now in our prod servers. The log file generated for aperture data s…

  86 views 3 comments 0 points Most recent by Henry Simms July 2022General
• Word Frequency

  Every now and then a scenario crops up where it'd handy to know how often a given word occurs withi…

  62 views 0 comments 5 points Started by Danny Roden July 2022 General
• Challenge 4 Solutions

  So did you figure it out? What approach did you take? You know what the results should look like, …

  31 views 5 comments 0 points Most recent by Danny Roden July 2022Solutions
• Parse Date 🧽📅

  Parse Date This function is designed to have flexibility to accommodate all sorts of different dat…

  142 views 1 comment 0 points Most recent by Henry Simms June 2022Functions library
• 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…

  Answered ✓ 43 views 4 comments 0 points Most recent by Henry Simms June 2022General
• Challenge 4 - Cleaning product (data)

  Want to test your Aperture Data Studio skills a little more? This next challenge requires you to an…

  21 views 0 comments 1 point Started by Danny Roden June 2022 Challenges