Skip to main content
Question

Getting Schema Reader to see SQL SERVER Database connection?

  • May 11, 2021
  • 2 replies
  • 178 views
jakeweaver
Participant
Forum|alt.badge.img+1

Hi folks, I'm trying to get the SCHEMA reader to read a MS Sql Server non spatial database. I keep trying to give it the correct Database Connection - but at the moment it wont. see it. Is there a way to make the Schema reader correctly get the database connection properties?

2 replies

david_r
Celebrity
  • david_rCelebrity
  • May 11, 2021

You can use a FeatureReader and tell it to only read the schema, e.g.

featurereader schema

jakeweaver
Participant
Forum|alt.badge.img+1
  • jakeweaverParticipant
  • Author
  • Participant
  • May 11, 2021

Thanks! - I hadnt realised the difference between the Schema Reader and a FeatureReader. Useful - very appreciated.

 

Community Stats

32,693
Posts
124,056
Replies
41,149
Members
Terms & ConditionsAccessibility statement
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.