Datasets

Discussion List

• 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, wha…

  Answered 21 views 2 comments 0 points Most recent by Henry Simms October 24General
• 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…

  Answered ✓ 58 views 6 comments 0 points Most recent by James T Sidebotham October 21General
• 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…

  Answered ✓ 17 views 1 comment 0 points Most recent by Henry Simms September 9General
• 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…

  Answered ✓ 44 views 3 comments 0 points Most recent by Josh Boxer September 4General
• Automatic Deletion of Dataset

  Hi, Is there a way we can delete the data in the dataset by setting up some Process? For example ru…

  Answered 40 views 2 comments 0 points Most recent by Mahulima July 8General
• User Information in Dataset get API

  Is it possible to get the User Information, ex, who used or created the dataset that Information or…

  Answered 43 views 4 comments 0 points Most recent by Henry Simms June 7General
• Data Discrepancy Comparison Post-Migration

  Does Aperture have an functionality that compares two datasets and highlights any discrepancies bet…

  Answered ✓ 66 views 7 comments 0 points Most recent by Josh Boxer May 31General
• Refresh dataset notification

  Hello dear community, my use case is: we refresh more that 200 dataset ( from SAP source) in the s…

  Answered ✓ 126 views 3 comments 1 point Most recent by Henry Simms February 26General
• Business Validation and Enrichment

  Aperture is a powerful tool when validating business information you already have. We can leverage …

  57 views 1 comment 4 points Most recent by Danny Roden January 25Tips and tricks
• SalesForce refresh failed to process query: INVALID_FIELD

  We have scheduled refresh Jobs to refresh the Tables on daily basis. The Wfs are getting the status…

  152 views 17 comments 0 points Most recent by Josh Boxer August 2023General
• Handling data from Experian Aperture Data Studio jobs

  We are getting error in the execution of Experian scheduled jobs as "There is not enough spac…

  Answered ✓ 35 views 2 comments 0 points Most recent by Josh Boxer August 2023General
• Copy of FiServ Files uploaded into DA & use of the Metro2 Parser

  Does anyone use Data Arc with a copy of a FiServ Metro2 File? We are setting this up as net new an…

  Answered 86 views 6 comments 0 points Most recent by Josh Boxer July 2023General
• 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…

  Answered 51 views 4 comments 0 points Most recent by Shreya July 2023General
• 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 D…

  Answered ✓ 73 views 2 comments 0 points Most recent by Shreya May 2023General
• 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 …

  Answered 54 views 3 comments 0 points Most recent by Shreya May 2023General
• Can we create a Dropzone folder where we can use multiple files?

  Currently we can create One folder Per Dataset where I can use only one file to be uploaded. Can we…

  Answered 42 views 1 comment 0 points Most recent by Josh Boxer April 2023General
• How to delete Duplicate external systems and tag dataset with the actual one

  How to delete Duplicate external systems in a space and then tag datasets that belongs to that exte…

  Answered ✓ 34 views 4 comments 0 points Most recent by Mahulima November 2022General
• Snowflake Issues with Dataset Creation

  We have deployed the proper snowflake drivers and have successfully connected to a hosted warehouse…

  Answered 147 views 7 comments 0 points Most recent by George Brown November 2022General
• Incrementally Loading Datasets

  I've thought through a few different ways that I can use to incrementally load a dataset using batc…

  Answered 49 views 3 comments 0 points Most recent by Henry Simms September 2022General
• Datasets not refreshing automatically

  Hi, We built an integrated set of schedules and workflows that allows data from existent datasets t…

  Answered 44 views 2 comments 0 points Most recent by Josh Boxer August 2022General
• Does Aperture have the "treat leading zeros as alphanumeric" option that Pandora had

  One a a global setting that instructed Pandora to treat any input field with leading zeros as alph…

  Answered ✓ 77 views 2 comments 0 points Most recent by Charles Thomas August 2022General
• Configuration of a dropzone

  Hi, We are working on the plan for integrating an application and Aperture. The latest was that a …

  Answered ✓ 41 views 2 comments 1 point Most recent by Marco_13112001 August 2022General
• SAP Views as Datasets

  Has anyone used SAP views as a datasets? I have a strange situation where SAP View can be defined t…

  Answered ✓ 33 views 5 comments 0 points Most recent by George_Stephen June 2022General
• Issue with dates being read as American dates

  I am pulling in my source data with a column that contains dates of the format dd/mm/yyyy. When ann…

  Answered 58 views 5 comments 0 points Most recent by Henry Simms January 2022General
• Drop zone configuration in server.properties

  Hi Team, Can we configure customize datadropzone folder at different shared location same as export…

  Answered 154 views 9 comments 0 points Most recent by Slimani November 2021General
• 🎞 A Short Feature Demo on dataset management in Data Studio

  25 views 0 comments 0 points Started by Clinton Jones July 2021 Tips and tricks
• Profiling Data for the first time and changing the underlying data

  This short video illustrates the ease with which you can define a dataset, profile the data to dyna…

  36 views 0 comments 0 points Started by Clinton Jones August 2020 General
• 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 proce…

  201 views 1 comment 2 points Most recent by Henry Simms July 2020General