Aug 13 2021 07:29 AM
Hello,
I am trying to build a Java Desktop client application for my organization. The current database is a an Excel file on our SharePoint. I want to use a shared database solution because I need data to be accessible for all of my team.
What are the recommended solutions for this?
Reading/writing to the SharePoint Excel file OR transforming the Excel file into a SQL database (with an option to export data to Excel file). If the second option is better, what libraries for java i need to use and what SQL database engines I need to use with SharePoint?
The client application will be a form entry with some customization.
Should I use MS SQL Server with SharePoint? Or I need to connect to the Excel file?