Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
prabhu0505
Valued Contributor

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

Tags (1)
3 Replies
Employee
Employee

Re: JDE Source

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
Valued Contributor

Re: JDE Source

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

Thanks & Regards,

Saravana Prabhu

tfidler240
New Contributor II

Re: JDE Source

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.

Community Browser