To create an Excel data source in Wyn Enterprise, follow these steps.
On the Resource Portal, navigate to Create (+) > Create Data Source.
Select Excel 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.
* Required fields
Click Next. You will be asked to select or rename sheets of the excel file.
Select and rename sheets as necessary and click Next.
At this step, you can switch tables to view data, modify column names, and adjust column data format. The following operations are available:
Click Create after the connection is successful.
You can view the added data source in the Categories tab of the Resource Portal.