Connecting Angular2 to DB

OlegKon

unread,

Dec 17, 2016, 5:06:38 PM12/17/16

to Angular

Hi,

I am trying to build Angular2 prototype connecting to SQL Server to call Stored Procs

(SQL Server 2016 can return resultsets in JSON, but we are not on it yet, currently on 2013).

Is using MSSQL for NodeJS a good idea? See:https://github.com/patriksimek/node-mssql

If not, how do we connect Angular2 to Java?

We have existing Flex / Java8 / Spring / BlazeDS app with a lot of grids and charts (Line, Pie, Bar, TreeMaps, heat maps),

which we want to start converting to Angular2 next year. Doing some preparation work - will build one screen from there.

Any guidance is really appreciated.

TIA,

Oleg.

OlegKon

unread,

Dec 25, 2016, 12:09:14 AM12/25/16

to Angular

What is a state of Angular Universal? Can it help to connect to Ang2 to Java/Spring?

Or what else can I use for that:

Spring Boot? (I've seen some courses on that on Udemy)

Rhino for Java-JS?

Sander Elias

unread,

Dec 25, 2016, 9:16:00 AM12/25/16

to Angular

hi OlegKon,

Angular is a front-end framework. That means the code runs in the browser. You need to talk to an (api)-server, and let that talk to your DB.

There are way's to hook up your DB directly to the internet, but I would strongly advise against this. Use a middleware server, that takes care of auth and validation.