• Welcome to the upgraded JDELIST forum and thank you for your patience.
    Please restrict discussions and issues regarding the new forum software to the Off Topic forum. We will be monitoring that forum for issues.
    If you have trouble logging in, please reset your password using the forgotten password form: https://www.jdelist.com/community/index.php?lost-password/
    If you are unable to successfully reset your password, please contact us: Click here!
    We hope that you enjoy the upgraded forum.
  • Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

Data mining from JDE



Could you have an proposal for good (and cheap ;-) ) product to data mining from JDE World?

I check Sequel, Exant, Symtrax and I would like to know your opinion about this (and other) products.


Tomasz Skorza


I'm working on a project right now building a data warehouse against JDE/AS400 (and lots of other data sources). You have two components - the ETL/data warehouse and the mining tools/front end. I'm guessing you are really asking about reporting/ad-hoc queries, not data mining. There is a big difference.

If you want reporting only I think these tools you mention would work - provided they know how to deal with JDE decimal points and date formats. Most generic products will require some work to handle these quirky JDE datatypes. I just posted a question on this forum on that subject.

The cheapest is to use Excel with As400 as the data source. You can create views of the F4211,F0101, etc with cleansed dates and decimals. With Pivot tables the users can create queries (limited to 65535 records). Warning - your AS400 may be severely impacted by large queries.

Keeping in mind that Oracle intends to tombstone the JDE product by 2013 you may want to invest in a product that works against an Oracle database in the future.