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 products marketed under this name:

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:

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.