Experian Data Quality Community

Discussion List

• Anyone got the Azure Blob Storage Datasource connection working

  If so, what URL did you use? Couldnt find documentation around this. Thanks for answering

  Accepted Answer 24 views 7 comments 0 points Most recent by shaun0 June 4General discussion
• Duplicate Match Status Converter

  This is not a difficult thing to do but is a bit time consuming. Find Duplicates Match status is nu…

  21 views 0 comments 1 point Started by Chris Downer June 2 General discussion
• All Find Duplicates Pre-built Rulesets

  This dmx file will import all the Find Duplicates default rulesets. These are pre-built rules and b…

  13 views 0 comments 1 point Started by Chris Downer June 1 Resources
• Default Find Duplicates Rulesets

  Another quick shortcut. This dmx file will import all the Find Duplicates default rulesets. These a…

  10 views 0 comments 1 point Started by Chris Downer June 1 General discussion
• How to systematically sample with a fixed sample size and varying population size

  I was recently asked how to build a Data Studio workflow that would output a systematically sampled…

  29 views 2 comments 2 points Most recent by Henry Simms May 29General discussion
• Data Studio v2.0 - Rest API - trigger workflows

  Hi For the script where is states: >Powershell {path}\apertureExecuteWorkflowv2.ps1 -environment…

  Answered 57 views 2 comments 0 points Most recent by Clinton Jones May 27General discussion
• Can a Workflow Trigger use a 'Snapshot' result as the sourceTrigger (1.6.0)

  If so, how?

  Answered 31 views 1 comment 0 points Most recent by Henry Simms May 20General discussion
• Find Duplicates Blocking Keys and Rules in v2

  If you have the license for Find Duplicates Fuzzy matching then you could use this functionality to…

  Accepted Answer 23 views 3 comments 0 points Most recent by Chris Downer May 19General discussion
• Enabling LDAP

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

  37 views 2 comments 2 points Most recent by Henry Simms May 15General discussion
• What is the status of data catalog integrations, for example Collibra?

  What is the current status of Aperture to Collibra-integration? https://marketplace.collibra.com/pr…

  Accepted Answer 75 views 1 comment 0 points Most recent by Clinton Jones May 11General discussion
• De-Duplication DateCompare

  Hi, I am having trouble implementing the "DateCompare" comparitor and was wondering if so…

  Accepted Answer 23 views 2 comments 0 points Most recent by stevenmckinnon May 11General discussion
• Setting up custom Find Duplicates rules

  @Carolyn asks I would like to set up a custom Find Duplicates - Not sure how to set up Find Duplic…

  Accepted Answer 34 views 2 comments 0 points Most recent by stevenmckinnon May 8General discussion
• Welcome to the new look Experian Data Quality Community! What's new?

  You may have noticed a few changes! We have been busy working behind the scenes to introduce new fe…

  73 views 0 comments 5 points Started by Tanj Jagpal May 8 Announcements
• Adding a variable comment as a "call to action" for data quality issues found

  This is an experiment on handling HR data quality issues using a validation workflow in Aperture Da…

  24 views 1 comment 1 point Most recent by Henry Simms May 5General discussion
• Specifiy or select non default schema when pulling external source from Azure SQL server using JDBC

  In previous versions of Aperture Data Studio is stated that their were bug fixes related to SQL Ser…

  Answered 21 views 2 comments 0 points Most recent by Henry Simms May 5General discussion
• Updating multiple keys after de-dup

  Good Morning, I have recently ran a de-duplication process and have a good set of cluster ID's. Wi…

  Accepted Answer 21 views 8 comments 0 points Most recent by Clinton Jones May 4General discussion
• De_Dup failing

  Anyone any ideas ? https://us.v-cdn.net/6031645/uploads/664/JJR2BYRPD2D4.png

  Accepted Answer 22 views 4 comments 0 points Most recent by stevenmckinnon May 1General discussion
• Data Studio v2.0 - Export JDBC Error 9002

  Hi We are trying to export data back to database. We have updated the export definition as follows:…

  Answered 21 views 1 comment 0 points Most recent by Clinton Jones May 1General discussion
• Split Column - 2 columns

  Hi I have a file that has a column for postal address that is in this format. Using V2.0 Data Studi…

  Answered 22 views 5 comments 0 points Most recent by Sueann See April 27General discussion
• Data Studio V2.0 Find Duplicates

  Hi Thank you for the answers around using Find Duplicates Workbench. I will investigate this long t…

  Answered 22 views 1 comment 0 points Most recent by Katya Jermolina April 24General discussion
• SSIS and Aperture

  Is it feasible to embed an aperture task within a scheduled SSIS job? This would be used in the ini…

  Answered 24 views 1 comment 2 points Most recent by Clinton Jones April 24General discussion
• Data Studio v2.0.10

  Hi, We’re pleased to announce the release of Data Studio v2.0.10.  You can get an internal copy of…

  5 views 0 comments 0 points Started by Ivan Ng April 22 General discussion
• Data Studio V2.0 - Trend Analyse & Data Consumer Dashboards

  Hi On the help documentation, there is no update on Trend Analyse and Data Consumer Dashboards If t…

  Answered 22 views 4 comments 1 point Most recent by Ian Buckle April 20General discussion
• Data Studio V2.0 - External System Connections

  Hi When you set up an External System Connection it will only appear under the workspace you create…

  Answered 41 views 4 comments 0 points Most recent by Ian Buckle April 20General discussion
• AWS database connection issues to Aperture (v1.6.4)

  Hi, Does anybody have any suggestions why a database can arbitrarily flip-flop between connecting t…

  24 views 4 comments 0 points Most recent by Clinton Jones April 15General discussion
• Data studio v2.0 - trigger workflows

  Hi In version 1.6.1 the way to trigger workflows was to setup the yaml file. How do you setup trigg…

  Answered 91 views 27 comments 0 points Most recent by Carolyn April 15General discussion
• APIs in Aperture Data Studio v2

  In v1 there were a number of APIs for the automation of UI as outlined here under the REST API guid…

  Accepted Answer 11 views 2 comments 0 points Most recent by Ivan Ng April 8General discussion
• Scheduling workflows using the Data Studio REST API in version 2

  In v2.0 of Data Studio, the REST API has changed from v1, so this original post has been updated fo…

  83 views 5 comments 2 points Most recent by Ivan Ng April 8General discussion
• Data Studio v2.0

  Hi When l have a snapshot at the end of a workflow, if the workflow is 200k or less lines it will …

  Answered 11 views 1 comment 0 points Most recent by Clinton Jones April 8General discussion
• Data Studio v2.0 - Run workflow

  Hi I have built a few complicated workflows …. lots of steps ending with a snapshot - when l run no…

  32 views 3 comments 0 points Most recent by Clinton Jones April 2General discussion
• Data Studio v2.0 - Administrator password reset

  Hi The administrator password needs to be reset and unfortunately the administrator is unable to ac…

  Answered 31 views 2 comments 0 points Most recent by Carolyn April 2General discussion
• Data Studio v2.0 - Run Workflow - Address Validation - Data Studio drops out

  Hi When we are selecting run on workflows it is failing and kicking you out of Data Studio. Only wa…

  Answered 12 views 2 comments 0 points Most recent by Carolyn April 2General discussion
• Data Studio V2.0 - tagging

  Hi I have spent a bit of time trying to determine how to do tagging on a file after or during trans…

  Accepted Answer 12 views 4 comments 0 points Most recent by Carolyn April 1General discussion
• Data Studio v2.0 - collective grouping columns

  Hi Hopefully this is a simple question. In version 1.6.1 to group columns across all data, you woul…

  Answered 24 views 6 comments 0 points Most recent by Carolyn March 31General discussion
• Data Studio v2.0 - Union multiple Files

  Hi I am loading over 15 data sources and once l format and validate, will need to union them all to…

  Answered 11 views 2 comments 0 points Most recent by Carolyn March 31General discussion
• Grouping in V2 and differences with V1

  if you're working with financial data with Aperture Data Studio, one of the things that you might w…

  11 views 0 comments 1 point Started by Clinton Jones March 27 General discussion
• Data Studio v2.0 - transform function Map to Target

  Hi I will be loading over 15 sources of customer data. To assist with column naming and tagging the…

  Answered 35 views 4 comments 0 points Most recent by Carolyn March 26General discussion
• Delta Data Loads - Data Studio version 2.0

  Hi New to this forum so hope this makes sense We have just gone live with Aperture Data Studio Ver…

  Answered 42 views 7 comments 1 point Most recent by Akshay Davis March 26General discussion
• Reading files without headers - then scheduling the job

  Hi We would like to use Aperture (currently using v1.6.2) to read a series of files that are sent o…

  12 views 7 comments 0 points Most recent by Nigel Light March 23General discussion
• The title field is required

  Body is 1 character too short.

  11 views 0 comments 0 points Started by Clinton Jones March 22 General discussion
• Code going missing in a v1.x job?

  Hi Are any other users experiencing the frustration of sections of code going missing? We (@Pavan …

  41 views 12 comments 0 points Most recent by Nigel Light March 13General discussion
• UK Bank Accounts / Sort Codes

  Is there way to validate a number against the above or does anyone have a list that I can use the c…

  Answered 21 views 4 comments 0 points Most recent by Clinton Jones March 13General discussion
• 2020 Global data management research

  Experian recently released its annual global data management benchmark report. This year we surveye…

  25 views 0 comments 3 points Started by ehaselkorn March 9 General discussion
• Find Duplicates Language for Notepad++

  If you're using Notepad++ as your text editor, it can be helpful to have an interpreter to highligh…

  11 views 1 comment 0 points Most recent by Akshay Davis March 6General discussion
• Using a network path for the server import or export directory

  It may be desirable to have Data Studio v1 or v2 import and export data from a network path. This w…

  36 views 0 comments 1 point Started by Akshay Davis March 5 General discussion
• Find Duplicates Training Data

  Attached is data to be used with Find Duplicates Training. https://us.v-cdn.net/6031645/uploads/176…

  31 views 0 comments 1 point Started by Akshay Davis March 4 Resources
• Profiling all tables of a source

  Hi team, Partner is using Aperture Data Studio to profile sources on client site - so that he can …

  Accepted Answer 74 views 4 comments 2 points Most recent by Clinton Jones March 4General discussion
• Sample data files

  This zip file contains a number of sample data files. Download these to facilitate your Aperture Da…

  55 views 0 comments 3 points Started by Tanj Jagpal February 12 Resources
• Data Views - an abstracted view of your data sources

  An entirely new concept of data views based on datasets is introduced in V2.0. Views enable designe…

  21 views 0 comments 0 points Started by Clinton Jones February 7 General discussion
• Handling Gmail email addresses for duplicate identification

  The problem: Gmail allows multiple e-mail addresses for a single account With over 1 billion active…

  92 views 3 comments 3 points Most recent by Akshay Davis February 6General discussion