CODEWITHSUNDEEP
sqlsql-servervisual-studiobiztalk
João Costa
João Costa

Reputation: 412

Biztalk get data from a view

I'm trying to get data from a view on a SQL server through biztalk. What do I need to do? Read some documentation but I think I only got more confused. Can't seem to generate the Schema.

Thanks

Upvotes: 0

Views: 328

Answers (2)

Dijkgraaf
Dijkgraaf

Reputation: 11527

  1. Right click the BizTalk project
  2. Select Add, Add Generated Items
  3. Select Consume Adapter Service
  4. Click Add
  5. Select sqlBinding
  6. Click Configure
  7. Select URI Poperties
  8. Fill out InitialCatalog (database name)
  9. Fill out InstanceName (if applicable)
  10. Fill in Server
  11. Click OK
  12. Click Connect
  13. Under Select a catagory: Expand Views
  14. Select the view
  15. Select either Delete, Insert, Select or Update.
  16. Click Add
  17. Give it a Filename Prefix
  18. Click OK

Upvotes: 2

DTRT
DTRT

Reputation: 11040

Is there a problem? Views appear on the list of Client operations along with Stored Procedures, Tables, etc.

There's really nothing special about it.

Upvotes: 0

Related Questions