@rt_gis FME doesn't support the creation of virtual tables on the SQLite writers, either native SQLite or the SQLite Spatial (FDO). You can probably create the virtual fdo tables you need using a SQLExecutor. But as far as I can gather, the virtual tables are typically application specific so you'd really have to understand the schema that the application used to read virtual tables. The SQLite writer supports a template file(database), so that might be a possible solution.
If you could share with us an example of a SQLite database that has the virtual tables you need and also tell us something about the application that uses them then we might be able to help a little further.
Hello, thank you for your answer. I have attached two sqlite files with different behavior.
Both were generated with FME 2018. The input data were shapefiles, xls-files and Oracle views.
In file A, the table of the same name with the prefix fdo_ is missing. In File B, this fdo table was automatically created without me consciously doing anything else in the Workbench.
I would like to use this data in a browser-based GIS via MapGuide Open Source. Our software based on this can better deal with queries on sqlite that point to the virtual tables.
sqlite.zip
Just to summarize this discussion:
- FME does not create SQLite virtual tables with any of the various SQLite writers such SQLite, SpatiaLte (FDO), etc.
- FME can view / read the virtual tables (Data Inspector) but will not resolve any of the virtual links or behaviours
