If you already have MS SQL Server 2005 or above, then you have access to SSIS (SQL Server Integration Services) which is a perfectly capable ETL tool.
-----Original Message-----
From: jen@xxxxxxxxxxxxxx [mailto:jen@xxxxxxxxxxxxxx]
Sent: Monday, July 30, 2012 8:49 AM
To: midrange-l@xxxxxxxxxxxx
Subject: re: ETL/ELT Tools
Hi Mike,
*vendor response*
RODIN is our ETL software for IBM i. RODIN sources data from local and remote DB2 for i tables, DB2 databases on other platforms, and Oracle, SQL Server, MySQL, and other databases and now that we partner with IBM's Cast Iron (SAAS, appliance and product) and Magic Software - we meet all of your SAP to DB2 requirements and more. (in addition to integration with Salesforce and Lotus notes should you require those down the road).
Feature-rich with modules included parallel loading and change data capture. Our pricing is affordable, server based and IBM i installed.
Let me know when you are ready to schedule a POC.
All my best,
Jen
Jenniefer Halverson | RODIN by Coglin Mill | 507.282.4151 x104 |
507.251.1281 Mobile | Rochester, Minnesota USA | www.thinkrodin.com
----- Forwarded by Alan Jordan/Coglin Mill on 06/21/2012 10:48 AM -----
From: "Crump, Mike" <Mike.Crump@xxxxxxxxxxxxxxxx>
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>,
Date: 06/21/2012 09:00 AM
Subject: ETL/ELT Tools
Sent by: midrange-l-bounces@xxxxxxxxxxxx
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/>
midrange.com
