Wyn Enterprise User Guide
- An Introduction to Wyn Enterprise
- Document Portal for End Users
- Using Report Designer
- Working with Dashboards
- Governing Data and Resources
- Using Dashboard Designer
- Section 508 Compliance
Wyn Enterprise: SQL Server Data Provider
To create a SQL Server data source in Wyn Enterprise - Resource Portal, follow these steps.
- On the Resource Portal, navigate to Create (+) > Create Data Source.
- Select SQL Server in the data source list on the left or in the icon view on the right.
- Fill in the database configuration information for the selected data source.
Field | Description |
---|---|
Name | The name for the data source that you want to specify. |
Server | A server name. |
Port | A port number, the default is 1433. |
User | A user name to connect to the SQL Server database. |
Password | A password of the SQL Server user. |
Database | Enter the server SQL instance name or click the drop-down arrow to select the instance. |
Use Configuration String (Advanced) | If you check this option, you only need to fill in this item and the name of the data source. The format of the connection string is: Server=myServerAddress; Database=myDataBase; User ID=myUsername; Password=myPassword; In addition, you can use the user context attribute in the string to filter data, in the format "@{User context name}" such as "@{DBName}". See User Context for details. |
Verify the SQL Server connection by clicking Test Connection. If the data source is available, and the credentials are correct, you receive a notification on successful connection.
Click Create after the connection is successful.
After the successful creation, you can view the added data source in the Categories tab of the Resource Portal.