RE: ETL/ELT Tools

SQL Server Integration Services?

It works well with the IBM i Access or MSFT OLE DB Providers (or ODBC).

Craig Pelkie

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Crump, Mike
Sent: Thursday, June 21, 2012 7:01 AM
To: Midrange Systems Technical Discussion
Subject: ETL/ELT Tools

We are looking at some ETL tool options.


1.) Source is SAP on MS/SQLServer

2.) Target is IBM DB2/400

3.) There will be other sources but the above is our primary concern -
the product has to play very well in the SAP arena and we would like to see
some affinity or knowledge of interfacing with DB2/400. Most people tend to
go the other way with BI/BW (IBM I -> MS SQLServer) but we have historically
had great success with DB2/400 and the IBM i.

4.) We have no interest in DIY

5.) We have looked at open source TALEND but aren't quite happy with it.

6.) Historically we have used SPSS (Showcase) Warehouse Builder but
aren't quite comfortable with it in the SAP environment

7.) We believe that InfoSphere DataStage is too expensive for our tastes
(I'm trying to confirm that)

While others may not have our requirements (#1 and #2 specifically) I
thought I would get them out there. Any opinions on experience with ETL/ELT
types of tools would be appreciated.


Michael Crump

Security and Data Center Manager
Verallia
SGCI
1509 S. Macedonia Ave.
Muncie, IN 47302

765.741.7696
765.741.7012 f
www.verallia.com<http://www.verallia.com/>

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