You need to first verify that the Excel extensions were imported correctly into the designer
window show view other
Teiid Designer Model Extension Registry
Choose the file driver
Set the Parent Directory to
jdv-demo/assets/excel, click apply, then ok
Set Translator to excel
Data Row number 2
Excel File excel-data.xlsx
Header Row Number 1, click Next
Set Location to demo-jdv/sources
Name ExcelDS, click Next, click Next again, then Finish
On the Sheet1 table, right-click on id then modeling set DataType and change double to int
On the Sheet1 table, right-click on each of region, visibility then modeling set DataType and select string and set length to 255
Save ExcelDS. There should be no red x next to the model.
On the Model Editor tab, highlight Sheet1 then click the preview data button. You should see the Excel data in the SQL Results tab
Lets now create a REST view on top of this base layer, the same was as the Postgres source.
file new Teiid Metadata Model
Model Type View Model
Transform from an existing model, click next
In the next window select the existing model as ExcelDS, click Finish and save the view model
If you receive an alert about properties, click ok.