JDEDirect setup in E1 9.0

Hello everybody,

Can anyone let us know how to setup/configure JDEDirect in 9.0. Thanks in advance.

Naveen
Jd Edwards 9.0/Windows 2008/SQL 2008.

What specifically are you having issues with? The product definitely works with version 9.0. The installation process is the same as with previous JDE releases.

Unity Solutions has made the product free. Are you using the latest free download or are you installing an older licensed copy? The latest online documentation is here:

http://www.unitysolutions.com/Helps/Unity_ODBC/HTML/index.html?unity_odbc_help.htm

If using the older v2.x licensed version you can use this documentation:

http://www.unitysolutions.com/Helps/Unity_ODBCv2/HTML/index.html?unity_odbc_helpv20.htm

If you require assistance past that you can purchase a support ticket from this link: http://www.unitysolutions.com/support.php

Hi Justin,

Thanks for your reply.
We are using the latest version downloaded from Unity Solutions website. Installed in one of our fat Clients.
But while configuring i am getting error.

The issue we were getting is "failed to validate user login using interoperability connector, error code: -1" while configuring the driver using Typical setup. When we configured passthrough setup it is working fine. Any suggestions on this error with typical configuration setup.
I even verified the JDBj.ini settings in the Unity folder of C drive in that fat clinet. They are fine.
Please let me know if I miss anything else.

Thanks,
Naveen

Hi Naveen,

The driver authentication operates in two modes:

1) Passthrough - The user id you pass to jdeDirect must be both a JDE user profile and an underlying database user. The password you enter in this configuration is the database password and not the JDE application password.

This is the easiest configuration and I have found that it suits a small group of jdeDirect users. It has the benefit of making each jdeDirect user trackable at the DB level.

2) Gateway mode - You must install and configured the Gateway Service. This uses Java Interop Connector to pass your User Id and Password (entered in the driver login box) to the JDE security server. If the authentication is succesful it then builds database connections using database proxy user(s) defined in the Gateway.

Take a look at this link in the documentation for detail:

http://www.unitysolutions.com/Helps/Unity_ODBC/HTML/ow_gateway_machine_installation_common.htm

Hope that helps.