title: How to publish tables from SQL database as datasets automatically into CKAN
body: <p>I am implementing open data portal for uni students such that they have access to all the datasets generated in different buildings of uni and they can work on the data to develop interesting applications.</p>
  
  <p>I have installed CKAN. Its working fine. I have implemented harvester as well.</p>
  
  <p>My main concern is :
  University has system that is storing the data coming from different sensors like temperature, light, noise etc. 
  The aim of project is to connect the data stored on system to the ckan so that data is synced between data stored on systems and open data platform. I tried harvesting for few source types.</p>
  
  <p>Can you please guide me what is the best feature that can help me connect to University data storage system.</p>
  
  <p>Do uni need to set up the web server from with whcih we can connect the CKAN by CKAN harvesting?</p>
  
  <p>Do we need to implement a new extension like publicopendataeu uses(eg. opengov_se etc.) to connect to different resources or we can use the existing extensions ?</p>
  
  <p>What format you recommend the uni to store their data in?
  Currently the data is stored as SQL database.</p>
  
  <p>is there any way we can connect those SQL tables to Ckan and import those tables as datasets?</p>