Informatica PowerCenter 8.1 安装配置手册

发布时间：2024-09-25

Informatica PowerCenter 8.1 安装 ETL tool,for ORACLE DB2 SQLSERVER.

Informatica PowerCenter 8.1

安装配置手册

2006年06月

　提交人: 杨晓东姜炜　版本号: 1.1

Informatica PowerCenter 8.1 安装 ETL tool,for ORACLE DB2 SQLSERVER.

安装前准备事项............................................................................................................5

PowerCenter 8.1对系统的配置要求.....................................................................5 PowerCenter 8.1对数据库的配置要求.................................................................7 PowerCenter 8.1对第三方软件的要求.................................................................8 PowerCenter标准版在UNIX下的安装.........................................................................9

配置UNIX用户的环境变量...................................................................................9 安装Domain和第一个Node.................................................................................10

执行install.bin –I console命令......................................................................10 指定PowerCenter服务的license key.............................................................12 定制化安装....................................................................................................13 选择安装PowerCenter Services....................................................................13 设定第一个Node的根路径...........................................................................14 创建新Domain...............................................................................................15 设定Domain的 Metadata库..........................................................................15 安装成功........................................................................................................16 登陆到控制台................................................................................................18 安装后续Node......................................................................................................19

执行install.bin –I console命令......................................................................19 指定PowerCenter服务的llicense key............................................................21 定制化安装....................................................................................................22 选择安装PowerCenter Services....................................................................22 设定新Node的根路径...................................................................................23 加入现有Domain...........................................................................................24 设定Domain信息...........................................................................................24 设定新Node信息...........................................................................................25 安装成功........................................................................................................25 登陆到控制台................................................................................................27

PowerCenter企业版在Windows下的安装.................................................................28

选定“Server”安装选项.........................................................................................28 欢迎界面...............................................................................................................29 为PowerCenter指定licnese key............................................................................29 安装前的必备条件...............................................................................................30 选择完全安装/自定义安装.................................................................................30 选择要安装的组件...............................................................................................31 指定DA和MM的license key................................................................................31 指定PowerCenter的安装根路径..........................................................................32 指定DA和MM的Application Server...................................................................32 指定Application Server根路径............................................................................33 安装前的配置总结...............................................................................................33 安装进程中….......................................................................................................34

Informatica PowerCenter 8.1 安装 ETL tool,for ORACLE DB2 SQLSERVER.

选择创建新Domain/加入已存在Domain............................................................34 设定Domain的Metadata库...................................................................................35 测试元数据的连接...............................................................................................35 配置新Domain的信息..........................................................................................36 Domain和第一个Node的创建中….....................................................................36 配置启动PowerCenter Services的系统用户.......................................................37 PowerCenter Services的配置中….......................................................................37 为Metadata Manager配置PowerCenter repository..............................................38 Metadata Manager的Repository Service创建中…..............................................38 Metadata Manager的PowerCenter Service配置...................................................39 PowerCenter Service的创建中.............................................................................39 为Data Analyzer配置Repository..........................................................................40 Data Analyzer Repository的创建中.....................................................................40 Repository的创建中.............................................................................................41 PowerCenter Services的安装总结.......................................................................41 对应的安装日志...................................................................................................42 PowerCenter Client的安装..........................................................................................44

选定“Client”安装选项.....................................................................................44 欢迎界面...............................................................................................................45 选择完全安装/自定义安装.................................................................................45 选择要安装的组件...............................................................................................46 指定PowerCenter的安装根路径..........................................................................46 指定Metadata Manger要管理的PowerCenter Repository...................................47 安装前的配置总结...............................................................................................47 安装进程中….......................................................................................................48 安装成功...............................................................................................................48 安装成功后可启动指定客户端程序...................................................................49 PowerCenter Reports在Windows下的安装................................................................50

选定“Reports”安装选项.......................................................................................50 欢迎界面...............................................................................................................51 安装前的必备条件...............................................................................................51 选择完全安装/自定义安装.................................................................................52 选择要安装的组件...............................................................................................52 选择PowerCenter Reports的Server URL.............................................................53 安装前的配置总结...............................................................................................53 安装进程中….......................................................................................................54 安装成功...............................................................................................................54 PowerCenter 8.1管理操作..........................................................................................55

登陆到Administration Console............................................................................55 创建Repository Service........................................................................................56

执行Create菜单命令.....................................................................................56 配置Repository Service.................................................................................56 创建成功........................................................................................................57 创建Integration Service........................................................................................58

Informatica PowerCenter 8.1 安装 ETL tool,for ORACLE DB2 SQLSERVER.

执行Create菜单命令.....................................................................................58 创建用于Failover的Integration Service........................................................58 配置每个节点的Codepage............................................................................59 配置主/从节点使用同一个$PMRootDir......................................................59 创建成功........................................................................................................60 创建Grid...............................................................................................................60

执行Create菜单命令.....................................................................................60 配置Grid中可用的Node................................................................................61 创建成功........................................................................................................61 创建为Grid服务的Integration Service.................................................................62

执行Create菜单命令.....................................................................................62 创建服务于Grid的Integration Service..........................................................62 配置每个节点的Codepage............................................................................63 配置Grid中多个节点的$PMRootDir (可选项)............................................63 创建成功........................................................................................................64 配置Domain为High Availability(HA)..................................................................65

设定Domain的Log and Gateway Configuration...........................................65 统一配置Gateway Node的Log根路径.........................................................65 配置成功........................................................................................................66 启动/停止Integration Service...............................................................................67 启动/停止Repository Service...............................................................................68 启动/停止Node上的Informatica Services............................................................69

UNIX操作系统..............................................................................................69 Windows操作系统........................................................................................69 使用Administration Console停止Informatica服务.......................................70 停止Domain..........................................................................................................71

Informatica PowerCenter 8.1 安装 ETL tool,for ORACLE DB2 SQLSERVER.

安装前准备事项

PowerCenter 8.1对系统的配置要求

安装产品

CPU数目

系统内存

硬盘空间

操作系统

Windows 2000 / Sun Solaris HP-UX IBM AIX

Red Hat Linux SUSE Linux Windows 2000 / Sun Solaris HP-UX IBM AIX

Red Hat Linux SUSE Linux Windows 2000 / 2003 / XP

PowerCenter Advanced Edition

完全安装

4 CPUs4 GB 2.3 GB

PowerCenter Standard Edition

完全安装

1 CPU 1 GB 1.3 GB

PowerCenter Services 1 CPU 1 GB 500 MB

Data Analyzer 2 CPUs1 GB 800 MB

Metadata Manager 2 CPUs1 GB 1.0 GB

PowerCenter Client 1 CPU 512 MB 300 MB

Informatica PowerCenter 8.1 安装 ETL tool,for ORACLE DB2 SQLSERVER.

Metadata Manager Client 2 CPUs512 MB 200 MB

Windows 2000 / 2003 / XP

注意:

PowerCenter Server安装需要1GB磁盘空间来保存临时文件。

在UNIX系统中, 安装程序将临时文件写入到/tmp路径下。

在Windows系统中, 安装程序将临时文件写到缺省路径下，可修改TMP或

IATEMPDIR(InstallAnywhere)环境变量来改变该路径。

最简化的安装：

在Server端安装PowerCenter Services 在Client端安装PowerCenter Client

Informatica PowerCenter 8.1 安装 ETL tool,for ORACLE DB2 SQLSERVER.

PowerCenter 8.1对数据库的配置要求

PowerCenter组件

数据库类型

IBM DB2 UDB

Microsoft SQL Server Oracle Sybase ASE

IBM DB2 UDB

Microsoft SQL Server Oracle Sybase ASE

IBM DB2 UDB Informix

Microsoft SQL Server Oracle Sybase ASE Teradata

IBM DB2 UDB

Microsoft SQL Server Oracle Sybase ASE

IBM DB2 UDB

Oracle

磁盘空间

PowerCenter repository 30 MB(最小值)

PowerCenter domain configuration database1 MB

Data Profiling warehouse* 5 MB(最小值)

Data Analyzer repository 60 MB

Metadata Manager repository 550 MB

* Data Profiling可以跟PowerCenter repository存储在同一个数据库实例中。

而针对Informix和Teradata数据库, Data Profiling必须跟PowerCenter repository存储在不同的数据库实例中。

注意:

必需的PowerCenter资料库配置：

PowerCenter domain configuration database PowerCenter Repository

Informatica PowerCenter 8.1 安装 ETL tool,for ORACLE DB2 SQLSERVER.

PowerCenter 8.1对第三方软件的要求

实现功能 PowerCenter Client (Visio Client for PowerCenter)

第三方软件

说明

使用Visio Client for PowerCenter,可以在Microsoft Microsoft Visio中创建PowerCenter mapping template。

Visio 2003 必须在安装PowerCenter Client之前安装Microsoft Visio

2003。仅针对Windows 2000操作系统：

Visio Client for PowerCenter在Windows 2000系统中，必须要安装Microsoft .NET Framework 1.1. Service Pack 1. 可从下列网址下载Microsoft .NET Framework 1.1：

Microsoft .Nhttp://www.77cn.com.cn/netframework/downloads/framework1_1/

还必须要安装Microsoft .NET Framework的Security 1.1

Version 1.1 Service Pack 1 (KB886903). 可从下列网址下载：

http://www.77cn.com.cn/downloads/details.aspx?familyid=8EC6FB8A-29EB-49CF-9DBC-1A0DC2273FF9&displaylang=en

在Data Analyzer和Metadata Manager中，可将报表内容导出到Excel文件中，并且可直接在Excel文件中刷新报表数据。

Data Analyzer,

Microsoft 为了使用上述的数据刷新功能，必须安装Microsoft SOAP

Toolkit.

(data refresh)

想了解Microsoft SOAP Toolkit的详细信息，请参考Data Analyzer用户手册中的"Working with Microsoft Data Analyzer, (interactive charts)

在Data Analyzer和Metadata Manager中, 可显示交互式的报告图标以及图表指示器。

通过点击交互式图表，可钻取报表数据和查看到详细数据。为了使用交互式图表，必须安装Adobe SVG Viewer。

想了解更多相关信息，请参考Data Analyzer用户手册中的"Managing Account Information"章节。

Adobe SVG Viewer

在PowerCenter Administration Console中，可使用Domain Activity Monitoring report来监测用户活动以及license使用的情况。为了使用该功能，domain中的gateway node必须能

License and X Virtual 够显示图形。

reporting 如果gateway node是在UNIX 上，则必须安装和配置X Virtual Frame Buffer (Xvfb).

想了解更多信息，请参考安装手册中的 "Install X Virtual Frame Buffer (Optional)"章节。

Informatica PowerCenter 8.1 安装 ETL tool,for ORACLE DB2 SQLSERVER.

PowerCenter标准版在UNIX下的安装

配置UNIX用户的环境变量

说明：在UNIX用户环境变量中，主要是配置跟数据库相关的变量，可不指定PowerCenter 服务的路径信息，下面是AIX UNIX下的.profile的例子：

####################Oracle#################### ORACLE_BASE=/data/ora92 export ORACLE_BASE

ORACLE_HOME=/data/ora92/product/9.2 export ORACLE_HOME

NLS_LANG="SIMPLIFIED CHINESE"_CHINA.UTF8 export NLS_LANG

LIBPATH=$ORACLE_HOME/lib32 export LIBPATH

CLASSPATH=$ORACLE_HOME/JRE/lib/rt.jar:$ORACLE_HOME/jlib:$ORACLE_HOME/network/jlib:$ORACLE_HOME/rdbms/jlib:$ORACLE_HOME/plsql/jlib:$ORACLE_HOME/assistants/jlib:$ORACLE_HOME/assistants/dbca/jlib:$ORACLE_HOME/owm/jlib export CLASSPATH

TNS_ADMIN=$ORACLE_HOME/network/admin export TNS_ADMIN

EDITOR=vi; export EDITOR

PATH=$ORACLE_HOME/bin:/usr/bin:/etc:/usr/ccs/bin:/usr/lbin:/usr/sbin:/usr/local/bin:/usr/ucb:$HOME/bin:/usr/bin/X11:/sbin:. export PATH

############# INFORMATICA ##################### LANG=C; export LANG

PM_CODEPAGENAME="MS936"; export PM_CODEPAGENAME INFA_JAVA_OPTS=-Xmx1024m; export INFA_JAVA_OPTS export LDR_CNTRL=NOKRTL

Informatica PowerCenter 8.1 安装 ETL tool,for ORACLE DB2 SQLSERVER.

安装Domain和第一个Node

执行install.bin –I console命令

Informatica PowerCenter 8.1 安装 ETL tool,for ORACLE DB2 SQLSERVER.

I n f o r m a t i c a P o we r C e n t e r 8 . 1安装配置手册

第 11页共 71页

Informatica PowerCenter 8.1 安装 ETL tool,for ORACLE DB2 SQLSERVER.