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 data into Excel from Data Studio using an edit-bar drop-down?
If so, are there any licence considerations to do this?
Thanks
Nige
Best Answer
-
No, they don't. Depending on your IT setup, ODBC connections can sometimes be a bit tricky, but as long as the port is accessible to the users, then this is a good way of providing up-to-date metrics to 'the business' without having to splash out on a Data Viz tool.
If you need any help with ODBC setup / config, I'd suggest raising a ticket with our support team.
6
Answers
-
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).
2 -
Thanks Danny - sounds ideal for distributing the results of data quality jobs...does the recipient need an Aperture licence?
0 -
Sounds good (and a good point re:opening ports, removing firewalls etc too)
Thanks Danny
0 -
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.
2
