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 Dashboards can be configured by adding, ordering and resizing different widgets including Views and Charts. One of these widgets is the Custom content widget: Firstly drag the Custom content widget onto your Dashboard. Next add some text that your colleagues will find useful: Add style 🕶 To make this…
What problem are you facing? I would like to include metadata in the export step (specifically in the JDBC option) that includes metadata for the target system and table (e.g. tablename, DBMS system, credentials used etc.) as this would help users / DBAs to debug/resolve any issues or be included in a point-in-time audit…
Hi, Was hoping fellow-customers or Experian staff would be able to give their experiences with this one. Wanting to update data in the DB directly using Aperture (thru the Export step - JDBC), but the DBA wants updates done via SQL scripting (is hesitant to use Aperture). I am pushing for Aperture as it is a controlled,…
Data is available from Aperture via the REST API that is not available in Aperture. Full details of Spaces, User Groups, Users, Jobs, Datasets etc. We would like to use Aperture to manage Aperture. For example: An automated workflow which checks for long running jobs and notifies us of issues; a regular review of user…
Hi, We are using Experian Aperture Data Studio version 2.14.14.40 and have changed the settings to accept csv delimiter to pipe (|) But there is a requirement to delimit csv files based on runtime configurations. Is there a way to define the delimiter in the export step while writing datasets as csv likely from a parameter?
What problem are you facing? The option to select what type of Line ending that should be applied to an export What impact does this problem have on you/your business? Different clients have requests on the specific file format they want depending on how they load these files. There are some that request their files with…
What problem are you facing? gzip(.gz) compression method option not available when adding of compressed datasets and in the export step for compress or compress and encrypt. What impact does this problem have on you/your business? Most internal and clients files are compressed using .gz. This is has been the case for…
It would be so helpful if Issue lists could be used as a data source for charts and indexes. For example, I have a nice donut chart of my issues (includes custom status) that I share with a customer in a dashboard. Currently, I have to send the issue list data to a dataset and then let the chart use that dataset for the…
Waiting to get an external system set up to allow updates via JDBC - in the meantime, if I select mode = UPDATE in the export step, does a full SQL statement get generated (to allow our DBAs to verify and QA the process). Thanks
Hi, I am starting a data migration/cleansing project and as each entity is analyzed and validated with data quality rules, any failing rows are sent to an issue list. That issue list is then shared with business leads to determine best approaches to fixing the data. There will be approx. 70 entities that we will working…
Hello, How can we connect to Snowflake external system with OAuth 2.0 authentication method? Thank you
