Experian Data Quality Community
Learn, collaborate and solve problems with like-minded data quality enthusiasts.
Discussion List
-
JDBC connectionHi Can you please let me know if there is/planned to be a JDBC connection for Optymyze? Thanks Nige
-
Function to calculate the number of working days between two datesRecently I wanted to create a function in Data Studio to calculate the number of working days betwe…
-
How to systematically sample with a fixed sample size and varying population sizeI was recently asked how to build a Data Studio workflow that would output a systematically sampled…
-
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…
-
Adding a variable comment as a "call to action" for data quality issues foundThis is an experiment on handling HR data quality issues using a validation workflow in Aperture Da…
-
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…
-
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…
-
Community guidelinesWe welcome you and your views in our community! We want to make this a positive, safe and vibrant p…
-
How to earn points, badges and to increase rankThe Experian Data Quality Community isn't about the volume of discussions and questions but about t…
-
How to register and manage your accountYou need to register to post and comment, but don’t worry - it takes a couple of minutes. Click Reg…
-
Welcome to the Experian Data Quality Community 🙌 Welcome! At Experian, we’re extremely proud of our data quality solutions, and we've set up this c…
-
APIs in Aperture Data Studio v2In v1 there were a number of APIs for the automation of UI as outlined here under the REST API guid…
-
Grouping in V2 and differences with V1if you're working with financial data with Aperture Data Studio, one of the things that you might w…
-
Reading files without headers - then scheduling the jobHi We would like to use Aperture (currently using v1.6.2) to read a series of files that are sent o…
-
The title field is requiredBody is 1 character too short.
-
Code going missing in a v1.x job?Hi Are any other users experiencing the frustration of sections of code going missing? We (@Pavan …
-
2020 Global data management researchExperian recently released its annual global data management benchmark report. This year we surveye…
-
Using a network path for the server import or export directoryIt may be desirable to have Data Studio v1 or v2 import and export data from a network path. This w…
-
Data Views - an abstracted view of your data sourcesAn entirely new concept of data views based on datasets is introduced in V2.0. Views enable designe…
-
Handling Gmail email addresses for duplicate identificationThe problem: Gmail allows multiple e-mail addresses for a single account With over 1 billion active…
-
User Spaces - a way to organize your workAn entirely new concept of user spaces is introduced in V2.0. Spaces enable designers of workflows…
-
Environments - giving your Data Studio installation more flexibility with sandboxesOne of the characteristics of business-critical systems is that they need to be secured in such a w…
-
Democratizing and controlling data access in v2.0Data Studio v2.0 provides a sophisticated and secure architecture for exposing data to the enterpri…
-
Connecting to an SMTP email server that does not require authenticationData Studio lets you configure an SMTP server connection, which can then be used to send email noti…
-
Scheduling workflows using the Data Studio REST APIAperture Data Studio is intended to be invoked from third party schedulers , like Windows Task Sche…
-
Hello world...🥂 our developers have been hard at work and we are stoked about this new release. Prod your account…
-
Inferring Gender from Title or Honorific and Gender ReversalSometimes it might be useful to determine the gender of a person from their honorific, so for examp…
-
Impact of snapshots on memoryHi, I am using a job that has several input snapshots defined in it, though I only connect 2 of the…
-
Data Studio v1.6.2 is now available!This maintenance release resolves several issues caused when executing workflows using the REST API…
-
Is it possible to 'pull' data from Aperture Data Studio into Excel?Hi, Whilst there is the option to export data from Data Studio into Excel, is it possible to pull d…
-
Approach for Matching Product data (product description)Yesterday @MiteshKhatri @Akshay Davis @Katya Jermolina and I were having a discussion about approac…
-
Partition Values (Dynamic SQL Partition Row Number)A question that's cropped up for a couple of clients recently is how do I segment my data and split…
-
Extracting the country from an unstructured address using a lookup list of countriesThe problem that you may need to solve is that you have data that is effectively a contiguous strin…
-
Accesing data from quick sense filesHi everyone, I'm new in data aperture and I have a client who calculates KPIs in a quick sense repo…
-
Cross-system and cross-table relationship discovery automationIn our customer cases data quality issues are often cross-system inconsistencies. Technically, cust…
-
Sequence countHi, I can't find a sequence count in Aperture - is there one planned in Version 2.x? Nige
-
Data Studio and MDMIt sometimes gets asked how we co-exist with an MDM system. We have many customers using Data Studi…
-
Use of SQL to refine source data prior to loading into ApertureHi, I was just wondering whether other users would find a Pandora-like feature to pre-filter prior …
-
Availability of source file/table metadataHi, We are using Aperture to compare profile statistics from 2 tables from different SQL databases…
-
Extracting a specific piece of information from an address using regular expressions and lookupsData Studio has several built-in functions to allow you parse strings of text and extract a particu…
-
How to trigger an e-mail notification if a job failsData Studio has a range of default notification options which allow you to send a custom email to d…
-
Checking data like social security numbers (SSN) for correctnessSocial Security Numbers, National Identity numbers and the like, on face value are simply strings o…
-
Checking data like social security numbers (SSN) for correctnessSocial Security Numbers, National Identity numbers and the like, on face value are simply strings o…
-
Sharing database connections across teamsWhat's the recommended approach to sharing tables/views and connections to databases across a wider…
-
Getting started with Regular Expressions in Data StudioA regular expression (from here on we’ll call them “regex” for short) is a well-known and powerful …
-
Tips to improve workflow performanceIf you ever find that a workflow is taking a long time to execute, you might want to think of ways …
-
Using a discriminant for Find Duplicates clusteringFind Duplicates will use fuzzy matching to link records, however, in some cases you may have a disc…
-
Data Studio v1.6.0 is now available!The latest version of Data Studio introduces new features, existing functionality enhancements, per…
-
Creating a new data connection to Salesforce from Data Studio via JDBCIt is likely that quite soon after you start to use Data Studio you will want to connect Data Studi…
-
Validate Customer data example WorkflowThis simple validation workflow leverages the Sample Data of Customer V1, The FILTER step filters t…
Categories
- All categories
- 17 Get started
- 484 Get involved
- 18 Support
- 254 Resources
- 3 Events
- Upcoming events
- 3 Event recaps
- 18 Ideas and roadmap
- 97 Community categories
Popular tags
- Release notes 140
- Aperture Data Studio 131
- Find Duplicates 59
- Functions 55
- Data Studio 31
- Workflows 29
- Datasets 27
- dmx 24
- REST API 22
- feature demos 22
- tips and tricks 19
- Rules 18
- v2.12 14
- v2.8 14
- Community Challenge 14
- v2.11 13
- Extensions 13
- v2.5 12
- Notifications 11
- Transform 11
- v2.10 11
- Address Validation 10
- Automations 10
- Dashboards & Charts 10
- blocking keys 10