Stuck with creating a Workflow or simply curious how Aperture Data Studio can help you? You’re in the right place! To get the most relevant answers, remember to tag your post with the version number (e.g. v1 or v2). Didn’t find what you’re looking for? Check out user documentation.
General discussion
Discussion List
-
Find Duplicates Language for Notepad++If you're using Notepad++ as your text editor, it can be helpful to have an interpreter to highligh…
-
Using a network path for the server import or export directoryIt may be desirable to have Data Studio v1 or v2 import and export data from a network path. This w…
-
Profiling all tables of a sourceHi team, Partner is using Aperture Data Studio to profile sources on client site - so that he can …
-
Data Views - an abstracted view of your data sourcesAn entirely new concept of data views based on datasets is introduced in V2.0. Views enable designe…
-
Handling Gmail email addresses for duplicate identificationThe problem: Gmail allows multiple e-mail addresses for a single account With over 1 billion active…
-
User Spaces - a way to organize your workAn entirely new concept of user spaces is introduced in V2.0. Spaces enable designers of workflows…
-
Environments - giving your Data Studio installation more flexibility with sandboxesOne of the characteristics of business-critical systems is that they need to be secured in such a w…
-
Democratizing and controlling data access in v2.0Data Studio v2.0 provides a sophisticated and secure architecture for exposing data to the enterpri…
-
Connecting to an SMTP email server that does not require authenticationData Studio lets you configure an SMTP server connection, which can then be used to send email noti…
-
Scheduling workflows using the Data Studio REST APIAperture Data Studio is intended to be invoked from third party schedulers , like Windows Task Sche…
-
Hello world...🥂 our developers have been hard at work and we are stoked about this new release. Prod your account…
-
Sample DataWe're looking to not deliver sample data with the installer for v2.0. Instead we are looking at usi…
-
Inferring Gender from Title or Honorific and Gender ReversalSometimes it might be useful to determine the gender of a person from their honorific, so for examp…
-
Impact of snapshots on memoryHi, I am using a job that has several input snapshots defined in it, though I only connect 2 of the…
-
Data Studio v1.6.2 is now available!This maintenance release resolves several issues caused when executing workflows using the REST API…
-
Creating a Blocking Key from more than one Generic StringI want to write my own blocking key, but the data I am working from has several field which are all…
-
Is it possible to 'pull' data from Aperture Data Studio into Excel?Hi, Whilst there is the option to export data from Data Studio into Excel, is it possible to pull d…
-
Is it possible to reuse the result dataset extracted from Datawarehouse?Scenario 1: Once the required dataset is taken from any Datwarehouse, how can we reuse it for analy…
-
Approach for Matching Product data (product description)Yesterday @MiteshKhatri @Akshay Davis @Katya Jermolina and I were having a discussion about approac…
-
Slow data loadMorning, Last night I created a sample data set that I am going to use to test our de-duplication m…
-
Custom date of birth - MatchingHi, As part of our matching process we break date of birth into day / month and year and then have …
-
How can we connect to a view in SQL Schema using JDBC connectionI am able to connect to table and see the columns using JDBC connection. How can I check the views …
-
Extracting the country from an unstructured address using a lookup list of countriesThe problem that you may need to solve is that you have data that is effectively a contiguous strin…
-
Accesing data from quick sense filesHi everyone, I'm new in data aperture and I have a client who calculates KPIs in a quick sense repo…
-
Cross-system and cross-table relationship discovery automationIn our customer cases data quality issues are often cross-system inconsistencies. Technically, cust…
-
Sequence countHi, I can't find a sequence count in Aperture - is there one planned in Version 2.x? Nige
-
Data Studio and MDMIt sometimes gets asked how we co-exist with an MDM system. We have many customers using Data Studi…
-
Use of SQL to refine source data prior to loading into ApertureHi, I was just wondering whether other users would find a Pandora-like feature to pre-filter prior …
-
Column Exceeds maximum allowed ?Anyone any ideas ? I was getting the problem on the postcode column so ran a length check and restr…
-
Availability of source file/table metadataHi, We are using Aperture to compare profile statistics from 2 tables from different SQL databases…
-
Purging LogsDoes anyone else see this in their logs ? Seems strange that the application is constantly purging.
-
Post Code improvementIf a UK postcode is listed in format AB123CD AB12CD A12CD How can I strip this out to a normalised …
-
Is UniqueI've had a few questions around checking if a value is unique in a column. Voila: (Thanks @Ian Thor…
-
XML driver for ApertureHi, Does anybody on the forum know if it is possible to read semi-structured XML data into Aperture…
-
Extracting a specific piece of information from an address using regular expressions and lookupsData Studio has several built-in functions to allow you parse strings of text and extract a particu…
-
Workflow comments and notesIs there any way to create and display comments or notes within a workflow? An example might be som…
-
How to trigger an e-mail notification if a job failsData Studio has a range of default notification options which allow you to send a custom email to d…
-
Checking data like social security numbers (SSN) for correctnessSocial Security Numbers, National Identity numbers and the like, on face value are simply strings o…
-
What are the limits of data loading in Data Studio?Back in June, I read an internal post by @Henry Simms that suggested that in test we had loaded 16…
-
Removing value (NULL) from Excel spreadsheetsHi, Quick question, can Aperture handle while loading a replace task for a specific set of values ?…
-
Checking data like social security numbers (SSN) for correctnessSocial Security Numbers, National Identity numbers and the like, on face value are simply strings o…
-
Sharing database connections across teamsWhat's the recommended approach to sharing tables/views and connections to databases across a wider…
-
Getting started with Regular Expressions in Data StudioA regular expression (from here on we’ll call them “regex” for short) is a well-known and powerful …
-
Tips to improve workflow performanceIf you ever find that a workflow is taking a long time to execute, you might want to think of ways …
-
Using a discriminant for Find Duplicates clusteringFind Duplicates will use fuzzy matching to link records, however, in some cases you may have a disc…
-
Data Studio v1.6.0 is now available!The latest version of Data Studio introduces new features, existing functionality enhancements, per…
-
Creating a new data connection to Salesforce from Data Studio via JDBCIt is likely that quite soon after you start to use Data Studio you will want to connect Data Studi…
-
Changing source file schemae and data definitionsLegacy system files often come without a schema or data definition embedded in the file, and if the…
-
JDBC Performance issues can simply be about securityIn Data Studio you have a number of different ways of accessing data. File Based methods Data conne…
-
Refresh your sourcesOccasionally you may find that the staged sources fall out of synch in how Data Studio renders them…