System integration
Barloworld Optimus products are widely used throughout many industry sectors and have been integrated with most leading ERP and transaction systems including SAP. In environment where simple flat file transfer protocols are not sufficient, Barloworld Optimus has, in partnership with ETL Solutions LTD, developed a comprehensive, flexible bi-directional connectivity solution using Transformation Manager (TM), and TM Transforms have been accredited “certified for use with SAP® R/3® software.
Why Transformation Manager?
The key to delivering robust, reliable data integration is to fully define the workflow, rules for exchanging data, and quality checks to be met. The workflow may comprise initial bulk load of data, near real-time data flows and periodic updates such as end of day and end of month, with data stored in staging databases as needed.
Using TM’s Design Tool integration rules are easily captured in a way that can be understood by all the people involved in the project. Once these have been agreed the data integration components are automatically generated.
Functionality
The supply chain integration component includes key features such as:
· Automatic scheduling and transfer of files
· Email notification if errors are detected
· Audit Tables which hold the records processed for subsequent review
· Log Files which summarise the transforms that have been run
· Lookup tables to assist with transform logic
· Staging tables where data is consolidated prior to be transferred to Barloworld Optimus Supply Chain Planning Systems
The integration effort using TM has been demonstrated in a great variety of projects. Working closely with Barloworld Optimus, ETL Solutions leverage their unique data integration toolset to deliver complete fully tested end to end integration guaranteed to budget for our clients. ETL have established an impressive client list of the worlds well known leading companies across sectors such as automobile manufacturers, defence, oil companies, banks and software providers.

Benefits of clients:
· High quality, fully tested data integration components delivered faster than ever before
· Implementations guaranteed delivery and within budget with the minimum of effort from client IT
· Ensure rapid cleaning of raw data and ensure data quality
· High performance & scalability ensuring data is available when needed and using existing infrastructure
· Configurable and maintainable without re-coding reducing on-going costs
· Integrate virtually any existing or planned systems
· SAP Netweaver certification
Further information
We would be delighted to share some of our individual experiences with you. Please contact us for our case studies and testimonials.