appLOAD - a next generation data loading tool for Oracle E-Business Suite R12/11i

apploadappLOAD is a new generation data conversion tool for Oracle E-Business Suite 11i/R12. The tool significantly reduces project timelines and cuts costs. Extremely useful during implementation or reimplementation of Oracle E-Business Suite and for routine production data maintenance. Very easy to use and does not need programming. Supports all open interfaces and APIs.

overview
no prog Business Users can use the tool with confidence for their data loading needs with no technical assistance. appLOAD is a flexible configuration engine which needs no programming.
pre validation It has extensive pre-validation, cleansing and correction capabilities.
saas Available as "Software as a Service"
xml It accepts data input in excel, csv, and xml formats. Also accepts inputs directly from database.
stop watch Our customers have experienced over 80% reduction in the cost and time of data loading activities.

demo request appload

demo request appload

demo request appload
appload timeline

Configuration - Chain-Sys provides a free proof of concept for your data loading requirements. This becomes the baseline for the initial appLOAD template. So our customers get the template with over 95% of their business requirements mapped. We have over 100 templates available immediately.

Mapping- appLOAD users can extend the base templates mapping between input excel/xml/csv/database files against open interface tables or API's. This is a simple drag and drop operation.

Transformation- appLOAD has a powerful and yet easily configurable data transformation engine. Using this engine the users can transform the input data to a different value based on conditions as required.

Validation- appLOAD proves to be a valuable asset for highly configurable and flexible pre-validation engine. Chain-Sys provides many standard pre-validations along with the template. The end users can add further pre-validations as needed. This engine helps the users to stop any incorrect data from being processed and shows cumulative totals of records processed, unprocessed and errored.

Cleansing- appLOAD provides extensive data cleansing capabilities at the pre-validation stage. The source and destination data is compared using our proprietary algorithms. Cleansing engine will show the matching percentage for the source data in comparison to the target. Automatic threshold factor can be introduced to allow the system to match the source and the target data.

Correction- appLOAD provides extensive and flexible features for data correction. Both offline and online data correction is available.  The corrected data can be re-validated as required. appLOAD also shows cumulative total records processed, unprocessed and errored. Email and dashboard notifications for corrections are provided.

Execution- appLOAD handles the data load execution process in the application server. Multiple processes can be executed simultaneously. appLOAD's execution is very robust and scalable. There is no need for manual monitoring and intervention.

  • No programming needed
  • Simple configurations
  • Intuitive and easy to use
  • 200+ Configurable Adapters
  • Easy scheduling of loads
  • Designed for Business Users
  • Benchmarked for multi-millionrecords in a single load
  • Data Cleansing
  • Extensive Audits
  • Secure
  • Available in SaaS, Cloud
  • Robust Java/J2EE Technology
  • Is not front end driven or excel macro based
  • Scalable Data Management
  • Enterprise Quality

Data from Excel into Oracle E-Business Suite (EBS)
appLOAD loads data available in Excel in Spreadsheets into Oracle E-Business Suite (EBS). appEXTRACT which is another products in the appLOAD Suite extracts data from Oracle E-Business Suite (EBS) into Excel Spreadsheets. Spreadsheets formats can be xls, xlsx and csv. The appLOAD Suite sports a very user friendly GUI.

The Excel data can be reviewed , transformed, validated and corrected before loading the data into Oracle E-Business Suite (EBS). appLOAD's configurable Excel templates have color coding for easy differentiation between mandatory and non-mandatory fields.

Excel can be used as a convenient user interface for Data Entry into Oracle E-Business Suite (EBS) for example, HR Departments can collect Excel based expense reports from employees and submit all of them to Oracle E-Business Suite (EBS).

appLOAD uses Excel only as a Data source and does not use any Excel macros. appLOAD is an well accepted Data Loader to for EBS and Data Loader and Data Conversion tool for EBS

appMIGRATE architecture
Technical Specifications for the appLOAD suite

The document comes up with the following technical specifications for the appLOAD suite

  • Hardware and Software requirements
  • Platform Certifications
    • Operating System
    • Application Servers
  • System Architecture
  • Technical Architecture

Software Requirements

The following are the software pre-requisites for the appLOAD suite.

  • J2SE 5 – Java 2 Standard Edition 5 (JDK 1.5.x)
  • Oracle 10 g Enterprise Edition
  • J2EE Application Server

Hardware Requirements

Server Capacity varies with the quantum of data and transactions. An approximate server configuration would need the following

  • Should be a server hardware
  • Processor – Dual-Core Intel Core2 Duo processor (2 GHz and 2 MB Cache or higher)
  • Memory – 8 GB memory or Higher
  • Drives – Hard Disk Drive (HDD) 160 GB

Operating Systems

appLOAD suite can run on the following operating systems

  • Oracle Linux 5.5
  • Microsoft Windows Server Editions (XP / 2003 / 2008 / VISTA)
  • Redhat Linux Enterprise Edition (4.x / 5.x) server
    • Certified by redHat  and runs well with the RHEL server versions as well.

Application Servers

appLOAD suite can run on the following J2EE Application/Web servers

  • Oracle Application server 10.1.3.x
  • JBoss Enterprise Web Server 4.x and 5.x
  • Apache Tomcat 5.5 and 6.0
  • Support WebLogic 11.1

technical architecture

Specifics of the Architecture

The Model-View-Controller (MVC) pattern, originally developed to support the Smalltalk language, supports a logical separation between presentation (view), application (controller) and the data (model) layers of the system.
As developers have grown familiar with the J2EE architecture, it has become increasingly apparent that access to the data, or persistent storage layer, through enterprise beans often incurs an unnecessary overhead. This overhead is a result of the transactional support provided through these components. In general, read-only access to data is much more common than transactional (create, update, delete) access.
As a result, non-transactional methods for access to the persistent data layer have been developed. These methods continue to provide the abstraction between applications and data, but don't incur the overhead associated with an enterprise bean approach. Chainsys intended to develop frameworks that implement these data access methods to support access to the persistent data layer without an enterprise bean implementation.(Bulk) Mass updates for EBS
This architecture is based upon the Struts MVC pattern and provides abstractions between the various tiers of the architecture. The dataflow is as follows:
Step 1 – Browser sends request to HTTP server via a URL that forwards the request to the Web application server. Based on the <servlet-mapping> entries in web.xml, the application server passes the requests having matching URL patterns, to the Struts Controller Servlet.
Step 2 – The Struts Controller Servlet matches the incoming request to a Struts Action. Further Struts Controller Servlet based on the action mappings passes control either directly to a JSP or instantiates the Action Form associated with the Struts Action. Struts populates the Action Form using the HTTP request parameters and stores the form bean in either HTTP request or HTTP session based on the form scope.
Step 3 – The Custom Action creates a Value Object (VO) and sets its attributes using data provided within the Action Form. It then calls Business Delegate method with VO as parameter. The Business Delegate serves to abstract the lookup of other resources and the methods accessed by the Custom Action
Step 4 – Business Delegate directs application business logic and calls other business objects to affect the application workflow.
Step 5 – Business Object requiring data access uses DAO Factory. A DAO Factory provides connections to a specific data store and implements retrieval of various DAOs.
Step 6 –DAO Implementation implements DAO Interface and provides interaction with Persistent Data (in some cases) via embedded SQL. For other sources of Persistent Data, this access may include EDI interfaces, XML exchanges or proprietary formats. The getDAO () method of the DAO Factory instantiates a new DAO Implementation object.
Step 7 –DAO object reference is passed to the Business Object.
Step 8 – Object calls CRUD operations on DAO Interface.
Step 9 – DAO Interface abstracts data store request to data store-specific DAO Implementation.
Step 10 – Data Access Object (DAO) accesses Persistent Data through JDBC or data store-specific interface.
Step 11 – Persistent Data is returned to DAO Implementation.
Step 12 – DAO Implementation converts retrieved data into list of VO's.
Step 13 – DAO Interface passes VO list back.
Step 14 – Business Objects passes VO list back.
Step 15 – Business Delegate passes VO list back.
Step 16 – Custom Action places results embedded list of VOs into either the HTTP Request Object or HTTP Session Object depending on whether the information is session-persistent or transactional in nature. The Custom Action returns a "forward" tag attribute value to the Controller Servlet, indicating the next URI to which the flow should proceed.
Step 17 – Controller Servlet identifies and forwards request to the appropriate JSP for the above Custom Action.
Step 18 – JSP assembles HTML page and responds to browser with resulting page.

system architecture

Application programmable interfaces (API)

Data Validation

Software as a service

Data Transformation

Data Corrections

Open Interfaces

Excel Input

Data Mapping

User Friendliness

Scalability

Security

Integration with appLOAD suite

Application programmable interfaces (API):

All APIs of Oracle E-Business Suite R12/11i are available through appLOAD.

go up button

Data Validation:

appLOAD provides powerful validation checks. The system shows clear warnings and errors reflecting the actual data load process.

go up button

Software as a service:

Data load capabilities of appLOAD are available as service. appLOAD can be accessed over the internet with high security.

go up button

Data Transformation:

appLOAD provides features such as: Change Case, to-Date, to-Char, Decode Statements, SQL Pre-Validations, as well as Results based on SQL Query or Constant. Complex data translation needs are handled smoothly.

go up button

Data Corrections:

appLOAD writes any errors back to the Excel input file. Separate info is provided for Processed Data, Unprocessed Data and Erroneous Data after the data load process is complete.

go up button

Open Interfaces:

All open interfaces within Oracle E-Business Suite R12/11i are available through appLOAD. 11i to R12

go up button

Excel Input:

appLOAD accepts data input in excel format. Sample data templates are provided with the software. Data templates are highly flexible to accommodate changes.

go up button

Data Mapping:

appLOAD offers easy data mapping between the excel input and the open interface table columns and API input and output parameters. It is a simple drag-and-drop model. Extra column mapping is allowed over and above standard template mappings.

go up button

User Friendliness:

appLOAD is designed for business users. It provides an easy and intuitive HTML user interface, online help documentation, and instructional movies.

go up button

Scalability:

appLOAD loads any size excel file in a single load. This applies up to the CSV and XML inputs.

go up button

Security

Helps protect sensitive data in non-production instances. Simple Configurations. No Programming needed. Protection coexists with Referential Integrity. Helps in SOX compliance.

go up button

Integration with appLOAD suite

go up button

  • Sep 28 2014
    Chain-Sys exhibited at Oracle Open World 2014, September 28th – October 2nd, 2014, at the San Francisco, USA.
  • Apr 07 2014
    Chain-Sys exhibiting and presenting Papers at Collaborate 14, April 7th - 11th, 2014, in Las Vegas, NV
  • Mar 13 2014
    Chain-Sys exhibiting and presenting at NCOAUG Training Day, Mar 13th, 2014, in Chicago, Illinois
  • Feb 18 2014
    Chain-Sys in association with Oracle and presenting "The Road to Business Excellence using Oracle EBS", Feb 18th, 2014, at the Chennai
  • Oct 20 2013
    Chain-Sys will be exhibiting in the Oracle Pavilion, October 20th – 24th, 2013, at the Dubai World Trade Centre, Dubai
  • Sep 22 2013
    Chain-Sys exhibited and presented Papers at Oracle OpenWorld 2013, September 22rd – 26th, 2013, at the San Francisco, USA.
  • July 30 2013
    Chain-Sys solution architect will present on our CRM integration solution on July 30th, 2013, Pittsburgh, USA.
  • June 10 2013
    We had a successful exhibit at NEOUG 2013 in worcester,MA.
  • Apr 07 2013
    Chain-Sys exhibited and presented Papers at Collaborate 13, April 07th - 11th, 2013, in Denver, Colorado.
  • Feb 22 2013
    Chain-Sys exhibited and presented at NCOAUG Training Day in booth 104, Feb 22nd, 2013, in Chicago, Illinois.
  • Nov 15 2012
    Visit us at OAUG Connection Point, Nov 15th – 16th, 2012, at the San Diego.
  • Nov 14 2012
    Visit us at the Michigan Oracle Users Summit 2012 (MOUS).

  • Archives
Config Mapping Trasnformation Valdiation Cleansing Correction Execution