× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



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.

This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.