Importing Data into SQL DB from IP device

[hambo12]

I have been asked to pull some data from an IP connected device on our network. This device is a dumb device that simply buffers the data, and im not sure where it sends it (if it even does).

I need to setup a schedule to import data on a regular basis into an SQL 2005 DB.

The main thing I need to know is how to connect to and pull data from the IP device on our network from SQL server. Is it even possible??

 

[mrdenny]

If you have drivers or some way to get the data from the device then yes. It'll probably take a little work. Can you provide more information about the device, and how you can access the data on it?

Denny
MVP
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL 2005 BI / SQL 2008 DBA / SQL 2008 DBD / SQL 2008 BI / MWSS 3.0: Configuration / MOSS 2007: Configuration)
MCITP (SQL 2005 DBA / SQL 2008 DBA / SQL 2005 DBD / SQL 2008 DBD / SQL 2005 BI / SQL 2008 BI)

My Blog

 

[simian101]

Just because a device is IP enabled does not neccessaryly mean you can access it's file system via IP. The device should have instructions for data transfers.

It might be FTP enabled or it might require software from the manufacturer to copy data to a server.

Simi