ERP CONNECTIVITY

FiREapps ERP Integration Ensures Seamless Data Collection

At FiREapps we have and continue to invest time and money into building out connectivity with all relevant ERP systems to facilitate a seamless straight- through process.

FiREapps provides customizable and battle-tested data extract toolkits for SAP, Oracle, JD Edwards and PeopleSoft. Starter kits for second-tier ERP systems such as QAD, FIS, NetSuite, Microsoft Great Plains, Dynamix and Navision are also available to extract data.

FiREapps EXTRACT TOOLKITS ARE THE ONLY SAP AND ORACLE CERTIFIED SOLUTIONS IN THE INDUSTRY.

SAP and fireapps

56 PERCENT OF FiREapps CLIENTS USE AT LEAST ONE INSTANCE OF SAP

SAP and fireapps

SAP

FiREapps Extract 3.0 is certified by the SAP Integration and Certification Center (SAP ICC) as powered by the SAP Net Weaver® technology platform.

The FiREapps general ledger extract program for SAP is a report written in ABAP and delivered via transport, containing all the objects required to execute and run the program.

  •  FiREapps first connection with SAP was completed in 2007.
  •  On average, enrollment in FiREapps Extract 3.0 takes 8-10 hours of an IT generalist’s time per ERP system.
Oracle and fireapps

53 PERCENT OF FiREapps CLIENTS USE AT LEAST ONE INSTANCE OF AN ORACLE PRODUCT

Oracle and fireapps

ORACLE

The FiREapps Oracle Extract Toolkit gathers information about account definitions and company information.

The queries for Oracle are reports written in SQL*Plus designed to be run from either the SQL*Plus command line or installed to the Oracle Applications Suite and run as concurrent programs.

  •  FiREapps first exposure extract report with Oracle was completed in 2007.
  •  On average, enrollment in the FiREapps Oracle Extract Toolkit takes 4-6 hours of an IT generalist’s time per ERP system.

JD EDWARDS

The JD Edwards Extract Toolkit contains ANSI SQL statement, PGP and cURL documents, as well as a set of specifications to create data extract reports.

  • FiREapps first connection with JDE was completed in 2010.
  • On average, enrollment in the FiREapps JD Edwards Extract Toolkit takes 12-16 hours of an IT generalist’s time per ERP system.

PEOPLESOFT

The PeopleSoft Extract Toolkit contains ANSI SQL statement for retrieving ERP, entity, accounts and balances from PeopleSoft, as well as a set of templates and specifications for optionally creating custom data extract reports.

  •  FiREapps first connection with PeopleSoft was completed in 2008.
  • On average, enrollment in the FiREapps PeopleSoft Extract Toolkit takes 4 to 6 hours of an IT generalist’s time per ERP system.

FACILITATING SET-UP & ONGOING DATA AGGREGATION

Using proprietary technologies, FiREapps aggregates raw general ledger data from ERP systems, as well as databases and spreadsheet data sources.

Data Category Field/Details Required
Entities Company code, name and functional currencies
Accounts Account code, description and account type (optional)
General Ledger Balances Life-to-date balances showing current value at a specified point in time or period balances, typically post-closing at period end
Hedge Information Includes amounts, company codes and currencies

ENROLLMENT

The FiREapps Client Services team will lead your IT staff through three simple, well-defined steps: retrieving master data, testing and deploying the balances extract, and automating the file upload process.

WHAT TO EXPECT DURING ENROLLMENT

Executive Oversight

  • Status updates and issue management

Project Lead/Treasury Ops Support

  • Project Management: Resource coordination and project status tracking/communication
  • FiREapps configuration review, process workflow design and testing
  • Exposure data and definition review
  • Issues Resolution: Work with other functional departments to resolve data and process issues

Controller & Business Unit Support

  • Review and resolve multi-currency accounting system, data and process issues
  • Review and resolve G/L system revaluation configuration and process issues

IT Support

  • FiREapps Exposure Extract Report data extract setup and validation
  • Download report, test data, validate output, migrate to QA, staging, production environments
  • Automated secure file transfer setup and testing

AUTOMATED FILE EXTRACTION, ENCRYPTION & UPLOAD

Automated File Extraction, Encryption & Upload is supported through standard protocols

  • HTTPS (e.g. via cURL) and SFTP/FTPS (encrypted FTP) automate the transfer of files to a secure staging area within the FiREapps application
  • Scripts (samples provided by FiREapps) can be deployed based on the needs of your environment
  • Scripts retrieve the output generated by the FiREapps G/L Extract Program and encrypt the file(s), before transferring them over 128-bit+ HTTPS or SFTP/FTPS to FiREapps

FiREapps Client Services team will supply scripts as part of the toolkit during the enrollment process. The level of effort required to automate the file transfer is subject to the complexities of the environment, but is typically around four hours per system.

To create or modify shell scripts to automate or align with existing processes requires a:

  • Systems Administrator
  • Developer
  • DBA with privileges

WANT TO KNOW MORE?

Read The Biggest FX Problem (That No One Wants To Talk About), A White Paper Exploring FX Challenges Specific To ERP Systems.