Details
-
Enhancement
-
Resolution: Done
-
Critical
-
8.2
-
None
Description
Flat File connection profile wizard includes a "Enter File URI:" input field. The intention is to select a specific data file (.txt, .csv, etc.) instead of a data "folder" containing one or more of these files.
Teiid Designer's Flat File importer only expects the "folder" version.
Need to work with a single file URI
Don't know if remote URI or just a local file URI is implied. The "Browse..." button only searches local/remote file system connections. Not sure if HTTP is supported.
Test with product data at: http://download.jboss.org/teiid/designer/data/products/file/productdata_data.txt
Note that Teiid's File data source is expecting a Folder location in it's properties. The Source model will contain a tag like: key="connection:FlatFileHomeUrl" value="/home/blafond/Testing/Test Data/FlatFileData/employee-data"/> and the file name will be injected into the generated SQL for the virtual table.