Save Time with Secure ERP Data Loads Straight from Your Spreadsheet

Safe and secure data entry and uploading into JD Edwards or Oracle E-Business Suite directly from Excel

Save Time with Secure ERP Data Loads Straight from Your Spreadsheet

Safe and secure data entry and uploading into JD Edwards or Oracle E-Business Suite directly from Excel

Tired of duplicating processes in Excel and your ERP?

Some processes can be completed more quickly and more easily outside of your ERP. Instead of adding information to Excel and then re-keying it in your ERP, what if you could input data as you go, then upload securely to JD Edwards and Oracle EBS at the click of a button? And all this while still providing central control and honoring your ERP security model.
Request Pricing

100% of surveyed education customers were able to automate at least 10 reports.

84% surveyed organizations saved 50 – 100 hours or more in one year.

74% surveyed organizations have been able to significantly streamline data extraction from their ERP and/or other relational databases

Easily create and update ERP data right in Excel

Purpose built for JD Edwards and Oracle EBS, Spreadsheet Writeback enables you to create, delete, or modify information and load it securely into your ERP without ever having to leave Excel. Update data and upload to any ERP module, including Accounts Payable (invoice uploads and supplier maintenance), Accounts Receivables (transactions and customer maintenance), General Ledger (journals and budgets), Inventory (transactions and maintenance), Human Capital Management, Project and Task uploads, and more.

Load data back into JD Edwards and Oracle EBS
Leverage standard JDE EnterpriseOne Orchestrations, Oracle EBS public, private, and custom APIs, and open interface tables with no additional programming necessary.
Safe and secure
Inherits existing ERP security and includes data validation with standard warnings and error messages.
Simple, intuitive data upload
Data uploading utilizes Microsoft Automation to simplify data entry, data upload, and reporting.
Third-party friendly
Works with your existing custom and third-party interfaces for maximum flexibility.
Maximize business user productivity
No programming necessary, and minimal IT involvement to get started.

Minimum Software Requirements

  • Windows XP Professional Service Pack 1, Windows 2003, Windows Vista
  • SQL Server 7.0 Service Pack 4, SQL Server 2000 Server Pack 4, SQL Server 2005
  • MS Data Transformation Services (DTS) on client machines for any user processing data to SQL Server Data Marts. This includes Database Manager, Budget Writeback and all filter products. Version and service pack level must be the same as the server. Install DTS by installing Client Connectivity from SQL Server Client tools.
  • Oracle 10g for Windows: Oracle Client 9.2 or higher installed on all clients. For Oracle sites, SQL Plus must be installed on any machine where a database will be generated with new or updated account parts. Typically install on machines that will have Database Manager and Profile Management installed. The version of SQL Plus must be the same as the server
  • For Oracle sites, SQL Plus must be installed on any machine where a database will be generated with new or updated account parts. Typically install on machines that will have Database Manager and Profile Management installed. The version of SQL Plus must be the same as the server
  • For Oracle sites where source and target data is not contained in the same database, it is highly recommended that SQL Loader be installed on any machine running filter processes. This allows for best performance of filter processing. If SQL Loader does not exist the application will still run using slower data transfer methods. (See ‘Guidelines for Permissions and Database Configuration’ in the ‘Analyst Suite Readme.chm” file for more information.)
  • IBM DB2 UDB for Windows Version 8: DB2 Run-Time Clients 8.1 with fixpack 4 installed on all clients
  • IBM DB2 UDB for Windows Version 8.2: DB2 Run-Time Clients 8.2
  • MDAC 2.6 Service Pack 1 or later required on client and server machines. MDAC version is controlled by the operating system in later versions of Windows
  • Excel 9 from Office 2000 (Service Pack 1), Excel 10 from Office XP, Excel 11 from Office 2003, Excel 12 from Office 2007

Client Hardware Requirements

Hardware requirements follow the recommendations for the Operation system, Microsoft® Office version and database platform.

Venkat Ramanan
Enterprise Architect
Hines

I believe this software is very powerful for traditional Excel users who do not want to deal with the complexity of an ERP system such as JD Edwards. Reporting is so much easier now.”

Start auto-populating your data right away