Informatica81安装手册

1、Informatica8.1安装与部署说明书大连港集团综合信息平台Informatica安装与部署说明书2008年01 月 22 日版本：Version 0.x修改历史日期修改内容修改人版本2008-12-08修改Informatica8.1Server的安装，添加目录 6, 7, 8，包括Informatica8.1的备份，删除，恢 复。任伟朋0.5审批签名(Signature)日期(Date)签名(Signature)日期(Date)文档说明参考文档Informatica8.1.1 安装说明哪些人员需要参考本文综合业务平台项目组人员本说明书的相关文档列出与本说明书相关的文档列表缩略语和术语

2、对英文大写联拼信息或专业术语进行解释说明Informatica8.1 安装与部署说明书 11 安装前准备工作 51.1 系统配置清单 51.2 安装 JDK 61.3 在数据库上的准备 62 Informatica8.1.1Server 的安装 72.1 Informatica8.1.1Server 端安装 72.2 指定 DA 和 MM 的 license key 112.3 指定 PowerCenter 的安装根路径 122.4 指定 DA 和 MM 的 Application Server （选择应用服务器） 132.5 指定 Application Server 根路径 132.6 阅

3、读安装信息后点击 Install 继续 142.7 安装进程中142.8 选择创建新 Domain 152.9 设定 Domain 的 Metadata 库 1 52.10 配置新 Domain 的信息 1 62.11 Domain 和第一个 Node 的创建中 172.12 配置启动PowerCenter Services的系统用户，本例中不选择直接点击next下一步182.13 PowerCenter Services 的配置中 192.14 为 Metadata Manager 配己置 PowerCenter repository192.15 Metadata Manager 的 Rep

4、ository Service 创建中 202.16 Metadata Manager 的 PowerCenter Service 配置（不选择 Create integration Service，character 选 Unicode ） 212.17 PowerCenter Service 的创建中 222.18 为 Data Analyzer 配置 Repository 222.19 Repository 的创建中 . 232.20 PowerCenter Services 安装成功 233 PowerCenter Client 的安装 243.1 选定“ Client安装选项243.

5、2 欢迎界面 253.3 选择自定义安装 253.4 选择要安装的组件 263.5 指定 PowerCenter的安装根路径 263.6 指定 Metadata Manger 要管理的 PowerCenter Repository 273.7 阅读配置信息后点击 Install 283.8 安装进程中 283.9 安装成功 293.10 安装成功后可启动指定客户端程序 294 PowerCenter Reports 的安装 304.1 选定 “ Reports安装选项 304.2 欢迎界面 314.3 点击 next 继续 314.4 选择自定义安装 324.5 选择 PowerCenter

6、Reports 的Server URL 324.6 阅读配置信息后点击 Install 334.7 安装进程中 334.8 安装成功 345 Informatica 配置 345.1 client 端资料库配置与连接 （Informatica 客户端的 Repository Manager） 345.2 创建一个文件夹并分配权限 396 备份PowerCenter资料库内容396.1 选定资料库，执行Actions-Back Up Contents 菜单命令 396.2 配置备份资料库的相关信息 406.3 资料库内容备份成功 417 删除PowerCenter资料库内容 437.1 选定资料

7、库，配置Properties-General Properties-OperatingMode为 Exclusive437.2 选定资料库，执行Actions-Delete Contents菜单命令 447.3 配置有删除权限的用户名/密码457.4 资料库内容删除成功 468 恢复 PowerCenter 资料库内容 478.1 选定资料库，执行 Actions-Restore Contents菜单命令 478.2 选定要恢复的资料库备份文件 488.3 资料库内容恢复成功 499 ETL目录结构部署 4910元数据目录结构： 5111ETL 部署521、开发期522、运行期531安装前准备

8、工作1.1系统配置清单序号产品名称厂商配置描述数量、软件部分1数据仓库引擎 及其管理软件OracleOracleDatabaseEn terprise Editi on 10g12ETL工具In formaticaInformatica8.1(2 CPU)13BI/报表工具软 件BOCrystal ReportXI14OLAP工具BOBOEXI,WebIn tellege nceXI15应用服务器ApacheTomcat5.51二、硬件部分1数据仓库服务 器wi ndows服务器1合用创建新实例，Oracle TNS = (host=34, sid =pdabi; port =

9、1521)2ETL服务器PC服务器1CPU, 2GBMemory ,200GB In ternalDisk34Admi nistrator/1234563应用服务器+BIPC服务器1CPU, 2GBMemory ,200GB In ternalDisk1已有，35Admi nistrator/1234561.2安装JDKInformatica PowerCenter 8.1的主安装界面是基于 JAVA平台建立的，所以在安装前安装 JDK （推 荐）。如果没有安装JDK，也可以进入安装文件下点击in stall来进行安装。1.3在数据库上的准备Informati

10、ca PowerCenter 8.1在安装前，要在数据库下新建用户，用来管理资料库，用于存放源 表和目标表。使用为资料库建立的表空间：ETL_PDABI新建一个用户 /密码：ETL_REPOSITORY/123456权限：CONNECT，RESOURCE，CREATE VIEW，UNLIMITED TABLESPACE ， SELECT ANY TABLECREATE USER ETL_REPOSITORY IDENTIFIED BY 123456 DEFAULT TABLESPACE ETL_PDABI TEMPORARY TABLESPACE temp PROFILE DEFAULT AC

11、COUNT UNLOCK ;GRANT CONNECT TO ETL_REPOSITORY;GRANT RESOURCE TO ETL_REPOSITORY;GRANT CREATE VIEW TO ETl_REPOSITORY;GRANT UNLIMITED TABLESPACE TO ETL_REPOSITORY;GRANT SELECT ANY TABLE TO ETL_REPOSITORY; ALTER USER ETL_REPOSITORY DEFAULT ROLE ALL ;2 Informatica8.1.1Server 的安装2.1 Informatica8.1.1Server

12、 端安装1、开始安装，执行install.exe，选择server端安装INFORMATICS2、欢迎界面3、选择 informatica 的 license.key冈INFORMATICSlaiiaaon setHspositor/ ConilyijrallDn Post-In stall ci*j on ci urn rriwi ry冲卩lit；电山on Srvr匚0口(1 Pr-lnSi tall si lion 3firnfh9y%Li 询n 猶Installsttoh DlrscRflliitalbrig.Drnai aseInstallation Prerequisites4、 n

13、extPrevious弋 Welcome弋 License KeyInstallation Prerequisites5、选择自定义 Custom安装 Inforatica PowerCenter &1. 1IN FORMATKAIm 愴IZjty*卅辛哼 b MficrwliioriRepfjsiior Oorinyu rationPosi-lnsiallcihon Summaiy QA a hlM License Kay I 砒悄II业规 Direckiry& Applicaiion Ssr/er Corjiiy.9 Rwtasialhigon Surnrriar/ Cf ln$ 怕lli

14、ig . Dornin OonfisrursiHon0 node Conflyurayon吃 AjihsniicaiioriC CompleteCustomIIICancelPreviousInstallation Set、 WelcomeB License KeyInstallatiom PrerequisitesInstallation SetNext6、选择安装组件：一般情况下，只选择安装PowerCenter Services 即可，PowerCenter DataAnalyzer 为 Informatica 的 BI 展现工具。E Inf orat xca PnwerCf?n+ er

15、 8. 1 .INFORMATICAPowerCenter Standard Edition ComponentsSelect the PovterCenter componenls to install;E PowerCenter ServicesE PowerCenter Data Analyzer移 W，,.刑刨 Lieer恺m Fey Q irihiihbon Directory Application S&rvarConflfr 0梓變jnstall抽巴星佈倫ry Q Iriihilling . DQiriin arjriyuriitionNo Us ConritjLininori

16、ruihe*ci!ictinori F/epciDiiciryCtinricjuraiiiDn Posi-lnsiiilhiiicjn Rummanin 筮glim蹄馆馆 by ftlstc revisionCancelHelpPrevious好 Welcome4 Installation PrerequisitesInstallation SetDA&MM License2.2 指定 DA 和 MM 的 license keyInforMatxca PowerCenter 8. 1. 1EHtXIPiii liuiafliaiaaMi himihu ZIN FORM ATI Data Ana

17、lyzer License KeySelect the license Key filE for Data An alvz er/Meta data Manager:ocumenlE And SettingsUdm inistralor Cllpc81 JicenseasiHn 轧 Jtml Restore DefaultBrowse.IribllMuri Dlrcicr/pplicaiion Server iJop Pr-Lri-iilkitio/i yFfirricir/ a insisiiiinij.Dcjrrr?ilfi CcjFifigur-iiticjn No.uth5riii(;

18、iicjriW Fspo-iiwrY Canriyuriiion Pout-Install anon Summer2.3指定PowerCenter的安装根路径INFORMATICSInf or Rai ica PowerCertt er S. 1. 1Application ServerWelcomeLicense Key/ Installation Prerequisites/ Installation Set f DA&MM License KeyInstallation Directorv Application Server Config.2.4指定DA和MM的Application

19、Server （选择应用服务器）Choose the application setver you want to use with Data Analyzer or Metadata Manayer The inallation 卩rogram infalls J Boss Application Server Version 4”3 tiy default. If you want to use Web Logic Servet or WebSphere Application Sertrer, you trust install the application serrer before

20、 you install Power Center.三 JBoss Application S&rvr-BEAWebLogic Seiver二 IBM WebSphere Application Server (Network Deplovmenl)C IBM WebSphere Application Server (Ease)Previous2.5 指定 Application Server 根路径2.6阅读安装信息后点击Install继续S InfPowerCenter 8. 1. 1 * INFORMATKAPre-Installation SummaryWelcome哼 Licens

21、e KeyInstallation Prere(uisitjesInstallation Set ts DA & MM License Keyinstallation Directoiyy Applicalion Server Config.Pre-insibilation Summaryorri?iin conmyuiRevievthe following information before continuing.Product Name :Inforrriatica Powercenter 8.1.1Selected Components :PowerCenter ServicesPow

22、erCenter Data AnalyzerInstallation Directory:E:MnftimnaticaPowerCenter6.1.1Chosen Application Server:JBoss Application ServerJBoss Home Directory:E: Mnfo rnn ati c aP we rC enters. 1.1JBoss403C1 C E旷C L FrJ!厂十FlnstallAnyi*diere by NacrosiDn CancelHelp2.7安装进程中InstallPrevious Create New Domain.Join Ex

23、isting DomainHeIp Mg SeIeHINFORMATICACreate or Join DonnainJ Welcome License key Installation PrerequisitesInstallation Set、Q DAE. MM License KeyIrslailation Directory Application Server Config. Preinstallation S：ummatyInsUlllrig Dorriair ConfigurationMMM2.8选择创建新DomainIf you are installing Powercent

24、er Services for the first time aryou want to create a new domain.If you are installing PoweirCeriter on multiple machines and ycu have already created a domain an another machine.Rerriirider: PowerC&nter iis licensed on a CPU ba&is. Consult your lirsnsirirj arjrpRtnRntfnr dptnils nn wnur licpnsRd mf

25、iniiratinrby Mat ration CancelHelpPrevious2.9 设定 Domain 的 Metadata 库数据库类型：Oracle数据库URL:Oracle : Orcale服务器所在的计算机上例如：10.93134用户和密码：ETL_DOAMAIN/12345服务器名:pdabiInforaali c& FoverCe：nlr 8. 1_INFORMATICSConfigure Domain Database、WelcomeLicense keyInstallation PrerequisitesInstallation SetDA&MM License Key

26、Indalliation Directory: Application Server Config. Pre-Installation SummaryInstalling.Domain CcnfiguraiionHpo-iiiGr/ C；orifiyurdiicjriPo-ir-lniiiIItiiitin urnrri油%PafWrCerrter Services ConfigurationEntiEnter the useraccourt informaition for tlie database to store Powercenter domain configuratiion me

27、tadata. You can stare tbie PowerCerrter domain configuration metadata and a PowarCenter repository in the same database us&r account. You must store configuration metadata for different domains in separate databaseDatabase type：Database URL：Database userID;Oracie|1O.9.134：1521|E7LJJOb4AIMDatabase us

28、er password: *+*+*Database ser/ice name: |pdabiTest ConnectionCancelInstall Anywhere by bl aero visionPrevious2.10 配置新Domain的信息登陆Informatica8.1管理控制台的用户名和密码：Domain user name: admin。Domain password : 123456ST Inf or&atica PoverCenter 8. 1_ 0INFORMATICAConfigure Domain、；Welcomey License Ke/y Installati

29、on PrerequisitesInstallation SetIns illation Directory.Application Server Config.:Pre-Installation SummaiyInstalling.Rsposisor/ ConriguriiijnSurniriatInstil Iere by 时讯viwionCancelHelpPowerCenter Services ConfigurationEnter the information for the Powercenter domain you want toDomain nam&Domain host

30、name:Node name-Domain port no;Domain user name:Domain password:Confirm password:Domain CIW161232CNW161232nodaCM CNW161232soaiadmin*Note: A Repository Service Is required for a Metadata Manager installation and is created by chraultAdvanced CorfiqurationPreviousNext2.11 Domain和第一个 Node的创建中y Welcome L

31、icense KeyInstallation Prerequisites- Installation Set DA& MMl License Key Installation Directory Application Server Confit Pre-Installation Simnmar Installing.Domain ConfigurationElirAnalyzing SystemPoerCenter S. 1_1Creating domain and nodelxfstem. This may take a fewCancelNextFreviious2.12 配置启动Pow

32、erCenter Services的系统用户，本例中不选择直接点击next下一步INFORMATICAt； Welcome、：License Key寻 InsUllatiori PrerequisitesInstallation Set、DA & MM License Key对 installation DirectoryApplication Server Config. 勺 Pre-Installation Summary Installing.Domain ConfigurationWMConfigure Informatica SendeesPowerCenter Services C

33、onfigurationEnterthe user name and password that the Informatica S 已 rvices service uses to log on to the machine. If you do not select this option, the Informatica Senrices service logs on with the Local System account (the user account currently logged in the machine)Select bis option if you vnt I

34、nformatica Services Io run under aCancelIn血1由柑时眈 by何肮rcsvi引MiPreviousNext2.13 PowerCenter Services的配置中 2.14 为 Metadata Manager 配置 PowerCenter repository知识库配置例如：用户和密码：ETL_REPOSITORY/123456ConnectString:edw_pdabi 需要把 Informatica8.1 的知识库放在 10.93134机 器上，需要填写本地oracle的网络配置。弔 InforBati ca FnerCenter 8- 1. 1InformaticsRgpository name|PowerCenterCode咖已MS Windows Simplified Chinese, supers.Database type:|OracleDatabase user ID:|ETL REPOS1TORData