• 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!

Importing Data from Oracle SQL Developer into JDE Tables

szNick

Member
This should be simple, but I can't find any documentation about it at all. Has anyone used Oracle SQL Developer to upload rows from a JDE table export (CSV file) into an existing JDE table? How is it accomplished?
 

Larry_Jones

Legendary Poster
To be clear. You want to use data exported from JDE in CSV format to import into JDE, correct?

The general accepted practice for importing data is to use some form of a UBE in order to validate data, ensure default values are supplied for missing fields, etc.

Unless you know your data and table structures really well I wouldn't advocate the SQL Developer approach. For instance - how do you plan to handle the JDE Date formats and Numerics with decimal values?

Just a couple thoughts,
 

szNick

Member
To be clear. You want to use data exported from JDE in CSV format to import into JDE, correct?

The general accepted practice for importing data is to use some form of a UBE in order to validate data, ensure default values are supplied for missing fields, etc.

Unless you know your data and table structures really well I wouldn't advocate the SQL Developer approach. For instance - how do you plan to handle the JDE Date formats and Numerics with decimal values?

Just a couple thoughts,
Yes. I wouldn't normally do it this way, I would use a UBE as you described. In this instance we are moving data from a custom table in one JDE release (9.0) into the same table in another (9.2). Another developer has an old copy of Toad that we've used to upload CSV data from 9.0 to 9.2 before, but I only have access to Oracle SQL Developer.
 

RussellCodlin

Reputable Poster
If the tables are the same in both systems then your best bet would be to connect to the 9.0 system with SQL Developer and export the table data as SQL. You can then run that SQL against the 9.2 database to load it in.
 

czarcasm

Active Member
In the past I've used BCP (https://msdn.microsoft.com/en-us/library/ms162802.aspx) - not sure if I can do links or not for references, going to try.

It'll allow you to dump all of the specified/required data from a table in one environment (save it to a file/.dat) then insert it into the new environment. Probably the fastest method I've seen without linking the two databases. It can be done directly from command prompt.
 
Top