Thanks Petter. I tried using the REST Connector when I originally posted here. At that time there was a bug, at least on the enterprise edition. the REST Connector screen/UI was not loading right.
This was fixed in the latest release and I am now using the REST Connector-Service NOW REST API's to extract my data.
Although, I am having to create separate connections for each Service Now Table, since endpoints were created for each table.
Did you have to do the same? or were you able to figure out a better way?