Data sources

The default view of the JDemetra+ window, which is displayed after launching the program, is shown below.

Text

JDemetra+ default window

By default, on the left hand side of the window two panels are visible: the Workspace panel and the Providers panel. The Workspace panel stores the work performed by the user in a coherent and structured way. The Providers panel presents the list of the data sources and organizes the imported series within each data provider. By default, JDemetra+ supports the following data sources:

All standard databases (Oracle, SQLServer, DB2, MySQL) are supported by JDemetra+ via JDBC, which is a generic interface to many relational databases. Other providers can be added by users by creating plugins. We will now focus on the Spreadsheets data source, which corresponds to the series prepared in an Excel file. The file should have dates in Excel date format. Dates should be placed in the first column (or in the first row) and titles of the series in the corresponding cell of the first row (or in the first column). The top-left cell [A1] can include text or it can be left empty. The empty cells are interpreted by JDemetra+ as missing values and they can appear at the beginning, in the middle and at the end of the time series. The example is shown below.

Text

Example of an Excel spreadsheet that can be imported to JDemetra+

Once the spreadsheet is prepared and saved, it can be imported to JDemetra+ as it is shown by the tutorial below.

Alt

An example of importing process for the Excel file