William,
Extracting data from the iSeries to any other database is fairly
straight forward via the ODBC connections. We extract data to Excel, MS
Access and SQL all the time for various reporting tools.
How much data are you trying to extract? Are you trying to pull all of
it for a migration to another ERP system or are you looking for specific
data like top items sold for a specific period? This would determine the
scope and time frame.
If your question of how much is regarding cost of a tool to extract, the
ODBC connections are included in Client Access.
Regards,
Jon Le Roi
Director of I.T.
Tegal Corp.
Petaluma, CA 94954
-----Original Message-----
From: mapics-l-bounces@xxxxxxxxxxxx
[
mailto:mapics-l-bounces@xxxxxxxxxxxx] On Behalf Of Gilchrist, William
Sent: Wednesday, June 13, 2007 8:50 AM
To: mapics-l@xxxxxxxxxxxx
Subject: [MAPICS-L] Mapics data conversion
My company is looking for a way to convert our mapics data to SQL or
something... Can it be done, how much and, the time frame are the
questions?
William F. Gilchrist Jr.
Sr. Network Services Tech.
Nordson Corp.
11475 Lakefield Drive
MS-620
Duluth, GA. 30097
E-mail wgilchrist@xxxxxxxxxxx
Office (770) 497-3527
Cell (770) 823-0157
This email is intended only for the use of the party to which it is
addressed and may contain information that is privileged, confidential,
or protected by law. If you are not the intended recipient you are
herby notified that any dissemination, copying or distribution of the
email or its contents is stricly prohibited. If you have received this
message in error, please notify us immediately, by replying to the
message and deleting it from your computer.
WARNING: Internet communications are not assured to be secure or clear
of inaccuracies as information could be intercepted, corrupted, lost,
destroyed, arrive late or incomplete, or contain viruses. Therefore, we
do not accept responsibilty for any errors or omissions that are present
in this email, or any attachment, that have arisen as a result of e-mail
transmission.
This email is intended only for the use of the party to which it is
addressed and may contain information that is privileged, confidential,
or protected by law. If you are not the intended recipient you are
herby notified that any dissemination, copying or distribution of the
email or its contents is strictly prohibited. If you have received this
message in error, please notify us immediately, by replying to the
message and deleting it from your computer.
WARNING: Internet communications are not assured to be secure or clear
of inaccuracies as information could be intercepted, corrupted, lost,
destroyed, arrive late or incomplete, or contain viruses. Therefore, we
do not accept responsibility for any errors or omissions that are
present in this email, or any attachment, that have arisen as a result
of e-mail transmission.
midrange.com
