File Formats for Reading

<< Click to Display Table of Contents >>

Navigation:  Integrating Blaze with Other Systems > Reading Data into s-Server > Reading from Other Sources  >

File Formats for Reading

Previous pageReturn to chapter overviewNext page

You can read a variety of file types. The Extensible Common Data framework parses these into rows in a stream or table.

Column names are used to derive the format of all column set types in the Extensible Common Data Adapter. Data formats are always derived from column names. You always declare columns in the foreign stream and those columns are always available to queries.

If you do not have information about the file format to be read, or need help filling in foreign stream or agent properties for a file format, you can use the Discovery parser to determine information about a file's format. This parser reads a sample of the file and returns information on file format options. Currently, the Discovery parser works for CSV, XML, and JSON files.

Currently supported file types are:

CSV Files
XML Files
JSON Files
Key Pair Values
ProtoBuf Files
Variable Column Files
Fixed Column Files
Files with FastRegex Row Filter
W3C Files

Note: You can also input data in larger chunks and parse it later using the Parser UDX. This UDX calls the parsers listed above in a function. For more information on using functions, see the topic Transforming Data in s-Server in this guide.