Skip to main content
search

© 2021 Excellerate. All Rights Reserved

Managed ETL Excellarator – File Broker

Accelerate and scale data extraction, normalization, and loading.

Upcoming ZipChat
October 4, 2022

Streamlining the Prior Authorization Process

Build streamlined authorization workflows for enhanced clinical experiences

Register Now
Upcoming Webinar
October 18, 2022

When One Size Doesn’t Fit All – Custom Agile Frameworks

David Wallace, Principal Agile Coach at Xero discusses custom agile frameworks

Register Now
Latest ZipRadio
Podcast

How AI Can Transform Healthcare? Disambiguation of Healthcare Data

AI is a means to get access, identifying patterns and trends in healthcare data

Play Now

Accelerate back-end data processing between banking, securities, cards, merchant services, and investment management services. With any-to-any graphical data mapping, File Broker makes mapping data from flat or EDI files efficient, lightweight, and scalable.

Key Benefits

  • Easy setup and maintenance
  • Reduce cost
  • Increase processing speed
  • Reduce errors
  • Process large-size files in a short duration
  • Improve relationships with business partners

Flat File Support

The Flat File source reads data from a text file. The text file can be delimited, fixed width, or in a mixed format. It also allows users to quickly set up file-based imports from vendor files and adapt to its changes. Supported file types include:

  • Account position files
  • Trade confirmations
  • Open trades
  • Transaction files
  • Multi-format settlement files

Additional Features & Technical Information

  • Built with .Net, C#, and SQL Server database
  • Support for MSSQL bulk insert of flat files
  • Configurable support for pre- and post-processing by calling stored procedures
  • Error handling is configurable, for e.g., continuation despite errors, halting on errors, or proceeding only if the file has less than the specified percentage of errors.
  • Leverages Microsoft’s TPL for concurrent processing of tasks across the number of available cores.

Trending Topics

Automation

Digital-driven Efficiency in Pharmacy Operations

With the rise in technology, there has been a significant change for independent pharmacies. Digital transformation and pharmacy tech acceptance are crucial to their survival. This technology allows them to…
Analytics

Preventive Health Using Big Data

Stakeholders in the healthcare industry are turning to big data analytics for help with preventive medicine and care. Big Data provides enhanced capabilities such as analyzing it effectively when needed…
Artificial Intelligence

AI in the Metaverse

There is no doubt that AI will play a significant role in the future of the Metaverse. As we move more and more of our lives online, AI will be…