Integrating OdataLink with Microsoft SQL Server
In order to integrate OdataLink with Microsoft SQL Server, you will need to use SQL Server Integration Services (SSIS).
You will need to have the following software installed:
- Microsoft Visual Studio 2019
- SQL Server Management Studio
- SQL Server Data Tools for Visual Studio (SSDT)
- SQL Server Integration Services Projects for Visual Studio 2019
You can find more information on SSIS here.
You may need to run Visual Studio 2019 as an Administrator in order for the package to run correctly.
You will need to the model to use basic authentication as well as add users access to the model.