External Data Import

[binky]

Has anyone ever linked JDE to an external data source. ie. retrieving data across the Internet? Is it possible to do directly from JDE or will I need another program to do the data retrieval and put it in a flat file for JDE?

Any thoughts would be greatly appreciated.

Binky

 

[jastips]

Ken,

You can use foreign table concept here. It will be database specific though. You haven’t specified what database you are going to use. But my thought is

If it is SQL Server
Create a ODBC DSN to that remote database and use foreign table concept.

If it is Oracle

Create a Connect String and use foreign table concept.

Configuring foreign table

Create a Data Source in JDE by using data source master and configure OCM mappings.