RE: Data Extraction Tool

["Roy Luce - Systems Plus" <lwl@xxxxxxxxxxxxx>]

Alan:

The key is the iSeries supporting the cloud application is to be located in
a central location and will be pulling from many different platforms.
I'd like to make the connection process as simple as possible; both for my
company and for the client.  
Because the PC is so ubiquitous it simplifies the connection issue on 2
fronts:
  1. at the hardware level
  2. at the application level.
The approach is to place a PC at each client's location.  The PC will run a
customer-specific (OS, DB and ERP system) extract routine.  That routine
will extract the required data and pass it back to the central cloud server.

In addition I'm motivated to use a commercial product rather than a DYI
application
A commercial product is likely to have more resources behind it so when
things go bump in the night I won't be on my own.
Given this preference, I'll use whatever method the commercial product
supports to define the logic required to define the extraction process.


Roy Luce

Direct:	847-540-9635
	800-913-PLUS (7587)
Cell:	847-910-0884
Fax:	847-737-7635
Email:	lwl@xxxxxxxxxxxxx


-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Alan Campin
Sent: Tuesday, October 11, 2011 2:09 PM
To: Midrange Systems Technical Discussion
Subject: Re: Data Extraction Tool

Do you have SQL Server in the shop? You could pull anything you want with
sql server either through scripts and the data transformation tool although
I agree you should be able to do through AS/400.

You did say is the data being transformed or just mirror image of AS/400
data?

On Tue, Oct 11, 2011 at 11:59 AM, Bob P. Roche
<BRoche@xxxxxxxxxxxxxxxxx>wrote:

> I have no experience, but I am wondering why it has to be a PC tool, The
> iSeries should be able to do that. It doesn't sound very hard to write in
> RPG either.
>
> It's kind of like training your own replacement though.
>
>
>
>
> From:
> "Roy Luce - Systems Plus" <lwl@xxxxxxxxxxxxx>
> To:
> <midrange-l@xxxxxxxxxxxx>
> Date:
> 10/11/2011 12:54 PM
> Subject:
> Data Extraction Tool
> Sent by:
> midrange-l-bounces@xxxxxxxxxxxx
>
>
>
> Good Afternoon.
>
>
>
> I'm searching for a PC based data extraction tool that I can use in
> conjunction with a project to move an iSeries application into the cloud.
>
>
>
> The data extraction tool will reside on a PC resident at a client's
> iSeries
> server location, extract data based on relational rules and transfer the
> data to the cloud server.
>
>
>
> Does anyone have experience with such a tool.
>
>
>
>
>
> Roy Luce
>
>
>
> Direct:  847-540-9635
>
>            800-913-PLUS (7587)
>
> Cell:      847-910-0884
>
> Fax:      847-737-7635
>
> Email:   lwl@xxxxxxxxxxxxx
>
>
>
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
> list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
>
>
>
>
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.