Fraser Stream Integration
Our approach is simple. We utilize the ERP or legacy system's reporting
ability rather than connecting to the source database. By avoiding
the database altogether, we save a great deal of development time,
query analysis, ODBC issues etc
Our technology maps and translates
any text file into CSV, XML, HTML, XSLT, and ADO Dataset format.
Our output always matches the data source.
Fraser Stream Integration (FSI) is the transformation engine that
maps then converts text or delimited files into the formats mentioned.
Each type of text report must be mapped in order to capture its structural logic. The report need
only be mapped once; the mapped settings can then be shared across
the company.FSI can run on a server to meet the data conversion needs of an
entire organization. In addition to text reports being converted
into CSV format for Excel users, the entire output and transformation
process can be automated to populate external databases. Multiple
ERP reports can be outputted and converted by Fraser Stream on minute-by-minute
basis, the data then can be appended to existing SQL, Access, or
Oracle tables.FSI's Web publishing capability enables documents such as Purchase
Orders and Sales Orders to be converted into html format and published
directly onto the Web for business partners to view. FSI's Web functionality
includes all the necessary tools to enforce secure Web access by
document or by individual user.