Difference between revisions of "Integrating OdataLink with Microsoft SQL Server"
Jump to navigation
Jump to search
| Line 10: | Line 10: | ||
You may need to '''run Visual Studio 2019 as an Administrator''' in order for the package to run correctly. | You may need to '''run Visual Studio 2019 as an Administrator''' in order for the package to run correctly. | ||
You will need to the [[Models|model]] to use [[Login Type: Basic|basic authentication]] as well as [[Allowing / disallowing users access to a model|add users access to the model]]. | |||
= Related Topics = | = Related Topics = | ||
[[Integrating with OdataLink]] | [[Integrating with OdataLink]] | ||
Latest revision as of 00:07, 6 October 2021
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.