RE: SQL and MAPICS

I use replicate MAPICS data to our SQL Server for 2 purposes.
        First off, I use the SQL Server as a data warehouse since drive
space for a Windows NT Server is a fraction of a cost of drive space for an
AS/400. For example our IMHIST file has over 3 million records in it. When
the data replicated to the SQL Server we can purge the AS/400 file and still
maintain a historical record of
        Secondly, using access with the replicated data allows for more
flexible data mining. And more "pretty" reports.

        For those that use SQL Server I would reccommend the Hit Software
OLEDB driver http://www.hitsw.com/ It costs around $1000 for a single server
license, but is roughly 4 to 5 times faster than the Client Access ODBC
drivers.

        For data manipulation of a MAPICS file, you must link to and ODBC
file. When you link to the MAPICS file Access will prompt your for the
unique record identifier. Here you would select all the fields of the MAPICS
files which are the keyed fields. Then you will be able to manipulate the
files at the rowset level.
        I would like to point out though that care should be taken when
manipulating MAPICS files "out-side the box", it is very easy to accidently
change important data in a file.

If you would like more information on this please contact me off list.


-----Original Message-----
From: McCready, Joan [mailto:Joan.McCready@metaltekint.com]
Sent: Friday, February 22, 2002 5:14 PM
To: MAPICS-List (E-mail)
Subject: SQL and MAPICS


Hi!

I have just finished Intro to, Intermediate Applications of and Adv Appls of
SQL through our local univeristy continuing ed program. I am now thoroughly
dangerous!

What tool do those of you who use SQL use with MAPICS / AS/400? We don't
have (and really don't need) MS SQL Server. Any suggestions?

I've played with Access today, and can query MAPICS files, but can't update
- or at least I haven't found the magic button yet.

Have a good weekend  -- Joan

Joan McCready, IS Manager      phone:  636-479-4499
MetalTek International               fax:  636-479-3399
The Carondelet Division             www.metaltekint.com
8600 Commercial Blvd
Pevely, MO  63070

_______________________________________________
This is the MAPICS ERP System Discussion (MAPICS-L) mailing list
To post a message email: MAPICS-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/mapics-l
or email: MAPICS-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/mapics-l.
_______________________________________________
This is the MAPICS ERP System Discussion (MAPICS-L) mailing list
To post a message email: MAPICS-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/mapics-l
or email: MAPICS-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/mapics-l.