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
-
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...(Image) (Image) 🥂 our developers have been hard at work and we are stoked about this new release. P…
-
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…
-
Quick Poll: Do you have a paid certification for a software product?Certifications seem like are a great way to demonstrate that you have the experience and technical …
-
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 …
-
Connecting to a SAP HANA database using Data StudioFrom the Data Studio v1.6.1 release onwards, we've made it easier to connect to a SAP HANA database…
-
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: (Image) (Thanks @…
-
XML driver for ApertureHi, Does anybody on the forum know if it is possible to read semi-structured XML data into Aperture…
-
SnowflakeWe have been experimenting with Snowflake technology and were wondering whether anybody has experie…
-
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…
-
Ensuring you always return the same duplicate ID with Find DuplicatesFind Duplicates returns consistent Cluster ID after each run. Consistency here applies to the seque…
-
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 clustering(File) (File) Find Duplicates will use fuzzy matching to link records, however, in some cases you m…
-
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…