Exporting to 400 to SQL for reporting

Hi All,

Does anyone have a document on exporting from the 400 to native sql? I'm looking at a client that wants to export from JDE to a sql database - to allow third party tools to query legacy data - they won't have JDE on the 400 - just have the data.

They'll be using third-party tools like Brio and crystal to do ad-hoc reporting ...

Thanks in advance!

Daniel,

do you mean exporting to an MS SQL Server database or a "generic sql" database?

If the number of tables is small why not just use Table Conversions from JDE. If you have larger needed then the built in tools of MS SQL would work pretty good. You can build DTS packages to automatically export the data. The only thing you have to remember is to install iSeries Access to get the drivers.

Just out of question do these 3rd party tools not use ODBC or OLEDB? If they do wouldn't it be possible to just leave the data on the 400?

Colin

At this time, it appears the client wants to export payroll, client,
invoice, manufacturing and a few other 'areas' of data - to a MS SQL
database. They will be using MS SQL as a reporting tool - using
Crystal, Brio, Access..., and the 400 will be going away (will not be
reachable)

My intention is to us JDE's TCs to export and MS SQL to import. What
I'm hoping for is some file relations in the different modules... I
recall - that JDE has documents on the relationships of the files
within the modules (internally) and externally to modules.

If someone knows the magical location of the module/file layouts and
relationships - I'd be very appreciative!

Daniel

On Sun, 13 Jun 2004 05:33:05 -0500, cdawes <[email protected]> wrote:




--
----------------------------------------
Daniel Bohner
ExistingLight, LLC
http://www.existinglight.net
[email protected]
mobile: 208.250.1917
fax: 208.246.3425
----------------------------------------



Member - iConsortium
Always looking for new gigs!
Daniel Bohner | JDE Developer
Independant-JDE/Web/Photo
www.ExistingLight.Net | [email protected]

JDE XE | SP20 | AS/400 | V5R1

If you are talking about the OW menu that has all the DB relationship Docs it is - GH9073 Data Model Illustrations