Rpv Reports

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.

​FairCom RTG modernizes COBOL and Btrieve applications by seamlessly replacing their native file systems with FairCom's advanced database engine, enhancing reliability, scalability, and performance without altering existing code. It enables real-time read/write access to live data through modern APIs, including JSON and SQL, facilitating business analytics and reporting without additional coding. With features like hot backups, automatic recovery, and ACID-compliant transactions, data integrity and uptime are significantly improved. FairCom RTG supports vertical scaling to thousands of users and horizontal scaling through replication for reporting, failover, and availability. The latest version introduces a JSON DB API, allowing simple JSON commands to manage COBOL data, and Hot Alter Table functionality for immediate schema modifications without rewriting records.