The procedure for creating a data model for a report is typically composed of three steps - select the model type, configure data source connection details, and select the desired tables and views.
In Wyn Enterprise, you can create a data model by manually filling in the configuration details in the designer or by re-using an existing data source available on the server. The supported data source types are Oracle, SQL Server, MySQL, and PostgreSQL. This article describes the detailed steps to create a data model using both these methods.
An embedded data source is defined in the data model itself and is used only by that model. Use the below steps to create a data model with an embedded data source.
Select the tables and views you want to include in the data model. You can use the following options also -
A shared data source is a data source that already exists on the portal. It is best suitable in scenarios where you want to use the same data source to create different data models.
Note: The list displays only those data sources on which you have sufficient permissions i.e. Execute/Create, Read/Write, and Full Control.
Note: If the data source referenced by the data model is no longer available on the portal, then you cannot change or use the data model anymore.
Note: Use the Save Draft button if you don't want to publish your changes. The report(s) using that data model would not be affected.