Aperture Data Studio allows you to:

  • Get started quickly with an easy installation and an intuitive browser-based interface
  • Save time and money by creating operational data quality workflows
  • Improve transparency with audit reports
  • Increase efficiency of your data migrations
  • Standardise and improve quality of your data with powerful data transformations
  • Encourage collaboration with reusable workflows

To get started, see an overview of the functionality or try out use cases.

Functionality overview

  1. Upload your data using the Data Explorer. You can either:

    • upload your source files: right-click on My files > Upload file or
    • connect to your database using a JDBC driver: Data sources > Click here to create a new data source.
  2. Preview, configure and tag your data.
    Preview the first 1,000 rows and check that your data is in order. If required, make changes: right-click on your file/data source and select Preview and configure.
    You can move, rename and exclude column headings and change character sets/delimiters/quotation marks. Click Apply in the top-right corner when you're happy with the changes. The file will now appear as Configured.

  3. Load and explore your data.
    Right-click on it and select View data. The previewed file will now appear as Loaded. To profile the data once the file is loaded, click View Profile/Outliers. It will appear as Profiled.

    You can now understand your data: filter, sort, view the outliers and discover inconsistencies. Ensure the loading has completed before you start manipulating the data.

  1. Create workflows. In the Workflow Designer, click Create a new workflow, name it and click Submit. Add your loaded file(s) and open the Workflow steps tab to manipulate your data as required in order to:
    • create a new and improved version of your data,
    • structure and prepare it for migration,
    • validate against user defined rules,
    • find matching/duplicated values,
    • cleanse records and more.
  2. Report/export your data.
    In the Workflow Designer, you can create a .pdf report for each workflow: click Report in the top menu.
    You can also save the workflow output as a .csv, .txt, .xls, .xml, .dat, or a .json file by clicking Execute in the top menu. To re-use a workflow, save it as a .wfl file by clicking Export in the top menu.