The Observations Data Model (ODM) defines a database structure for storing hydrologic observations time series data, along with metadata such as site information, variable description, methods used and more. This design is implemented with a SQL database, using either SQL Express or SQL Server 2005.
There are a number of ways for importing your observations data into an Observations Database (OD), which is a database that is ODM compliant. These tools range from the new SQL Server Integration Services (SSIS) to manual entry. However, for the database administrator new to SQL and/or new to ODM, the process of loading data may seem difficult.
To alleviate simple data loading, CUAHSI provides the ODDataLoader tool. While not as robust as SSIS, the ODDataLoader does not have as steep of a learning curve, and is useful when the data do not have quirks that could only be handled with more sophisticated data loading means.
This tutorial demonstrates the use of the ODDataLoader tool to import observations data into an ODM database. In this tutorial, we will use an Excel spreadsheet as the input file and an ODM SQL database as the output.
The dataloader requires an exact version of the OD database.
Feel free to add an example or hints page. Please Start the Page with 'Dataloader'