0

I need to develop a small application integrated in sharepoint. I am using the 2019 version on on premise. The application consists of data entry, sql queries for loading data into the fields. I want to use the latest approaches for this purpose. I still have time, but I don’t know which way to go.

I looked at a lot of solutions without code, but as I understand it, I need to move in the direction of JS, at the same time I want to save it in sharepoint lists or where to store the entered data. But how can I get data from the external MSSQL database, use node.js or the web part, REST. I am very confused, help me please. I developed applications on C # windows form with ado.net, if I know the direction I will figure it out in JS.

Viktar Radzin
  • 3
  • 1
  • Hi there, can you clarify what your application will do? Try to break it down in terms of Front-End & Back-End. If I understood correctly you want a GUI that can fetch data from a Database and then update fields in Sharepoint. Is that correct? If that's the case you may just need something like React for the Front-End, NodeJS to do operations on your data and interface with Sharepoint through their REST API. – Ramiro Ramirez Jun 26 '19 at 18:45
  • Yes, that correct. Front-End this is the form in which the user enters data that fills in additional fields from the database (MSSQL). After that, the completed form is saved in the sharepoint list or somewhere else. – Viktar Radzin Jun 26 '19 at 18:54

1 Answers1

-1

So following up with the comments, you could implement the following stack:

  • React or Vue: To implement a simple GUI to perform basic CRUD on you DB
  • NodeJS: To handle the data manipulation (if any) and push things to Sharepoint

Take a look at the very popular MERV stack for inspiration on the app structure. (MERV uses MongoDB, but the logic would be the same if you swap that bit for MySQL)

Using NodeJS you can leverage Sharepoint REST API using the available libraries. Check out this tutorial for details on the implementation.

Ramiro Ramirez
  • 1,462
  • 14
  • 16