Connecting your data to Statistical Tools

NOTE: This tutorial involves connecting Fusion Registry version 9.0 to external tools. Fusion Registry 9.0 is not yet released - to read more about this release, click here. If you want early access to the Fusion Registry version 9, please send us an e-mail to: support@metadatatechnology.com

The SDMX Connectors project from Banca d'Italia provides connections from SDMX web services to statistical tools such as Excel, Matlab, R, SAS, and STATA. These applications have been configured to connect to known SDMX data sources, such as the OECD, Australian Bureau of Statistics, IMF and others. In addition to these known sources, it is possible to connect your own, by simply pointing the application to use your Fusion Registry web service.

To read more about the SDMX Connectors Project, please visit their GitHub page where the project is hosted:
https://github.com/amattioc/SDMX/wiki

In order to get you going, we’ve added the step to connect your Fusion Registry to the R tool, but this logic can be easily applied to the other products supported by the connectors project.

Connecting Fusion Registry to R

The first step is to install the RJSDMX library in R. This is achieved by simply clicking on Packages --> Install Package(s).

After we selected a mirror close to us (we chose Bristol in the UK). We were then presented with a long list of packages in alphabetical order. Scroll through this list looking for RJSDMX.

Once we've installed R, we simply ensure our installed packaged is loaded, and then we're ready for action!

Now we have installed our library, the next thing to do is add our Fusion Registry to the list of existing data providers. This is simply a case of using the addProvider function giving it an alias, and a URL. The URL points to the web service entry point of the Fusion Registry which in our case is http://localhost:8080/FusionRegistry/ws/rest. If you are running an Apache service with URL rewriting on, you simply put the entry point to the Fusion Registry, postfixed with /ws/rest, for example http://registry.sdmxcloud.org/ws/rest

Now we can start browsing the contents of our Fusion Registry by simply using the built in functions, for example showing the dataflows:

Or showing the dimensions for a specific data flow

Or the codes for a specific dimension

You can use this information to help construct a data query, or if you prefer, simply type sdmxHelp() to bring up a helpful query builder

Select your data provider from the top menu, and then you can browse you dataflows, dimensions, and codelists. You can make code selections, which update the URI at the top, and you can click 'Check Query' to obtain all the matching series for the query:

Once you know what data you want, simply run the query from the command line to pull the data from the service

It's as simple as that, and of course the Fusion Registry version 9 can both host your data in it's local data store, or it can connect to any number of existing data stores. So you can use this tool to browse data across your organisation, even if your data is managed outside of the Fusion Registry.

If you're interested in getting your data in Excel, we would recommend our FusionXL plugin, as it has many added benefits.