Uploaded image for project: 'Teiid Designer'
  1. Teiid Designer
  2. TEIIDDES-1826

Designer doesn't yet support Flat File Connection Profile URL input option

    XMLWordPrintable

Details

    • Enhancement
    • Resolution: Done
    • Critical
    • 8.3
    • 8.2
    • Datatools Integration
    • 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.

      Attachments

        Activity

          People

            mdrillin1@redhat.com Mark Drilling (Inactive)
            blafond Barry LaFond
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: