Thanks Craig. That is one that is currently on our list to look at.
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
-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Craig Pelkie
Sent: Thursday, June 21, 2012 5:33 PM
To: 'Midrange Systems Technical Discussion'
Subject: 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.
--
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.
As an Amazon Associate we earn from qualifying purchases.