Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
prabhu0505
Specialist
Specialist

JDE Source

Dear All,

   For my QlikView document, sources are:

1.       Excel files updated manually (pretty sure about accessing this)

2.       JDE (totally blind about this)

Some of the queries that came into my mind immediately:

1.       How to config JDE connector

2.       How to use JDE connector to collect data from JDE

3.       Are there any special things need to take care during using this connector

Would be really very useful, If you could share more on this context.

Thanks & Regards,

Saravana Prabhu

3 Replies
Ferran_Garcia_Pagans
Former Employee
Former Employee

As long as I know, JDE (JD Edwards) is usually supported by an Oracle or IBM databse. You can connect to the JDE Database using ODBC.

Ferran.

prabhu0505
Specialist
Specialist
Author

I read somewhere that it requires special connector to use. Does my understanding is correct?

Thanks & Regards,

Saravana Prabhu

tfidler240
Contributor II
Contributor II

Connection to JDE is at the database level.  Such as iSeries (AS400) it is to the DB2 files (F0101, F4210, etc...)  These are access via ODBC.  You will need a user name and password at least on DB2.

On our Qlikview server "iSeries Access for Windows ODBC data source" is defined in the ODBC Data Source Administrator under System DSN.  You will need Client Access basic install is you are on an iSeries.  I believe that SQL database is already in Windows.  Oracle DB I have no idea.