| General Info: This program is used to transfer AS/400
files to SQL server and vice-versa. It demonstrates how to go directly from one ODBC
connection to another. It uses a trick - make a connection to an .MDB file and then ignore
it.
Since it uses ODBC, it's a little slow. Don't count on this to automate your data
warehouse. It's more of a utility that can be used to upload, say, a list of JD Edwards
address book entries and then update JDE files from there. Or output a world writer to
your library and send it directly to SQL server
There's also a button that sends an Excel spreadsheet to SQL server. We didn't have
time to "pick" the Excel file, so you'll see it's a little awkard, but simple in
that way, and easily modified.
This application has NOT been made commercial friendly. You have to hard-code your ODBC
parameters (the text file shows you how). Then you can modify it for use in your
organization.
JDE and JD Edwards are copyrights of JD Edwards Inc, All rights reserved. MiniSolve has
no affililiation with JD Edwards, either stated or implied. JD Edwards does not know
anything about these programs, so please don't contact them.
Back to Mini Solve Products and more Tips
|
