WebService调用ODI同步任务

本文介绍了如何在ODI11G中利用WebService接口控制和访问同步任务。当ODI代理启动后,会自动开启一个Web服务端口,通过其提供的WSDL文件,可以使用Axis等技术生成调用代码。详细步骤包括获取WSDL地址,使用Eclipse的Axis插件生成Java代码,编写Java类并设置相关参数以调用ODI的集成场景。

摘要生成于 C知道 ,由 DeepSeek-R1 满血版支持, 前往体验 >

1. 概述

ODI11G默认提供了WebService的调用接口,供其他各种应用程序通过接口控制、访问ODI自身的同步任务。

ODI11G在安装完成,启动代理后,会自动启动webservice的服务端口,对外提供WSDL文件服务,外部应用可以通过WSDL文件利用各种技术反向生成自身应用程序所需要的调用代码,本文将以Axis作为WebService容器来介绍,如何生成代码并调用ODI接口。

2.   技术说明

2.1ODI WebService介绍

ODI在安装过程中会默认生成一个“代理“,代理有设置的端口号,假设代理的端口为:505,那么当代理在服务器上成功启动以后,会生成一个web服务对外提供ODI控制所用的WSDL文件,地址为:

http://hostname:505(端口号)/oraclediagent/OdiInvoke?wsdl

2.2生成客户端调用代码

本文档以Axis生成Java代码为例进行详细介绍如下:

首先将附件《WebService调用ODI所需Eclipse插件》解压缩至Eclipse的plugins目录下,并启动Eclipse。

在启动后的Eclipse界面中,点击fileànewàOther,弹出如下界面:

界面中选择Axis2 CodeGenerator--->Next:

生成接口调用client代码

输入ODI的WSDL地址:

一般是localhost:505/oraclediagent/OdiInvoke?wsdl

然后根据提示生成Java代码,可以选择将java代码生成至某已有项目,如oditest

调用代码生成完毕之后,便可以正式开始书写客户端调用方法,用于调用ODI的数据同步场景或代理。

2.3编写Java类,调用ODI集成场景

以TestOdi类为例:

public class TestOdi{

       public static voidmain(String[] args){

           &n

ODI API Organization of This Manual ............................................................................................................. 1 Using Substitution Methods............................................................................................................... 3 The Principles ................................................................................................................................ 3 Generic Syntax .............................................................................................................................. 3 Specific Syntax for CKM................................................................................................................ 3 Using Flexfields ............................................................................................................................. 3 Using Substitution Methods in Actions.............................................................................................. 5 Introduction .................................................................................................................................... 5 Action Lines Code.......................................................................................................................... 5 Action Calls Methods..................................................................................................................... 5 List of Substitution Methods .............................................................................................................. 7 Global Methods.............................................................................................................................. 7 Journalizing Methods..................................................................................................................... 7 Loading Methods ........................................................................................................................... 7 Check Methods.............................................................................................................................. 8 Integration Methods....................................................................................................................... 8 Reverse Engineering Methods ...................................................................................................... 9 Web Services Methods.................................................................................................................. 9 Action Methods .............................................................................................................................. 9 Substitution Methods Reference ..................................................................................................... 11 getAK() method............................................................................................................................ 11 getAKColList() Method................................................................................................................. 11 getCatalogName() Method .......................................................................................................... 14 getCatalogNameDefaultPSchema() Method ............................................................................... 15 getCK() Method ........................................................................................................................... 17 getColDefaultValue() Method ...................................................................................................... 18 getColList() Method ..................................................................................................................... 18 getColumn() Method.................................................................................................................... 24 getContext() Method.................................................................................................................... 26 getDataType() Method................................................................................................................. 27 getFilter() Method ........................................................................................................................ 29 getFilterList() Method................................................................................................................... 29 getFK() Method............................................................................................................................ 31 getFKColList() Method................................................................................................................. 32 getFlexFieldValue Method........................................................................................................... 35 getFrom() Method ........................................................................................................................ 36 getGrpBy() Method ...................................................................................................................... 36 getGrpByList() Method................................................................................................................. 37 getHaving() Method ..................................................................................................................... 38 Oracle Data Integrator Substitution Methods Reference iv getHavingList() Method................................................................................................................ 39 getIndex() Method........................................................................................................................ 40 getIndexColList() Method............................................................................................................. 41 getInfo() Method .......................................................................................................................... 43 getJDBCConnection() method.....................................................................................................47 getJoin() Method.......................................................................................................................... 48 getJoinList() Method .................................................................................................................... 48 getJrnFilter() Method ................................................................................................................... 50 getJrnInfo() Method ..................................................................................................................... 50 getModel() Method....................................................................................................................... 52 getNewColComment() Method .................................................................................................... 53 getNewTableComment() Method ................................................................................................ 54 getNotNullCol() Method ............................................................................................................... 54 getObjectName() Method ............................................................................................................ 55 getObjectNameDefaultPSchema() Method ................................................................................. 57 getPK() Method............................................................................................................................ 58 getPKColList() Method................................................................................................................. 58 getPop() Method .......................................................................................................................... 61 getPrevStepLog() Method............................................................................................................ 62 getQuotedString() ........................................................................................................................ 64 getOption() Method getUserExit() Method................................................................................... 65 getSchemaName() Method.......................................................................................................... 65 GetSchemaNameDefaultPSchema() Method.............................................................................. 66 getSession() Method.................................................................................................................... 68 getSessionVarList() Method ........................................................................................................ 69 getSrcColList() Method................................................................................................................ 69 getSrcTablesList() Method........................................................................................................... 72 getStep() Method ......................................................................................................................... 74 getSubscriberList() Method.......................................................................................................... 76 getSysDate() Method................................................................................................................... 77 getTable() Method ....................................................................................................................... 77 getTargetColList() Method........................................................................................................... 80 getTargetTable() Method............................................................................................................. 84 getUser() Method......................................................................................................................... 86 getOption() Method getUserExit() Method................................................................................... 86 hasPK() Method........................................................................................................................... 87 isColAttrChanged() Method ......................................................................................................... 87 nextAK() Method.......................................................................................................................... 88 nextCond() Method...................................................................................................................... 89 nextFK() Method .......................................................................................................................... 89
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值