How a Meteor App connect and get data to a MS SQL db app?

help
1

How do you connect a Meteor app to an existing MS SQL backed application?

Basically, I want to connect and get a data from a legacy application backed with MS SQL.

Should I use ddp protocol or http rest package?

Do you have any resources or patterns that I should look into?

Thanks.

2

A couple ideas:

  • Have an intermediate application or meteor-synced-cron which polls the MSSQL DB and puts the relevant info into your app’s Mongo DB. Then do all the regular pub/sub stuff.
  • Load all your data through methods instead of publications, where the method gets the data from a REST endpoint or a local cache
1 Like
3

Thanks @energistic for your valuable ideas! :thumbsup:

I will definitely look into it.