Connecting to a Delimited Flat File

  1. Access the Connections page using one of these:
    Spectrum Management Console:
    Access Spectrum Management Console using the URL: http://server:port/management console, where server is the server name or IP address of your Spectrum Technology Platform server and port is the HTTP port used by Spectrum Technology Platform.
    Note: By default, the HTTP port is 8080.
    Click Resources > Connections.
    Spectrum Discovery:
    Access Spectrum Discovery using the URL: http://server:port/discovery, where server is the server name or IP address of your Spectrum Technology Platform server and port is the HTTP port used by Spectrum Technology Platform.
    Note: By default, the HTTP port is 8080.
    Click Connect.
  2. Click the Add connection button .
  3. In the Connection Name box, enter a name for the connection. The name can be anything you choose.
    Note: Once you save a connection you cannot change the name.
  4. In the Connection Type box, select Flat File.
  5. Enter the File Path by clicking the Browse button and locating the file.
    Note: While building a model store on a flat file connection, periods (.) if any, in the column name automatically gets converted to underscores (_).
  6. Select the Character Encoding of the flat file from the drop-down.
  7. Select the Record Type as Delimited.
  8. In Field Delimiter, select the expected separator between any two fields of a file record.
    If the delimiter does not appear on the list, click the Add field delimiter button to define the delimiter.
  9. Optional: If there is one, select the Text Qualifier that encloses field values.
  10. In Line Separator, the value Default is selected, indicating that the expected line separator depends on whether Spectrum Technology Platform is running on a Windows system.
  11. To specify whether the first row of the file is a header row, shift the First row is header row slider to either ON or OFF.
  12. To specify whether the data type of the various fields in any record of the file should be automatically detected, shift the Detect data type from file slider to either ON or OFF.
  13. To skip malformed records during file parsing, shift the Skip Malformed Records slider to ON.
  14. Click the Preview button to view field values based on selections you made in previous steps of this procedure.
  15. Click Test.
    A message confirms the successful test of the connection.
  16. Click Save.
    A message confirms the successful creation of the connection.
In order to view a sample record fetched using the created Delimited Flat File connection, click Preview in the header bar. File records will be fetched and the Fields sorted according to the details provided by you.