Aperture Data Studio

Discussion List

• 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 …

  Answered ✓ 51 views 2 comments 0 points Most recent by Shreya May 31General discussion
• 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 18 views 1 comment 0 points Most recent by Josh Boxer May 30General discussion
• 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 43 views 3 comments 0 points Most recent by Shreya May 12General discussion
• 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 56 views 7 comments 0 points Most recent by HussainSyed April 13General discussion
• 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 28 views 4 comments 0 points Most recent by HussainSyed April 3General discussion
• Aperture Data Studio - Find Duplicate Servers

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

  Answered 45 views 1 comment 0 points Most recent by Josh Boxer March 24General discussion
• 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 ✓ 18 views 1 comment 1 point Most recent by Josh Boxer March 20General discussion
• Future Date Check 📅 (Dynamic)

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

  102 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 760 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…

  Pinned post 31 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…

  74 views 3 comments 1 point Most recent by Josh Boxer February 6General discussion
• Java pid hprof crash files.

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

  25 views 2 comments 0 points Most recent by HussainSyed December 2022General discussion
• 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 …

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

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

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

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

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

  30 views 0 comments 3 points Started by James Bate October 2022 Resources
• Standardise Country 🌎

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

  255 views 6 comments 0 points Most recent by Henry Simms October 2022Functions Library
• 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 ✓ 34 views 2 comments 0 points Most recent by Charles Thomas August 2022General discussion
• Repeating Characters 🔁

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

  122 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 51 views 3 comments 0 points Most recent by Josh Boxer August 2022General discussion
• Extract First Word 🥇📝

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

  21 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…

  16 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…

  15 views 0 comments 0 points Started by Fatme Kungyova August 2022 Functions Library
• Aperture data studio log file location

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

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

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

  53 views 0 comments 5 points Started by Danny Roden July 2022 General discussion
• Parse Date 🧽📅

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

  129 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 ✓ 37 views 4 comments 0 points Most recent by Henry Simms June 2022General discussion
• Notifications based on emails in the data

  We have 50 service desks placing orders for customers around the country. We want to monitor those …

  Answered 69 views 6 comments 2 points Most recent by Sueann See June 2022General discussion
• How to setup Google Big Query as an external system for pushing data into BigQuery table

  Hi, Did anybody try using the Google Big Query 6.0 JDBC and know how to configure the credential de…

  Answered 109 views 3 comments 1 point Most recent by Henry Simms June 2022General discussion
• Low Disk Space Notifications and others.

  Hi team, this is to ask you if I create a low disk space notification on aperture data studio syst…

  Answered 50 views 2 comments 0 points Most recent by HussainSyed April 2022General discussion
•  Calculate the distance between two sets of co-ordinates 🌍️ 

  Summary Returns the approximate distance in kilometres between a pair of geographical co-ordinates.…

  37 views 1 comment 2 points Most recent by Danny Roden February 2022Functions Library
• Force workflow failure due to failing rows

  Is there a way I can force a whole workflow to fail as a result of failing rows in a validation ste…

  Answered ✓ 142 views 7 comments 0 points Most recent by Josh Boxer February 2022General discussion
• Enabling LDAP

  In case you haven't noticed, LDAP has been introduced since Aperture Data Studio v2.0.11. Go to Set…

  165 views 3 comments 2 points Most recent by Josh Boxer February 2022General discussion
• Issue with dates being read as American dates

  I am pulling in my source data with a column that contains dates of the format dd/mm/yyyy. When ann…

  Answered 52 views 5 comments 0 points Most recent by Henry Simms January 2022General discussion
• Next ⏭️📅 & Previous ⏮️📅 Working Day

  Summary The 2x functions contained within this package relate to identifying the last working date …

  34 views 0 comments 0 points Started by Danny Roden November 2021 Functions Library
• Last day / working date of month 📅

  Summary The 2x functions contained within this package relate to identifying the last date of the m…

  38 views 0 comments 0 points Started by Danny Roden November 2021 Functions Library
• How to promote from dev to prod environments when using different external systems

  Problem: I’ve recently been working with a client who had used their Data Studio development enviro…

  454 views 4 comments 2 points Most recent by Matt Berry October 2021General discussion
• Relationship Discovery by using Find Duplicates Step in Aperture Data Studio

  We tried to find the join candidates across tables and databases by using the profiling metadata in…

  Answered 35 views 3 comments 1 point Most recent by Sueann See October 2021General discussion
• Dynamic Naming of Output File

  Hi, Is it possible to have a dynamic text element of the naming of an output file. I understand th…

  Answered ✓ 53 views 2 comments 0 points Most recent by beth.kirby August 2021General discussion
• Error with resuable workflow step in new workflow

  Hi, I have created a workflow that produces an output and has been made reuseable. This workflow i…

  Answered ✓ 26 views 1 comment 0 points Most recent by beth.kirby August 2021General discussion
• 👋 Introduction to the Functions Library 📂

  Intro This area of the Community hosts our library of re-usable functions for use in Aperture Data …

  Pinned post 253 views 10 comments 1 point Most recent by Nigel Light July 2021Functions Library
• Create our own Elements for Find Duplicates Step

  Hi Team, I'd like to ask some questions about Find Duplicates Step. Is this step only for CONTACT …

  Answered 44 views 4 comments 0 points Most recent by Josh Boxer June 2021General discussion
• Questions about Data Tagging and Profiling in Aperture Data Studio

  Hi team, Is it possible to tag and profile multiple tables at the same time in Aperture Data Studio…

  Answered 78 views 11 comments 1 point Most recent by Sueann See June 2021General discussion