I am sorry if this question is already answered, I suspect my more practical leaning approach is missing something in the instructions I have read.
I have an established SQL Server not currently hosted on Azure. In this SQL Server I have things like my client list, sites and water bodies we look after. The SQL Server also handles my remote field staff needs such as time cards, work requests and so on.
One thing the SQL Server doesnt do well, is handle my quotes process, I have tried to build models for quoting but somehow it fails.
After considering our current practices and looking at this issue, a SharePoint Site with document library solves most of the issues I am aiming to build for.
However when I add a document to the library I want to also add data such as Client, Site and Water Body data already in SQL Server. Seems to me likely I should connect the relevant tables from SQL to a list in SharePoint to enable the document library to be populated correctly and save a lot of double up of data entry.
In reading into this further I am getting very lost with BCS, BCDM and so on.
I have the provider data and the connection string.
Can someone direct me to a resource that steps through the set up for this type of connection? I don't know I am really missing something here.