Fraser Stream Integration

Map and translate any text file into CSV, XML, HTML, XSLT and ADO Dataset format
Fraser Stream Integration (FSI) is a powerful data transformation tool that rapidly transforms structured ASCII text reports and delimited files into various file formats.

Fraser Stream Integration can convert any text report and:
Translate text reports from any source into Excel, PDF - Custom format, Word -Custom format, XML with style sheets
Dataset, CSV.

Extract information from text reports and deposit directly into any database
Publish information onto the web as HTML, XML with style sheets or PDF
Output to XML format for integration with other applications or to share with business partners.

Fraser Stream Integration is the server-based version of Fraser Stream Reports. Fraser Stream Integration automates the process of transforming ASCII text reports (or delimited files) into EXCEL, CSV, HTML, XML or ADO DataSet format. Fraser Stream Integration is the transformation engine that maps then converts text or delimited files into the formats mentioned.

Fraser Stream Integration can automatically generate web reports using XML/HTML output or, populate either existing tables or create new database tables altogether in Access, SQL, or Oracle.

Use Fraser Stream Integration to post sales reports on the web or to populate tables for your Business Intelligence applications. FSI can integrate Fraser Stream Reports' text file transformation capabilities with other applications and batch processes.

Fraser Stream Integration contains a simple command structure which can be included in a batch process or integrated into any Windows based application; use the command structure in your Visual Basic, C++, legacy, and ERP applications.

Fraser Stream Integration has three distinct functions:
1. Batch Creation
Create batch files that automatically select, transform, and deposit your text reports into any folder in CSV, HTML, XML, and DataSet format. Your destination folders can be individual user folders or web report folders for your entire organization.
2. Database Output
Text report or CSV files can be outputted directly into a database table. FSI provides two distinct methods of outputting data to a table. FSI can either pre-populate an existing table or generate a new table on the fly. FSI supports any database format including MS Access, SQL, and Oracle.
3. HTML Reporting Structure
Create HTML page hierarchies that contain links to the folders that contain your newly transformed files. These web pages can be made available through your intranet or on the Web and secured directly through the folder security settings.

Main features of Fraser Stream Integration:

automatically transforms the text or delimited files directly into Excel, PDF, Word, XML, HTML

runs as a simple command that can be part of a batch process or can be integrated into other applications

facilitates information exchange from one application to another using XML (the standard format for application information exchange today)

transforms ASCII text reports into Microsoft ADO DataSet in XML format - this format can be used by ASP applications or can be exported into other databases

improves business to business data exchange by quickly extracting, transforming, and delivering data to business partners via CSV, XML or Data Set format

creates a unified report format from a number of different data sources

is quick and easy to implement - FSI does not require a great deal of technical knowledge

outputs data directly into database tables

creates a table that contains the text report's information - ideal for preparing data for use with Business Intelligence tools such as Cognos

stores the text report's information within a single record of a database table (as csv, xml, or dataset) for use with other applications


Requirements of Fraser Stream Integration:

133-MHz Intel Pentium-class processor

128 MB of RAM, 256 MB recommended


Limitations of Fraser Stream Integration:

30 days trial

Transforms only the first 250 lines from a text report

Free Download ( Evaluation | 45.9 MB )