Zerion Software SQL Server Data Pipe

This video how to push data using the Zerion Software SQL Server Data Pipe.

---

Closed Caption:

hello folks this is Ben ray with Syrian
software I want to put together a video
of our newest rule the added 20 and
sweet called R siegel datapipe now with
this told us that allows data captured
directly on iPhone killer stored in a
computer cloud to be instantaneously
sent over to a sequel server now this
supports building of the tables it
supports adding of new columns as well
as flattening of your your some form
data says one to go over quick demo of
this so if I just fill out this form
I'm just gonna fill out the parents or
just for demonstrating you choose the
GPS location you choose the name of the
inspector you choose any man was that he
would have and you just sign off on the
inspection now at this point where you
can do is hit done and what's actually
going to do is sync up and write
directly to us equal Server database so
here just a second I submitted the
record I'm just going to run a quick
refresh year and I'm gonna see that here
now here's the fifth record of submitted
so again you see here's all the details
in combat I filled out here now if I was
able if I wanted to go in and build a
new column in here i'll show you how
it's a towards adding a new field so
instead of data fckin sure we're gonna
do two day next inspection and at this
point we can make this a date field and
I'm gonna go back here and in sync up my
right device now once the device thinks
I'm gonna fill out a record with this
new field in it and when I submit this
actually gonna see on the sequel
server-side it's adding a new a new
column there as well so you can capture
the GPS location name inspector we've
been date of next inspection is gonna be
june 4th 2016 and I'll sign up now at
this point when I submitted was actually
going to do is add a new column to this
list so I just do you can't ends and I
will see we have our date of next
inspection here now I went in and five
or six other fields they automatically
appear here good news is if you delete
the field it actually still gonna stay
intact here so you will preserve your
data
and with that I hope you enjoyed this
sequel server data and you get a lot of
stuff it thanks so much for watching