Microsoft SQL data source
The MSSQL data source provides direct access to a Microsoft SQL Server database from a portal. Pages or portions of pages in a portal can interact directly with a SQL Server database.
Note: This data source is designed to work with
Microsoft SQL Server 2008 R2 and later. You can check the version of your
server by executing this command using the Microsoft SQL Server Management
Studio:
select @@VERSION.
This is the general process for using the MSSQL data source:
- Create the data source. For cloud customers, the data source is created by the Infor cloud team.
- If pairing with a Mongoose-based data source is needed, set up the pairing.
- Apply the data source to a selected portal in the Portal Manager.
- Use collections from the data source as needed when working with layouts and scripting.