RE: Recommendations for a newcomer?

Isnt this over generalizing?

Most ETL type stuff by definition is batch, and that occurs millions of times per day in the US. Think of all the EDI, ADP payroll feeds, B2B file transfers, 1099 reporting, bank feeds, even intracompany feeds.

Like many larger organizations, our company has hundreds of independent apps. Many of them run ETL batch processes to move large amounts of data to feed other systems within our company and to outside groups as well.

It may seem archaic, but it is widely used today and will be in the foreseeable future.



-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Dan Kimmel
Sent: Tuesday, May 14, 2013 3:32 PM
To: Midrange Systems Technical Discussion
Subject: RE: Recommendations for a newcomer?

With few exceptions, "batch processing" is a dead horse. Today's systems process transaction at a time directly from whatever capture mechanism is used. Data entry on a keyboard is fast becoming extinct. We grab information in barcodes at a retail checkout or IFR tags in a warehouse. Even those transactions are processed transaction-at-a-time. Proctor and Gamble knows my wife has purchased a can of Folgers before she swipes her credit card at the local Walmart.

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Gqcy
Sent: Tuesday, May 14, 2013 3:21 PM
To: midrange-l@xxxxxxxxxxxx
Subject: Re: Recommendations for a newcomer?

Dan,
are you saying that "batch processing" is to be replaced?

or can you provide some examples of where SQL would "be a better batch transaction processor"?




Paul Nelson wrote:

Name a better batch transaction processor than RPG or COBOL, please Dan Kimmel wrote:
SQL

Paul Nelson wrote:

Now go write me a payroll timecard processing program in SQL.

On 5/14/2013 3:08 PM, Dan Kimmel wrote:

Payroll time card processing is not a batch application. It's a user interface transaction...

--
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.