Data Loader for Visual Studio

Data Loader for Visual Studio

Observations Data Model (ODM) is a database to store time series data and Streaming Data Loader (SDL) is created to load streaming sensor data from text files into ODM. It supports file formats that contain table based, delimited text files.

You can download and install ODM SDL. 

After installation you have to map the streaming data in ODM database and it is the first step in loading data.

Open the Configuration Wizard > Double click the shortcut on desktop > A window will appear to add sensor data file > Click “+” Add button on top.

A window will appear to enter the location of your local or remote text file containing sensor data. Click browse button on the locate file option > Locate the file dialog box > Navigate location > Open.

Next specify interval at which data will be added to the file, server address, database name, username and password.

Add info about data file regarding column header and data starting row number, and Check the box at the end to view previous data in the database.

Click Next to continue and you will need to enter new site, new variable, new source as at first your database will be empty and needs to be filled up.

Click Finish and records will be added up of the file being mapped. You are now ready to run the update either manually or using the configuration wizard.

A great tutorial to further guide you through data loader for Visual basic along with figures is here on this website.