%Verbindung zur Datenbank. 1 Treiber installieren wie in Email beschrieben,
conn = database('ECUP_DSS_DB', 'sa', 'Ecupadm1!', 'com.microsoft.sqlserver.jdbc.SQLServerDriver', 'jdbc:sqlserver://192.168.56.83:1433;databaseName=ECUP_DSS_DB;');

%test
ping (conn);
% laden der Methansensoren
Methane1= fetch (conn,'select * from HXT101_QT01');
Methane2 = fetch(conn,'select * from HXT101_QT02');
Methane3= fetch (conn,'select * from HXT101_QT03');
%PLOT
% Methane1 (timeval= converts date into nummeric datavalue)
timeval_1 = datenum(Methane1(:,1),'yyyy-mm-dd HH:MM:SS.FFF');
dataval_1 = [Methane1{:,end}]
plot(timeval_1, dataval_1) 

%Methane2 
timeval_2 = datenum(Methane2(:,1),'yyyy-mm-dd HH:MM:SS.FFF');
dataval_2 = [Methane1{:,end}]
plot(timeval_2, dataval_2) 

%Methane3
timeval_3 = datenum(Methane3(:,1),'yyyy-mm-dd HH:MM:SS.FFF');
dataval_3 = [Methane3{:,end}]
plot(timeval_3, dataval_3) 



% laden der PAK Sensoren

PAH1= fetch (conn,'select * from HXT101_QT04');
PAH2= fetch (conn,'select * from HXT101_QT05');
PAH3= fetch (conn,'select * from HXT101_QT06');

% laden des MEG Sensors
MEG= fetch (conn,'select * from HXT101_QT07');

% laden der CTD
Connectivity= fetch (conn,'select * from HXT101_CTD01CT');
Temperature= fetch (conn,'select * from HXT101_CTD01TT');
Depth= fetch (conn,'select * from HXT101_CTD01DT');

% laden der Hydrophone
Hydrophone1= fetch (conn, 'select* frpm HXT101_HYDP01');
Hydrophone2= fetch (conn, 'select* frpm HXT101_HYDP02');
Hydrophone3= fetch (conn, 'select* frpm HXT101_HYDP03');