TSB logo

Trade Statistics Knowledgebase

Welcome Guest ( Login )
Latest Additions Most Popular
Home » Knowledgebase » UN Merchandise Trade » UN Comtrade Data » Web services » Comtrade SDMX, Web Services and Data Exchange

Comtrade SDMX, Web Services and Data...

Expand / Collapse
 

Comtrade SDMX, Web Services and Data...


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:
UN Comtrade SDMX
Data Extraction Using Comtrade Web Service
Data Exchange Suite (DES)

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 to this article: UN Comtrade SDMX.

Security & Authentication

Comtrade Web Services use IP authentication. A user must have premium access service 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


Rate this Article:

Attachments


SDMXSample.zip SDMXSample.zip (1.65 MB, 2,390 views)


Related Links



Add Your Comments


Name: *
Email Address:
Web Address:
   
 
 
 
 
   
Verification Code:
*
 

Details
Last Modified:Thursday, September 16, 2010
Last Modified By: comtrade_admin
Type: INFO
Rated 5 stars based on 1 vote
Article has been viewed 10,978 times.
Options