comtradekb logo
United Nations Commodity Trade Statistics Database |  Statistics Division

Comtrade KB Home : Comtrade SDMX, Web Services and Data Exchange
Q10087 - INFO: Comtrade SDMX, Web Services and Data Exchange

Comtrade SDMX, Web Services and Data Exchange

 

General Information

 

Please refer to these articles for general information about Comtrade SDMX, Web Services and Data Exchange:

http://comtrade.un.org/kb/article.aspx?id=10050
http://comtrade.un.org/kb/article.aspx?id=10051
http://comtrade.un.org/kb/article.aspx?id=10052

 

You can get the SDMX format by clicking the SDMX download in any of query result pages (for an example at http://comtrade.un.org/db/dqBasicQueryResults.aspx?cc=62&px=BE&r=251&p=705&rg=2&so=6)

 

The SDMX key families and simple power point presentation about Comtrade SDMX are attached at this article http://comtrade.un.org/kb/article.aspx?id=10050

 

Security & Authentication

 

Comtrade Web Services use IP authentication. A user must have site license account in UN Comtrade and Web Service access right is granted.

 

Depending on access right, the following data can be obtained:

Comtrade Data, Tariff Line Data, Total Trade, Annual Totals, Processed Data or Original Data. The latest three are restricted for data exchange between UN and OECD.

 

Click here to check your access rights: http://comtrade.un.org/ws/CheckRights.aspx

 

ComtradeTools

 

There is no need to use special tool to access Comtrade Web Service. Data can be obtained via web browser by providing the right url (see example below).

 

However, there are many limitations with web browser: limited data download size and difficulty to create url string.

 

ComtradeTools was developed to help user downloading data with synchronization and DTS engine built-in (it is possible to import data to SQL Server directly).

 

For an example, if you want to download new data for EU25 countries,  you just need to specify a project in ComtradeTools and run it. The next time you run it again, it will only download the latest addition.

 

Note: ComtradeTools is a command line program. Step by step instruction can be found at http://comtrade.un.org/ws/comtradetools.aspx

 

Reminder: ComtradeTools is not required tool. Anybody can make its own download tool.

 

URL Example

 

Country code :  381 = Italy
Classification :  H1 = HS1996
Years : 2002 and 2003
http://comtrade.un.org/ws/getSdmxV1.aspx?px=H1&r=381&y=2003,2002&cc=TOTAL&p=0&comp=false
Country code :  36 = Australia
Classification :  S2 = SITC Rev.2
Year : 2004
http://comtrade.un.org/ws/getSdmxV1.aspx?px=s2&r=36&y=2004&cc=TOTAL&p=0&comp=false

 

Attached File

 

Here is the example of 2005 data for reporter country Albania (no. 8 of UN code)  for the HS1996.  The attached  zipped file holds the XML original file plus the CSV converted file, which will be used for loading to SQL via DTS.  The link from the Web below will give you the same information in a Web-Service format.

 

http://comtrade.un.org/ws/getSdmxV1.aspx?px=H1&r=8&y=2005&cc=TOTAL&p=0&comp=false

Related Articles
Q10050 - INFO: UN Comtrade SDMX
Q10051 - INFO: Data Extraction using Comtrade Web Service
Q10052 - INFO: Data Exchange Suite
Q10088 - INFO: UN Comtrade References (via Comtrade Web Services)
Q10089 - INFO: UN Comtrade Data Availability (via Comtrade Web Services)
Q10091 - INFO: Comtrade Tools

Article Attachments
SDMXSample.zip
Data Transfer Mechanisation_DST001CEn.doc

Related External Links
http://www.sdmx.org
http://www.sdmx.org/knowledge/document.aspx?id=107
http://comtrade.un.org/ws/comtradetools.aspx
Help us improve this article...
What did you think of this article?

poor 
1
2
3
4
5
6
7
8
9
10

 excellent
Tell us why you rated the content this way. (optional)
 
Approved Comments...
It is clear and easy to understand. Approved: 2006-07-06
Created on 2006-06-26.
Last Modified on 2007-12-10.
Last Modified by B.Amdemariam.
Skill Level: Intermediate.
Article has been viewed 8450 times.
Rated 5 out of 10 based on 61 votes.
Print Article
Email Article