Learn, collaborate and solve problems with like-minded data quality enthusiasts.
The Data Quality Community is a great place to collaborate, seek answers, and learn Aperture Data Studio. Register for free to join in with discussions.
Welcome! Find out how to get the most from The Community.
This is the place to ask a question or to start a discussion.
Get help and keep learning and expanding your knowledge.
Find out about new features, download the latest releases, and read case studies.
Find out what's coming up, suggest ideas, and take part in exciting research with us.
Hi all, I hope you have had a great start to the week. Thank you to everyone who has signed up as a Product Advisor; your contribution is invaluable to us. The community of Advisors has grown massively from 20 to over 120 members in just over a year, but we are always striving to further diversify the opinions and voices…
A user recently asked about connecting Data Studio to their AWS RDS MySQL Database. The first thing to note is that MySQL on RDS uses the MySQL community edition, which is not supported by Data Studio's native JDBC driver. When attempting to connect, you'll receive this error: "Connections to MySQL Community Server are not…
This in-person event will offer valuable insights from industry leaders, networking opportunity, and key takeaways from our recent Data Governance Survey, featuring THE Data Governance Coach – Nicola Askham! Here's what you can look forward to: Expert insights from Coman Wakefield, CTO of Experian Data Quality Industry…
This will be a special User Group event for us as we have an opportunity to share a real milestone in our product innovation. Our ‘new’ Aperture Data Studio is ready, and we’d love to have the opportunity to celebrate the enhanced capabilities together! We know you love data – by coming along you can exchange with your…
Hi, I have a requirement where I receive a csv file with postcode(no other address fields is provided), and I need to do the below 1. Mention if the postcode is Valid and compliant as per Address GBR data 2. Standardize raw postcode value to UK postcode format 3. Specify the reason for UK postcode being…
What problem are you facing? It looks like the Sessions and Events endpoints have an internally configured maximum number of records to return, which is set to 100k. This would be in place to prevent the API response from getting too large, but paging of the response would seem to be a better solution. What impact does…
Hi, just upgraded to version 2.14.12.195 and noticed something in the 'Export' step. If I export to CSV, Excel etc. and my file name is split with a full stop, the extension is suppressed. For example file name "FILEOUTPUT" gives me" FILEOUTPUT.XLSX" but "FILE.OUTPUT" does not add the .XLSX extension. I noticed because…
I am not able to access the Session API from Swagger, it showing me 401 as response code. We have Aperture as external system we are not able to fetch the records from Session but able to get the other metadata information. I checked in Progress data direct response code for Session are 401 there as well and even in…
I am in Aperture Version 2.8.8.27 I am trying to get connected to Googlesheet thru BigQuery. BigQuery is set up with link to Googlesheet and connection to BigQuery from Aperture seems to work ok. External system Connection is OK, using Service Account with .jason Private Key File. But when I try to add dataset in aperture…
What problem are you facing? As a Find duplicates user I want to be able to manually evaluate and change clusters of records where I think the rules have matched records incorrectly e.g. I've got a husband and wife in my data, both called M. Smith and they share the same postal address, email address and loyalty card…
We had a recent scenario where 1k jobs were sent to the queue, which did flag up a couple of UI/UX suggestions for the 'Jobs' page: Is it possible to multi-select to cancel jobs? We could only see the option to delete one job at a time in the queue? I.e. would be good to be able to select all jobs, multiple jobs or single…
has the process changed to update ssl cert on newer version? previously i used to do this, and hit save, now i see this, and does the section for public certificate needs to be empty? you guidance will be really appreciated, as our cert is expiring in 1 month or so on our dev server. Br, HS
What problem are you facing? When exporting data to Excel, I like to have each worksheet named according to the function or type of data being presented. To do this, the prior step must be named and that gets passed to the export step. However, if the workflow is changed and new steps are added prior to the export, the…
Hi, I thought I had this set up correctly, but testing reveals otherwise. I have a reusable workflow that is set up to send data passed to it to an external destination (as an Excel file). However, I only want to run this when the data being fed has rows. The reusable workflow is fine when used in a workflow - it uses the…
