際際滷

際際滷Share a Scribd company logo

App Load Presentation 2009

Download as PPT, PDF
S
sundu72

New generation data conversion, extraction and interfacing productivtity tool for Oracle E-Business Suite R12 and 11i.

1 of 32
Download to read offline
app LOAD family of Productivity Tools app LOAD Team: Robert Keating Keith Meddock Sundu Rathinam Chain- Sys Corporation
Introduction Traditional data conversion model app LOAD suite data conversion model app LOAD suite processes app LOAD tool features and benefits app INTERFACE features and benefits app EXTRACT features and benefits app MIGRATE features and benefits Demonstration Comparisons Customer Testimonials Q and A Agenda
Company Profile CHAIN SYS is a fast growing management consulting/ product development company. Established in 1998 and headquartered in Lansing, MI, with more than 350+ engineers working worldwide. Strong Partnership with Oracle Corporation. Oracle EBS, Database and Middleware products Reseller Oracle Certified Partner Oracle EBS Mobility Solution Provider Oracle University Authorized Education provider and Center Oracle Consulting Services (ORS/NAC/NAIO/SSI) Partner Proud developers and owners of: e- chain ERP/SCM suite for SME Products for Oracle EBS: app LOAD family of productivity tools for Oracle EBS R12/11i Networking Products: Gopster Network Test Tools Company Profile
app LOAD Suite Introduction app LOAD is a new generation data conversion and interfacing tool for Oracle E-Business Suite R12/11i. This tool aims to reduce the cost of Oracle EBS data conversion, extraction and interfacing activities. Any business user can confidently use this tool and convert/ interface data into Oracle E-Business Suite with little if any technical assistance. With app LOAD , there is no additional programming needed for all your data conversion/interfacing needs. app LOAD supports all the open interfaces and APIs available within Oracle E-Business Suite R12/R11i. app LOAD works on the hub and spoke model .
app LOAD Suite Architecture
appLOAD Suite Architecture (Cont) Web Tier Struts / Tiles Controller Action Form Custom Action JSP (View) Web Service Axis 1.4 (JAX - RPC) WSDL POJO WSDD Business Tier Delegates Business Object Business Interfaces Integration Tier Abstract DAO Factory DAO Factory DAO Interface DAO Implementation
app LOAD Suite Architecture (Cont) app INTERFACE Engine app LOAD Engine app XTRACT Engine FTP XML XLS CSV External DB Web Interface Web Service HTTP request e chain Oracle EBS PLM e chain Oracle EBS PLM
Oracle EBS Traditional Data Loading Through Interface Validation Procedure Flat File Base Table Interface Table Staging Table SQL Loader Import Program
app LOAD Data Loading through app LOAD Excel File Base Table Interface Table / API Staging Table Validation Procedure Import Program
Oracle EBS Traditional Error Viewing or Retrieval Staging Table CSV file Base Table Interface Table Error_ Message Error_Flag Error Table
Error Handling with app LOAD Excel File Base Table Interface Table/ API Staging Table Error_ Message Error_Flag Error Table Error Message into Excel
XML Editor Map the data load configurations for Oracle E-Business Suite (EBS) R12/R11i using the XML Editor. All the configurations for open Interfaces and Application programmable interfaces (API) comes pre-seeded with the system install. Loader Setup Add Attributes Pre-Validation Translation Rules Concurrent Input SQL Query Validation IT/User Inputs for Data Load Pre-seeded Inputs for Data Load Validation Correction Execution Data load launch processes Chain-Sys Business User IT Division or User Data Loading Process
app LOAD Tool Features Open Interfaces All open interfaces within Oracle E-Business Suite R12/11i are available through appLOAD. Application Programmable Interfaces (APIs) All APIs (Exposed and Unexposed) of Oracle E-Business Suite R12/11i are available through appLOAD. Excel Input appLOAD accepts data input in excel and CSV format. Sample data templates are provided with the software. Data templates are flexible to accommodate changes. Data Validation appLOAD provides powerful validation checks. System shows clear warnings and errors reflecting the actual data load process. 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 the standard templates.
Data Translation appLOAD provides features such as: change case, to-date, to-char, decode statements, SQL pre-validations and results based on SQL Query or Constant. Complex data translation needs are handled. Scalability appLOAD tool is scalable to load any number of rows in a single load. Decide on the batch size based on the pre-validations required. Data Corrections appLOAD writes the errors back to Excel input file. Separate info provided for processed data, unprocessed data and erroneous data after the data load process is completed. User-friendliness appLOAD is designed for business users. Easy and intuitive to use HTML user interface. Online help documentation and instructional movies. app LOAD Tool Features (cont.)
Saves cost and time on data loading. Cost savings up to 90%. Assured high quality data conversion program. Hub and Spoke model. New revolutionary concept. Simple configurations. No additional programming needed. Easy and intuitive to use. Data Load Tool for Business Users. Technical consultants not needed. Reduce Oracle implementation time frame. Data load is available as Software as a Service app LOAD Tool Benefits
FTP Service You can build inbound and outbound interfaces through secure FTP service for Oracle E-Business Suite R12/11i. Appload Service You can build inbound and outbound interfaces through secure AppLOAD server service. On this model the data is exchanged through appLOADs application server. Service oriented architecture (SOA) Service You can orchestrate web services to build inbound and outbound interfaces for Oracle E-Business Suite R12/11i. The web services are implemented with high security and the data is transmitted over the web in an encrypted manner. Process logs and notifications Each interface process is run as a background job. The logs are maintained against the processes. The system automatically creates processed, unprocessed, and error record files regarding the runtime. E-mail notifications are sent to the user launching the process, with all the essential status and output file information. + All of the appLOAD Features Apply app INTERFACE Tool Features
Save up to 90% cost and time in building data interfaces into Oracle EBS 11i/R12. Service Oriented Architecture (SOA) enabled. Highly secure and data encrypted. Achieve 100% Inter-Operability. Makes app LOAD and app EXTRACT products extremely powerful with web service orchestration. Works seamless with Oracle Fusion Middleware products such as ESB and BPEL High Quality and Robust data interfacing framework. app INTERFACE Tool Benefits
Preprocessing Engine app EXTRACT provides a strong PL/SQL preprocessing engine. You can write custom PL/SQL package to preprocess the data for data extraction. The processing can dynamically use the action performed by the preprocessing engine. Database Independence app EXTRACT is capable of processing data from any database. Certified databases include Oracle, DB2, and SQL Server. As our commitment towards open source we also certify for MySQL database. Data Output app EXTRACT can output the data in various formats such as: XLS, CSV, TXT, XML, HTML, and PDF. The formatted data output from app EXTRACT can be used for data loading and reporting purposes. app EXTRACT Tool Features
appLOAD and appINTERFACE Integration Engine appEXTRACT is delivered with built-in appLOAD and appINTERFACE integration engines. This enables you to extract the data from other systems and load into Oracle E-Business suite without additional programming. Scheduling Engine appEXTRACT has automated scheduling of extraction routines. The scheduler can process one time request or periodic continuous extracts. The scheduler also loads the data extracted using appEXTRACT automatically into Oracle E-Business Suite. Jasper Reporting Engine appEXTRACT can be used as a reporting tool as well. It is integrated with Jasper reporting engine to create clean formatted reports in the PDF, XLS and HTML formats. Security appEXTRACT templates are secured for modification and execution by users accounts. app EXTRACT Tool Features (cont.)
Robust and simple SQL based data extraction engine. Confidently extract data from any database such as: Oracle, DB2, SQL Server, Sybase and MySQL. Substantially reduces time and effort in data extraction. app EXTRACT can be web-service enabled using app INTERFACE . Extraction can be a scheduled process. The scheduler can also use the extract to load into Oracle EBS 11i/ R12 using app LOAD . Highly affordable. Quick Return on investment. app EXTRACT Tool Benefits
app MIGRATE Tool Features
Migrate old Oracle E-Business suite 10.5, 10.7, 11.0.3, 11i master and transactional data into the latest releases of Oracle EBS R/12/11i without additional programming. Save up to 90% cost on any new Oracle EBS R12 data migration project. app MIGRATE Tool Benefits
app LOAD Demo
app LOAD Differentiators
Product Comparisons
What do current enterprise-level customers think about app LOAD ? Customer Testimony .
Teknion Inc. Oracle Configurator Template for CZ Item Conversion Oracle Configurator Template for CZ Item Modification Oracle Configurator Template for CZ Non BOM Model Conversion Oracle Configurator Template for CZ Non BOM Model Modification Oracle Bills of Material / BOM Template Modification Oracle Configurator Template for CZ Non BOM Model Properties Conversion Oracle Configurator Template for CZ Non BOM Model Properties Modification Oracle Bills of Material / BOM Template with Automatic Item Creation You and your people have been able to create templates for an area of Oracle which had never before been touched and updated in such a rapid time. You all deserve my greatest appreciation and thanks for your efforts. This will also go a long way for CHAIN SYS as other Configurator users will benefit from such templates to use. Edward Wilson, Product Database Specialist, Teknion Corporate Marketing app LOAD Customer : Toronto, Canada CHAIN SYS Products and Services: app LOAD Industry: Furniture CHAIN-SYS Partner: IBM Canada
Hypercom Corporation [the] app LOAD tool helped us tremendously in reducing our project time lines for converting large amounts of data from various legacy systems into Oracle. We were able to achieve the data conversion with very limited technical resources. Especially support team is very responsive. We got every penny of our investment from this tool. Ravi Dayakar , Director, Enterprise Applications, Hypercom app LOAD Customer : Scottsdale, AZ CHAIN SYS Products and Services: app LOAD Industry: Payment CHAIN-SYS Partner: PWC, Oracle General Ledger / Journal Entries AP Invoices (Both Open and Closed) AP Payments Vendors, Sites and Contacts Customers, Sites and Contacts AR Invoices (For both open and Closed) AR Receipts Fixed Assets Sales Orders and Lines (Both Open and Closed) Purchase Orders (Both Open and Closed) Items with Rev., Categories and Org. Assignments On Hand Quantities with Serial Numbers Item Cost (Standard) Service Contracts Employees and History BOMS Routings ECO Item Cost (Resource, Ohd, Material and Material Ohd) Approved Supplier list MRP Forecast Installed Base
American Axle Manufacturing Inc. World leaders in Automobile Axle manufacturing with production units in USA, Mexico, Europe, China, India and Japan. app LOAD Customer : Detroit, MI CHAIN SYS Products and Services: app LOAD Industry: Automotive CHAIN-SYS Partner: Internal Team Item with cost and revision Sub inventory Assignment Customer Items Customer Item Cross Reference Price list creation and updation Sales order Item Categories Bills of Material Routings Miscellaneous Receipt Miscellaneous Issue Account Alias Transaction Work order less completion
Our Happy app LOAD Productivity Suite Customers (partial list)
Questions?
www.chain-sys.com [email_address] Chain Sys Corporation 325 S Clinton St, Suite 205 Grand Ledge MI 48837 Tel: 517-627-1173 ext 203 Chain Sys (India) Pvt. Ltd. World HQ Development Center 3 rd Floor Sarovar, 670 SBOA School Rd, Anna Nagar (West), Chennai 600 101 Tel: (91)-(44)-2615 5580/81/82/83 Other office locations: UK, UAE, and Singapore. Thank You!!

More Related Content

App Load Presentation 2009

  • 1. app LOAD family of Productivity Tools app LOAD Team: Robert Keating Keith Meddock Sundu Rathinam Chain- Sys Corporation
  • 2. Introduction Traditional data conversion model app LOAD suite data conversion model app LOAD suite processes app LOAD tool features and benefits app INTERFACE features and benefits app EXTRACT features and benefits app MIGRATE features and benefits Demonstration Comparisons Customer Testimonials Q and A Agenda
  • 3. Company Profile CHAIN SYS is a fast growing management consulting/ product development company. Established in 1998 and headquartered in Lansing, MI, with more than 350+ engineers working worldwide. Strong Partnership with Oracle Corporation. Oracle EBS, Database and Middleware products Reseller Oracle Certified Partner Oracle EBS Mobility Solution Provider Oracle University Authorized Education provider and Center Oracle Consulting Services (ORS/NAC/NAIO/SSI) Partner Proud developers and owners of: e- chain ERP/SCM suite for SME Products for Oracle EBS: app LOAD family of productivity tools for Oracle EBS R12/11i Networking Products: Gopster Network Test Tools Company Profile
  • 4. app LOAD Suite Introduction app LOAD is a new generation data conversion and interfacing tool for Oracle E-Business Suite R12/11i. This tool aims to reduce the cost of Oracle EBS data conversion, extraction and interfacing activities. Any business user can confidently use this tool and convert/ interface data into Oracle E-Business Suite with little if any technical assistance. With app LOAD , there is no additional programming needed for all your data conversion/interfacing needs. app LOAD supports all the open interfaces and APIs available within Oracle E-Business Suite R12/R11i. app LOAD works on the hub and spoke model .
  • 5. app LOAD Suite Architecture
  • 6. appLOAD Suite Architecture (Cont) Web Tier Struts / Tiles Controller Action Form Custom Action JSP (View) Web Service Axis 1.4 (JAX - RPC) WSDL POJO WSDD Business Tier Delegates Business Object Business Interfaces Integration Tier Abstract DAO Factory DAO Factory DAO Interface DAO Implementation
  • 7. app LOAD Suite Architecture (Cont) app INTERFACE Engine app LOAD Engine app XTRACT Engine FTP XML XLS CSV External DB Web Interface Web Service HTTP request e chain Oracle EBS PLM e chain Oracle EBS PLM
  • 8. Oracle EBS Traditional Data Loading Through Interface Validation Procedure Flat File Base Table Interface Table Staging Table SQL Loader Import Program
  • 9. app LOAD Data Loading through app LOAD Excel File Base Table Interface Table / API Staging Table Validation Procedure Import Program
  • 10. Oracle EBS Traditional Error Viewing or Retrieval Staging Table CSV file Base Table Interface Table Error_ Message Error_Flag Error Table
  • 11. Error Handling with app LOAD Excel File Base Table Interface Table/ API Staging Table Error_ Message Error_Flag Error Table Error Message into Excel
  • 12. XML Editor Map the data load configurations for Oracle E-Business Suite (EBS) R12/R11i using the XML Editor. All the configurations for open Interfaces and Application programmable interfaces (API) comes pre-seeded with the system install. Loader Setup Add Attributes Pre-Validation Translation Rules Concurrent Input SQL Query Validation IT/User Inputs for Data Load Pre-seeded Inputs for Data Load Validation Correction Execution Data load launch processes Chain-Sys Business User IT Division or User Data Loading Process
  • 13. app LOAD Tool Features Open Interfaces All open interfaces within Oracle E-Business Suite R12/11i are available through appLOAD. Application Programmable Interfaces (APIs) All APIs (Exposed and Unexposed) of Oracle E-Business Suite R12/11i are available through appLOAD. Excel Input appLOAD accepts data input in excel and CSV format. Sample data templates are provided with the software. Data templates are flexible to accommodate changes. Data Validation appLOAD provides powerful validation checks. System shows clear warnings and errors reflecting the actual data load process. 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 the standard templates.
  • 14. Data Translation appLOAD provides features such as: change case, to-date, to-char, decode statements, SQL pre-validations and results based on SQL Query or Constant. Complex data translation needs are handled. Scalability appLOAD tool is scalable to load any number of rows in a single load. Decide on the batch size based on the pre-validations required. Data Corrections appLOAD writes the errors back to Excel input file. Separate info provided for processed data, unprocessed data and erroneous data after the data load process is completed. User-friendliness appLOAD is designed for business users. Easy and intuitive to use HTML user interface. Online help documentation and instructional movies. app LOAD Tool Features (cont.)
  • 15. Saves cost and time on data loading. Cost savings up to 90%. Assured high quality data conversion program. Hub and Spoke model. New revolutionary concept. Simple configurations. No additional programming needed. Easy and intuitive to use. Data Load Tool for Business Users. Technical consultants not needed. Reduce Oracle implementation time frame. Data load is available as Software as a Service app LOAD Tool Benefits
  • 16. FTP Service You can build inbound and outbound interfaces through secure FTP service for Oracle E-Business Suite R12/11i. Appload Service You can build inbound and outbound interfaces through secure AppLOAD server service. On this model the data is exchanged through appLOADs application server. Service oriented architecture (SOA) Service You can orchestrate web services to build inbound and outbound interfaces for Oracle E-Business Suite R12/11i. The web services are implemented with high security and the data is transmitted over the web in an encrypted manner. Process logs and notifications Each interface process is run as a background job. The logs are maintained against the processes. The system automatically creates processed, unprocessed, and error record files regarding the runtime. E-mail notifications are sent to the user launching the process, with all the essential status and output file information. + All of the appLOAD Features Apply app INTERFACE Tool Features
  • 17. Save up to 90% cost and time in building data interfaces into Oracle EBS 11i/R12. Service Oriented Architecture (SOA) enabled. Highly secure and data encrypted. Achieve 100% Inter-Operability. Makes app LOAD and app EXTRACT products extremely powerful with web service orchestration. Works seamless with Oracle Fusion Middleware products such as ESB and BPEL High Quality and Robust data interfacing framework. app INTERFACE Tool Benefits
  • 18. Preprocessing Engine app EXTRACT provides a strong PL/SQL preprocessing engine. You can write custom PL/SQL package to preprocess the data for data extraction. The processing can dynamically use the action performed by the preprocessing engine. Database Independence app EXTRACT is capable of processing data from any database. Certified databases include Oracle, DB2, and SQL Server. As our commitment towards open source we also certify for MySQL database. Data Output app EXTRACT can output the data in various formats such as: XLS, CSV, TXT, XML, HTML, and PDF. The formatted data output from app EXTRACT can be used for data loading and reporting purposes. app EXTRACT Tool Features
  • 19. appLOAD and appINTERFACE Integration Engine appEXTRACT is delivered with built-in appLOAD and appINTERFACE integration engines. This enables you to extract the data from other systems and load into Oracle E-Business suite without additional programming. Scheduling Engine appEXTRACT has automated scheduling of extraction routines. The scheduler can process one time request or periodic continuous extracts. The scheduler also loads the data extracted using appEXTRACT automatically into Oracle E-Business Suite. Jasper Reporting Engine appEXTRACT can be used as a reporting tool as well. It is integrated with Jasper reporting engine to create clean formatted reports in the PDF, XLS and HTML formats. Security appEXTRACT templates are secured for modification and execution by users accounts. app EXTRACT Tool Features (cont.)
  • 20. Robust and simple SQL based data extraction engine. Confidently extract data from any database such as: Oracle, DB2, SQL Server, Sybase and MySQL. Substantially reduces time and effort in data extraction. app EXTRACT can be web-service enabled using app INTERFACE . Extraction can be a scheduled process. The scheduler can also use the extract to load into Oracle EBS 11i/ R12 using app LOAD . Highly affordable. Quick Return on investment. app EXTRACT Tool Benefits
  • 21. app MIGRATE Tool Features
  • 22. Migrate old Oracle E-Business suite 10.5, 10.7, 11.0.3, 11i master and transactional data into the latest releases of Oracle EBS R/12/11i without additional programming. Save up to 90% cost on any new Oracle EBS R12 data migration project. app MIGRATE Tool Benefits
  • 23. app LOAD Demo
  • 24. app LOAD Differentiators
  • 26. What do current enterprise-level customers think about app LOAD ? Customer Testimony .
  • 27. Teknion Inc. Oracle Configurator Template for CZ Item Conversion Oracle Configurator Template for CZ Item Modification Oracle Configurator Template for CZ Non BOM Model Conversion Oracle Configurator Template for CZ Non BOM Model Modification Oracle Bills of Material / BOM Template Modification Oracle Configurator Template for CZ Non BOM Model Properties Conversion Oracle Configurator Template for CZ Non BOM Model Properties Modification Oracle Bills of Material / BOM Template with Automatic Item Creation You and your people have been able to create templates for an area of Oracle which had never before been touched and updated in such a rapid time. You all deserve my greatest appreciation and thanks for your efforts. This will also go a long way for CHAIN SYS as other Configurator users will benefit from such templates to use. Edward Wilson, Product Database Specialist, Teknion Corporate Marketing app LOAD Customer : Toronto, Canada CHAIN SYS Products and Services: app LOAD Industry: Furniture CHAIN-SYS Partner: IBM Canada
  • 28. Hypercom Corporation [the] app LOAD tool helped us tremendously in reducing our project time lines for converting large amounts of data from various legacy systems into Oracle. We were able to achieve the data conversion with very limited technical resources. Especially support team is very responsive. We got every penny of our investment from this tool. Ravi Dayakar , Director, Enterprise Applications, Hypercom app LOAD Customer : Scottsdale, AZ CHAIN SYS Products and Services: app LOAD Industry: Payment CHAIN-SYS Partner: PWC, Oracle General Ledger / Journal Entries AP Invoices (Both Open and Closed) AP Payments Vendors, Sites and Contacts Customers, Sites and Contacts AR Invoices (For both open and Closed) AR Receipts Fixed Assets Sales Orders and Lines (Both Open and Closed) Purchase Orders (Both Open and Closed) Items with Rev., Categories and Org. Assignments On Hand Quantities with Serial Numbers Item Cost (Standard) Service Contracts Employees and History BOMS Routings ECO Item Cost (Resource, Ohd, Material and Material Ohd) Approved Supplier list MRP Forecast Installed Base
  • 29. American Axle Manufacturing Inc. World leaders in Automobile Axle manufacturing with production units in USA, Mexico, Europe, China, India and Japan. app LOAD Customer : Detroit, MI CHAIN SYS Products and Services: app LOAD Industry: Automotive CHAIN-SYS Partner: Internal Team Item with cost and revision Sub inventory Assignment Customer Items Customer Item Cross Reference Price list creation and updation Sales order Item Categories Bills of Material Routings Miscellaneous Receipt Miscellaneous Issue Account Alias Transaction Work order less completion
  • 30. Our Happy app LOAD Productivity Suite Customers (partial list)
  • 32. www.chain-sys.com [email_address] Chain Sys Corporation 325 S Clinton St, Suite 205 Grand Ledge MI 48837 Tel: 517-627-1173 ext 203 Chain Sys (India) Pvt. Ltd. World HQ Development Center 3 rd Floor Sarovar, 670 SBOA School Rd, Anna Nagar (West), Chennai 600 101 Tel: (91)-(44)-2615 5580/81/82/83 Other office locations: UK, UAE, and Singapore. Thank You!!