We use an OLEDB driver by Hit Software (
http://www.hitsw.com) that allows
us to create a linked server on our SQL Server; it works real well to
integrate Mapics data real time with SQL Server data. They also have a
replication software that can use the journal to move data change real
time.
Marc Rohde
IT Manager
Pentair Filtration, Inc. & Everpure, LLC
Confidentiality Note: This e-mail message and all attachments to it are
intended only for the named recipients and may contain confidential
information. If you are not one of the intended recipients, please do not
duplicate or forward this e-mail message and immediately delete it from
your computer.
"Jon Le Roi" <jleroi@xxxxxxxxx>
Sent by: mapics-l-bounces@xxxxxxxxxxxx
06/13/2007 11:39 AM
Please respond to
MAPICS ERP System Discussion <mapics-l@xxxxxxxxxxxx>
To
"MAPICS ERP System Discussion" <mapics-l@xxxxxxxxxxxx>
cc
Subject
Re: [MAPICS-L] Mapics data conversion
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
