Compare IBM Datastage, Informatica and Microsoft SSIS

转载 2015年07月09日 16:29:09

1) System Plfatform

DataStage: Windows, Unix, Other Platforms
Informatica: Windows, Unix
Microsoft SSIS: Windows

2) Parallelism

DataStage:  Have both sequence (DataStage Server) and parallel (DataStage Enterprise Server )process
Informatica: ?
Microsoft SSIS: ?

3) Deployment facility

DataStage: No
Informatica: Yes
Microsoft SSIS: Yes

4) . Numbers of available transformation functions

Informatica:. 58
DataStage: 28 
Microsoft SSIS: 30

5) Slowly Changing Dimension

Informatica:. Supports Full history, recent values, Current & Prev values.
DataStage: Supports only through Custom scripts. Does not have a wizard to do this
Microsoft SSIS: Yes, with a Wizard but difficult to modify

6). Time Dimension generation

Informatica:. Does not support.
DataStage: Does not support
Microsoft SSIS: Does not support, but Time Dimension can be generated by using Microsoft SSAS

7). Rejected Records

Informatica:. Can be captured
DataStage: Cannot be captured in separate file
Microsoft SSIS: Can use conditional split transformation and error redirection to either CSV files or tables.

8). Debugging Facility

Informatica:. Not Supported
DataStage: Supports basic debugging facilities for testing.
Microsoft SSIS:  can use Breakpoint, Data Viewer and error handling

9) Application Integration Functionality, support for real Time Data Exchange

Informatica:. Not Available
DataStage: Not Available.
Microsoft SSIS: Not Available.

10) Metadata: Ability to view & navigate metadata on the web

Informatica:. Does not support
DataStage: Job sessions can be monitored using Informatica Classes
Microsoft SSIS: Does not support

11) Ability to Customize views of metadata for different users (DBA Vs Business user)

Informatica:. Supports.
DataStage: Not Available
Microsoft SSIS: Does not support 

12)  Metadata repository can be stored in RDBMS

Informatica:. Yes
DataStage: No. But the proprietary meta data can be moved to a RDBMS using the DOC Tool
Microsoft SSIS: Does not support 

13) Support And Maintenance, Command line operation

Informatica:. Pmcmd –server interface for command line
DataStage: Not Available
Microsoft SSIS:  Usage of Dtexec.exe

14) Ability to maintain versions of mappings

Informatica:. Yes
DataStage: No
Microsoft SSIS:  No

15) Job Controlling & Scheduling, Alerts like sending mails

Informatica:. Supported.
DataStage: Does not support directly ( no option). But possible to call custom programs after the job get executed)
Microsoft SSIS:  Job Agent, Email Notification

16) Languages

Informatica: ?
DataStage:  Script, C++
Microsoft SSIS:   C# (2005,2008), VB.NET (2005)

 17) ETL Proccess

Informatica: ?
DataStage:   DataStage Job
Microsoft SSIS:   package

18) Support for looping the source row (For While Loop)

Informatica:. Supports for comparing immediate previous record
DataStage: Does not support
Microsoft SSIS: Yes. ForEach Loop

ETL 和数据库平台的比较

 http://topic.csdn.net/u/20081014/15/ff429eb0-e04c-4f0a-9e17-f3174b990e0e.html 主要集中在,对异构数据源的支持,对代码效率...
  • thunder09
  • thunder09
  • 2009年10月29日 17:24
  • 3466

ETL工具比较(Informatica ,SSIS,Kettle )

发现自己真懒,只写了几篇就不更新BLOG了。近期要换工作,得做做知识储备和整理。顺便开更把。 个人观点: 1. 如果是自家用,多数情况选哪个工具并不是决定性的。工具能优化工作效率,但不是没有就不能...
  • xinyuelangzi
  • xinyuelangzi
  • 2017年04月11日 13:48
  • 6167

IBM 官方datastage文档链接

文章来自IBM官网。只转链接: 用IBM WebSphere DataStage进行数据整合  第 1 部分 https://www.ibm.com/developerworks...
  • pianzif
  • pianzif
  • 2014年03月03日 17:52
  • 1757

SSIS vs. Informatica

Here is my thinking after looking at both products... First of all let me tell you what I like abo...
  • thy822
  • thy822
  • 2013年01月10日 14:17
  • 1697

用IBM WebSphere DataStage进行数据整合: 第 1 部分

转自:http://www.ibm.com/developerworks/cn/data/library/techarticles/dm-0602zhoudp/ 引言 传统的数...
  • jediael_lu
  • jediael_lu
  • 2013年08月23日 11:20
  • 2111

IBM InfoSphere DataStage 实时监控和统一运维平台

IBM InfoSphere DataStage Operations Console 是一个基于 Web 的监视工具。它为 InfoSphere DataStage 和 QualityStage 客...
  • chenjunji123456
  • chenjunji123456
  • 2017年07月07日 10:18
  • 501

IBM Datastage job 一直在running状态

IBM Datastage job 一直在running状态,跑了好几天了 1、尝试清除运行锁定 打开DIRECTOR,JOB---cleanup resources---------选择...
  • zhgq2134
  • zhgq2134
  • 2017年02月27日 10:36
  • 652

助力大数据集成,且看DataStage新玩法

如何将传统数据和大数据进行高效的集成、管理和分析呢?如何保证数据的准确性,一致性和可靠性呢?带着众多疑问,我们来看看IBM所提供的DataStage大数据集成方案,一切必将豁然开朗。...
  • chenjunji123456
  • chenjunji123456
  • 2016年09月22日 10:38
  • 803

IBM Information Server(DataStage8.1)安装

IBM Information Server(DataStage)安装注:抱歉现在不能上传图片,CSDN啥时候才能传图片呢一、      安装条件——系统需求. 二、      安装步骤. 1.   ...
  • zzphapy
  • zzphapy
  • 2010年02月05日 16:59
  • 5451

datastage7.5.1.A License 及 下载地址 Download

DataStage V 7.5.1.A 下载地址: http://pan.baidu.com/share/link?shareid=60438&uk=2030455576#dir/path=%2...
  • kk185800961
  • kk185800961
  • 2013年02月19日 10:28
  • 6145
内容举报
返回顶部
收藏助手
不良信息举报
您举报文章:Compare IBM Datastage, Informatica and Microsoft SSIS
举报原因:
原因补充:

(最多只允许输入30个字)