-
ℹ 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…
-
Group Step > Being able to select and right click view multiple rows in groups
What problem are you facing? When the Group step is used, we can only view rows in group on one value. What impact does this problem have on you/your business? Feedback received of this not being user friendly and having to exit the screen to be able to get to the multiple filtered values. Do you have any existing…
-
Error attempting to delete match store
Hi, In my project, we are using Experian Aperture Data Studio(2.10.10) to connect to a Remote Find Duplicate match store(3.8.15) over http. The Find Duplicate step is configured with the 'Clear and re-establish store' checked as part of our requirements. Majority of the time ,the process runs end to end successfully,…
-
Has anyone noticed varying results checking domain validity of same email list a day or 2 later?
-
Handling data from Experian Aperture Data Studio jobs
We are getting error in the execution of Experian scheduled jobs as "There is not enough space on the disk" We have installed the data from the Experian Aperture Data Studio on the E Drive (511 GB) out of which only 19 GB is remaining. Majority of the data is occupied in the E:\ApertureDataStudio\data\resource folder under…
-
Stored Procedure invoked from PostSQL of Export step is not processing all records
hi, In my workflow, I am connecting to SQL server 2012 using Custom JDBC jar (Microsoft JDBC Jar 12.2) and the connection string looks like below…
-
Error while connecting to Embedded Duplicate Store
Hi, I am getting error as below when I am trying to connect to the Embedded Duplicate store in my Data studio server(2.10.10). Please let me know if you have faced similar issue and help me with the steps to resolve this. PS: We do have a remote duplicate store(3.8.15) which is working fine and we have secured the Data…
-
Error while invoking stored procedure from Experian Aperture Data Studio using custom JDBC driver
Hi, I am using the Experian Aperture Data Studio (2.10.0.80) and have configured a custom JDBC Jar for adding Microsoft SQL Server Driver to query On premise SQL server(Microsoft SQL Server 2012 (SP4-GDR) (KB4532098) - 11.0.7493.4). With this driver, I am able to perform DML SQL queries like Select, Insert and Update.…
-
TLSv1 and TLSv1.1 protocols disabled by default in Data Studio
Towards the end of 2021, TLSv1 and TLSv1.1 protocols became disabled by default in Java 8, on which Aperture Data Studio is built. As a result, when you upgrade to a new version of Data Studio, if you are using Data Studio's packaged OpenJDK, you may find that some connections to External systems (e.g. JDBC) no longer…
-
📣 Join us in person at our next UKI Data Management User Group I 9th March 2023 📅
I am pleased to confirm that our next UK Data Management User Group will take place on Thursday 9 March 2023, 10.30am until 3pm London UK time, and if you are an Experian client based in the UK you can sign up today. This time we are excited to host the event at our newly refurbished offices in Cardinal Place, 80 Victoria…
-
Join us Online for our next Data Management User Group | 15 September 22 !
I am pleased to confirm that our next UK Data Management User Group will take place on Thursday 15 September 2022, 10.30am until 3pm London UK time, and if you are an Experian client based in the UK you can sign up today. We’re also excited to confirm that this will be our first hybrid session. The event will be hosted at…
-
Calculate the distance between two sets of co-ordinates 🌍️
Summary Returns the approximate distance in kilometres between a pair of geographical co-ordinates. Input latitude1, longitude1, latitude2, longitude2, output value is distance between each set of co-ordinates while considering the spherical nature of earth using the law of haversines. Example Buckingham Palace, London is…
-
Force workflow failure due to failing rows
Is there a way I can force a whole workflow to fail as a result of failing rows in a validation step(at desired tolerance level)? I want my workflow to stop and fail when I have a certain number of failing rows. I have email notifications set up with fire event to email me when I have failing rows but I also want the full…
-
Undo and Redo
In Aperture Data Studio Version 1, we had the Undo and Redo menu options while creating or editing Functions. This was however not available while creating or editing Workflows. In the earlier days of Version 2, while there was the concept of Actions that you can remove or apply easily within the View creation or grid…
-
Scheduling in Aperture Data Studio Version 1 vs Version 2
Many Aperture Data Studio customers process large volumes of data. Workflows are likely to be scheduled as overnight jobs or scheduled to be run over the weekends so that much of the waiting time happens outside the core business hours. There may also be a need to run multiple workflows, one after another automatically. In…
-
Fixed Width file parsing in Aperture Data Studio v1 versus v2
Fixed width files may be one of the common file formats that you have come across and need to process. You will often find that this would be more challenging as compared to a comma separated or Excel file. Here is an example of a small section in a layout to be submitted to the IRS (Internal Revenue Service) of the United…
-
The importance of profiling when using Find duplicates
When implementing Find duplicates in Aperture Data Studio we've seen many examples of the importance of profiling prior to configuring and running Find duplicates. This has the potential to benefit both the performance of the Find duplicates step as well as the quality of potential duplicates found. Find duplicates works…
-
Removing an unwanted intermittent string from the start of an alphanumeric field
At St. James’s Place we needed to remove a string, that occurred intermittently, from the start of an alphanumeric dataset. The “Trim” function didn’t quite meet our needs so we managed to achieve this by creating a new column in a “Transform” step as follows : “Replace” function, replacing the string that you are…
-
Fuzzy Matching logic
How does the fuzzy matching in the Find Duplicates step work?
-
Find Duplicates Step configuration
What is the difference between the Name, Household and Address/Location choices in the default Find Duplicates step?
