The place for most Aperture Data Studio discussion
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.
I'd like to share some progress we're making with Data Stewardship or as we're calling it, "Cluster refinement" for data matching within Aperture Data Studio. We've been told by a few of you that it would be a very useful capability. The original post on the community ideas board can be read here. The improvements we're…
We're experiencing a problem when trying to share Views. Specifically, when selecting Spaces for sharing, we receive the following error message: Has anyone else come across this? Any insights on what might be causing it or how to resolve it?
Hi everyone, In this post I'd like to provide you all with a sneak peak of a new real-time data quality enforcement offering that we're currently exploring, that we'd love to get your feedback on (complementing our existing contact data validation products). The idea centres around exposing Data Studio functionality (e.g.…
For our customers on the Aperture Data Studio Hosted and Managed Service: The maintenance schedule is now available on the Community site at this section. There is also an option to subscribe to maintenance status updates at the Experian Data Quality status page.
We've successfully configured an external system using Connection type: JDBC and DBMS: Apache Hive 6.0. I’m looking for guidance on how to set up a Schema-Flexible configuration. Specifically: Is it possible to use Schema-Flexible JDBC connections to support workflows that export data to multiple schemas? For example,…
Hi, I have a validation step that performs a 'Contains Match' on a lookup table (I am checking FK integrity). The workflow is set to 'Refresh Sources' however this does not apply to the lookup table. (I noticed due to failed rows). What is the recommended best practice here? Thanks
i have some date columns in my table (like below example). Just done profiling on those columns it recognizes their datatype as alphanumeric instead of date. after profiling i just right click and seen the values, there it shows as Date datatype all rows have date only in MM/DD/YY format because of this i am getting wrong…
I am not sure how to apply distinct count as aggregation while do group by ? There is check box "distinct", even though i enable that still does not give distinct count. Can someone help me to apply distinct count as aggregation in group by
Recently we upgraded to experian 3.1, and i would like to try Workflow Scripting (preview). But i unable to find those feature. Can anyone please help me with this?
Hi, When using the dataset API, the value for "Enableddropzone" is FALSE even though the dataset is set up for "Enable external system dropzone". Does the API only show "Enable server dropzone"? Thanks
i have created the workflow(Let say workflow_1 with source as dataset_1) and make it as reusable. created another workflow(Let say wrokflow_2 as parent workflow) with workflow_1 as child workflow and changed the source as dataset_2. dataset_1 & dataset_2 are exactly same, the only difference is that the dataset_1 has one…
Hi, This is one of the error messages. In some cases there is no error message in the log file although no rows have been imported. "Caused by: com.experian.aperturedatastudio.jdbc.sforce.phoenix.sql.ae: Socket Error: Read timed out Caused by: java.net.SocketTimeoutException: Read timed out" Do you know what can cause…
Hello, How can we connect to Snowflake external system with OAuth 2.0 authentication method? Thank you
Hi DQ Community, I wanted to share some insights into the powerful custom workflow step for ABN (Australian Business Number Validation) within Experian’s Aperture Data Studio. Built using our SDK, this workflow step enables users to validate ABNs with a real-time API lookup against the ABR database. It not only confirms…