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 our beta program.
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…
Data Studio uses a JDBC driver to connect to Salesforce, allowing data to be extracted, transformed, validated, and then optionally pushed back to source. As well as standard username / password authentication, the driver supports OAuth 2.0 authentication when establishing a connection. The following guide is a brief…
Hi admin, i have aperture data studio ver 1.5 server and license exp on 13 feb 2025 , the problem is when server date is actual date/current date, the service running about 1 minute and stop suddenly. for example if today is 5 oct 2024 and date server is same the service stop, and if date server changed to 25 oct 2024 the…
Is there any documentation available where it tells about how secure is Aperture in terms of handling the data. We might need to provide this document to one of our internal team as we try to access that source system's data through aperture
Hi, is there a way to see all the comments that have been added to an issue list? Also, can comments only be updated manually? Thanks
Hi I have full addresses split by ; that I want to split out into new rows ready for the Address Validate step. An example of the data layout ... "Address1 Address2 Address3 Town County Postcode;Address1 Address2 Address3 Town County Postcode" This should become two rows "Address1 Address2 Address3 Town County Postcode"…
What problem are you facing? For charts, if I only want to list the last N batches, I have to create a whole new process to create a new dataset. What impact does this problem have on you/your business? Extra maintenance and resources Do you have any existing workarounds? If so, please describe those. Use workflow to…
Hi, if i wanted to create a chart that graphs data quality over time, but I only wanted to display the latest 10 batches from a dataset, what are my options for this? I was thinking that a workflow would use the original file as a source, and I would specify 10 batches, and that would output to a dataset (single batch…
Is there a way to bulk update/set an option to add the Source name to all columns, rather than just the _1 on the second source? For example, if Source1 and Source2 both have an ID column, then columns would be named Source1.ID and Source2.ID, rather than ID and ID_1 which is ambiguous outside of the workflow.
You can easily get your data from Data Studio into Excel or Tableau using OData. OData (odata.org) is “an open protocol that allows the consumption of data via a simple and standard RESTful API”. If you choose to turn on OData in Data Studio (v2.2.3), you will be able to link your datasets (including snapshots) to any BI…
We would love you to join us for our next Data Management User Group taking place on 12 November 2024 between 10:00am – 3:00pm at our offices in Cardinal Place, Victoria, London. Join us for a day of networking, in person to hear from industry experts about what’s happening in the world of Data, AI along with real-life…
Hi there, I am having trouble with some date data. ADS is not recognizing the dates that comes from Azure Data Lake. Is that anyway to change that?
Hello I have a user case that requires migrating Salesforce objects that contain attachments such as HTML Body, PDF's, Word, Excel and jpg's attachments to another instance of Salesforce. These are normally stored as a VARBINARY(MAX) in a MS SQL database and I think would be a Blob in SQL Lite. Given these data types are…
Join us for a day of networking, in person to hear from industry experts about what’s happening in the world of Data, AI along with real-life case studies on successful data transformation initiatives. We are offering this session in person only so that you have the opportunity to be part of a community that will drive…
