Aperture Data Studio

Discussion List

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

  Answered 16 views 1 comment 0 points Most recent by Josh Boxer November 29Support
• Your API key < API key name > will expire in 10 days'

  can u help me set up this? i cannot find the right directives in below documentation. i need to k…

  18 views 2 comments 0 points Most recent by HussainSyed November 28Administration
• Support for VARBINARY(MAX) field type in ADS

  Hello I have a user case that requires migrating Salesforce objects that contain attachments such a…

  Answered 70 views 2 comments 0 points Most recent by Henry Simms November 26Support
• Data Studio Salesforce Connection

  Connecting Data Studio directly to your data sources and CRM systems, like Salesforce, has never be…

  105 views 2 comments 6 points Most recent by JRowe November 11Feature demos
• Fuzzy Matching Logic

  Hi, I have a requirement to match records from two separate systems on the basis of FirstName, Last…

  Answered 37 views 2 comments 0 points Most recent by Danny Roden November 4General
• Automations and notifications.

  if I want to trigger automation if any workflow failed in that space. is that true for that case as…

  Answered 31 views 6 comments 0 points Most recent by HussainSyed November 1Administration
• swagger UI for find-duplicates- error. after recent upgrade.

  Hi, We are seeing this error after the latest upgrade. Upgrade done on our dev is as under.Upgrad…

  23 views 3 comments 0 points Most recent by Ian Hayden October 9Administration
• Invoking PowerShell script from Experian workflow/Schedule

  Is there a way to invoke a PowerShell script from Experian Aperture Data studio using workflow or s…

  Answered 23 views 1 comment 0 points Most recent by Josh Boxer September 19General
• Rows to Columns

  Hi, I have been testing out the Rows the Column function. However, it seems to be not pulling throu…

  Answered 35 views 4 comments 0 points Most recent by WilliamPerrin September 17Support
• Flattening out / Pivoting / Transforming results

  Hi, I'm having an issue flattening out results. Essentially, I have multiple rows for the same cust…

  Answered 40 views 4 comments 0 points Most recent by Josh Boxer September 17Support
• Compare Dates (Verbose) 📅📅

  Compare Dates (Verbose) [Category: Conversion] This function provides a summary of how 2x input dat…

  235 views 4 comments 1 point Most recent by christyjime September 11Functions 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…

  55 views 2 comments 0 points Most recent by Josh Boxer September 9General
• Error while invoking REST API from Experian Studio VM

  Background Experian data Studio version - 2.14.14 SSL setup done on the data studio url and private…

  Answered 61 views 2 comments 0 points Most recent by Henry Simms September 5General
• ♻ 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 …

  115 views 1 comment 3 points Most recent by christyjime September 4Reusable Workflows
• Experian Aperture Data Studio REST API error

  Hi, I am planning to automate dataset creation using Data studio REST API, however I am getting 401…

  Answered ✓ 44 views 3 comments 0 points Most recent by Josh Boxer September 4General
• 5
  Group Step > Being able to select and right click view multiple rows in groups

  What problem are you facing? When the Group step is used, we can only view rows in group on one va…

  In development 60 views 0 comments 5 points Started by Jacky Lu August 6 Ideas board
• 👩‍💻 The HTTP Request (REST API) step

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

  114 views 1 comment 3 points Most recent by KatriM August 1Feature demos
• Assign latest changed id to all linked records

  Hi, I have a scenario where input file is providing changed address ids in from-address and to_addr…

  72 views 5 comments 0 points Most recent by slngupta_1 July 4Tips and tricks
• 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 104 views 9 comments 1 point Most recent by Shreya April 29General
• Issues with Dev Environment Post-Upgrade

  I'm reaching out to address some critical issues we've been encountering with our Dev environment f…

  45 views 1 comment 0 points Most recent by Ian Hayden March 26General
• Use a View in the Map to target step

  The Workflow step Map to target allows the schema (column order and column names) of a table of dat…

  40 views 0 comments 0 points Started by Mirjam Schuke March 25 Feature demos
• Data Management User Group 6 March 2024: Recap and reflections

  A note from Sarah Williams reflecting on the Data Management User Group that was held on 6 March 20…

  240 views 2 comments 14 points Most recent by Chris Roy March 22Event recaps
• Managing Data Quality issues using Issue lists

  Issue lists allows Users in the same Space (including read-only Consumer users) to capture problema…

  60 views 0 comments 2 points Started by Mirjam Schuke March 15 Feature demos
• Compare two data sources

  The Compare step allows you to detect and highlight differences between two data sources, e.g. year…

  131 views 0 comments 4 points Started by Mirjam Schuke March 8 Feature demos
• ssl cert update process.

  has the process changed to update ssl cert on newer version? previously i used to do this, and hi…

  Answered ✓ 92 views 6 comments 0 points Most recent by HussainSyed February 28Administration
• 📋 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 1.1K views 8 comments 7 points Most recent by Danny Roden January 29Functions library
• Business Validation and Enrichment

  Aperture is a powerful tool when validating business information you already have. We can leverage …

  59 views 1 comment 4 points Most recent by Danny Roden January 25Tips and tricks
• UK Postcode formatter 🏡

  Summary This package contains a single function but may be updated in the future to include others.…

  115 views 4 comments 0 points Most recent by Lucy January 11Functions library
• 🔎 Data profiling showcase

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

  126 views 1 comment 0 points Most recent by Jaden December 2023Feature demos
• Aperture Data Studio 2.12.8, Find Duplicates 3.9.1

  We upgraded today our prod servers, and now we have the same situation, settings in find duplicates…

  37 views 1 comment 1 point Most recent by Ian Hayden December 2023General
• 🦸‍♂️ 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 66 views 2 comments 1 point Most recent by Seamus Kyle December 2023Event recaps
• 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…

  132 views 1 comment 7 points Most recent by Tanj Jagpal December 2023Tips 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…

  149 views 7 comments 2 points Most recent by Danny Roden November 2023Tips 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…

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

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

  34 views 3 comments 0 points Most recent by HussainSyed November 2023Administration
• Standardise Country 🌎

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

  374 views 8 comments 0 points Most recent by Henry Simms November 2023Functions library
• 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 ✓ 73 views 7 comments 0 points Most recent by Ian Hayden September 2023General
• Autonomous REST connection SQL query

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

  232 views 18 comments 0 points Most recent by Henry Simms August 2023General
• 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 ✓ 35 views 2 comments 0 points Most recent by Josh Boxer August 2023General
• 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 ✓ 55 views 5 comments 0 points Most recent by JRowe July 2023General
• 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 24 views 1 comment 0 points Most recent by Josh Boxer July 2023General
• 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 87 views 6 comments 0 points Most recent by Josh Boxer July 2023General
• 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 51 views 4 comments 0 points Most recent by Shreya July 2023General
• Date formats...

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

  81 views 1 comment 0 points Most recent by Danny Roden July 2023General
• 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 ✓ 76 views 2 comments 0 points Most recent by Shreya May 2023General
• 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 54 views 3 comments 0 points Most recent by Shreya May 2023General
• 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 84 views 7 comments 0 points Most recent by HussainSyed April 2023General
• 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 44 views 4 comments 0 points Most recent by HussainSyed April 2023General
• Aperture Data Studio - Find Duplicate Servers

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

  Answered 69 views 1 comment 0 points Most recent by Josh Boxer March 2023General