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.

Here are some key 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:

· 133-MHz Intel Pentium-class processor
· 128 MB of RAM, 256 MB recommended


Limitations:

· 30 days trial
· Transforms only the first 250 lines from a text report