JDE Stored Procedure

JDE Stored Procedure

Directly integrate with JDE from SQL

Leverage inhouse SQL skills to create powerful JDE interfaces: call any JDE functions directly from any SQL code - Triggers, Stored Procedures, etc.

Current version: 1.0

  • Product Brief
  • More Details
  • System Requirements
  • Licensing
A successful ERP implementation is often about good interfaces. And many interfaces are data-driven, making the database SQL platform the best place to code them.

This solution turns SQL into a supported platform for JDE development.

By leveraging your existing SQL skills and taking the coding closer to the database, the task of creating interfaces for JDE will become easier and the resulting code may work faster and be more flexible.
This software addresses a need to execute JDE functions from the database code - stored procedures and/or table triggers.

For instance, you can use this software to look up data using JDE BSFN's, add data to JDE through JDE BSFN's, call JDE BSFN's to submit jobs, etc.

It will also be a perfect fit, if you use a lot of plain-SQL reporting in your organization: it will become a complete solution with this software, allowing you to do more on the SQL side, including such functionality in JDE that could not be re-made in plain SQL. SQL reporting will always be faster than using any external reporting tools, making it a very attractive option for many companies. It has always been the inability to call JDE (for both reading the data from and writing the data to) from the SQL scripts that was making this approach impractical for some applications. It will also save such users a lot of time and effort, because many fewer JDE processes would have to be rewritten in SQL, and make the final solutions smaller and more manageable.

Another powerful solution would be to implement a tighter database-to-JDE integration for real-time transactions, for instance to do posts through BSFN calls immediately from table triggers, which would be much faster and substantially more efficient than running periodic or subsystem jobs, polling the tables and wasting the server performance.

And of course by enabling any database server to communicate directly with your JDE system, all kinds of integrations are now possible at the database level. Please try this approach for your next integration project - you will be pleasantly surprised how easy this is.

There are eight different editions of this software, depending on whether it's for Oracle or MS SQL Server database, each in either 32- or 64-bit version and for these four combinations, two sub-editions each - one using "C API" to access JDE and the other one using XML.

When purchasing, please e-mail us stating which of these products you are specifically after. Licensing is "Per Server", in this case this is effectively per Database Server.

Please note, that with XML implementations this database server does not need to be in any way related to JDE at all. The thin JDE XML client component consists of only a few files, which need to be installed on this database server, but apart from this, it can be any database server in the network - reporting database, another system's database, etc.

Existing database development/administration skills can be leveraged in any project utilizing these products. In effect, these stored procedures fill in the void between different skillsets, enabling database and SQL-skilled application professionals and power users to comfortably work with JDE just the way they like it. All latest versions of MS SQL Server and Oracle are supported.

Both 32-bit & 64-bit Windows/Intel platforms are supported (sold as different products). The functions will in all cases be executed on the JDE Server, so client-only functions cannot be used. From the Windows security point of view, these functions will be executed in the context of the Windows user, which JDE Services are configured to start up as - this can be either BUILTIN\System account, local Server's or Windows Domain account, as configured. From the JDE security point of view, these functions will be executed as the user, whose credentials were passed into the stored procedure.

The 64-bit implementations use our state-of-the-art proprietary Refusion technology to enable 64-bit servers to communicate with 32-bit libraries of JDE, without compromising the ease of installation and use of the software. All executables are digitally signed for extra protection. Limited Trial versions are available - please e-mail us.

Very simple installation. Inherently easy to use - just run the stored procedure with the BSFN & connection parameters and receive the results back in a tabular format:

for MS SQL Server, or for Oracle database:

All errors are reported just the same as in any other stored procedure. Additional enhancements (including non-JDE functionality) are possible, please inquire.

For additional security, password encryption enhancement can be delivered as an extra add-on.

Hosting Database: MS SQL Server 2000 & up or Oracle 9i & up, either x32 or x64 editions. - this does not need to, but can be a JDE DB.
OS: MS Windows (x32 or x64)
OS Versions: 2000, 2003/Vista, 2008/Windows 7
OS Editions: Workstation or Server, excluding Home Edition
CPU: Intel or AMD (x32 or x64)
System Type: Physical or Virtual
JDE Releases: XE (B7333), ERP8 (B7334), B9 (E1 8.9), E810, E811 (including E811 SP1), E812, E900, E910, E920
JDE Tools Releases (pre-Unicode): SP16 onwards
JDE Tools Releases (Unicode): TR891 onwards
JDE Backend Hardware Platforms: hardware-independent - all platforms supported by JDE are supported
JDE Backend Database Platforms: DB-independent - all platforms supported by JDE are supported

This software is licensed "Per Database Server".

The optional Yearly Update/Upgrade Subscription is available at the time of purchase (not available separately) for an additional yearly fee. It is payable in advance per license, per year. It includes premium support and all software updates released during the paid period. Its cost is calculated as 20% of the product's list price at the time of invoicing, as may change from time to time. Unless the software is purchased for a single use application, we generally recommend to opt in for this Subscription: any future JDE Tools Releases and Releases/Updates may require an updated version of this solution and it's generally more cost-efficient compared to one-off Upgrades.
Related products:

For JDE interfaces:
Media Object Attachment interface - One Attachment Manager
World-fastest REST interface - EveREST2JDE