Experian Data Quality Community

Learn, collaborate and solve problems with like-minded data quality enthusiasts.

Sneak peak of new data quality offering: Let us know what you think
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.…
Customizing your Dashboard with the Custom content widget
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…
Connecting to an Amazon RDS MySQL Database
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…
🔔 Follow what you're interested in
When you navigate into any of our categories you will see a Follow button in the sidebar. This will allow you to subscribe to getting email notifications and notifications in the community about that topic. So for example if you want to be notified of new releases, navigate to the release and downloads section and click…
Case statements in Aperture Data Studio V2
Hi everyone, I’m looking to convert a SQL query in Aperture, which contains multiple CASE statements for a single column in the dataset. I’m looking for the best practices to achieve this efficiently and clearly. The column I’m working with contains various conditions that need to be evaluated. Could anyone share their…
Lookup or Joiner using Contains in the Match
Is it possible to do below check I have this in one channel Want to check and populate 'Issue Pending' column value from other channel where it has comma separated values
Kill Dataset refresh job via API
hi, I am performing bulk data profiling on datasets using API automation where my steps are as below list all datasets to be data profiled in a csv file process csv for each row trigger dataset refresh and capture job id wait for job to get completed or for max 30 mins. if time elapsed is more than 30 mins then skip next…
To be able to use groups and group permissions when using SAML and LDAP
What problem are you facing? Administrators are currently having to add individual users. This is a pain when a customer has more than 10 users to add. What impact does this problem have on you/your business? Not user friendly and time consuming to add users. Do you have any existing workarounds? If so, please describe…
Unable to connect Amazon redshift database
We are trying to connect Amazon redshift database from aperture, and we are getting the below error while trying to connect. Failure com.experian.aperturedatastudio.redshift.jdbc.base.fv: [ApertureDataStudio][Redshift JDBC Driver]Error establishing socket to host and port:…
Include Metadata in the Export step
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…
Updating Data via Aperture vs SQL
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,…
Aperture REST API calls as Datasets within Aperture
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…
Delimited csv file creation using Export step
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?
Configuration of Line Endings in Export Step
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…
Adding gzip Compression Method
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…
Issue list as a source for charts & indexes?
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…
Exporting to External System using JDBC
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
Issue list best practices
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…
connect to Snowflake external system with OAuth 2.0 authentication method
Hello, How can we connect to Snowflake external system with OAuth 2.0 authentication method? Thank you
Suggest Validation rules - Validate step
Aperture Data Studio has a Validate workflow step that allows you to define rules of how data in specific columns should be populated. This information can then be used to be alerted to any data quality problems or to track data quality improvements over time. These rules can be simple: should not be null should be a…
Performance
We have just stood up a new server that is the same spec as our old server but has a slightly new version of ADS but workflows are taking 5 to 10 times longer to run, does anyone have experience in tuning ADS?
Best practices designing complex Workflows
A Workflow is a sequence of steps that defines a process to transform and manipulate your data. When a single Workflow tries to tackle too many actions it can become difficult to read, understand and manage: If you are designing a Workflow alone this might be fine, but if you are collaborating or planning to have others…
UX Improvement - Output label case sensitive
What problem are you facing? The Workflow step output names/labels are being all converted to lower case when the reusable workflow is added inside another workflow. What impact does this problem have on you/your business? It makes it more difficult to distinguish between outputs, especially when there are several, which…
Native Function: Is Web URL
Hi, I am using the above function and the result for checking this site "www.californianotary.academy" comes back as bad, even though it can be accessed in a browser. Does that function expect something like ".com" rather than ".academy"?
Update Issues once Resolved?
Hi, is it possible to update an issue once it has moved to 'Resolved'? For example, a set of data gets manually updated, and after resolution we want to reflect that via the 'External ID' (e.g. a ticket number). Thanks
Adding an Owner to my business rules
Submitted on behalf of a customer. We have created many different validation rules to monitor the quality of different datasets over time. It would be useful to denote who is the owner of a specific rule in case changes need to be made in future.
Automated date in output
I wonder if there is any way of setting up in an automation the Take Snapshot step with the date information on it. Like for example: ADSExtrac_20241113.csv
Suggested approaches for manipulating JSON values
My data includes a column containing JSON values - I've made a dummy example below: Example JSON value: { "magenta": "#f0f", "yellow": "#ff0", "black": "#000", "usageList": [ "giraffe", "lion", "axolotl" ], "properties": { "cost": 99, "difficulty": { "part_a": "hard", "part_b": "easy" } } } I have a couple of requirements:…
Is it Possible Integration with with NETCONF Protocol ?
Can Aperture Data Studio integrate with device configuration system with NETCONF Protocol
Sorting an Issue list results in fewer rows
hi, So I have a workflow that I use an 'Issue list' as my source - the issue list has 29 rows. If I add a step to sort on the 'Failed Rows' column, my output for that is now 22 rows. No other filtering going on. Tried it on 2 different issues with the same result. However, if I remove the sort on the 'Failed Rows' column I…
Looping workflows
About the requirement Recently I’ve been asked a couple of times if it’s possible to cycle through a workflow for every value within a given column. This is mainly to drive 2x types of use case: Dynamic data export – effectively taking an input dataset and splitting it out into a separate file for each subset of data (as…
Adding Microsoft SQL Server to an ADS server
Has anybody got any experience in having Microsoft SQL Server and data tools installed on the same server as ADS is installed on which uses SQL Lite, we were wondering if they would interfere with each other?
Is it possible to configure which events are included in the audit report?
There would be a need to get some more events included in the audit report, is that possible to be configured by the administrator?
Your API key < API key name > will expire in 10 days'
can u help me set up this? i cannot find the right directives in below documentation. i need to know via email, before api keys expire. Br, HS i want to know before hand, @Henry Simms @Ian Hayden , @Josh Boxer https://docs.experianaperture.io/data-quality/aperture-data-studio-v2/monitor-data-and-troubleshoot/
Support for VARBINARY(MAX) field type in ADS
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…
Best approach for this set-up?
Hi, Any recommendations for this configuration? Lets say I have a space called 'PROD-DQR' that is used to access production data with a read-only credential to the source DB. It validates data, sends to issues etc. Only DBAs are allowed to perform updates in production, so was thinking: New spaced called 'PROD-UPDATE' that…
Rule Question (DataArc360)
Hello, Can someone help me understand a rule and why certain criteria is listed? Rule name- The DOFD is more recent than normal on a derogatory account Why did they select those Account Statuses? For instance, Account Status 95 can be reported if an individual is not 120 late since the member is voluntarily surrendering…
How to resolve "No space left on device" errors
Hello, In the last few days we have been encountering the "An unexpected error has occurred during Workflow execution: 9003: An unexpected error has occurred during Workflow execution. No space left on device" error. We have gone through our installation and removed a lot of datasets that we no longer need which should…
Dynamic Reports in workflow - if x then do, if y then do something else
Hi all I'm new to Aperture and have just built a report in a workflow. It looks good and I am happy with the tables that I have pulled through. My report shows a summary of all of the checks and then I have an individual table showing the failing rows for each of the rules. Of course, sometimes, I have a rule that doesn't…
Data Studio Salesforce Connection
Connecting Data Studio directly to your data sources and CRM systems, like Salesforce, has never been easier. This video is to remind and inform users, just how easily two systems can work in harmony, without any complex development. We've created out of the box connectors, for a wide range of common platforms, to make…
Annotate Columns
Hi, is there a quick/easy way to mass update when performing 'Annotate columns'? I want to add tags not based on the data contents, but on security definitions. E.g. Some columns could be PUBLIC, some could be CONFIDENTIAL. Thanks
Experian Aperture Data Studio Report View
Hello. new to the tools trying to figure things out. Making progress, I've created several workflows successfully, and created datasets using snapshot, and used those datasets in other workflows and views. My question concerns Report View In Workflows. I've found very little documentation on this. I added a Report to the…
Data Studio certified to run on Azure Stack HCL or Nutanix?
Is Experian Data Studio application certified to run on Azure Stack HCI (Azure's version of VMware) and/or Nutanix?
Unable to connect Find dupliactes on new server
Hi team, We have recently installed the aperture Data studio application recently on our new pre-production server and we are unable to connect find duplicate server due to the below error. Please help us to this issue 2024-11-04 00:05:32 205 WARN c.e.d.m.MatchServiceManager [MatchLicenseMonitor] Unable to connect to Find…
Do you have a need for Pivot/Unpivot steps?
As part of our product discovery activities, we would like to find out if any of our clients have a use case for pivoting or unpivoting data. If you do, we'd like to hear about it. Please leave us a message and we'll get in touch.
OAuth 2.0 authentication method with Snowflake
What problem are you facing? How can we connect to Snowflake external system with OAuth 2.0 authentication method? What impact does this problem have on you/your business? We cannot develop new functionalities. Do you have any existing workarounds? If so, please describe those. We can connect through a user ID / password…
UX improvement - connecting Workflow steps
Submitting on behalf of a user: What problem are you facing? Sometimes it can be a bit tricky connecting two workflow steps that have ended up far apart. What impact does this problem have on you/your business? It's a bit fiddly and slightly more time consuming. Do you have any existing workarounds? If so, please describe…
Fuzzy Matching Logic
Hi, I have a requirement to match records from two separate systems on the basis of FirstName, LastName and DOB from System1 and FisrtName, MiddleName, LastName and DOB from System2 to return the match Id from System2 to System1. Below are the challenges The names are not consistent in both systems . For eg in system1 for…
Export Data Object to external systems
Submitting on behalf of a client: What problem are you facing? Cannot export the new data objects to external systems, re-work of re-tagging is time consuming. What impact does this problem have on you/your business? Time consuming and need to match the object tags back to the relevant CDE's Do you have any existing…
Validate address data dictionary?
Hi, started looking at 'Validate Address' step and cannot find a data dictionary for the returned fields. For example, AddressAction I see 0 & 3 and Street Non-trivially Corrected I see blanks, 0, 1. Any pointers would be great, thanks
Automations and notifications.
if I want to trigger automation if any workflow failed in that space. is that true for that case as well. I was going through some documentation. Data Quality user documentation | Automations and notifications so here i would want the same for workflow failure. any workflow fails in that space, i want the event to trigger…
Any Function to check the one field in Present in the List of the fields?
For example I have a column where I have Value like this If I use function contains then I am getting this true for all of the above scenario, but I want only row 1 should be true and rest should be false when the entire string is not matching. Can this be done?
Turn a field storing a list into rows?
Hi, is it possible to turn a list stored in a column into rows? For example: ID COL 1 AA,BB,CC 2 XX,YY,ZZ Becomes 1 AA 1 BB 1 CC 2 XX 2 YY 2 ZZ Thanks
Unable to restart the Aperture services
Hi team, Suddenly the aperture data studio application is connecting. We tried to restart the services and the services are still stopping .we are unable to restart the services. Can you please help us to resolve this issue ASAP .
Dropzone
Hi there, How do add columns on a dropzone file? The columns have been added in the source file but it's not reflecting on the dropzone file in aperture. How do I fix this? I have tried adding a new external system but it doesn't work. Many thanks, Mariana
Network error
I am trying to create a development environment to test some changes but when I try to import anything to it, gives me this network error message. Any ideas on what the problem is? I am connected with the VPN, already checked that! TIA, Mariana
Best practice for checking that Datasets have been refreshed
A user asked this question: We have hundreds of datasets we need to refresh before a migration, what is the best practice in ADS to make sure they have all been updated, without adding a source in a workflow for every dataset can you iterate through the desired datasets and look at the metadata to determine when it was…
What's the syntax for the Dataset "file pattern" text when loading from an SFTP dropzone?
I'm setting up a Dataset that automatically refreshes with data from files dropped into an External System dropzone (SFTP in this case). I only want to load specific files, determined by the file name. To do this, I was going to use the "Starts with file pattern" config option, but I couldn't find any information about the…
Prevent object tags from requiring a workflow to be re-published
What problem are you facing? I have applied the new Object Tags to various workflows. In each case the workflow status changed from Published to Draft when the Object Tag was saved. The tags can be bulk added but the workflows must then all be individually re-published and a comment added. What impact does this problem…
Application Theme?
Hi, Is there any config that can be changed to tweak the appearance of an environment to help differentiate between a development and production build. For example, I was thinking something along the lines of being able to select a different colour for the left menu or top bar may offer an obvious visual reminder. Thanks…
Where I can change Backup period start time?
Hi all, I found place where I can set backup time period. But nowhere are no mention how to determine exact start time of that period. So, our case I want that backups are made ones per day and time should be around 22.00 or near. This time is important because our server backups are running over a night. Now, it seems…
Inquiry Regarding Royal Mail Address Database Updates
Good afternoon, We are currently using the "Validate Addresses" step to check UPRNs. However, we have observed a significant number of addresses—where we already know the UPRN—that are returning empty during validation. Could you please confirm how frequently the Royal Mail address database is refreshed? Thank you for your…
find duplicate update row limitation
Is currently is there any limitation in the latest version ? I am getting error in my existing workflow . Please suggest where I need to change to set the limit
DDL for datasets before including in aperture.
Hi, Is it possible to see DDL of tables before adding those in datasets from external system? or Aperture does not have that kind of control. can i see DDL of tables before adding? or service_account wont have that control.? Br, HS @Ian Hayden , @Henry Simms
All Schedules information?
Hi, I'm looking for a way to be able to view details of all the Schedules that exist within our environment. I'm thinking details like space, schedule name, recurrence pattern and workflows ran by it. Is there a way to surface this information via API or otherwise? Thanks Mike
swagger UI for find-duplicates- error. after recent upgrade.
Hi, We are seeing this error after the latest upgrade. Upgrade done on our dev is as under.Upgraded to Aperture Data Studio to version 2.15.4 and Find Duplicates Service to version 3.11.3 @Ian Hayden , @Henry Simms , Kindly help and let us know what this is about. Services are UP, but we usually dont see this error when we…
unable to connect Aperture application
Hi Team Since yesterday, we were unable to connect Experian Dev server application due to the below issue. 2024-08-20 10:26:03,880 INFO c.e.o.o.CLITool [main] Executing '"C:\Program Files\Experian\Aperture Data Studio 2.14.10\oaserver\runtime\windows\64\admin\oacla" -nologo -dbg -d "C:\Program Files\Experian\Aperture Data…
Drop-down picklist instead of free text entry for re-usable workflows
What problem are you facing? Currently re-usable workflows allow a free text input option, which suggests most recent entries. The value entered will be used in processing within the workflow, often relating to fields/data to use for matching etc. This leaves risk of error, if the user enters a typo, which could result in…
Different date formats not being recognized as a date
What problem are you facing? Because the data is coming from many different sources the dates have different formats and when they are mixed up in one input it gets difficult to put them in the same format as they are not recognized as date datatype, so I would love to be able to just use the format date function and fix…
Workbench
Hi everyone, I am trying to analyse some blocking keys on the workbench but it keeps on this page forever. Is anyone else going through the same issue?
Importing data into Salesforce child objects
I have a user case to use out of the box functionality that come with Salesforce and is available in the Progress Driver to relate data in parent and child objects on import. In a Salesforce object you can designate a field as an external ID. When you load a child object such as Contact where the parent is Account and you…
Issue list - see comments?
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
Aperture Data Studio service suddenly stop
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…
Security related Documentation
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
Split a value into multiple rows
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"…
Ability to select specific last number of batches in charts
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…
Charts - last 10 batches
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…
Add Source to Column Names
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.
ℹ️ Importing your Datasets into Excel or Tableau using OData
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…
📣 Join us at our next User Group - 12th November 2024
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…
Date format
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?
📊 New chart types
With an increasing number of users now spending more and more time building (and then interacting with) charts and dashboards, there are a couple of additional requests I'm hearing cropping up relating to this so I'm posting them on here for discussion and to get the wider Community's thoughts. They are: Adding some new…
Invoking PowerShell script from Experian workflow/Schedule
Is there a way to invoke a PowerShell script from Experian Aperture Data studio using workflow or schedule? I am using the 2.14.14 version
Ingest data with API, check rules, send results back to source system
A Data Studio user raised the following questions: Is there any demo or material to show how can we configure Aperture ingest the json data with api service and check the data quality rules and response it back to the calling system again ?
Use REST APIs to automate processes
Data Studio now has over 100 REST APIs that allow information to be extracted or actions taken programmatically allowing processes run automatically with little intervention. APIs also enable integration with third party applications to make Aperture part of your broader business operations. Besides the additional APIs…
Rows to Columns
Hi, I have been testing out the Rows the Column function. However, it seems to be not pulling through all the columns. In the DEV data set, I currently have 62 rows which I would like converted to columns. When using the Rows the column, it automatically only finds around 56. Wondering if anyone else has had a similar…
Flattening out / Pivoting / Transforming results
Hi, I'm having an issue flattening out results. Essentially, I have multiple rows for the same customer because they have different PII's. Is there any way of transforming / pivoting / flattening out the results to have one row for each customer? I have left a screenshot of mock-up data below to help people understand. I…
Include Chart in notification?
Hi, is it possible to include a chart in a notification? Lets say I want to show progress on some cleansing over time, and the chart is sent at the end. Thanks
Compare Dates (Verbose) 📅📅
Compare Dates (Verbose) [Category: Conversion] This function provides a summary of how 2x input dates compare (and also includes simple 'convert to date' logic to aid the analysis). Output options are: Exact match Incomplete - Date 1 is missing (or not a date) Incomplete - Date 2 is missing (or not a date) Incomplete -…
REST API workflow Execution Error
hi, I have created a reusable workflow accepting 4 parameters with source configured as below "sources": [ { "stepExternalLabel": null, "canSupplySourceWhenExecuted": true, "mustBeSupplied": true, "allowAutoRefreshed": true } ] I am trying to execute the workflow using below request, but I am getting error for the…
Experian REST API for Dataset Creation
Hi, Can someone please help me with the JSON request to create a dataset using SQL query? Below are my dataset requirements a. Type : JDBC(SQL Server 6.0) b. Allow Refresh : True c. AllowBatchDeletion : False
Experian API call to Execute Workflow
hi, Can someone help me with the JSON request to invoke a workflow through REST API? Below are my workflow specification a. Workflow accepts workflow parameters b Workflow accepts source at execution and its mandatory to give source information.
How to capture log errors into a table if error occurred during execution of workflow or Schedules?
How to capture log errors into a table if error occurred during execution of workflow or Schedules
Aperature Data Studio Elearning
Hello how do you request access to the elearning? is there a cost? We are planning to use the product to maximum degree possible. this could come in handy in our learning process, especially if it includes videos/samples for the functions within. 403 App Not Assigned Sorry, you can't access Docebo-Production because you…
OUTPUT step in a workflow
Hello, rookie here again. I'm trying to understand the output step but the only thing I can find in documentation is below. When do you use an Output step? Where is the output located? how do you use the output step in another workflow, view, etc.? When a re-usable Workflow is using the Output step, the step's data will be…
ℹ How to use Functions in Workflows
Workflows Workflows is the area in Data Studio where designer users tend to spend most of their time. For anyone new to it, imagine a data pipeline that manipulates one or more data sources through a number of stages and then does something with the results. Whilst a Workflow is easy to build by connecting different steps…
📣 Join us at our next User Group - 9th November 2023 📅
I am pleased to confirm that our next User Group event for Aperture Data Studio users will take place on Thursday 9th November, 11am-3pm (UK-time). We will be running the event from our offices in London (near Victoria statioon) but will have a dial-in option for those who are unable to be there in person. Following on…
COMING SOON: Webinars
Subscribe to be the first to find out!
Error while invoking REST API from Experian Studio VM
Background Experian data Studio version - 2.14.14 SSL setup done on the data studio url and private CA is added to the trust store under E:\ApertureDataStudio\certificates\cacerts API Key genrerated with 365 days validity and able to invoke API via Swagger Issue While trying to invoke the CURL command from command prompt…
Having an issue managing too many objects
Submitted on behalf of a customer. Multiple active users collaborating in a Space have created many Workflows and Views etc. It is becoming difficult to quickly find the specific item that you are looking for sometimes needing to go in and out of a few things before finding the correct item. It would be good if the…
More detailed manuals/examples/syntax
Hello. I'm new to Experian Aperture Data Studio V2. I'm using the documents/help at the Data Quality User documentation site. I'll give you an example. I'm trying to use Get age to filter a dataset down to records with an effective date (one of our fields) to only the current year. The Get age tells me "Returns the number…
Accessing Azure KeyVault
I have stored my Azure SQL's connection string as a secret in the Azure KeyVault. I wanted to access this secret value while trying to create an External System.
♻ Reusable workflow example – calculate word frequency
Today I’d like to share with you a reusable workflow that I built a little while ago not only as a downloadable .dmx file (see below) for you to explore/use as you wish, but also as a means of demonstrating one of the key themes of Data Studio…reusability. If you find that there are duplicate tasks being executed on your…
Experian Aperture Data Studio REST API error
Hi, I am planning to automate dataset creation using Data studio REST API, however I am getting 401 Authorization Error. Background Experian data Studio version - 2.14.14 SSL setup done on the data studio url and private CA is added to the trust store under E:\ApertureDataStudio\certificates\cacerts Please see the steps…

Top contributors

Mahulima 266

James T Sidebotham 145

M.Lambert 119

Uma 79