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.
Snowflake is a popular cloud-based data warehouse that is used by many organizations to store, process, and analyze large volumes of diverse data. Connecting Snowflake to Aperture Data Studio Aperture Data Studio can import data and metadata from file stores, CRMs and databases, including Snowflake. To connect to Snowflake…
Did you know Aperture Data Studio supports Markdown? This lesser-known feature can transform how you present information, making your dashboards, workflows, and catalog entries more engaging and easier to read. Markdown enables a wide range of formatting options, including: Text formatting (headers, subheaders, bold,…
Hi, We've got a dataset we're trying to pull into Power BI via OData connection - with no luck. It has around ~3.5mil records and the same dashboard successfully pulls smaller sets (and pulled this before a latest batch was added), but after a long time, we get the below: Is there any configuration on the Aperture…
When exploring data, there is an option to download data. When performing analysis, it would be helpful to have an option that is 'Send to Snapshot'. Currently have to download data and then upload into a dataset, whereas this approach would be easier.
We now have the new phonetic comparators (Soundex, NYSIIS and Double Metaphone) for Find Duplicates that you can use to supplement the edit distance comparators (Levenshtein, JaroWinkler) for better match results. Why the need to supplement the edit distance comparators? Edit distance algorithms count the number of steps…
From the Data Studio v1.6.1 release onwards, we've made it easier to connect to a SAP HANA database directly from Data Studio. With the SAP HANA JDBC connection you can load in data from HANA to Data Studio, or export back. First, you'll need to locate the SAP HANA driver. The driver (ngdbc.jar) is installed as part of the…
Hi, I've created a custom model for Autonomous REST API by using Progress DataDirect and uploads are working for multiple endpoints but we have noticed that rows are missing for some endpoints. Testing via Bruno gives an error message at the end of json file: ""error": { "message": "Transaction cancelled: maximum execution…
We have hosted Aperture data Studio in a EC2 instance and now we want to load data from other external S3 which is hosted in a different AWS account. is there a reference document to follow on how to achieve this?
Hi, I currently have a number of schedules and automations running in order to run some sequential steps in a find duplicate process. I have an initial schedule that refreshes data and then an automation that detects the datasets are refreshed and kicks off a workflow that validates that the date stamp on the data is…
Hi all, Is it possible to connect an Oracle database to Aperture without a hostname? We would like to connect to a database with the TNS hostname but I’m not sure if this is possible.
Hi everyone, Happy New Year! 🎉 I wanted to share a quick tip that came up in a recent discussion around BCBS 239 compliance and data quality checks in Aperture Data Studio. Specifically, how to handle Uniqueness and Referential Integrity validations. Context When working with BCBS 239 or similar regulatory frameworks,…
Hi There, We have renewed the Server Certificate and need to add the same to Aperture Data Studio. Do we need to store the .pfx file in server or in client machine to save the details in Settings → Communication . I tried to add the file location from my machine and as well as server location. both shows error "Cannot find…
Hi All, I’d like to ask whether Aperture is capable of directly connecting to OpenText Content Server, without requiring any middleware or intermediate systems (such as Talend or external scripts). Is there a native connector or export integration available for pushing data directly from Aperture into Content Server?…
