Hello, I am trying to figure out how to get "batch data streaming" from network tracking-cameras, into SQL server. The data looks like this when received by a data logger server (TCP/IP Data Logger):
POST / HTTP/1.1
Host: 192.168.1.114:5 7385
Content-Length: 673
Connection: Keep-Alive
<?xml version="1.0"?>
<Metrics SiteId="STR409" Sitename="STR40 9" DeviceId="Cam1"
Devicename="Cam 1">
<Properties>
<MacAddress>00: b0:9d:..:..:..</MacAddress>
<IpAddress>192. 168.1.121</IpAddress>
<HostName>Cam-12788583</HostName>
<HwPlatform>230 0</HwPlatform>
<Timezone>-6</Timezone>
<DST>1</DST>
<DeviceType>0 </DeviceType>
<SerialNumber>1 2788583</SerialNumber>
</Properties>
<ReportData Interval="1">
<Report Date="2016-05-22">
<Object Id="0" DeviceId="Cam1" Devicename="Cam 1" ObjectType="0" Name="Zone0" ExternalId="zer o">
<Count StartTime="01:3 1:00" EndTime="01:32: 00" Enters="0" Exits="0" Status="0"/>
</Object>
</Report>
</ReportData>
</Metrics>
HTTP/1.1 200 OK
Server: Http parser for Data Loggers
Content-Length: 4
Accept-Ranges: none
Cache-Control: no-cache
Connection: close
Content-Type: text/plain
OK
<<CLOSE>>
It's going to be on the local network, and the data required is the time, camera id, and counts (the camera counts people). Then I'd like to get the live data into Excel or the like.
I have not used SQL server before, but followed a few tutorials on setting the TCP/IP ports and creating a database. Maybe I'm still a long way off, would this need metadata to work, or some programming in SQL server? Might there be an easier way to store and access the data?
POST / HTTP/1.1
Host: 192.168.1.114:5 7385
Content-Length: 673
Connection: Keep-Alive
<?xml version="1.0"?>
<Metrics SiteId="STR409" Sitename="STR40 9" DeviceId="Cam1"
Devicename="Cam 1">
<Properties>
<MacAddress>00: b0:9d:..:..:..</MacAddress>
<IpAddress>192. 168.1.121</IpAddress>
<HostName>Cam-12788583</HostName>
<HwPlatform>230 0</HwPlatform>
<Timezone>-6</Timezone>
<DST>1</DST>
<DeviceType>0 </DeviceType>
<SerialNumber>1 2788583</SerialNumber>
</Properties>
<ReportData Interval="1">
<Report Date="2016-05-22">
<Object Id="0" DeviceId="Cam1" Devicename="Cam 1" ObjectType="0" Name="Zone0" ExternalId="zer o">
<Count StartTime="01:3 1:00" EndTime="01:32: 00" Enters="0" Exits="0" Status="0"/>
</Object>
</Report>
</ReportData>
</Metrics>
HTTP/1.1 200 OK
Server: Http parser for Data Loggers
Content-Length: 4
Accept-Ranges: none
Cache-Control: no-cache
Connection: close
Content-Type: text/plain
OK
<<CLOSE>>
It's going to be on the local network, and the data required is the time, camera id, and counts (the camera counts people). Then I'd like to get the live data into Excel or the like.
I have not used SQL server before, but followed a few tutorials on setting the TCP/IP ports and creating a database. Maybe I'm still a long way off, would this need metadata to work, or some programming in SQL server? Might there be an easier way to store and access the data?