Is it possible to 'pull' data from Aperture Data Studio into Excel?


Whilst there is the option to export data from Data Studio into Excel, is it possible to pull data into Excel from Data Studio using an edit-bar drop-down?

If so, are there any licence considerations to do this?



Best Answer


  • Danny RodenDanny Roden Administrator

    Hi Nigel, you can publish data from Data Studio, a snapshot via ODBC as an option for exposing a 'latest' version of a given step result (if it's a workflow that's ran routinely, e.g. validation results).

    Any data published via ODBC can then be setup as a data source for reference/pulling into Excel via the below options (you can then simply 'refresh' Excel to pull through the latest data from that snapshot as and when it refreshes).

  • Thanks Danny - sounds ideal for distributing the results of data quality jobs...does the recipient need an Aperture licence?

  • Sounds good (and a good point re:opening ports, removing firewalls etc too)

    Thanks Danny

  • Clinton JonesClinton Jones Experian Elite

    Just be aware that there are bitness issues with JDBC (32bit vs 64bit) and most Excel implementations only support 32bit whereas Data Studio is 64bit by default.

Sign In or Register to comment.