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, 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…
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…
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…
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
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?…
