Project Overview
The company decided to store daily data from the Energy Exchange Istanbul (EPIAS) and its own powerplants for further and deeper market analysis. SQL Server 2012 was chosen as the database system since it is well-known and widely used with plenty of resources available online.
Technologies Used
- C#
- SQL Server 2012
- Cron Jobs
- Visual Studio 2017
Description
The Auto Data Collector is an app developed in C# using Visual Studio 2017 that automates the process of collecting data. The data collected comes from public APIs as well as the company’s own powerplants, including information like reservoir levels, generator outputs, and energy production.
The app runs on the company's server and uses Cron jobs to schedule and trigger specific functions at defined times. The collected data is written to the Enerji database for storage and analysis.
Additionally, the app provides a log file so users can manage the Cron jobs and easily check for errors during function execution.
Visuals
Figure 1: Snapshot of one of the databases and its tables
Figure 2: Auto Data Collector uses Cron Jobs with C
