ODI Studio拓扑结构的创建与配置(Oracle)

时间:2023-03-09 09:20:28
ODI Studio拓扑结构的创建与配置(Oracle)

一、概念解释

Topology Manager主要用来管理下面5类任务,并将信息存储在主资料库中,供所有模块共享使用。

ODI Studio拓扑结构的创建与配置(Oracle)

物理体系结构:

定义各种技术及其数据服务器、物理架构、物理代理。数据服务器瞎可以建立多个物理方案,每个物理方案的实质就是schema。

逻辑体系结构:

定义各种技术及其关联的逻辑架构、逻辑代理。一个逻辑方案需要基于一个或几个物理方案,实质上就是一层抽象,是物理方案的别名。

上下文:

上下文的主要目的是实现逻辑方案多物理方案的多对多关系,比如同一逻辑架构在不同上下文情况下可以对应不同的物理方案。

语言

不同技术所能采用的语言特性。

代理:

代理是一个JAVA 组件组件建,也分为物理代理和逻辑代理两层,通常它需要在目标库上运行(也可以在非目标库上运行),作用是对数据迁移JOB 进行调度,通常,它只是从执行资料库检索代码,并请求数据库服务器、操作系统或脚本引擎执行代码。

资料库:

包含主资料库及其附属的工作资料库。Master Repository,保存企业所有IT资源的Topology,保存项目和数据模型的安全信息、版本信息,供ODI图形模块等使用。通常创建一个即可。Master Repository要尽可能独立存储,单独的Instance,或单独的Schema。Work Repository, 保存项目和数据模型,供ODI图形模块等使用。可创建多个。一个Work Repository只能连接一个Master Repository。一个Schema只能存储一个Work Repository,不过Master Repository倒可与其安装在同一Schema。

二、创建物理体系架构

2.1. 创建源数据库和目标数据库Scheme

这里分别使用ODI_SRC和ODI_TAG模拟源数据库和目标数据库。

创建用户ODI_SRC,ODI_TAG

 1 /*第1步:创建临时表空间  */
2 create temporary tablespace odi_temp
3 tempfile ‘C:\app\ORACLE\oradata\orcl\odi_temp.dbf‘
4 size 50m
5 autoextend on
6 next 50m maxsize 20480m
7 extent management local;
8
9 /*第2步:创建数据表空间 */
10 create tablespace odi_data
11 logging
12 datafile ‘C:\app\ORACLE\oradata\orcl\odi_data.dbf‘
13 size 50m
14 autoextend on
15 next 50m maxsize 20480m
16 extent management local;
17
18
19 /*第3步:创建用户并指定表空间 */
20 create user ODI_SRC identified by ODI_SRC
21 default tablespace odi_data
22 temporary tablespace odi_temp
23 quota unlimited on odi_data
24 profile default ;
25 create user ODI_TAG identified by ODI_TAG
26 default tablespace odi_data
27 temporary tablespace odi_temp
28 quota unlimited on odi_data
29 profile default ;
30
31 /*第4步:给用户授予权限 */
32 grant connect,resource to ODI_SRC;
33 grant connect,resource to ODI_TAG;
34 grant create view to ODI_SRC;
35 grant create view to ODI_TAG;

创建两个用户ODI_SRC_WORK 和 ODI_TAG_WORK,用于物理方案ODI_SRC和ODI_TAG的工作scheme

 1 create user ODI_SRC_WORK identified by ODI_SRC_WORK
2 default tablespace odi_data
3 temporary tablespace odi_temp
4 quota unlimited on odi_data
5 profile default ;
6
7 create user ODI_TAG_WORK identified by ODI_TAG_WORK
8 default tablespace odi_data
9 temporary tablespace odi_temp
10 quota unlimited on odi_data
11 profile default ;

2.2. 创建数据服务器

Step1:点击拓扑->物理体系结构->选择Oracle->右键选择新建数据库服务器:

aaarticlea/png;base64,iVBORw0KGgoAAAANSUhEUgAAATwAAAGcCAIAAADLe4u/AAAgAElEQVR4nO2de1QUV7rod7LWuWudMzm5M5m15twT17pzbuLk4TEa4pHQifGtY9QkOr7A3BjjxIo6kSQqRrxoMIqZxFgxjhHUOYoaEYWYpKVbRVAU0dgKiOKDRjHKiESgARWf4L5/VHf1rqpd1b2b7t7V8P3WXlpdvXvX7qZ+/e1dj6/R3L/thAIFSgQVtMZWCgUKlAgqIC0UKBFWQFooUCKsgLRQoERYAWmhQImwAtJCgRJhBaSFAiXCikLajP2nc346v+vYBSiBlaYTf7t7ZMZdxxye5ciMphN/4/5RdJKS89P5jP2nuUmbWXDG7rgAJeDSWLrqXtlSk5TG0lXcP5DOUzILzvCR1nb0PJT2lLuOWdxdlctdxyzuH0inKnyk3flTZQSVv2bkce+DquAH901VuH8gnarwkdZ6pDKCypL0Xdz7oCrYZHD/QDpV4SPtD4edEVQWpH3PvQ+qwltSNdw/kE5V+Ei741CFXvlua+I7y87tOFTxXWFu0rJcco27wrLEd7bqPiTLN1tzvyvM/WbruR2HKr7bmvtNIb2az5IgZhh1uHDdkO6JZOPyRhV10PikwnPfzHz+6Zm5gXWDLMYKOUWLYDeuYheQu4p3qR20/x1B8b/wkTa78JxBmf/a85MzzmYd3D25O5J4euZu+Vlp/eAvzroffjGOfDa78FzWwTWD3a8bN9/byPOTM84ab1evJIgZBs9mHVwzeeZu5XYRem2Nos4X4wZ/cTbr4O7Jr81beTDAbpDFl7SiHWO7gJRYRG+EtgseU71L7aD976hzlqNVDQZF71VmlFYqWQfXDH5tTbZnj9etpnlWsshjiNuTlTPnzQ/Ulvglfzfu5+SZaya/Nm+l3OGMeYNV3zKvzVt58GxWxrzJM+c97bUo8O8R39JK4mKnKIi0wbRdEOzYLopO39Jevnz56NGj0vLRo0cvX74M0garGJhpOmk355UblGXT587Ze2rT0rkT009tzivflD63K0IIoQFLT2krb1o6Vlq/Kd22bO+pzXnlm/amTuzWEyE0YPrcAdNTly2d2xWhrtNtxhs1KO/9v1X6Xe2JEEKo58SlcidtE7tJTo6ds1fuf8+J6baJI+Yu25s6sR09kYuBrxZPWBXtdpqzcg2EBNFud9oFC1VrkvLy8hMnTpw4caK8nL7p9r+jzlmOVjUE8BQfadNzT1LLhg0JTyKEUM/YaWPQ8NXulXtyYp8d89GesvTckxtSxkiSxKZINQme7RmbUuZpgUrP2A1leps2KFPmiAbPbtizOnZaQuzwMf2m5WxISYjdUPbRtITP9+TETlvt7vzwMf2GJ3yekhC7oWzDntWx03KkN9IvJZDOSKXRkGMpKVnHUlKyXFlvv53lcjU2Nrpcx44dc8kVXK6st9/OOpbydsoxV9bb0dHRCCH0dpZLv8nGAwcOHDhwoK2trbW1VftswG+kk5ejVQ0BPMVH2o17TxmUWcPHxm3ISU8Z69VteMLnG056K0xL+DzX/TA9ZWz/lJO0RnrGbTi5ce+p9A0J/aflGG/RuEye9aXeU59PkyLt2FkbEroihLolxKUkxHVDCCGpV59PGxu3ISdueMKsDTkb955Kz03t735HqbNSUgPuUr0+dY4lvRFCvZc4HEuWTJrk/QwnbXNXcNdAvZc46uvrt02atK2urq7OsaR37yWOOmqbhYWFJSUlp0+fPnToELVCez7ezlyOVjUE8JRJpZ2Ve/LzDTnpG1JnbTj5+bSxcRsUWhpLK4nRP+XkrGkJn7tbkNRCXQOyd0qCaPBsem5q3PCxXWmB3f2tkZsTN9zd4fTc1Lj2fYNIRdfYbZNQ7yXblizZVudYMmmJY9ukSdvq6uvr6+q2LVnikBYmod7SE9JLJGkNvgWOHj1aWFj44MGDu3fvHjly5Pjx4yBtsIpkpur4E/kUtfCR1nigP2fE2AEjUNfptk17bRO7ITQiVV1h+txl6XMHTLdtJua0Utm0dCxCPbtOT50zQppVpg5AqOt0mzRPDmziYTCn3SxNoT3T1Dkjxg4YMXaiNCffa1smzcn3SrNZ93x7gNfqsQF3ycCx+vp6x5Il27YtWeKoqyOklS1VPfQpbX19/f379x88eCAtt7a23r9/X1WB++QwQos0cVVJSz5FLXyk/Ta/XK9szrO92Q0N+OzUt/nlmzfN7ToiNWGE+yFZAXWb+2XeqW/zyzd/NpZ81l1hRuq3+eUJM+Z+mZf65gzbt/nlX86Ym5B3ymC7BiV+yd8NO+zehNTPhBFjE/JSByDUdYbN258Rnt56Krez+Ja2rq6+vj5Y0vqk/e+oc5ajVQ0BPMVH2i37ThuUbze5j8SibnOX55dv2Xc6YSRCCA34a7mngk1av2Xf6W//OlZe716T74lmI1O1TQVQ4pf83birXUeO7erpXsLIsQn55Vv2nV4+43lpzbf5tjdHurf+bX7qgJGpgXWDLHry1NVtmyTNVj3SymFdmsHW19fLc94gStv+d9Q5i/F5Wr1X8ZF26/4zEVTmihnc+6Aq7XQs6HD/QDpVAWl9lwVp33Pvg6rwllQN9w+kUxU+0m4rOBNBZUn6Lu59UBXekqrh/oF0qsJH2qyDZ6G0p/CWVA33D6RTFT7Scr/mM9ILb0nVcP9AOlXhI+13hyqgtKfwllQN9w+kUxU+0jYAABAoIC0ARBggLQBEGCAtAEQYIC0ARBimkHba+jI0OQ9NzkNv56FJuWhSLvq/udPXuatdrqmr+Lk27J8MAAQT8qZN8qG0zNQUH2ldStDkvJoWLJUrLfgfN3H1TfzQxN2HDx92uVyTVx4fvrgo+2ClCwAiE4QQxvjChQtWq/XChQvSQ4yx1WpFCLG2Zgppp2842e2T4vRKvP4cXncWp57BfyvHKM6ekZFx8vzVf3tv3/OLTnT/y66NdvULAcD8qHIjSN5KugZgrMsk0jov/9Ll/bzZu+rdxp7GK05hNMGekZHxzjclHxbc2XERv7D4pCX+R8eJc8H4GAEgTPSb39xvfvNzMxvlNbK9AbfJR1pVWrCV9spfTy9Yew6nnsGrTuOvTuFlZfih8baN3259e4XjmcRjs47g94vwr2LtCV/v+uWXX4zTmgGAeeg3v3mn4+6v3ygNYpt8pG1SMmZF8UtfnJJGxX2WnV5WhpeW4ofG7czMzKy91jB8/q4/zHVMK8RPfXzspenby8vLmwAgQpClDWKbppD2iQ8PxNvq/3Yav/zl6eiPrE8k/LSoGD/0J2tmZmZTU1P2wfP/Y/SPUw7gwetr/9f47QcOHAji+weA0CEZ229+MyntY2+6qMsyqjmwtgIfaZuV/NOkXLGs7atT+KEJ9k1bto1bvOehP1n/z5QfHhr1w19WH6+ta3xoRPZb+/C43a3/NGz7zp07mwEgEiClldY89qaLuqxCNpb6LB9pbyh54oOCadb6L8rwP03cNf/r7KamJofD8dCoH8424i5/OThgtu3p+SWxefiVdbX/PiYzKyvrBgBEAv3mNyduapGkvXHjxmNvujDG2mUqCCG9p0wh7TjxeO+UsqWluHtScf8531dUVt24ceOh178/48JTCrBk7Jhc/L8/PNrnvcycnJzgfKIAEEqkMCtLK1lKLj/2pgv1PxxAy3ykbVGyevf5f528d1ExTjqGn0089sbCPXUNTQ+N3HHahd/ahyVjX9+F//mN72cs3l5UVNQCAKZHJa12WZI2gJb5SHtLyeVfmgcvPND7s1MfH8Xv5d0ZNs969OjRh0dkn2rAsXn4T7n49V04evXVfx+19b83ZVVUVNwCANMjjY3fXuENuaplSdoAWuYj7W0N1p8u9Zi5u/uCkscm7UnbmO1wOB4ann2yAY/Jxa/vxq/a8eAc/Nik/NFzspubm7UvBwBTQcqZuKlFKvLy2ytuyNIG0Dgfae/QyMw/8/KHO4fO2vH99983NjY+/MesE/VeY/tZ8cs/4If7f1tSUkJ9OQCYh+dmNsrS6pXH3nSh6IwAGucj7V0dTlVc2ruv8Pjx43fv3o1fdfzhIdseHrT14UEZDw/MeHjAlof7ffvaB5k7duzQezkAmITnZjb+6bPreqXf/ObH3nRJ0gbQOB9p7+lz8+bNW7duScsnTpz4XsOJEycMXg4AZuC5mY2Slr9+o1QuqP9hb4nOkEoAjfOR9j4AAIHCR9pWAAAChY+0bQAABApICwARBh9pTwAAECh8pH0AAECg8JH2fmtrCG6EAoCOTyuv4fHde/d5v3cAiEju3ed09BikBYDA4CbtnTv3QpDcAwA6Pnfvcrq4ouX2Hd7vHQAiklt3OF17fKPlVsD5IxFCqgWDmlq07fjTlKo1an8MmmLdFgDocfMWp7t8mm+0kMmXa2rrqWV20mfaTM1ylmdqumcyE7S2JvkSvWVtU8appVVP6TVlXAEA/OT6TU43wWulxTRU0mpVpHrFtEB9qMIfY6lR3Z9qBtsFAC3cpG1svllHUFNb/+AB1pbZSZ+R1VS7u7RG9a9qQQtZx6ACuVG9h9otUutrO6xXGQB80nidU46ohqbrZD9qautv323VFq20dTRDDKSlLmjl1JPHWGm9ldR2jDsGAH7S0MQpG+O1hmayHzW19a7rd3p9tMySIL788QpLgtjro2Wu63dU0koYS0sNa8a26MVY1UYNxFa1o6psIDZIC7ByrYFTsvKrdY31BDW19dXXblRfu3HnXitZZid9Vq9BckBakNdoH8o1VWjraFugbo5cQ13WQ2/Tfr4cAEiu1jXykfZKbQPZj5ra+nOXGrVFJS1179fzUPVC6hrj11KdJ/tg8NDPToK0ACtXajn9ErxW2uKKa9qiF2nrDX3zM9LqRTy9eGvw0Gcj1C7ptQMABnCT9nJNXQPB7KTP9EqDBoSQ8bKkhN5LqJVlDKoZNCWt1OuYQQe06wHAmMs1dXykvVj9S8Cd1vNH1sDAPb01VHlYvx0M/NeTE6QFWLlY/QsfaS9cuhrwyWWkvMTC5bliQVuNCtmIqk29Ndr2tfW1L/HZPrURADDm/KWrfKR1XrzC+70DQERSUXUFpAWASIKbtGcvVPO+WQIAIpIz56v5SHvs5HkoUKAEVvhIS72nBwAAfwBpASDCAGkBIMIAaQEgwgBpASDC6FDSVmWg8vXoeBo6tBLlLkPWFJS5EKXPQyHaHABwoYNIW5ONqjIQrv5KXU78EZe8Is5AS98FdYEOQkeQtiYb4aIuuPorXDEdV0zHZ9/Bp+PwyTckY/Hx3tjxHD7y5JwJvr1FCBk81KtsXA0AgktHkLYqA2GMjY3FV9bMeCNU0vqsCQBBpCNIW74e4WNRGGNc1IVi7OXl+EIiLuoy5VV/paXeHqRXGQDCjLmktdvtyTTsdrvBeziehnDdj25vMcZX1ijKhUTnZnR4FZo4yEfY1PqpDbzG+POJA0A7MZe0ycnJTOslDq1EuO5HXLPO7e2xKHcp6tK0E/28FUnSjuoTzOExiArwwnTStrbeb2tzl9bW+62t927fumEsbe4yj7QXEjHG+EIiLh+nlXZYdODDY71qGAbJQNgxnbS3b7fcvt1y+/bN27dv3rp1s7mp7solp7G01hS/pO3bwy9ptSqCtICpMJ20LS3Nqih3sfKkJK3ev5kL/ZI2+hm/5rTyQ/IpVU29BQAIA6aT9vp1V1NTfUPD1fq6mmu/VFf/XFF55rhxpE2f55e0PZ5gm9NSA6mezOAtEDZMJ+0/LlWcP1d67tTRsyePnCk7fPJ4QelPe42lTZvll7Rdu7T3QBTTQwAIEaaT9uTx/Yf37Ti4O/PA7q0Hdm8t2JVRmLvdWNrMhah8PTKQ9vAqtP0ThgNR5LLxAWSfDQJA0DGXtIGdp8UYZy5EcyYglbRNO5FzM3JuRl27+GssefRYu15b32ebABB0zCVtO5nyKpo4CI3qg4ZFo749UPQzqMcTfo2KASCCMK+0xkNiAOi0mFdaAAComFdaiLQAQMW80oYZyHoBRArmlbY9kZbptZD1AogszCtteAhi1gsACA/mlTY8kTaIWS8AIDyYV9rwwJ71wiaQdzMINmK9/ECu430aAIKFeaVljbRhzHrh9bPSZqvUbZvUGACChnmlZSWMWS8kG306CdICIcG80rJGWjLrBUIolFkvtKNfaY1KUY20lWIMQgjFiPrRGQB8Yl5pWSGzXiCEQpn1ghpptXFVtaZSjJF0tQmgLdAOzCttAJE2XFkvqONen9KSR7Bg2AwEjnmlZYXMeoEQCmXWi8CkrRRjwFUgCJhX2gAirZz1AiEUsqwX1NM5qpXK00JyTfecFma1QLswr7SscM96AQDhwbzShuc8LQ5S1gsACBvmlTbMQNYLIFIwr7Rhu8sHACIL80oLAAAV80oLkRYAqJhX2jADmSuASMG80kLmCgCgYl5pwwNkrgAiDvNKC5krAICKeaUND+3NXOHvpf82wX31onQpY5gvQtbLtuHna+GSaXNhXmlNnLkCs+/K8g231Dtvw4Cf2TaACMC80rISxswVOCBpY2JiYkSbGBMTE8NNWgibHQHzSmvizBWYlsZNEATdu3xysE1AgiAgQRBiRFFQ3/fjuTkexcTEaMaw6joIIcHmXim17HnavUjVknofEtlncltkt5E2QYfOq+DepTBhXmlZCWPmCky9wV2wadcr69uknV2uo8hl4cQ2AcWIlaqQ6Kkj1/VOjzWd8dbR6YDmu0bZZ/mOX1U143cKGTnCjXmlNXHmCkzblbW7u6Z+pRjj1RKrclnkKLzSNmi0Cck2w7GvwT36xHTXE2iJqj7fKWTkCDfmlZaVMGauwAFK645F2simrOM70lLzZhiPT72vsomqdow77/OdQkaOcGNeaU2fuUI18TM+OCzt4pWiaFNoQOSycNKlpc5pKZswVEd7yofeZ6KeKopqHxLvFDJyhBfzSstK585cEZT5pDSplpchfpoU80oLmSv8Q4p4wYlx5MFjUNa0mFfaMAOZK4BIwbzSwv20AEDFvNICAEDFvNJCpAUAKuaVNsxA5gogUjCvtJC5AgComFfa8ACZK4CIw7zSQuYKAKBiXmnDQ4CZK3zmoKBcpuBZRd6sA1cxAOyYV1qzZq7wJwcFeT2g+wJ9+dpg4v45uFQQCATzSstKuDJX+JODQmsjcT2/j/t1AMAH5pXWrJkr1DkoqLkjcjyZJWi3kvu8jw8AjDCvtKyEK3MFNQeFXu4IeZwM0gJBw7zSmjVzBTUHhUHuCJuAhBxcKcZ4UitVijEgLdAOzCstK+HKXEHNQYGVuSOkm909q2PESvn/SnFqTAyizWk9CSUAwAfmldbEmStoOSiUuSNoeZM8p3w8WV8E1agAgi7gH+aVlhXemSv8zR1hEyAtC9AuzCtt5GSuCGbuCADwiXmlDTOQuQKIFMwrLdxPCwBUzCstAABUzCstRFoAoGJeacOMP5kreglruBRenwlgTswrrQkzV4C0gBkwr7ThgSlzBUgLmAHzSmvCzBUgLWAGzCtteGDKXCEpFDV1e/pVjDHGV4tjp6YF5mHU1LwCdxeqFvhqhNNnA5gU80prwswVkkKxtqr05LRewpqodVU/27a3J4RGTc0rAGkBRswrLSthyFzhCbNuzaKm5hW0I9iCtEBgmFdaE2auUGkmLSe9u7cAY4yrFiQX/ywtTE3rJayJtTVKmyhY53Yyyl0B45I8PWk9dRqlYA7SAlrMKy0rYchcQZV2wdQ09wSViLrKp6SF7elXccG6NHWsJqSNmro9/WpjenKaKoaH4uMCIhfzSmvCzBV6w2PqKNcbV5X2GgyPiaNTmDxAxfQ5AB0e80rLShgyV3gORDVKI175QBRllKsfaXsJa2LX5cXqRlrKFDcUHxcQuZhXWhNmriDUwhi7x8N6J2+i1lV5NyPV9Kz52bZdGVS9r/XGZxgeAzqYV1pWwpC5oj1nd/wv1BNXABBmwhFpw5C5ImzSMr1xAAg6AUobZvzJXAHSAp2EMEXaDkOnfeOAeYiMSGseQFqAOxBp2ei0bxwwD8nJyV9nH1r1/U8Qaf0CpAW4k5yc/OnaH/66cXeYIu2kSZOGDBkyceLEwF7OHZAW4E5ycvL7ySs/Xr4phJG2tLRU3tcHDhzocrn69u2bn5+PMZ47d67D4fC/KYQQuSA/1FbT0q734AGkBbiTnJz8VvzC95NXhirSlpaWxsfHDxkyZNCgQatXr+7fv39BQUGfPn0mTJgQExMTHR09YsSI7OxsP1tTSatakOU0qNZOQiOtU7RYRKf+83b1Twupf2nIx9luoEORnJw8Xkh4b/6XoYq0ycnJQ4YMcblco0ePXrBgwebNmwsKCjIyMhYuXPjqq6+WlZW98MILr7/+ek1Njc+mSPGoEhor3d53gjEOubQ0Owkj7QLptvKRpyFvfado8bbirWoXkOE3BGB2kpOTx02d/V7iMt/SBnxV06BBg0aPHp2fn19QUFBYWHjkyBGHw1FcXFxWVjZ06NDnn3/earUeOnTIZ1+10qqGvtqoa/7hsUJTUianaNEEUB/SkgHbLiiac4oWr/6+Ajtgbhik1dtffe7Hq1evXrBgQUFBwZYtW+Lj4wcMGBAfH//dd9+Vl5cvWrRo9OjRVqvVZ0fJoa+eh5EfaZXrGKW1C7KWdkE7ZibXEVWBiINNWtbsE5MmTRo4cGD//v03b95cWFgYHx8/fvz4OXPmjBkzJj4+/ty5czk5Od27d+/WrdvQoUMNeok0h52oxpJiq6pFsrSKYS4di1hBNkIfARNrIdZGMmzSsmafkGaz0qi4qKiof//+c+bMyczMLCoqeumllyorK51O5+XLl69cufLss89Kx5MNMJYWR+bwGGNMaKkc0LJFWmWgpThJTngh1EYwbNKyZp+YOHFi3759+/Tps3XrVofDER8fP2bMmKKiopSUlPj4+Kqqqj179jzzzDNPP/10VFTUzp07jfvqv7TG1dpDyOa0/gyPVfFRKa1qQkuXVl4LoTaCYZM2gOwT+fn5EyZMWLhwYXFx8XfffRcfH//SSy/Fx8fv2rXr8uXLixcvHjlypNVqtVqte/bsMe6rykDjGWykRVp/pFWFR/1I63NOC5E2kmGTNoDsExjjmJgY6exOeXn5uXPnKisrL168KI2K+/Xr94c//MHP6yv0AqnKVeOXtBOO0ipO52BMk9b72Cla9I8eU9oCIgg2aQPIPjF37tzo6Gjp7E5ycnJOTk5lZeWePXsWL17cr1+/a9eude3atW/fvv70VW9IjIijyv68pD3wktYpWjQjXoOjx/JriENVRlWBSCIc52lHjBjxwgsvPP/886NHj+7evfvly5efffbZkSNHPvXUU127do2OjrZarYWFhT77qmegNrpG0PDYYxblkghyAko/GmxwntbHNmFCG8EwSNseXn/9dWni2q1btytXrjz99NNWq9XhcPTt29dqtfo8bmweTH7tsTTs1fvakoAroiKdMEmLMZaueRo6dOizzz77wgsvyBdU+BNjzYPJpQU6A+GTtmMA0gLcAWnZAGkB7oC0bIC0AHdAWjZAWoA7IC0bIC3AHZCWDZAW4A5IywZIC3AHpGUDpAW4A9KyAdIC3AFp2Qi5tJRsbdhXOka49r9zAdKyEXxpfaVH1TpM9xpjrL7lTnU/HuRh7CCAtGyENNLaBYsoChZRFCg5K/yItKq7d5yixWJR3jcL9/d0BEBaNkIkrRRuBbsnjHofqzC6e111k6wkqPrOWbiTNvIBadkIbd5jnTjqu44qGyPG3qCqGhNDrI18QFo2QhNpqbNUbZIopyiqgyRRSRlDva6qrIVQG/GAtGyESlrjySrGWH9e682OTLhJmqq0FkJtxAPSssEt0jpFwUKZzupEWu23AORh7DiAtGzwibTyMSWjSkRAVWdQJR5DHsbIB6Rlg8sVUXbpFBAtRpLhWH5em/XYuwYCbeQD0rLB5eixcVXFxRQ+pqswoe0IgLRsmPzaY+NsjHBFVMcApGXD5NICnQGQlg2QFuAOSMsGSAtwB6RlA6QFuAPSsgHSAtwBadkAaQHugLRsgLQAd0BaNqjSUn8BFACChXZ/A2kZ0H6CABBmQFo2QFqAOyAtGyAtwB2Qlg2QFuAOSMsGSAtwB6RlA6QFuAPSsgHSAtwBadkwkLYqA5WvR8fT0KGVKHcZsqagzIUofR7KTX0qnD0EOjwgLRtUaWuyUVUGwtVfqcuJP+amPvWgrRG8BYIISMuGVtqabISLuuDqr3DFdFwxHZ99B5+OwyffwCf+aPv6SdvKJx+0NdpWPmlb+WQw+wF5YzoxIC0bWmmrMhDGWGvsji9+33bzRFtLGW450XazrO1m2Y4vfq/bLj0TjDsfmzc5lEW0a7Ifg7ydDZCWDa205esRPhaFMcZFXWRjcckr+HjvLZ8+vuXTx3HtxoxPH89Y9Di1QU0KcvJXQNTJyr1+yg+UKZPlBKmKJHBEZlUwvAMA0rKhlfZ4GsJ1P7q9xRhfWUOW9Ym/u39h8frE300chHSa9GZBdZtIzXLqFk4nI6PkIqG16hcG6D9DAEQmIC0bWmkPrUS47kdcs87t7bEodynq0rQT/bwVrZnz28Or0Kg+etJ6VJLlpUirWUWLtKqfGJDXK/KTQ97jyAekZUMrbe4yj7QXEjHG+EIiLh9HSuvcjA6vQsOiqdJSfqBHEARVFK2Q46vRnFYRRQlpNT80DbE2wgFp2dBKa03xS9q+PfQjLcbUiKn5hR9iBcU9RQylzmm11YBIBKRlQytt5kK/pI1+hi4t/UCUUlr3wNkpWqi/VauZ0GLVMSfFz4RAqI14QFo2tNKmz/NL2h5P6ERa9+jVLlgEweOmerrqFC0W0U7+ip4fkVb/hy8h0kY2IC0bWmnTZvklbdcuenNa0lC7YBFFj6vk8NguINUpW2V0xtrgSo+08Kt5kQ9IywZ1eFy+HhlIe3gV2v6J3oEoGY+hitM2KmkRMprTGvxArfIX4sHZCAekZYN67fF7+t8AABo0SURBVHHmQjRnAlJJ27QTOTcj52bUtYuxsZ5ZrebnLO3ekOudt9ICrcdK+NW8zgFIy4bBXT5TXkUTB6FRfdCwaNS3B4p+BvV4Qm9UHCrgV/M6AyAtG3A/LcAdkJYNkBbgDkjLBkgLcAekZQOkBbgD0rIB0gLcAWnZAGkB7oC0bIC0AHdAWjZAWoA7IC0bIC3AHZCWDZAW4A5Iy0aIpPX33hvNffHey4mdooVMViHfgNuebVLvKYL7DXgD0rIREml17wPwSiLnfFPcJWsRnYp7AAyyv8liG6B+LXE7H8VUj/Rq+eEK51AD0rIRAmntgsVCv/fGq6hWQ+m+eZW0nrre3Is66eB0+qHONkXLYGVXN6WN2HAvUWgBadkIurR2wSI6dRKjEplk3FboRNrlFW69lK4YD4/1IaVVtEh2xPC2erhrN5SAtGyEZk5LmaoSq+mDWk+KC/Vd87pfAILdx+hYdl4jLfG/9s5dmrQQa0MJSMtGqKQ1toioaDSnVWZrpGd0JNGLxL6lJSMp9YAWhNoQAtKyEbJTPsaHb7Qxkjan9ScNq+oXDfyW1nM4jDws5u2bphkItSEEpGWDU6RVBU7pob603m8AzyrF0SkyjTktrHvWWwRBqksksIJIyx+Qlo3gS+vJs4ixXVAmYFP+LoBWWvkpxVSUPF9Leuk9goR0jy57nlcKp04qhw1+dQTrrwOCBUjLRvCPHotKF5DSMTeEtIJgURjkkdYuIGSx+HBFks0uSA34cXTZKVo8fSF1Vx89VodrCLShBKRlI/iRltznVZFWq69iiiqPYlUjWJ2htvenC5Ttq2bKyo6pJqbeCGo0aYUJbWgBadmAa49l9DI/whVRoQakZQOkBbgD0rIB0gLcAWnZAGkB7oC0bIC0AHdAWjZAWoA7IC0bIC3AHZCWDZAW4A5Iy4ZK2tZ790o3bUpDKH/2bGp924wZSxE6uW1bWHoHdApAWjZU0pZs3JiGEN42Ow2hHe++q6r8w3vvLUUIb5u9FKGidevC2E2gIwPSsqGSVjIWT0d4OkpDKJvw9ntBkIzFQxEeipYidPXSpbD3F+iAgLRsqKQt/PLLNIQkaSVvv5sxA2O8fepUlbFpEybk5+fTmpSvFvamllDfFku5EBnuo+m8gLRsaA9E7Vu8eKXGW9LY+QitHDPGarWeP3+e1qTn5lhJWs99stJF915ppf8UqddE7a00SpUp9yLAhcG+UdxLof9p6d4WYZgtJBiAtGxQjx5n//nPbm/fQjgOJSuN/drIWMwgLXkjD/UOOHXmJuVdQ+oEUIAOPu/wl5+ifpCh/4BBWjb0Tvns+MtfliKE4xAehSRdcX80H6GVsbGGxmK/pRWlfUElI3nLu48MiTJws6sxys/H+0iOwKqbExXrlTMc1UuCBEjLhsF52sIvv0xGXmOT/TWWfverlAuZkFYQpDtikcWifIkgCMgiVqjyyBgnnIJYa4BSWqf8Zan6cnSKFotYobNelYA2uN+TIC0betK6jZVGxf0R7o/wf6D5CK0YN85Xk8zDY/JlBMSOoc4Go/q2h1BrCFVaZdIAWeMKnfWKMOtjcswMSMsGVVqFsUPRFITwf7jLbIQ2Tp1q2CTTgSgp2YwaxRc8ph5uUk3UINTqQx0ea7/oZGlp60OacwekZUMrrdbYlbGxKm/X//nP+k16wijL0WNsHGkp1qqehUirD/VAlPfggWeVPDymrXdSXxIkQFo2tOdptcZardYV48aR3goIbdKLt97hl2CXrNSmL/YMtDwZ3ATPT+KRe4NCVE2CJ3+PUgG6p3z8OhDleQwHosyDSlqVsSvGjLFardJTPyYmkt5OQehUWZm2QSKZoiAIihxtWDs2IxKrkjmIPSlYlfsGLU0iptQDIgyQlg2VtD98/LF0xHgK7QoK2dspCK2dPFn2mcQueC6EslgsFtEuuhOkqlItqn9Mknpow6+5KkxoIx6Qlg3tnPaHjz+eglDqhAnUszuSt5Kx//jHP0LdPb0MiTJwRVQHAKRlg3r0uPrSJYPzsafKyqxWa3V1dYi7BnQWQFo24CZ4gDsgLRsgLcAdkJYNkBbgDkjLBkgLcAekZQOkBbgD0rIB0gLcAWnZoEqbDAChRLu/gbQMaD9BAAgzFGkfAPqAtAB3KNLeb21tBnQAaQHuUKS9e+8+bzXMC0gLcAekZUOWtpewBgqUMBddae/cudcE6ADSQuFYdKVtuX2HtxrmBaSFwrHoSnuj5VZj+0AItbOF4LYTRIylff8b/M4yPH4JHjEf9/8I95mJewlrclOf4v7HhtIxiq60zTdaXAQ1tfXUMjvpM5cOCCG99cb43xQv9KT9eD2OX41f+UBR+sTj3NSnHrQ1grdQglIYpKUewgpAWn/qBCB2OKFKm5iu1lUqtq+ftK188kFbo23lk7aVTwbxjxe1qPhiTXHc1DTuuxGUcBZdaRubb9YR1NTWP3iApTIjdbu8PDvpszodEEJ6T/lZR/usP22GAa208zfSjd3xxe/bbp5oaynDLSfabpa13Szb8cXv9f4YUWursEbCqKl5BRgXrE1LKvF8U9YUJ9lcqm/Pi7asXsKaqEXFBbasqKlZ6TVVSVPT4myugrVpUWurcEmeos1FxRdL8noJa7xtEhSsTZM2Kj/UVKtK8nQyampeAXalL6J/cURNzUqvUbQcR/YcvnGCK21D03VyN62prb99t1Uqb3/1bVvbA2nZWFoV1Dp1+ipGkLQfpGGM6d5u+fTxLZ8+jms3Znz6eMaix6l/hji1hFVJa6u0hkg1JT97EZE2am2VvDLO5ipYm5VeU5XuqSmpq3DJK63at6QSj7Q1xXEe7clq8jeCXJ+Guz5ZWWpK7r+8Ce8n4PlmIb8ysOfLRX6DUHSlvdbQTO6mNbX1rut3Xvjwi+jZy1+cszx69vIXPvzCdf1OsCKtP96axNg6mrTC1/hYNcYY76ugeLs+8Xf3Lyxen/i7qNFl1D+Daue+aMvShsde3lBM7NMkNcUf56gjcMFaZeWa4r95NasqMIi0utLmFXi+R5JKMC6pKlB+rSSVYEI/vyItOc6PWlsl1ZTf8kX32EE3nne2oivt1brGeoKa2vrqazeqr924c6/1SeHTO/dapTI76bN6HRBCek9R61Dr+6zABa20b32Oj1XjfRX4xxK8r8K98GMJ/iANf5CGxy/Ba+b8tk88fv4Nh95fwr3jemIgZUxL2KJ4iTLS9hLWJNmqCmrcSsTZXNIC+XKDSEtsy2uaVE32TQ7g3pgpqb6o+CLhm7a4v480I2opvJNNUbpE+xbrnEVX2iu1DeRuWlNbf+5So1SeFD5tuX1fWg6itHovkVaax9h6mrRjkr3Sbi7EqXvw59/hpM34gzT856/w+CV4WCLuE497jNxHM0QRjtyqlFQpHtcUx8oDZoM57dSs9BosDY+T1lZdtOWll1QV1FQlTU1TRDONtKpjWgaRltL/RcUXlYGatJQSylXv693tchSlzuq9W4E5MKu0xRXX5HK95Z60EAZp/WwqnGilHTHfL2mfe9Vu8Mcgp3lyYFEJo6ij2Y+lyp7BdlZ6iSReVfoiRTR2a1ZTnE6dkdYUx767VymtqoZrQ/J27xeNug+e9URglELoRVsWOXgmnvIMAQyk1Qw0Om3RlfZyTV0Dweykz/RKgw4IIb2nAqjjT82woZV24Cz/pB22g/pnoB+IUkrrPhS8qPhiSR7l8I9ssmb6J/nvOcLkieoleWRNSqQlImdSiSvdVkUMhtXyqMbnciH6SRxwXltFdjs2+bhiQqsrLUxrfUl7sfqXdu7Z7ZdWOuas95AjWmn7zPRL2u6DN1P/DFGLii/iqqSpeQU17tGsPGNUjWCTiEPBtEhLMdktKunkouKLJXmSfunq7wspVmuHx25XiaksZVRPNqKt4z7/pO4eEWn1TyBBpPUt7YVLVwO46oD1ogjjiytYnwobWmlf+otf0v7nwHW03dEdQzyq5BXUFKd7XCWHx0klUsiiHz32HAqqSvKISh7doUir+RaQNyd/HZBzWrdvlDPJihhIHgnXnvKRY7L8vaASNc7mwsRDb33PW+PuDPeiK63z4hW+YpgZ6hVRMe/6kJZqrHLv9+zHRAjVSEs/U6JoRPa4JE8+gyIfRpallU5+akbm7gPF5Dle5dFj5dhbc8RYGTl9R9pexNFjWVRvHfnsERw9Bmnbg961x9GT8X9NbNJK231I5n8O/G9DXb1TTdVOnOQNud5zLbRAi7F7rqsIU+rJpOc87UVbMTkAlnsibS6pxJW+SOqS9NDbNzluxyoDL3kM2XvEy49I28uPI8MwofVL2rMXqnnfS2NejO/yeWH8+agxp59/w9Fj5L7nhu3sPiST+5/Z/EW6Ior+ZYQxXBFFFl1pj508D0WvwP20UDgWXWl5Jzw0NSAtFI5FV1rIxmgASAuFY9GVFhK7GQDSQuFYQNpAgBSqAHcgGyMbIC3AHcjGyAZIC3AnmNkYkSd5IvUyRp/VqE01+peT0Z929Jpi2hZV2uD8NBoA6OBb2vZkY5SuDdb7l6yjt9LnU/JKgwub/WnW/22RaD9BAAgzfklLfaXPbIzUf0nN9MTzxzR/niW/HbT4U03bJkgLcIcirUE2RrIwJXZDvjJCqV5u3IiqJvUhdYva+mTLBq3JgLQAdyjSGmRjJItKWq1X1J2eNITqpFZOPc+NldZbSW2njiY5SAuYE4q01GyMvT5aZkkQX/54hSVB7PXRMr1sjCppqaHMZwykNqLdlqqO3lN6ndF7LUgLmByKtAbZGMlCzRGFPKnYEC0FFKmN6iGi5V5ERGI3pJP5jboh7bIeqq37fDlIC3CHIq1BNkayGEirWtbzSs8QlaV69Q2o9+8LwnhDIC1gTvySlszGKBef0tbTIiG50iDSGvvsc6PGdQy+RFSea9sBaQHuUKRtTzZG5MmfKKF9llyPdFK3kQsk1G1RF7TNqrZFbUf7LrRvEKQFuEORNuBsjAb7OrWanpM+pWrQl1AlPLlez3+9DoO0gDmhSBtwNkZyWYvx5RAGFbT1tdsyrh9A+9RGXKG4uMIpCqITY6doEezyf3YBCXZVNYtgxxjbBcpn665rFxCyiE5p0b2AsV3wrKS82CI63dvybkB+paob2k7pr9XrqbrL7reGkEW0ixb9OgABRVpI7GZAKCKtU7QIdqdoEUTRIgnjEUhdCSudkiCtcYoWyVBPNclju9OpqS6/TCWttkFldVrn/XqP6n67bZXlVLWk2KCnG06l2N4KxDdTxwekZSPo0jop8UUZoyziOu9jQTCItARat73P+JIWY7sg2PUipfs7wc8oSrxNnQ7J/dCX1vti+TvEUwVRKnV4KNJCNkYDQjSntYuCYHELIUdL9Y6rE2ndLRhqhBCKWZ6r+X7wfA2opdW2rXpKd0ys9xRNKcX3lcHwWPkpKFsnVxh0qmNBkZZ7xkMzlxBIK+13TtEi2O2CRbSLgiBI/pB7ulZaemhxz2vdDmt3YvlVOpFWMsdTRVlVM4JWDRM8QZgl0kodNZJN9Smo6hJrOk2spUjLu0umJujSesSQhJCPSgnkxBRjjx8WUaRG1JjERIsiOnkPaCnjlnfup5aLiLReWZX/06QlfQpAWrtosSBBFAXqG9M0aChtpwm1IC0boRkea3ZpuyBNbT0BTraOqGkYWOijaHKv9i57zCaON3uPYhmOWNstrV0URQEJdmkWTa2peEyVVtOFjg5Iy0YIIi0luMinQbx7IHEuSFRP/izLK7THs6hRS4HuLFZlvFN7UDs4w2OnKMhnnHTOR2EfkVZx1BgiLUAjFOdpPfuhaqRHk9YpWiyiXX2YVaODXUAWizomedv1pbVi3ozoB6c1kVb1lPZdaqW1i6KTNkzXjDp05rTEeWnFk/KhPO1ChwCkZSM0w2NCJc+5FslQxe4q2KX9VxNVid1Rask7baUqh4kmdTsj2N1W6XS4/UeP6fW1NVVHj3UHD+TJI5A2KFRloPL16HgaOrQS5S5D1hSUuRClz0Mh2lyICM3wWGWd8iokz3laiygKnj1QFWm9w2Od48kIkQerjILtOnkbenXoV2wRL/HjTC7xZSI1pbM9eVju27jOMqHF4ZG2JhtVZSBc/ZW6nPgjLnlFnIGWvhsx6sK1x1yQRr4G3wCd/Yqo4G6gJhvhoi64+itcMR1XTMdn38Gn4/DJNyRj8fHe2PEcPvLknAm+vUUIGTzUq2xcjRWQFuBOyKWtykAYY2Nj8ZU1M94IlbQ+azIB0gLcCbm05esRPhaFMcZFXSjGXl6OLyTioi5TXvVXWuroSK9y0AFpAe4wSGu326npz+12o3Njx9MQrvvR7S3G+MoaRbmQ6NyMDq9CEwf5CJtaP7WB1xh/Pg6fgLQAdxik1dtfjffjQysRrvsR16xze3ssyl2KujTtRD9vRZK0o/oEc3gcXFFJQFqAO2zStrbeb2u739Z2HyHU2nq/tfXe7Vs3jPfj3GUeaS8kYozxhURcPk4r7bDowIfHetVwCAbJIC3AHTZpb99uuX275fbtmwihW7duNjfVXbnkNN6PrSl+Sdu3h1/SalUEaYHOBpu0LS3Nqih3sfKktB/r/Zu50C9po5/xa04rPySfUtXUWwgKVGn9/O0zAAgM7f7GIO31666mpvqGhqsIoWu/VFf/XFF55ri2UZL0eX5J2+MJtjktNZDqyRxEb43fLACEATZp/3Gp4vy50nOnjiKEzpQdPnm8oPSnvcb7cdosv6Tt2qW9B6KYHgYMSAtwh03ak8f3H9634+DuzAO7tx7YvbVgV0Zh7nbj/ThzISpfjwykPbwKbf+E4UAUuWx8ANlngwEA0gLcYZA2sPO0GOPMhWjOBKSStmkncm5Gzs2oaxd/jSWPHmvXa+v7bDMAQFqAOwzStpMpr6KJg9CoPmhYNOrbA0U/g3o84deo2FSAtAB3ApS20+67nfaNA+YhfJG2YwDSAtyBSMtGp33jgHkId6R96623Bg8eHBcXF9KthA6QFuBOOCJtaWnpJ598Ii0PGDDA5XK98sor+fn5GOOEhASHw8HebW6AtAB3Qh5pS0tLZ86cOXjw4IEDB37zzTf9+vXbv3//yy+/PH78+BdffLF3797Dhw/PysryszXVxYl653Ui69Y8/XxMlF/h6hxJQgEjQh5pP/nkk8GDB7tcrlGjRiUlJW3atGn//v1btmxZsGDBsGHDysrKoqKiXnvttZqaGn9aM7i0mJQzdFcgh0haWn4jerJE4/xlBr8u16myKEUWrDtnOOa0AwcOHDVqVF5e3v79+w8ePHjkyBGHw1FcXFxWVjZkyJCePXtardZDhw75bMfn5cTGSrf3bWCMeUdaT3Ud+/R+Xc7nCwGusI4Ew3FF1DfffJOUlLR///6ampozZ844HI4zZ87U1tbeuHHj/PnzpaWlVqvVz/emWlYNfbVRN1KGx7qRlpKrVPEDj6ondH9dTlMDMA+suyjbtcdM6zHGb7311oABA/r167dp06aDBw+eOXPmuZEf/lr46dF3ix6deuTRacWPvrP/0cn5//qW/Tdj/+7PG8NKIbV1fC60kzBKq/OU+4dBqL/yYfDrcr62BPCDNbSwScuauUKazUqj4kOHDjkcjkcmbP/Nx1d/NXxFtNj82wUtv/no/KPvOR5999AjE7bv3LnT4F1hX8PjyJ3TGmUGV6vnsZEegRW/eUNrA0KtGQmttKyZK+Li4l555ZWXX345IyNDGhU/MmH7b2Zd/NXwFf+VUvWbDyskYx/988FHJmz3OUg2lhZH7PCYCl0v79EkTdD08etylEqASQjt8DiAzBX5+fnjx49fsGBBcXFxbW3tIxO2/88Pzv1q+Ir/SjnvNXbiD8GV1rhaewi6tD5/7U75q3AGUdP4d1zprwHMAGtQCXnmCozxiy++KJ3duXHjhlfaRWe9xo7byiot9jWDjbBI6/4ZaS9avbTnbJRr9H9djtgKnOc1Iaw7Z8gzVyQkJPTu3Vs6u1NZWemVduFJr7EBSYs1c12tnOaPtBJOu10U1D/ERejlFC3UI8aKX4PT/XU5uQoE2g5ByDNXYIyHDx8eFRXVs2fP0tJSWdpHJv7gNfZP6f8y/KsApMX6N8cbvKQ9hHxO69VNMRDWn4kS3vqYscKEtoMQjvO0GOPXXnvNarVardZHJmx/ZMJ2bYWApdWu15sb+uykP5j82mODX5eDK6I6DOG7y0e65unZoe/98zDxX0as+JcRXxNlxa9eXe7nJRZ8Mbm0QGeAw03wu3btstIwOE9rHkBagDuQuYINkBbgDkjLBkgLcAekZQOkBbgD0rIB0gLcAWnZAGkB7oC0bIC0AHdAWjZAWoA7IC0bIC3AHZCWDRPkiNLJ+AZ0GkBaNnhlYyQfqJbJ19KzMVrEdXDhcQcCpGWDV6T1S1qjbIxwi0/HAaRlg1c2Rn+k9ZGNEW6m7SiAtGzwysZokPvN81pf2Rgh1nYUQFo2eGdjdFenRVrdbIyQt6KDAdKywSkbo+5BKYztghyLfWRjhFDbQQBp2eCSjbHCH2l9Z2OESNtBAGnZ4JSN0U9pfc1p5YNaUk3tAhAJgLRs8MzG6OtIlL9Hj0HaCAekZYNLNkZD5EhrPGmFCW3HAaRlw+TXHutlY4RUjB0JkJYNk0sLdAZAWjZAWoA7IC0bIC3AHZCWDZAW4A5IywZIC3AHpGUDpAW4A9KyQf0JMgAIMyBt4Fy/fr2ioiInJ2fdunUrVqwQgU7PuKmzw1Deil/4fvJKkDYQbt26VV1dfeTIkZycnOzs7Cyg0/Ne4rIwlPeTV368fBNIGwj37t1rbm6urq6uqKg4ffp0OdDp+WR1dhjKp2t/+OvG3SBtILS1td27d6+lpeX69evNANDc/HXWoXCU7EOrvv8JpA2EBw8ePHjwoK2tra2trRUAWltTdxaHoaTlFKflFIO0ABAEZI/CUEBaAAgCIC0ARBggLQBEGOGU9v8Dz4B9XHOf9Y8AAAAASUVORK5CYII=" alt="技术分享" />

Step2:指定数据库服务器的定义:

名称:ODI_SRC

数据库服务器:localhost

连接(数据库的用户和密码,该用户的权限应高于或等于数据所在schema的权限)

用户:ODI_SRC

口令:ODI_SRC

ODI Studio拓扑结构的创建与配置(Oracle)

Step3:指定数据库服务器的JDBC:

JDBC驱动程序:oracle.jdbc.OracleDriver

JDBC URL:jdbc:oracle:thin:@localhost:1521/pdborcl

保存,点击测试连接测试成功即可。

ODI Studio拓扑结构的创建与配置(Oracle)

相同的操作建立数据服务器ODI_TAG

最后效果如图所示

ODI Studio拓扑结构的创建与配置(Oracle)

2.3. 创建物理方案

Step1:在新建好的数据服务器ODI_SRC上点右键选择新建物理方案:

ODI Studio拓扑结构的创建与配置(Oracle)aaarticlea/png;base64,iVBORw0KGgoAAAANSUhEUgAAATEAAAGUCAIAAADS1oJiAAAgAElEQVR4nO2deVQUV/7ob3LOvHN+M/nlzeQ3Z977Jee9mTc6WRyjYkaGToxb1DFoosYVMi4xseMSMS5oUDStgsaYtMaooCaKEhFFMWnpVhEUBTW2LLKpNIgLEY1gAyLiAt73R3VX13LrdnXT1dXL93PuwerqW7eq2/r0995avoU2G4ugQIHiOwWpvgVQoEDhFnASChTfKuAkFCi+VcBJKFB8q4CTUKD4VnE4mXK8POPnqkPnLkNxrzSe//bhmRkPzfPVLGdmNJ7/VvWvIkhKxs9VKcfLlXIyNeeCyXwZituloWjDo+KVPlIaijao/oUET0nNuaCIk8azVVA6Uh6a56quIlsemueq/oUEVVHEyYM/V/pR+SIlS/VtEBT85LFPFdW/kKAqijhpOFPpRyUu6ZDq2yAo2MdQ/QsJqqKIkz+etvhRWZJ4QPVtEBS1HRSi+hcSVEURJ9PzKqTK/t0xH6y5lJ5XsT83M3ZNJneOrcKamA92S77klo27M/fnZm7cfSk9r2L/7syNueRqTku0PoW2wblbB3WN4TbOrpRXB42Nzb20cVaPl2ZlurcZ3EI3xKLXaE30KiYtslVxTHWAjn8iKPKLIk7uy71EKYve6TE55WLaycOTuyKGl2YdZt9l5g/88qLt5ZdjuO/uy72UdnLzQNtyYxY5GukxOeUifb1SJVqfQnk37eTmybMO89eL0DubeXW+HDPwy4tpJw9Pfuez9Sfd3Axuceak3oSxSYv4aPSO+GrS2kV0THWAjn+i4Cxnq+9QitRSKjjJlLSTmwe+s3mffYeWrCZ6l5HELoBNg/WzPlvkrgxRcd/Rt3PyrM2T3/lsPbvBKZ8NFPyIvPPZ+pMX01I+mzzrs5cckrj/M+HcScZLbNFr9aSerkmrNWGTXm9x7uT169fPnj3LTJ89e/b69evgpKcKRTxvO5mcVUYpa6YvmH+0dOfKBZFJpclZZTuTFnRGCCHUf2WpuPLOlaOZ+TuTjGuOliZnle08mhDZpTtCqP/0Bf2nJ6xZuaAzQp2nG+krpZSPF2+Q3tTuCCGEukeuZDfSGNmFUW70/KPs9nePTDJGDl2w5mhCZAe2hC0UHTX2oKg3mUhKsjUQ0upNJotJqyFay6WsrOz8+fPnz58vKyOvuuOfKDjL2eo7bryliJNJmSXEsn17dCeEEOo+ftooFL7JNvNIxvhXRs05UpyUWbI9fhTjwPh4piaHV7qPjy+2t0Ck+/jtxVKrppQp8/WUd7cf2TR+WvT48FF9p2Vsj48ev714zrTo1Ucyxk/bZNv48FF9w6NXx0eP3168/cim8dMymA/SN96djWFKA5Vz8fFp5+Lj06xpkyalWa0NDQ1W67lz56xsBas1bdKktHPxk+LPWdMmhYaGIoTQpDSrdJMNJ06cOHHiRHt7e1tbm/hdtz9IkJez1XfceEsRJ3ccLaWUueGjI7ZnJMWPdtgUHr16e4mjwrTo1Zm2l0nxo/vFl5Aa6R6xvWTH0dKk7dH9pmXQ10gvk+d+JfXW6mlMnBw9d3t0Z4RQl+iI+OiILgghxGzV6mmjI7ZnRIRHz92eseNoaVJmQj/bJ0qYG5/g9ibVS1NnjuuFEOoVZzbHxU2c6PgOJ+6xVbDVQL3izPX19XsmTtxTV1dXZ47r1SvOXEdsMzc3t7CwsLy8PC8vj1ihI19vMJez1XfceEsdJ+dmlqzenpG0PWHu9pLV00ZHbOdZR3eS2e/7xZfMnRa92tYCYw7q7JacU6L1lHeTMhMiwkd3JoVl249CZkZEuG2DkzITIjr2A8EUSSH3TES94vbExe2pM8dNjDPvmThxT119fX1d3Z64ODMzMRH1Yt5gFmGcpEh+9uzZ3NzcJ0+ePHz48MyZM/n5+eCkpwojnuDQDvctYlFhPDl/6Oj+Q1Hn6cadR42RXRAamiCsMH3BmqQF/acbkznjSabsXDkaoe6dpyfMH8qM6BL6I9R5upEZo7rX6aeMJ5OZ4at9iDh/6Oj+Q0dHMuPho8Y1zHj4KDOStI11+zukHe32JlEUqq+vN8fF7dkTF2euq+M4yUooeOnUyfr6+sePHz958oSZbmtre/z4saCC6gMzPy3MoFHgJPctYlHEyR+yy6RKcpbx/S6o/6rSH7LLkncu6Dw0IXqo7SW3Auqy4Kus0h+yy5JXjea+a6swI+GH7LLoGQu+ykp4f4bxh+yyr2YsiM4qpayXUqLivqNusG0VzHZGDx0dnZXQH6HOM4yO7Rlq31p75Q4W507W1dXX13vKSad0/BMFZzlbfceNtxRxctexckr5YaftGCbqsuDr7LJdx8qjhyGEUP8vyuwVjMz8XcfKf/hiNDvfNifbHouGJYibcqNExX1H39TOw0Z3tm9e9LDR0dllu46Vfz2jBzPnh2zj+8Nsa/8hO6H/sAT3NoNbpNyoq9szkRkp2p1kgzIzeqyvr2fHmx50suOfKDgL/fyk1FKKOLn7+AU/Kgv0Kapvg6B0UCGPo/oXElQFnLywJPGA6tsgKGo7KET1LySoiiJO7sm54EclLumQ6tsgKGo7KET1LySoiiJOpp28CKUjRW0Hhaj+hQRVUcRJ1a8z9PeitoNCVP9Cgqoo4uT+vAooHSlqOyhE9S8kqIoiTt4BAMBdwEkA8C3ASQDwLcBJAPAtwEkA8C284eS0bcVochaanIUmZaGJmWhiJvp35vSttmrXa+sqrt7y+gcHAE/CvYuP+5KZdqkpRZy08kGTs2pbMFNutOBf7uGae/ipyMOnT5+2Wq2T1+eHrzi172SlFQD8E4QQxvjy5csGg+Hy5cvMS4yxwWBACLnamjecnL69pMvnBUmVeNslvPUiTriAvy3DKMKUkpJSUnXzf318rMey811nHtphEi4IAL6P4FZ3RkvGRjeEtHrHScv1X1/4JGveoXqbkOV4XSlG40wpKSkfbCz8NOdB+hXcc0WJJuon8/lLnviWAMBL9F3U1HdR06uzGtg5rJxut6mIk4IMS+tNlb+fnrPlEk64gDeU47WleE0xfmqscccPuyetM78cc27uGfzJKfy78abobw79+uuv9AxRAOA79F3UdND88PfDizzYpiJONvIZta7g9S9LmS5r7zXla4rxyiL81JiDqampt27fCV906G8LzNNy8YsLz70+fW9ZWVkjAPgJrJMebNMbTv710xNRxvpvy/EbX5WHzjH8NfrnZQX4qfcMqampjY2N+05W/Y+RP005gQduu/W/x+49ceKEBz8eACgHI2TfRU1cJ59730qcZhGMP8UVFHGyic9vJmbqi9vXluKnxpl27tozZsWRp94z/L8pPz414seZm/Jv1TU8NXTfhGN4zOG23wzZe/DgwSYA8Ae4TjJznnvfSpwWwApJfFcRJ5v5/HV2zjRD/ZfF+DeRhxZ9s6+xsdFsNj814seLDfiFmSf7zzO+tKhwfBZ+c+ut/x6VmpaW1gwA/kDfRU0xO1sYJ5ubm59734oxFk8TQQhJveUNJ8fo83vFF68swl1jC/rNP1BRWd3c3PzUuwcuWPGUHMwIOSoT/99Pz/b+ODUjI8MzXxgAKAkTJFknGQm508+9b0X9TrvRsiJOtvDZdLjqPycfXVaAY8/hV2LODV96pO5O41PD0suteMIxzAj57iH8H8MPzFix99SpUy0A4PMInBRPM0660bIiTt7nc/3XpoFLT/RaVbrwLP4468GQzwxnz559eui+0jt4fBZ+LxO/ewiHbrr53yN2f78zraKi4j4A+DxMx3XSOkfAFEwzTrrRsiJOtoow/Hyt26zDXZcUPjfxSOKOfWaz+anwfSV38KhM/O5h/LYJD8zAz03MHjl/X1NTk3hxAPApuO7F7GxhCjs9aV0z66QbjSvi5AMSqdkX3vj04OC56QcOHGhoaHj6X2nn6x1C9jXgN37ET/f7obCwkLg4APgOr85qYJ2UKs+9b0WhKW40roiTDyUorbh29Fhufn7+w4cPozbkPz1oz9Nv7X76rZSnB6Q83X/X031/eGd2anp6utTiAOAjvDqr4b1Vd6VK30VNz71vZZx0o3FFnHwkzb179+7fv89Mnz9//oCI8+fPUxYHAF/g1VkNjHW/H17EFtTvtKOEpjDFjcYVcfIxAADuooiTbQAAuIsiTrYDAOAu4CQA+BaKOHkeAAB3UcTJJwAAuIsiTj5ua1PgzhgACHzaFOq7Pnz0WO2PBgB+yaPHyhx3BScBwD2UcvLBg0cKZFoAgMDn4UNlrhloaX2g9kcDAL/k/gNlrndtbrnvdiI9hJBgglJTjLgdOU0JWiNuD6UpV9cFAFLcu6/MfSFNzS3cHLK1t+qJZV7sKnHCWTZZLTFrLTehrbgmdxGpaXFT9Ay5grekmqJXAACZ3L2nzD3NYicxCYGTYtOI2rg0QXwpQI6QxJgspxplvQAgRiknG5ru1XGovVX/5AkWl3mxq7jVBHszM0fwVzAhhluHUoG7UqmX4jUS64s3WKoyADil4a4y+XjuNN7lrqb2Vn3rwzZxETtZRxKA4iRxQuyelBt0Y6VmEtuhbxgAyOROozJ5627faeKupvZWvfXug9fmrNFE699YuE4TrX9tzhrr3QcCJxnoThKDEl0GqQgpWCnFW0E7gsoUb8FJwFVu31Em5/LNuoZ6DrW36mtuN9fcbn7wqI1b5sWuqhfB7OLMBDtH/JKtKUBcR9wCcXXcOcRpKaRWLXNxAOBys65BESdv3LrDXU3trfpL1xrEReAkceeW0kywIHEOfVmi0txtoLyUuZHgJOAqN24p85xmsZMFFbfFRSpO1lN1khknpeKVVLSkvHTaCHGTpNoBAApKOXm9to77fPZ5saukCvG58PRpZo+XWoRYmYVSjdIUEj2VXuYGiOcDAJ3rtXWKOHml5le3t0lKD3Yvp6glNYfohqvyU/SWcg+cBFzlSs2vijh5+dpNt8+ZIv6VA1b7iXhxNSLcRgRtSs0Rty+uL17EafvERgCATtW1m4o4ablyQ+2PBgB+SUX1DXASAHwIpZy8eLlG7cvrAcAvuVBVo4iT50qqoECB4l5RxEniXSAAAMgBnAQA3wKcBADfApwEAN8CnAQA38KfnKxOQWXbUH4iyluPMtcgQzxKXYqSPkMKrQ4AVME/nKzdh6pTEK5ZKyzn/4UL39TPQCs/AjOBAMEPnKzdh/CpF3DNWlwxHVdMxxc/wOURuGQ4IyTO74XNr+IzneaPc64lQojyUqoyvRoAeBY/cLI6BWGM6ULiG5tnDFfKSac1AcCD+IGTZdsQPheCMcanXiAIef1rfDkGn3phyttynSTeUCJVGQC8jFedNJlMOhImk4myifmJCNf9ZNMSY3xjM69cjrEko9MbUORbToKeWD9x2KQj5wsFgA7iVSd1Op1L8xny1iNc9xOu3WrT8lyIrZx6ofEgurobMU6O6O3Jvit4CKiFt51sa3vc3m4rbW2P29oetd5vpjuZucbu5OUYjDG+HIPLxoidHBLqft9VqhqGHizgdbztZGtrS2trS2vrvdbWe/fv32tqrLtxzUJ30hAvy8k+3WQ5KTYNnAR8Cm872dLSJIhRVypLGCel/qYuleVk6MuyxpPsS+5bgppSEwDgBbzt5N271sbG+jt3btbX1d7+tabmakXlhXx6nEz6TJaT3f7q2niSGAalXAUtAa/hbSd/uVZRdanoUunZiyVnLhSfLsnPKfr5KN3JxLmynOz8QkeP8bj0EgAUwttOluQfP30s/eTh1BOHd584vDvnUEpu5l66k6lLUdk2RHHy9Aa093MXjvFwp+mHXp02CAAex6tOund+EmOcuhTNH4cETjYeRJZkZElGnV+QKyT3uKt4vri+0zYBwON41ckOMuVtFPkWGtEbDQlFfbqh0JdRt7/K6rICgB+hmpP0/ioABC3+FCcBIBiAOAkAvkWwxEnIUQD4C34ZJ11aFnIUAP5FgMdJD+YoAADvEOBx0oM5CgDAOwR4nHQ9R4FRy71AXmvkzGdfsHUcbwOAp/CbOOnFHAUO/SqNxkrJtrmWAoDH8Js46cUcBYxsTpUDJwFF8Js4yc1RgBBSMkeBuGvKzBEYKHKyUh+GEEJheunYCgBO8ac4yeYoQAgpmaOAGCfFUVEwp1Ifxtho1IKVQAfwpzjprRwFxE6pUye5B4egTwu4jz/FSTZHAUJIyRwF7jlZqQ8DFQEP4E9xks1RgBBSLEcB8TyHYCb/fAlb0zaehBEl0CH8KU6qm6MAALyD38RJdXMUAIDX8Js42UEgRwHgL/hNnPTUsgDg4wRLnAQAfwHiJAD4FsESJyHPAOAvBH6chDwDgH8R4HES8gwAfkeAx0nIMwD4HQEeJzuaZ0Du1eRGre2SOub6Oi9f+CqVG0HmsnCZrm/hN3HSi3kGsOt7KnuDJfFOSy8gMzcC4Af4TZz0Yp4B7JaTYWFhYXqjPiwsLEw1JyHoBQJ+Eye9mGcAkzJiabVayftCMrBRi7RaLdJqtWF6vVZ4p4j9XmcUFhYm6mAK6yCEtEbbTKZl+9u2SaJ1xDtXuNvMXRd3s5E4nYLEUnC3i5fwpzjprTwDmHi/stYons+vb2T2ZbYOL/OABRu1KExfKQho9jpsXcfQVLQxjjoSGyD6KeFvM3uHp6Aa/ZNC/gRv409x0lt5BjBpTxXvzaL6lfowh3VYkHkgg6eNuEHaKhiZqB1Tyi3XnKGmPUxyqjr9pJA/wdv4U5z0Vp4B7KaTtkgijkv8Os7jJDHLAb3z6FjKqBe0Q994p58U8id4G3+Kk97NMyAYdNEPqzJ7cKVeb+Tt5ZzMAxayk8TxJGEVVDPE50LI28ypJ4iB4pecTwr5E7yLP8XJIM4z4JGxHDOgZach+vkofhMngzXPABOvPBOhuIddwUifxW/iZAeBPAOAv+A3cdJTywKAjxMscRIA/AWIkwDgWwRLnIQ8A4C/EPhxEvIMAP5FgMdJyDMA+B0BHichzwDgdwR4nHQ9zwB2nFrv0Il6yavkAICO38RJr+UZqNRPtbnogQva4BI2wGX8Jk56K88A92LvjksJTgIu4zdxkptnoL39sWJ5BoT3+zpuxrff+y95LyJhlshJuGcfcIY/xUk2z0Br6z3F8gwQ78GXvvefd58he2uT1F38cM8+4Bx/ipNeyTNA7LuSuqCOmyxcumMYbswAnOBPcZLNM1BfV6tcngGHlI5gJiezBhsnudkcxXESVASc4E9xks0zcLHkjGJ5BrDoXIjEWQ1uzOMnCQjTV0rmboZ79gFn+FOcDOI8A0AQ4TdxMljzDABBh9/EyQ4CeQYAf8Fv4iQABAnBEicBwF+AOAkAvgXESVl8shF/sAaPjcNDF+F+c3DvWcIKr2k3q1LU+DIAZQm6OOnqehduw1Gb8JuzeaV3FNZocdiHjmrgJOApIE7SiEkS2igooRMeMjXBScBTQJyUZNEOJ0Iy5bXxNRicBDwHxElJZidijJ0I+eFa3HOMBdudDNEVXGWXL8yyzZyalYMbknSJ9mmG6iVTE8cbGzC+Vc5bbXXsR0e5dVj9uO2AkwEMxElJtN/gczUYY3ysgmDj7ET84VrcOwqHjCzGGIudWWIsGD818TXt5pCt1Rjjq8a9HLWql0xNDNlajW/a69hnCupw9RO0A04GKhAnJZmwGp+rwccq8E+F+FiFbeKnQjw7Ec9OxGPj8JAY3DsK9xhuxg4nhSK9pt083thwtaj6Kl+/JGMD5ggsx0lBO+BkoAJxUpJROoeTybk44QhevR/HJtsiJOtkt2HHsLDvytNpSSHO2bo36aaw+8qNeHKcFLQDTgYqECclGbpIlpOvvm3C/GM8/AGkzaLxxgZGQptvugJuxHPqpLgdcDJQCdI4KefvgLnynBySjkXHXR2DRu5Rn5sF46cmsm9x7XLupKgdcDJQgTgpSe9ZspzsOjAZ28aTe5OM9mOt9uM3jgl78HToKjweK+nkEmPBuC3CdsDJQCVI46QcXp8py8m/D9iK7XFySaFj8ZytiezQMWdrInPUlHPmo3qJcI5tPudciJ2CYlE7NmPlfmzAf4A4SSPsIydOMkJila4ZIN7kDQAsgRYnGUIn439ENoqd7Doo9e8DvmerqeWkp78eIHBw2Un/oufYqpBR5T2Gm7sNO/bqkINdB6UKKoCTgK8RsHHSlwmkzwJ4nACPk74JOAlQgDipAoH0WQCPo9PpvtmXF7Bx0mmeAVUAJwEKOp1u+ZYfAzBOyswzoArgJEBBp9N9olsfaHFSfp4BVQAnAQo6nW5C1NKAipMu5RlQBWW+Q4teo9FbpN838Z+EIkLrJDE94CV0Ot1YbXRAxUmX8gzYcDwAT/BkWPaRPbwnAlXqwxAaMoS/S2dIPTWI1w7GijtJko8jnEnLVZf/yt6Qo75Fr3G04qhq0iLqDwDgPjqdbszUeQEVJ13KM4AxFjhj1PM05MhkfwAev7roSZWip+KJnkzr8e+QZyHXFYteIwp/TpzkhluTltecRa9x2O0sLAPu4rKTvo9LeQYwxhKPhcWV+rCwqVPD+Prp9WF8v5w7KWrHi31X1500aVnrTFpxh5Y7j1MV8CABGCddyjNgw9Z35elk1CKtkX1qOma7r/wnUDp3UtSOKk7y+qBkNPoKbiPk7ilnLkRKZQjAOOlSngE+3F6pzSKOTGK5sAwnxe0o56So8+pynOSHSYJy3MEmBEpF8LM4KeevS3kGRNil4h71cTz42XaAhzDIJL8ktqPceFJO31UQ3fhOCgaTZCfZuRAoFSEA46RLeQYwxhhX6vV2j9hI6QiZ3FmMb4LjsZJOGvV6C6EddceTguAmHSedjichTiqDn8VJObiUZ4DByDluaT+0ap+2TbJnPrRG4Rzb/AxeMwghhKYuE7WjNarqJO88B8YkJx2vLXqN9HFXQluARwjAOIldyTOgCmo5adFrRN1RynFXdhniaRYIk0oRgHGSQWaeAa9j1CLk8e/QLg7hTD938Ec+jko5P+lknTCYVITAjJMsTvMMqIKPX+/K9Enp503gOh7lCNg46csE0mcBPE6Ax0nfBJwEKECcVIFA+iyAx4E4qQLgJEAhAOOkdr31t+/V/jEyiV60662KbjAFcBKgEIBxsusXVzC+iPHFxPSKwqpHhVWPVm83Y2zGbSfxlR24+UdsTcHF8X+MTJLTGkKIOE2fSW8NnAQoBGCctDn5qODrlEunLz5KPVK1NOEsbjuJH2RiSwK2puDb23D+YqdOMv6I/xKrMRMCiHVc+ixAEBKgcfLyPnx+/cyVx1ZuOblyy8l/LzyAr+zAlgScNR8Xx+P8xfhAZEakrPgmP04K3iW+BCcBp/h0nDSZTMQnnJhMtEu6/r6qSk7fdddQmpPEoCf/JWUmUuA6HiCQ8Ok4KbXv0vfpLvEWOX3Xb/o7j5PcLqjTeChVgTsT4iTgFJ+Okzqdrq3tcXv74/b2xwihtrbHbW2PWu8307fhlRWX5PRdnTrJDXSCOeJq2KfGk4TEV9hZ4jq4nNxX8PU42dra0tra0tp6DyF0//69psa6G9cs9H365WXluOkobjoak1BuOvfAdO7BjC9Os11WfGMDvvYVzptJd5LooZSTgvlS0nI/l4xP7wrO8kSKFSVrizEW3oMluEELMtYpjq/HyZaWJsHudaWyhJ5n4CVdKW46iu8cnPNN2f5TrWt3V0xZfortsuJrX+HLcfj4BzL7ruKX4sAoeCmOk4IWFP0OTVqNXq/V6PVaQoYBGXFScL+HRa/RaPj3ScIdIcri63Hy7l1rY2P9nTs3EUK3f62puVpReSGfvk+/uPQ8PvcFPr9+2KeZs1cfn736+JsfpLFdVpw3Ex//AO8cvPpNF47xsDOxs76rYD5x91fISSZYak32IOh4LYB2M7LgpkjGP+GdknDnpJL4epz85VpF1aWiS6VnEUIXik+X5OcU/XzUiZOxhfiXHfiXHe8vL/0+s+X7zJZh8/LYLiu+tAiXzcWm4XQnsURfVBz9kES3llJT2fyuElHQeR1B3jqMHSFR0GGFSKkkvh4nS/KPnz6WfvJw6onDu08c3p1zKCU3cy99n/7bonz8yw58JWHk4pKNGS0LN10c8Eku22XFZXNx0TT8k5M4ySAV+gR1sERUlGpHmd814ghRnJDHotcLQxynEj8COlQUSAmBUkF8Ok66d36yc8xZnP0JPrmg+/uHxi7MHrsw+y/DUtkuKzYNxz8Nxhtk9V3ZaSwRAwX6EQUWB0ylnJQKkZxKUmNKRxZYjnpcEflSQqBUEJ+Ok+6hXW/9pj/6pj/6Y+TOP0Z898eI734z9Ntv+qPVb/LK7mEuXKfqWVSLkxa9VkMYSkrESbHkkLHOG/h0nPSF9SqBOnGSPVxDq8QJh8JUkpzXkLFOSQIwTvo+qvy+mJhzI6QIxw2m7Pvi7K6OORAmlQTipAqoctyVXpV3jYCToSIMJpUF4qQK+PjvCz1vHVzHozQBGCdLi06WFp3MzEhKS/4qLfkrRbfKPXzcSUBdAi1OlhadtDThq9a2vKsP864+TDrza0e0RBLXzRGriedLAU4CFAItTmZmJDFCfnusli2pW+LZ8v2GFVvXLdmw+jM5rSHXL+WRAzgJUAi0OJmW/NWDht33swY0H+jELS3Gbmy5d+Av9w785Zz+KaetyYmTUnUoioKTAAWfjpNuXMfDONl8oBPz8kHD7gdVy59ULHhSsQCXanGp9kn+uMd5Q+9nDdgy//9QVi1HLbYmdjFUgpMABZ+Ok27kGeA6SRHy3oG/0J1kQPyrWDHpYjp6t9bV7QcAn46TbuQZSN0S//jGt80HOrFCMjYKhLy69RmXnHT6l60vJ7qCkwAFX4+TruYZ+H7DigdVy+/u+QMTHketOTbmy5z3VmW/HX+k/+eZtgmdKTT2UGjsoX/P/JK+AeLxoVg5T8VJYi8dCAbEe4JPx0lX8wxsXbfkScUCxklcqh255si2PcekSq+3P5RaNf1wjtRM6LsCHSlK5HEAAB/mSURBVMdlJ72JzvU8A4yTV7c+w/RXey8xuuckgyA2ErumUn1Xip/gJEDB1+Okq3kG1uq0uFR7deszT/LH3c8a8N8f7uu4k+w00TSIk4Bn8fU46WqegbU67f2sAVe3PsOUP/77B484KXVQB4OTgKfx6TjpXp6BVTGTF80cO3vKu+8N0XTESe5xHXaOYIIyTQGcBCj4dJzsOB2MkwoBTgIUfDpOdny9vd7+kF48vp1yACcBCgEeJ30TupOfbMQfrMFj4/DQRbjfHNx7FsYYZya86KWNA9QmwOOkbyL1WRZuw1Gb8JuzeaV3FM5MePFJewNoGSRAnFQBopMxSUIbmWL8ppNxfacn7Q3G9Z2M6zt5cjsgiYdPEphxcsOGDRs2bFi8ePHixYuV2yS3EX+WRTvIQqZ/+ef2e+fbW4pxy/n2e8Xt94rTv/yzZLvktBy21FaORDwavUmU5RXc9B0CME5u2LCBna6rq5szZ07H25R5ksNpfSTxDJ/ZiRhjspa7lj+/a/nz+NaOlOXPpyx7ntisKJMy91EEwpzLDv3YF/zUsGymSF4+LU6KSRBYUQItTrJC1tmpqqpyT0viJXXiC+ucXnCHRSc2xZ9F+w0+V4MxxscqCFpui/nT48srtsX8KWRkscTGOtJB2kQjpnu0+SSRu45RjWOtIA86OVk64GkCLU4yTo4cOXL16tWMkFVVVc3NzXPmzJkzZ85iETKblRMn6RcPcC8/EDs5YTU+V4OPVeCfCvGxCtvET4V4diKenYjHxuHN8/+rdxTuMdwsuXrGFNZNgpOiWaQ4KUiEzs7npVmG/K5K4tNx0o3reBgnV69ejTGu4tDc3Nzc3CyoHB4eLtUOJUgKQiJ3EfE0cVnxdzhK53AyORcnHMGr9+PYZDw7EX+4Fo+Nw0NicO8o3G3YMdLGEh4CotXyY6FGX8FGR9p4khcDOU6KnhMLkVIxfDpOSvlP+V1gQh8bIauqqvLy8vLy8tLT0zUaTXp6enh4eFVVFfOSsmo5QQ/L7rtiZ3Fy6CJZTr76Nj06EeKd6CkinBkEtXgRkDieFFcDPItPx0md63kGFi9ezArJqLhjxw5Gv/Dw8JkzZ2KMY2NjmQk5yJSTPh85G08OmCvPySHpxNWRj/HwnbT1ai16DfFZlKLBJBYczuE9qwACpYL4epx0Nc8AxnjHjh3p6emMjayQLCfWjpkRHiZzA6TCILeC1IKUOuLt7z1LlpNdByaTN9TWtTRpNVqtXT3hUNGi12j0Ju5ztmTESekn30GcVApfj5Ou5hlgFgwPDw8PD9doNGIhf72Ss3xE1wUD/yZ/MyiCye+7cueLv8PXZ8py8u8DtpJaFQho0mr0eruK3L6rSYsEpyr5sRWLQyM5TsJztZTE1+Okq3kG6Ozdsqhs36eW/TMPL3vXaWXSfisZMHHHjvFgjMM+cuKkhJBc7ALyzmcInESINp6kPICS//xmUFIxfD1OuppnwCmW/TP3vRPi6lJSHkrVoXR0pZzEGIdOxv+IbBQ72XVQ6t8HfE9duX1EKXqenckRMB1jRvIvDbMMPFdLbXw9TrqaZ4DCpHXNSdkPmLJly5ZJ64SnRsQg/rEZTJXTaReXfUnf/p5jq0JGlfcYbu427NirQw52HZTqdDs9CzxXS118Ok66l2eAyKR1zQfNDw+aH8bsbInZ2TJpXfNz71ufe99KWUTQ/xTP574rnklcliGQ7nEBPI5Px0kPot14jxHyvVV3+y5qYoT8/XB1PjI4CVDw6TjpQV6d1cAU1kamqLIxfvodAt4hWOKkTwFOAhSCJU76FPAdAhQgTqoAOAlQ8F6cnDhx4qBBgyIjI91bPJAAJwEKysbJoqIidv8bMGCA1Wrt06dPdnY2xnjBggVms/TdgCIEZwgpF9OI6dBnUABwEqCgYJwsKiqKiooaNGjQW2+9tWnTpn79+uXk5PTu3XvcuHFhYWGhoaFDhw7dt2+fzNYop++57rl0ll8twEmAgoJxUqfTDRo0yGq1jhw5csmSJcnJyTk5OSkpKUuXLn377beLi4t79uz57rvv1tbWOm1K5mVr9AnfAZwEKMhy0u3rad56662RI0dmZ2fn5OTk5uaeOXPGbDYXFBQUFxcPHjy4R48eBoMhLy/P6VaKnRT0S8UxMwj7rnLv1hDd5uy4hNWi13BTC7A3XHZkncS7UOASdmlkOenG/f4MmzZtWrJkSU5Ozq5du6Kiovr37x8VFbV///6ysrJly5aNHDnSYDA43URuv1RKM4iT0peWOxxg02fx7orU6C28y8opibRYbykIl+Xc30UQ0e600O1gvqpWrpOu3u8/ceLEAQMG9OvXLzk5OTc3NyoqauzYsfPnzx81alRUVNSlS5cyMjK6du3apUuXwYMHU7YPiY7oEIXkeiuoFhxOmrQaDfluDYeBYsuY26AFTtrrOrLUSWTWktgOYWYfUrYgk7ApcbwN3rtP5Drp6v3+zEiS6bKeOnWqX79+8+fPT01NPXXq1Ouvv15ZWWmxWK5fv37jxo1XXnmFORJLge4kDvq+q0mr0VskMkRy0nrYdnqJOPl1hc0evgr0vqs0XCd5LXI3hHqXdLDepSnXSVfv94+MjOzTp0/v3r13795tNpujoqJGjRp16tSp+Pj4qKio6urqI0eOvPzyyy+99FJISMjBgwfpWynfSXo1H0GZ8SRhmMiZTe5x2hMSCG+ClvRba3LSdWWVFjnJ+Vd8pybJyWCNlHKddON+/+zs7HHjxi1durSgoGD//v1RUVGvv/56VFTUoUOHrl+/vmLFimHDhhkMBoPBcOTIEfpWCgRD1NGjGKffgpdRykm6JJyKtPEkP68dOfcdF6k46txJbhwkHisK0kAp10n37vcPCwtjTnuUlZVdunSpsrLyypUrTJe1b9++f/vb32ReNiAVBgUq0hfxHRQ7F0I/MiKOcKTxpJx8lIK867KdtB9p4h5xcmybqJkgDZRynXTjfv8FCxaEhoYypz10Ol1GRkZlZeWRI0dWrFjRt2/f27dvd+7cuU+fPnK2kigY6yExGAafk07jpCDsMS+lnXQIbp/FO/DDzcZMCsr2+RqtlqnLSRYEcZKGsucnhw4d2rNnzx49eowcObJr167Xr19/5ZVXhg0b9uKLL3bu3Dk0NNRgMOTm5jrdSinBxLExSPuu9ox0GJu0/FxW/OzlYifZt3jDQO55Sq52joMzSPK4rP19vk/C/FyY8ugDLD0vGFD8vpB3332XGTR26dLlxo0bL730ksFgMJvNffr0MRgMTo+4BiSeP+6q5+/qiK+QDY6TWq2GJ4jdSZMWIY3GiQqMSyYt04CM47IWvca+LVybhcddhcE2SMOkV+7VYq7UGTx48CuvvNKzZ0/2OgE5ETIg8Xyc5O7SgjgptpM3PGS7mILupUSXw5Fgnd8+v45gwwSDQkf8ow0Yg3QwieH+SVWA611ZpHLkwXU84KRXAScBCuCkCoCTAAVwUgXASYACOKkC4CRAAZxUAXASoABOqgA4CVAAJ1UAnAQogJMqIHCy7dGjop07ExHKnjePWN84Y8ZKhEr27PHK1gEqA06qgMDJwh07EhHCe+YlIpT+0UeCyj9+/PFKhPCeeSsROrXV6WNhAb8HnFQBgZOMkHg6wtNRIkL7OFoe0GoZIfFghAejlQjdvHbN69sLeBVwUgUETuZ+9VUiQoyTjJb7Z8zAGO+dOlUgZOK4cRJX7bNXqDoSAQhvgyRc/Bqsd174NuCkCoiP8RxbsWK9SEuukIsQWj9qlMFgqKqqIjVpvxmScdJ+XyRzHbfDSeYfXhYrvfjmC76phMvb/ftiVN6F89KfQ/IaeGrWBU8ATqoA8bjrvg8/tGk5AeEIpOML+Q1NSOyCk9xbP4i3RAmz5PDvMxEm2/FDnN5Kzb5F/IjKf3RwUgWkzoWkz5y5EiEcgfAIxNiI+6FFCK0fP54qJJbtpJ7ZoQSuce9gdpJLjsV/b27kb7njFRs/BfeR8ebzBwaCRTwEOKkClPOTuV99pUMOIXVyhSTf7cjkfOU4qdUyd0AijYa/iFarRRp9hSCpBz25j59GSr6TFvZXSvCrZNFrNPoKifmCHJme/YECJ1VAykmbkEyXtR/C/RD+C1qE0LoxY5w16XLflbsYB87eJUzNIYgIfhsoiU7y785mLa2QmM8Lkk4Gpi4DTqoA0UmekIPRFITwX2xlHkI7pk6lNunSMR4m84cQXhDAxCM5gqGYfwZKYt9V/AvDOkmar2hqEnBSBcROioVcP368QMttH34o3aQ9CLpy3BXT4yRBSsG7/h8n2SGzY0htn8X2XUnzLcRFPAQ4qQLi85NiIQ0Gw7oxY7haahHaKRUtHT0wrYmRTpym1d7XsifD0tofmsXdpXgeipLpyD0A5NNInQuRdYzH/hqO8QQYAicFQq4bNYpNI/ZTTAxXyykIlRYXixvkpJ3TarW8dFdY3D3jZJjk5lq156Lk72CkhHKYUA/wGOCkCgic/HHhQuZY6xTShQGsllMQ2jJ5MvHpgCat/fIdjUaj0Zv0tkyRgqR0wqfJEY9NyBon+u1g0h8AJ1VAPJ78ceHCKQgljBtHPO3BaMkI+csvvyi9eVK55Fj8+zoenwecVAHicdeaa9co5yFLi4sNBkNNTY3CmwaoDzipAnBPM0ABnFQBcBKgAE6qADgJUAAnVQCcBCiAkyoATgIUwEkVACcBCuCkChCdJD51FwgGxHsCOOltxP8NAMDCc/IJ4BXASYACz8nHbW1NgPKAkwAFnpMPHz1We3cNCsBJgAI4qQKsk69pN0OBwhaCkw8ePGoElAechEIsBCdbWh+ovbsGBeAkFGIhONnccr+hYyCEOtiCZ9vxTShObtiwYc2aNStWrFi0aNGcOXOioqKY+ZkJL6q+x0BRuhCcbGpusXKovVVPLPNiV1klQAhJzacjv6kAgOjkd999t3Hjxtl8oqKipk+fnpnw4pP2BtAy4IssJ4nHhdxwUk4dN7z1U8RObtu2bbYExm86Gdd3etLeYFzfybi+kwf3gJBlBVdqCyKmJqq+L0JhCsHJhqZ7dRxqb9U/eYKZMiNhLzs9L3ZVnQQIIam3ZNYRvyunTf9C4OT27dulhEz/8s/t9863txTjlvPt94rb7xWnf/lnqf/RkC3VWORYyNSsHIxztiTGFtp/U2sLYo1Wwe/sFWMau0iE0ZqzJfE1krQhU9OSah1L5RRWi36xrUnLhJLHFvLaJxY5dQK+EJy803iXu+vU3qpvfdjGlElrf2hvf8JM050UQKxTJ21aEDqZkJCAMZbSctfy53ctfx7f2pGy/PmUZc8T/y8jhI5Vx26pdkxzpIowWtldn1UuZEs1MzNkWcGVwizWSW5lbmGqvcb8ChRmsRqHTE1LqiU4GTI1K0fkasiygivEbpjI7QijlVmLvSk7hVkBJjPBydt3mri7Tu2teuvdBz0//TJ03tf/nP916Lyve376pfXuA0/FSTlaBp6QdSIn161bV11djTEuLy8XO5mQkLAt5k+PL6/YFvMnqf/LkKlpSbU29xiRWFt41WyBlLNbc6ktGL+lGtudFIREW2Bk4yfrJMklR0yWojDL0cjUtKRaW8tsiS20OcmN1czq2JrMT4nUD4E/FoKTN+sa6jnU3qqvud1cc7v5waO2TtrlDx61MWVe7Kp6CRBCUm8R6xDrO63g7wic/OKLL6qrq8vLy81mc3l5OTNhNpsTEhISEhJWrFgRExOzef5/jRo1ivLfadt3RRGM421WDj9miuMkN95eqbXiwqyQqVk5tQURW6qvGNN4fVp5cVIq0r5GiO1CmAVjC+0/BPZOOOGzk36A/LEQnLxx6w5316m9VX/pWgNTOmmXt7Q+ZqY96KTUIszMgBSyXuSkTqdjnczJyWH6/LHJGCH04VqMEBoSgxFC3YYdY94S7pHEgCYY6TEx0D4tNZ5kolOE0ZqzxRZ4QziRk9GDEwOtSUYn40lWY8mfEr5Ogh8OruTE0bLgx0V1qbzhZEHFbbbcbXnETHjBSZlN+SkCJ+fNmydwcvV+HJuMZyfiD9fisXF4SAzuHYVfHZKOMRY7yduhud0823CLJwmvDn9XZt+KMFpzCqu5YYpphNeflBcnSZ1YvrTL0vgdYH4k5yhKc1LUBfDTQnDyem3dHQ7zYldJlTsSIISk3nKjjpya/ojAyaioKK6TCUcw0cmuA5O5S3EL+RgP30mbNssKrhRmEVSx7+62txjlbNLaXBU7yd0AcTwUK8pzjD+s5XZQ2bgtHExKOhkgQ0qCk1dqfu3g3tZxJ5numdTLwEDg5CeffCInTv59wFapOBmyrOAKro6dmpVTW51TWx07NZEdyAkOlsRy5BF3+ZioaA96toOltoNG3G6k3UnimJB7DIYS94QfwT6m5csmcJgsXiDHycvXbrpxBtzVc/1SZ/8pFwYE/DUDH3/8MT1OMkIS4yRri73zmZVTW5BkV5Hbd40tZDqH5OOurEvc0aPd9kTuoV37aQze6QpBnGRGuQLNuL8CTo/x2I4wCU6KcF7yTuEEqpOWKzfU3l2DAuK1dR999NGkSZPEcbLroNS/D/ie3VHljCe5u77ISUc3VerQCO/4qt0BJhYt/mgvczxJYKDASdthJ/EFDMSrGhijtlRfMRaIIyF73NXRAkdax8xAPe4KTnoHyjXoERERIaPKeww3dxt27NUhB7sOShXHD5KN9kOv9tPo7H4c6wiYWHzCQxCXuIJx+67M+4SgR2yntuDbQo4wvMPCoh8I+28E52Qjb3ucHlMNmMEk2cmLl2vUvmUiKKDfq4UQIjuDMabGyUAtzHU8Ul9IgF/Hc66kCooXilMnGS2Jf4PQyeApBCfVzucWLMA9zVCIheAk5K3zDuAkFGIhOAk5srwDOAmFWMBJ1YBckgAFyFunAuAkQAHy1qkAOAlQ8EzeOmRPM0e8ts5pNWJTDfKy18lpR6opV9flKYhOeuQJTYA/QnOyI3nrmOtRpf5y60jNdPoWO5NyMa2cZuWvSyHE/w0AwOLESeIyTvPWEf9yLZLySo5Ict7lyi9GTjXKejsOOAlQ0MnMW8ctLuXIQs6y7wgWpzciqEl8SVyjuD63ZUprSgBOAhR0MvPWcYvASbE2xH2aKwBRObF7Um7QjZWaSWynjuQwOAmoiM5p3rrX5qzRROvfWLhOE61/bc4aqbx1AieJgchpBCM2Qtm5KRW46yLaS/EWnARURCczbx23EPPxIHtWK0RKt8O1QvASkbLUIU6OLCSRRIu4IvG0FIK1u7p4RwAnAQo6mXnruIXipGBaShspAQQSStWnUC/Pf/qKwElARZw4yc1bxxanTtaT4hh3JiVO0nV1ulJ6HcpvhEBjcTseBJwEKOg8lbcO2TPNMYjf5c5HElmwuBNciOsiToibFayL2I74U4g/oAcBJwEKOo/krZO5Kwu8FSvn1Jk70o4JfObOl9JbaoPBSUBFdB7JW8edFkOsKbW41FtS66LXd6N9YiOeRQknLXoN8ctHSGsS1xTOA3wIHeTI8j4KOanRW0izCf5JVHa8i7QmkeaOdkxaRFkcEICoCZbEgJMqoG6ctFeX0MrxDj+gmrSctuhSAzyY/wb59XWQt877eDtOmrQiMXmGCd7giMevwp1BaBMgw/46yqyvg7x1Kuat8yCUyEV4y6RFWj1pCW5d8cCTMwcipWy4nRY59XlOKr1xAIMix12lO6+igGhXixw/2VlUJyFQygac9AO8di6E7I3jEI0o2PFmEJ3kRlEIlLLoUN9V0S0DWDzuJCVE2nDoY9IKDqHytKPGSd7xVoiTcunQMR7lNgvgolSctOi1/Mgl9kZ8GoM/h/tKfNyVUxHOcsqmQ+dCFNomQIBCTlpMJj1fHL6TFr2GeKzVotc4FhIcdyVFWkLTgAfxhpPVKahsG8pPRHnrUeYaZIhHqUtR0meu/XgEEoqPJx02yTzRz9FS1jgRBpMKoqyTtftQdQrCNWuF5fy/cOGb+hlo5UfBaKaPX+/KdEspg1O4jkdRFHSydh/Cp17ANWtxxXRcMR1f/ACXR+CS4YyQOL8XNr+Kz3SaP865loIeOb2Dzr7raj/ea/i4k4C6KOhkdQrCGNOFxDc2zxiulJNOa6oFOAlQUNDJsm0InwvBGONTLxCEvP41vhyDT70w5W25ThL7UVKVfRlwEqAgy0mTyUTM32wy0Y685SciXPeTTUuM8Y3NvHI5xpKMTm9AkW85CXpi/cRhk46cL8KbgJMABVlOSu1D9H0rbz3CdT/h2q02Lc+F2MqpFxoPoqu7EePkiN6e7Lv6rIdcwEmAglwn29oet7c/bm9/jBBqa3vc1vao9X4zfd/KXGN38nIMxhhfjsFlY8RODgl1v+8qVQ37dg8WnAQoyHWytbWltbWltfUeQuj+/XtNjXU3rlno+5YhXpaTfbrJclJsGjgJBCRynWxpaRLEqCuVJcy+JfU3daksJ0NfljWeZF9y3xLUlJrwNcBJgIJcJ+/etTY21t+5cxMhdPvXmpqrFZUX8un7VtJnspzs9lfXxpPEMCjlqm9qCU4CFOQ6+cu1iqpLRZdKzyKELhSfLsnPKfr5KH3fSpwry8nOL3T0GI9LL30BcBKgINfJkvzjp4+lnzyceuLw7hOHd+ccSsnN3Evft1KXorJtiOLk6Q1o7+cuHOPhTtMPvTptUF18IB+PRPIswAdQ8Pwkxjh1KZo/DgmcbDyILMnIkow6vyBXSO5xV/F8cX2nbaqLWnnruC8E09xlKXnr4EpXL+CN+0KmvI0i30IjeqMhoahPNxT6Mur2V1ld1kBFrTgpy0mpvHWkuoASuOwkjIU6jlp56+Q4SctbJ6oBKAHc06wCauWto6TRsi9Lz1vnbE2AJ4A4qQJq562zVSfFSWE+HlIbECiVxXtxcsKECQMHDoyIiFB0LX6BSnnrJI/3YGzSspGUlreOnQ+BUkGUjZNFRUWff/45M92/f3+r1frmm29mZ2djjKOjo81ms+sbHAiokreuQo6TTvK72itDnFQSBeNkUVHRrFmzBg4cOGDAgI0bN/bt2/f48eNvvPHG2LFj//nPf/bq1Ss8PDwtLU1ma4h/xZzUCQ/iDumRj+NBVMpbJ9NJGeNJ9pARU1k8AXQABePk559/PnDgQKvVOmLEiNjY2J07dx4/fnzXrl1LliwZMmRIcXFxSEjIO++8U1tbK6c1JH05K9c9SjXfQc28dc4O8kjmrRPXACeVQdnx5IABA0aMGJGVlXX8+PGTJ0+eOXPGbDYXFBQUFxcPGjSoe/fuBoMhLy/PaTvI2SWsdGM7+jE8jSp566iwcdLpaBEGk4qj7HU8GzdujI2NPX78eG1t7YULF8xm84ULF27dutXc3FxVVVVUVGQwGORspdhJQb9UHDODse/qISh56+A6Hi+gVJ6BCRMm9O/fv2/fvjt37jx58uSFCxdeHfbp77U/P/vRqWennnl2WsGzHxx/dnL2f04w/WH0d/RN5PZLpTSDOAkEDErlGWBGkkyXNS8vz2w2PzNu7x8W3vxd+LpQfdN/LWn5w5yqZz82P/tR3jPj9h48eFCqHSQ6okMUEsaTQMCgVJ6BiIiIN99884033khJSWG6rM+M2/uHuVd+F77uH/HVf/i0ghHy2Q9PPjNur9MerEvjSei7An6NgnkGsrOzx44du2TJkoKCglu3bj0zbu//nH3pd+Hr/hFf5RAy8kfPOkmv5iOAkwAFBfMMYIz/+c9/Mqc9mpubHU4uu+gQcsxuV53EzkaPECcBv0bBPAPR0dG9evViTntUVlY6nFxa4hDSLSexaJwpds8HVWQBJwEKCuYZwBiHh4eHhIR07969qKiIdfKZyB8dQr6X9NvwtW44iaXvdaYs4iOAkwAFZc9PYozfeecdg8FgMBieGbf3mXF7xRXcdlI8n9hx9UE5iU4Sv2EgGBDvCYrfF8JcqfPK4I//Y4j+t0PX/XboN5yy7ndvfy3zyoGAQfzfAAAs3nCS5dChQwYSlPOTAQk4CVDwqpMAAzgJUAAnVQCcBCiAkyoATgIUwEkVACcBCuCkCoCTAAVwUgXASYACOKkC4CRAAZxUAXASoABOqoDnnbTlrSJnSbalqOPk3HFg0Ws0Wi2bn06YbUfi6Vui2ZATxIOAkyqgSJw0aZFW71CK0cak1egtrEEEc2zv8R7cQ3qeDyYthU1awtXFolyU/F8KjX4rCEwFnFQBxfqujEMmLdKaSE4yGWD1JJE4cdWi12j1Emknmda59rn1fC5IfkcDnFQBjztpD4BOnSQtKmmHdL5zYvZmfnUnz+eCXOrSgJMqoECcZPZ7mpNM5BOJwHOSiYHMDG5qZeFSzCypHM625yBQ86lDpJQGnFQBtfquYpU0er0wTtokJQ4VOd1b/jEkahzkuUt6gBfAA5xUASWctOg1Gr3J5iQrIslJzJskHEIVSMqvYRdMa5LQFiHGeyfP54JAKQk4qQJKOGm3T6PXa21WSDhp0vMOzQgdtC9COw7kWJqnFqcpp8/ngjgpCTipAgo4yXuwDuI9yIcfE7XsmUy+VaxcTuKkoEWT1r46/okWZ8/nknqOHgBOqoLnnXScZnQcoeE6IXgQFmeMpzWxh4ccY01n1w0IZjk6scSHOcNxV9cAJ1VAiet4NHoTf9e392M5jjEh0CI6AssesuE8rpncdUVaE3tslvTwLpPjWXu0ASMMJmmAkyoQJNe7Sj2fCy7EowNOqkCQOAm4BzipAuAkQAGcVAFwEqAATqoAOAlQACdVAJwEKICTKgBOAhTASRXw2MNfgAAFnFSZu3fvVlRUZGRkbN26dd26dXrAPxkzdZ6nyoSopeCkmty/f7+mpubMmTMZGRn79u1LA/yTj2PWeKp8olsPTqrJo0ePmpqaampqKioqysvLywD/5PNN+zxVlm/58f8DU9/SeCxPqjcAAAAASUVORK5CYII=" alt="技术分享" />

Step2:创建源数据库的物理方案,方案中均选择刚才在Oracle中代表源数据的ODI_SRC,

目录:ODI_SRC(表示该物理方案应连接到的源数据schema,也就是源数据在哪里)

工作目录:ODI_SRC_WORK(这里指定了之后在数据迁移过程中,需要创建的临时表的存放scheme),如果选择了ODI_SRC,则临时表在ODI_SRC的scheme下

ODI Studio拓扑结构的创建与配置(Oracle)

ODI Studio拓扑结构的创建与配置(Oracle)

点击保存,忽略掉下面的警告,稍后再配置上下文

aaarticlea/png;base64,iVBORw0KGgoAAAANSUhEUgAAAYwAAACHCAIAAACK6/lqAAAgAElEQVR4nO2de3ATV57ve/7crd0/ZncqtX9t7c7UTpLKTjK1wRjHCcT3ZgkQ8ABeiI3xTG3dYAz2zkzCI2CSvWENGAiTQBLPTCZ25mJsHgMBjI2x8ROwLVmSJb8tS7IstaTWW9bDtmSru7l/tB4tdffpliyDTM63vuWSWqfPo/ucj3/ndKuFKB3kpINUOUiVk1Q7SbWT1DhJjYucYtoZb03YaiepdpAqBznpICftpNJOTtjJCRs5biPHbOSYlRy1kqNWcsRKjljIEQs5HLGZHDKTQ2ZiyEwMmvFBDB80BRWmoMK0qDAtKoyLcqAH6DZwWsbnAWNwwIgPGPEBEy43EXKMkJtIORb1QJxNpIxhKd1GUhIyITES/REbCHHYIpr70Kh7KeuJXj3RE/ajsB9OEw+niQfT+AMt3q3Fu6aCnZrFTs1ih3qhXb3Qpgq0TYZ8n+bWyUCrMuqWqP0tSv+9iXg3x3nc3zzuvzvuvzvub54INE8E7ikX7ikXWiYXW1TBVhXeosZb1USrmmjVxPg+t9viPBVyO5s7KGtD7mS4S0t0TRNd00Q3zQ8o64gHOuIhzZGDGTm81NGmjjz9XNDPkdhAiFFChBJilBCjuFgfFOmDIv2iSEd5gW6xbkGsj3F/2BLKKIul6GKcY3qpgerqQbkxKDfhcgxXYIQCIwYxctDM4iG6LYLsmifz1mYZe3pVtTWa2hrNpRrtpRrdpRq0rsZYV2OsqzHX1Vjqamx1NY66Gkddtauu2h32Vx8ey9tZTPmrD4+xbnHVVTvqqh11Nba6Gkt9jbm+xlhfY6yvQetrdHU12roaTV2N5lKN6lKNsbc3b23WjJ8csZJIBE8RMGld5PRMyLqwpzmsdZHaMMIoWqkoWoVRNU6hKpZTwzTTDiUNVRg+iOEKDFeY+C0H2xjvCI9CjsMTRoIJxYMnUwRPJB1PYlY8oex46mHFE22YPZgmuqfx7iingp2aYIcm2KEJtquD7erFiNtUUd+ne3KxNdYtrFYutigX70Uc/SjYogq2qPAWNd5C4YlBKCG04kIVK606YmnFwqmloaqHC1Vo9HyFOGWIoAoXo8GQ9UGxPtiPxlgSZ0NQGmuZAY+xMeoBuk1UF8XpeAoRigNS8agSBqltWRmG7u6Jb6qU31Qpv6lSf1Olqa7SVlfpqqvQ6ipjdZWxuspc/ZWl+itb9VeO6q8c1V9SzttZ/DisvJ3FXxw4ErfFUf2lo/orW/VXluqvzNVfGaurjDVVaE2VrqZKW1OlqalSV1cpq6uU1VUT1VWGB93bsjJCkKJCJzqbdDOk3k3q3STqJlEPiXpCb9kdQViYVhFUTTriQyomp0JHJ5ZTEQ9iRARYCVnB5zDCiJCxMJ5iCcUbQAHwJGGLnsQc0RMroUKjSEc8ouMpYi3RHRqZeJcW75yiHOycCtEqxKw4q4NtDN+Psyrq1njjlFvUQvG0XKjSsgdWIFTp4lFFHVuWqIrBKXpUJaajKvy2HyX6UbzfgPcbcAnDUmPIMobj/2XSYRRjQm4iImxSUGziI1SiIZVrnsx99WXt/ZbBz84MfX5m+PMzY5+fGT9/Wnn+tOp8peZCpfZCpe5CJXqhEr1QabpQiV2oNF84ablw0nLh5IXffBBHJfrrC7/5wHzhJHah0hTeXXehUnuhcupCpfp8pfL86fHzp8c+PzPy+Znhz88MfnZm+n5L7qsvhyBFBVBaCk9hNhk8pMFDGj2k0UsaPVxW/F9kR+0kibpJvTsacGkjUVWYU8oIpyKQspIjrIeJdjTDh5hIyLSzyG45FoskjFRgpAKLCZ1Y8cRDKA48sc7vWNgUO79jj54oT1NhVNiRYaklOqOxBt4xhbfHWYO3MXyfbnXUrZwmomBi4olr+zLMAcGoWuIEkD7745oAUmwS005xf6ypnhCxNGyZKd4DTGPEAHdfpczLpiQ45ZonN//8JU3zXdnpCvnpisHTFcOnK0bOHh89e1x59rjq0+OaT49rzh3XnTuuO3fccO648dxx47njWNjn/+u3dDZFCHX+v36LhRMbwrtrzh3XfHpc9elx5afHRz89PvLp8eEzFYNnKuRnKmRnKjT37m7++UshSFEBVCR6kt3YgZxShPCkursF2VGrYrKJQ6cUUU65YjhFzfvGaJwaBhKd0ywUE2QFq4XgiTeASmj5iSN6YuKJPXqKHXLUIOxijE/60KUGM3OQR6OVWC4ACAKKktQcTltUsUZV3Khin/3RTnG/IXrqw2AiJUZSaozpLXEdacDE0t/iOmSISmwdOOWccs2Tm15+QdXY0F/xsbTi44GKjxUVHw+ePDZ88tjYyWPKU8dUp46pKo9pK49pK4/pK4+hlcfQymNGmj8v/XXezmJ3WHk7iz8v/TX1EZVYH95dVXlMdeqY8tSx8ZPHhk8eGzp5TFHx8UDFx9KKj/srPlY3Nmx6+YUwpOgxlAer3YZs3raDA0I7LqlIk0fxSegFaQqTy+AhB67vQE4pqJCKmvox530Up0as5HASkEotngQSim9+x0UooStQS8YTJ6E42PTk8PQEUdWe9FpVIqji5ZRYGKeEoEo4p1KLKtc8mf2jv+k/f+7mxnW3Nq1r2LSucdO65k1r729e27H5je7N2Q+3ZPflZktys2W52fLc7KHc7OFYV+bl5e0stoSVt7O4Mi8v8ulQbrY8N1uWmy3Jze7LzX64Jbt7c3bH5jfub157b9Paxk3rGjatu7Vp3c2N6yTnz2X/6G9CkIqEUaibNPR+9oOtd+Ve0ugJMQjzMq34hDuSCkEqNphS0SA1agtN94at6R5ACcZTUgvkrBfvOCZ3DwTgiTd0an/ybFpOWiV6EZAVVQ84JoDsC1VJoooUiqo0CKlc82TWD/9KfO7M9f+ddeOtrJtvZd1+K6vprTUt69e0rc/sXJ/R/XZGz4YM8YYMyYYM2YYMxYaMQZort23L21lsiFXezuLKbduoBIoNGbINGZINGeINGT0bMrrfzuhcn9G2PrNl/Zqmt9bcfivr5r9n3fj3rOtvZYl/dybrh39FgxQtjEJOKQwe7NI2FgRtuYGFIbWjTh1ilikSSd3YgZxSoExIOaMX+yLL54kFU+lHKN4Fct7bC3gu3iU3uXu6Mzs10ULzUwyswPcrgKMq/jsVeG9TiJ39SeJQld6ccs2TWX/31/2fnbn+VvZ367Nvrc9ueDu76e3XWja81rZhTeeGzO6NmT2bMsWbMqXvZMreyVS8kzkYduX27Xk7i7Vhxb2u3L598J1MxTuZsncype9kijdl9mzK7N6Y2bkhs23DmpYNrzW9/VrD29m31md/tz77xlvZ/Z+dyfq7v46HlOzGDioaAoZRwEiqUhFZRJ+OhZTSEZ3ujSY040v1FE/OR6iEboCSCL5+lxI8JRo9PRU8pT+qeCeAS0GVmIEqSSKrVExUMXts6qd+dEj96G+lX/7uRm7Ordyc27k5Tb/Iad6a07I1p31rTtfWnIdbc3q25oi350i258jy3lTkvTmYt45y3s5iVVh5O4srd+yI2zKYt06R96Ys703J9hzx9pyerTkPt+Z0bc1p35rTsjWneWtO0y9ybufm3MrNuZGbI/3qd1k/+tsopKgl89ZTOy7e+OwHpxRG7kjK7CXNXsVxZEe9mjRTkVQ4mJLf2BEDqZnostRkBFL2RCC1DItQia5AyWLxJGXiiSOAYrm9gG1+x3/x7knhKbVsWm5apRZVwi//gWd/rKhihFREiFNGIKeErFItwxKVa57Mfu6Hsj9W3c7fcid/S1P+lub8LS35m9vyN3fueqe7cOOj3Rv7dm8U794o++VG2S83Kn65cTDsyl0FkVs3K3cVsG5R/DK0o3j3xr7dGx/t3thduLFz1ztt+Ztb8jc3529pyt9yJ3/L7fwtsj9WZT/3w3hIhdakIpGUl8S8pJnFiuNCIqkwpFTJQSrVUzzeACq5S3gsAZTgu5/AeEpt9JRk6JQiQi2FUwkEVqmLqhJYqOK+9pfognqinAKgKmlOuebJdf/wnPzSn5tLiprfK7j3XkFbcUH73oKuvQXdJfk9Jfl9Jfni/fmy0ndlpe8Olu0YLNsxUrZjlMMjjLfULtTu4v35fSX5PSX53SX5XXsL2vcWtBUX3HuvoPm9guaSIvmlP6/7h+fCkHLFLpyfUhg9ZFvlD5gI+qSXZfYXd40vbrqnjoOUwOleUnjiIhTz1MYTCnwPlJGdUGLWKV4K53dPF0+pY9OTngOmNqpKavbHyikx2yoVOKQaYKCKtTMvnVODNEj94vkfy2581/XRofYD+9oP7Os+WNJ9sKTnYEnf4b2SI3tlR/bKj+wdLN8zWL5n9Nie0Y/2jH+0Z4LD44y3ox/tGT22h9pdfmSv7MheyZG9fYf39hwsoQqiCu366JDsxne/eP7HM/PksIVEtC6CusCHuklDz2c/OKUweMj7lT/YfB2jwQir20ZBCqvbhnzSh9Vt21GnJtsrEQRBNt/ADB7SoLq7GUH+u4cWRtEhRbsFAbRwnuopXhJ4kvEGUHx4Atxe8D3H07OKKvC1P+YqFSCkYp/68aEqVVM/1zxZsbvw21MnRq7Uic5W9FQc7fnkkPiTQ9L/OSSrODR44tDgiYMjJw6OVh4crzygPH1Aefp9TSJWnn5fefrAeOWB0cqDIycODp44OHjikKzikPR/Dok/OdTzyaGeiqOisxUjV+q+PXWiYndhCFJTTiJ6F0JPKJK6zxFJDd7YgVQqMG8IUtEwqvczBPms1a34bwT5+BGpnSGnIpAK3ydFn+ux34LwhKd4fDeRs17C473DIC6AAt39JODinVA8LefCU8rxJBRVqVuuShhVAtbU2e+o4gipWGd/gAt/yXAqFSGVxklO6m1bfvbiHz46Kmtq1LW36loadS2NhpZGY0uj8X6jua3B0t5gaW+wtTfY2xscidve3mBrD2Vibmsw3m80tjQaWhqpgnTtrbKmxj98dHTLz15UobYpJzlsIRGNA592EXRIRSIpU/gyn8mDXdqGfNIbeUu2VcYjbPN1jJrrMe8/iFmQ4gqjUkqoJKZ4vPdApRZPrMtPyxc9pSGenhyqko6qElmoWhqq2O+leipTvwnLAmqf++I/C/e8+uKWn/7jlp/+Y+7z/7T1hX/e9uKPt7/0k7yXfvIf//ovO372050vP//uK8/nv/JC/isv7KL88xd2/Tz84pUXdr3yQsErMW+pxO++8vzOl5/f8bOf/se//kveSz/Z/tJPtr34460v/HPu8/9EFbfn1Re/+M9Cg2NuwrJAfcMXUduDU04iZmXKHf7injAbPKTBTaJuUkcRihFG0ZfM2SH1JKd4fGvkwgOohFbHH6YcT+lx2S6d54DLEVVFUPWQDVWghapUhVS8q+lLnvppnKRrfqmeWZqnXNEHpSBK66LaQWjDnEoIVRE8sdxoHjvRi1+NikDqaU/xnlwAldC9BVPshHqG8fR0UQV4CAz4ToX0DKme2Hf9wB5OkZFxS0Blx9UOYspJaF3kdOT7xjPAJ7QwHtUSwlN4sZweQ9Ev6o0sG6FSOMUTeAc559eDE18dT2H0lOYzu9SgKnFaLTGqErimHhdSsX5Fme8O9TSa+qUJp5AxLKC04So7oXYQaicxFX62FP3RdwBH2KQJP9gz5hvFdnKMFkOxEiqho7YUQiUUQPE+w4A9gBIyvwNevBOCpxW68JQOqGJdrmJHlbDLf0JmfwJDqv4kQqoneHfCU+QUMmL0j1twpQ2ftBOTDkLlCD9BmHoYHtBRMIXZRMdTJICKJ1S6TvFAD4Fiu8Mgofkd7/LTk8fTUwdQymj15FHFt1DFNfsD36PQvwwh1TMw9UMGDf5Rc3Dcio/biAk7obSTk/YQblRAT0aoFHkCJ8WmSPQUh6dlIFSiARTgLk2B33HhDaCY8zsQnpZvcrdiQ6flCKxSNQHkRxXv7E/Al/6YIRX/PZ/P9NQPURjmR8zBEQs+ZsHHrMSYjZywkhO2kJUcpj4dj9hKjoUdekawJfY3F8yR31zgJhTGaQWbo+fAFPVArEMn0kjKImc6bImBMiGhPU0x9LhF6r8cSohQok8fcm/YPTqiJ/LkWV3olxHCv49APJgmurVRhyYIU0Rn2B00t2viHTNs1ESbmrjPZtBAVXG65RkyoJmAg8N6MKnjTD/yzPNCP2uRU9k1FTq/9DNO9QF6r4h0FarnRDpSpGtFOluk+0Uf7xkyKTHEd2CqV8eEVGHTR0RMSMUwYNDxcCopDwsxE1Iy/dyQaXHYHBwx4yMWfNRCjFqTsoUYsRDDYQ9RjjytfAmP/ZVzewCLf+5q3INZpbTHttKf5Up/zGs0dIqAKRI36WPWxXuiTxzHKT+YDrmbshbvCruT8hTeQTPgYb7MJ/lyPcO3hcsqTt97Rg1oMtdR4jqqoUcn085C3Alq10RPH/2cdk6FznXk1HdrQ/0h0j0iHSZEq7iVdX3sHJD+AHXuRxJLuR9JzHwYMWAQAYZeog/vjnhoibbEGJHp5hTGBbOXsPlwu4+w+wj7bLL2ETY2W1NkC9heFpvZjFH2xNvEYWPEbsLoJgwMo24CdePoDIv1TLtwHZ+noZ+SeU+N3sVyTllPPerGUbbeQvWiSKfi6nXM/kn1W9Yuzdr5weMlVaOSdcjbfIRtdqk2+4ghMz5kxhHJ9CzmwWsu3yrcd6Rw35HC/UcK9x+FhoaGfrr+9spts5cYxHBEMj1r8QR37fvQCQUFBZU2Ktx3xOrFFcZgGFIlh592laCgoKCi2rXvQ6s3KDcuhCBVsBdCCgoKKo20q+SwxRMcQAOIVDcHIQUFBZVuKohASqaft3iCBXC6BwUFlU6KRlIDaMDiDe4qgQvnUFBQaaTompTCuGj14oX7jjztKkFBQUFFFb26N4gFbT4IKSgoqPRS4f6jNh8xhOHIEBa0+/DC/RBSUFBQaaTdpUfts8SwBUeGzUH7LIykoKCg0ku7S8vtc8SolUBGsEW7Dy+Ed5xDQUGlk4pKyx1z5JiVREawBbsP3nEOBQWVXioqK3fMkeN2EhnF/HZfsGDvoaddJSgoKKioisrKnfOk0hGGVH7xwaddJSgoKKioisrKXfOkykki42a/YzaYX3zgaVcJCgoKKqqisvIZP6lxkcikJeCahZEUFBRUeqmorNztJ7UzJKKxL8zMBfOLl2VNyuFwWK1WDMNMJhOKonqaUBQ1mUwYhlmtVofDsRylQ0FBrVwVlZV7AqTOTSI6V9Djx1P7BWOHw2G32y0Wi9lsttlsLpfL7/cHAoFgMBgMBv1+v9frtVqter1epVKp1WoURc1ms91uXz5aIQgSeUEXOLHwbMEfCUy2xILi0jB3EVKW8LYvXz7Ca57atgspKG4juNyln3depSqfNFRRWbk3QBo8JGJ0494AkcL7pCg8WSyW2dlZkiQfcwvH8YWFBYvFMj4+Pj4+rtPpKFSlqiZxok6nEHaAT3wS9BGeIX0jWMzd40AsvCwhCYTXR3hZvNV4Km0XAkTWUoRs4f3oCR/ndFZRWbkvQGJeEjF7iNkAkZI7zqnJHYUnAJuYqAoEAgaDYXh4eGJiAkXRZZ0AsnZxZ4Kdgzk2BBYEHnv0srjqCc6ctaoJdXohPZ4rTaJlCRegxLiik64P+IDzVok15xV3nNNKRWXlswukxUciNh8xt0Ds3n90iTk6HA6LxeJ0OsHRE6tIklxYWPB6vWNjYwqFQqvVms3m5eAUa18BdFbWHHg7B8JNmVSVxUzAlTlvEbxbhOy19DwBuT2BtidRZ8CpBHQA4fnzpkntcU5DFZWVzy2Q9lkScc4R84vE7tIlQcrhcJjNZo/Hw8ogj9d/4uTdf8s49b/e+rL2kowLVRSnxsfHJRKJWq3GMCxVnBJ+8sBQAGfLC6ml91TW9HEJeKvNWxxvJmAELH3wMMsVUlZybQef30hLma/jymLWBFz/dDjOaa6isvL5RdI5TyIzftIfJHeXliedFxVDcRHq8ePHJ07e/bdVJ1dlnl2ddX5N9u9vN0wAOOV2u8fGxkQikVqtTmE8Be5hkTSAvsK7PfKWq2ez5iCws4LHEut2QBGA4oR09LiWgqsESAMoC3C+hGROL0JI25M4MoC3zOPzFI/zylVRWbk/SM74ScQTIANLgFRklgeYzb2aUbkq82zma1+89vrX2Wurf/tBKyCx3+93OBwSiUQsFk9NTVksltTO+7j6lsBREbcjoGsKHKhcW8BjKW4XrsoLKTHRBE4BTROegPfI8KIhhW0Hi/XUgDc62TqD8Mos/TivaBWVlQeCpCdAIr4FcmEJkLLZbBaLBQCdx48fb93+TWbWhdde//r1dX9+483aL6ukgMQkSXq9XrPZ3NXVNTAwoNfrbTZbClsOPq/COzdzFKUWUgLrEDdOuHbhhQJvBQBpAMcnUQaxJgBDgbdKQsriEm+dwRud3MfhyRznFa2isvKFIOlbIBGti3T7k4QUtRTl9/vBkGrvUK/J/n322uo33qw9dKTD6ZoHp19YWHA4HGNjY21tbWNjY6lanAJAhJ6Gt7M6+bqpQEjxsg8sIbvwphFYK3Aarl3AWXFVgFlhIUUvpe0C689aJfDGhLYIr0ASWa1Ehe44d5HIsIW0zSYJKZvNZrPZwMShZDJ5LtUN1tUPe70LQtJ7vV6DwdDR0dHb26vVapceTC3lfCe6LwBSvGODqzcz8wRnLqQC4FakJE3S40cIfZwpansSkGLW5wlACpCGmdLhuPor5FdXV/J3OYrKym2z5LCZRAbNSULK4XBgGDY/zxMWJadAIGA2m+VyeXNz88jICIZhS2ltXAeKnFeBXUfIf10nYzDQOzGzKyf93xtQZ67xzIs5QAWSSBN3YFmPs5AiWCssEBwJtZ25b1wmvDkwM2F+yruFNU/wp4Dj7HBc/dWqE9KVD6lBM4kMmgnbbDK3INjtdrPZnMRdUUKE47jdblepVHfv3hWJRDqdbult5uo9zL7IlYC10zBHBaAgrr7OOiq4KsYsjrV6zLK4xiH3IBU65FjrLPAjrvTMsgCHKOm2g5vDVQfWY8jckVnJJ3OcHQ7piVWrTkhXMKGcMZDCcJsvmZs5LRaL1WoFs0YiQS/WSo4cvb2v7Or+sqtFv7qUmXXh179tFMIpt9ut0Wju3bvX1tY2OTm5HEcBCgoqbRWFlNyEW33JfC0GwzDAvVEhSEkNR8ubVq0+u2r12YzMc5lZF9Zk//43798VAimv16vRaB48eHDnzp3h4eHlOApQUFBpqyikBgyLFm8yP8RgNBoDgYAQ3Fys7c/IPJf52hdZr/8xe231b95vEbKXz+fTaDR9fX3Xrl2TyWTLcRSgoKDSVlFISfUBiyeYxKNaUBRdWBB0qe7x48cZmefWZFdlr61+fd3/e/+D+0J2mZ2d1Wg0IpGovr5eIpEsx1HgXYwAf8S1miBkcYG5osGbFXPtg/ctuP6Aj7iWYwTmBt5LuATmI7CIpdQE6skrCimJbt7sWUzioXd6vX5xcVEgpFatPpv52pfZa2veePPi+wcEQcrn86nV6r6+vtraWrFYvMQGCxx14O1cWfGOXkCCOPSw7ghYZE0VpFjrI6QVAtnKtRdrowTmw9suQEGsxUGllaKQEmtnMfdCEo8P1uv1Aqd7jx8/fnX16czXvsh+o1o4pLxer1KpfPTo0cWLF1MIKSc3sBLt0FykAJfOLI75FlBtrgQCR6CQwRzZwltncD25qgTeEdx8cP4Cawg4FFDpIyakEv4hBr1ePzc3JxRSGZWZWRcSgpTL5RodHe3q6kptJOXkg4vwvgvOR3ieXKOXSQ3maI+jCW9WrPmAKwwY8MyPeN9yZZVooYD84z5NtO1QaaIURFIoijqB3yteCqQIgrBarXK5/O7duylZkxLOI8C/X67/0pGPnGzg4CpIYIngNEtJzwUyri0CKxB3HMA5c4GDeZBZDzvrFqYAFYZKW8WvSSXx46BGo1Gv1xMEsRyQCgQCOp1OLBZfvXo1JVf3BEJKCFyEjwqucQgYpczBTH/NNZiZb7nS8L7mal1c/eOqF9dq1gyTqBvzoAEqxnp8WOsPaCDXp1BPXrSre2jA4knmZ9YxDNNoNALXzqOQWicIUtRTpR48eFBbW9vQ0LD0+6R4R4iTe9SxZgUeGELyicuN9aM4LnA1gXWgJgoFruKY9WTdUUiVEqoP4FNmxVi3sJ4d8PkCnCmoJ6yisnIrBSlZ6D6phG/mtFgsk5OTdrsdx/GEIAV+ntTjx48XFxeNRqNEImlubq6urk7JHee8nT4ugRAA8ebG9ZZeBOCtkPoILwhADWajmG2kb+f6FJxDEvUBtBSwXXhK5kcQUukjClIKM4kMGHGLlyhM/Gsxdrt9enpaqVQGAgHeb/CFru6tFQSpmZmZsbGx7u7u2tra+vp6kUg0PT29xAYDWAPYyJuGOZZYtzOzBQykhBhETw+uDO9rOilYGcH6KYAmS6wP4FOBGwE0ZO0PkFBppSikqK/FJPEFY+opCKOjo1arlfeuzlWZZ9dkV2Wv/faNdRf/z547gJRzc3Narba3t7epqenrr79uampa+lMQnHxxEzgZM42QwQNOw4QC18hxcgw2rlLAI43rUyZZAKwBH6WEyJIEpJIgFz03SKKVIhqkMMLqI5J+npRWqx0aGvL5fFyc8noDF2v7V2edz3r9j6+v+/Mbb158Y93FuvoR1gdL+f1+o9EolUo7Ojpqamrq6+tT9TypiMD4EAipuNdJwI4LAbwDnpcygDRCdudFkvBPWUkK2J21sXQis+YPaAtXesipFaEopBRm0jpLFpUl+WRODMPGxsbGxsa8Xi+TUxKpcU121ZrsqqzX/5j9RnUIUm/Wrt94OW/nd0xCmUwmuVze0dFRX1//zTfftLa2pvbJnMKhwxq5AHLjypxZBD19XEzENZ55y+KtHiAlV0GsVWImAGTFWh+uXViLBiQDf8paQ+HnCyodlBpIOV0Pb9YAAAk7SURBVJ1Om82m1+vlcvnExITb7Z6fnxd4UwJdJEnOzs4aDAa5XN7Z2Xnt2rU//OEPDQ0Ny/GMcygoqBWhWEj5kocU9WsxU1NTEolkdHTUbrd7PB4hS+kRLSwsOJ1OjUYjkUg6OjooQn333XfL9GsxUFBQK0JFZeVWHwUpbEmQcoZ/joH6MrBEIjGZTDabjYqqgsEgF61wHPf7/S6XS6/XDw8P9/T0tLe319XVUYTq6+tL7e/uQUFBrSyFIIWlAlLO8OKUWq3u7+/v6OhQKBQoilK0crlcXq/X5/PNzs7Ozs76fD6Px+N0Os1ms1arHR4eFolEXV1dt27d+tOf/lRdXX3nzp3+/v7U/oIxFBTUilMUUvJUQMoZjqe0Wi218t3a2iqTySYnJ9VqtSYstVqtUqkmJiaGh4cHBgb6+vq6u7sbGhpqamq+/vrrq1evtre3y+VyrVYLYygoqO+5KEjJUwgpp9PpcDisViuKohMTE/39/S0tLXfu3Ll3715HR0dfX19fX59IJOrt7X348GFnZ2dDQ8Ply5e//fbbmpqaa9eutbS09Pf3T0xMoChqtVohoaCgvudaFkhRon5FRqfTjY+PS6XSrq6upqam69ev19fX19bWXrx48eLFi9St5NevX29qaurq6pJKpePj4zqdzmw22+32VNUECgpq5WoZIeV0Oh0OB4UqFEVVKtXo6KhcLpdKpWKxWCQSiUQisVgslUrlcvno6KhKpUJRlMITDKCgoKAoxUDKkmpIRURNADEMM5lMKIrqaaJW1jEMg5M7KCgoporKyi0UpAaWE1JQUFBQyYmC1ACEFBQUVHoKQgoKCiqtBSEFBQWV1qJBygQhBQUFlXYKQcpEIjIIKSgoqPQTBSkZhBQUFFR6igYpI2nxkkVJPZkTCgoKaplUVFpu8ZIyI4lIjYTFm+Tjg6GgoKCWSbtLyy1eQmokEIkBN3uT+SEGKCgoqOXT7tKjZi8hMeBIPxo0e/AkftIKCgoKavlUuP+o2YP3o0FEpFvEPMn8OCgUFBTU8qlw3xHMg4t0i4hoOmByB3ft+/BpVwkKCgoqql37PjS5g6LpANKr9ZvcwV0lh592laCgoKCi2lVy2OQO9mr9SI/Wb5oJFkBIQUFBpZMKSg6bZoI9Wj/SO+U3zcBICgoKKr20q+SwaSbYO+VHeuGaFBQUVPqJWpPqnQ4gfdOLJje8ugcFBZVeKtx3xOTG+6YXEZE+aIL3SUFBQaWZCvcdMXnwPt0iIkZxzAPvOIeCgkovFe4/YvLgIv0iIjYQmAd+dw8KCiq9RE33enWLiBglMA8Bn4IABQWVVirc96HJHeyZDiBiA4F5Cfg8KSio9NeMqsH7qNT7cN/K9qPSGVUDb2N3lRw2ziw+1MwjIggpKKiVILf0pL9964LyTwuTNSvbyj/527e6pSfB7S3Ye8jgWuhWzSIiA4F5IKSgoNJdc1eeW5jRLjwbmtHOXXkO3N784oOoM9Cp9CIilDBBSEFBpb3mGlf7nyHNNa4Gt5eCVMeEB+mDkIKCWgn6nkJK6YWQgoJaGZprXDP7DGmucQ24vQV7D6Guha7JWQgpKKiVodk7azzLIARBkv50KZq9wwOpXSWHUddit3oe6YWQgoJaCZq9k+lashCauLYwd1l6uUzN3skEt7dw3xHDTPDBVADp1UNIQUGtAPkaVttSJARB4l7EbQQrJXXwNfCsSRXuP2p04w+1QaQHQgoKaiXIffNVZYqEIAhgC/NT8L7JyX3zVXB7d5ceNbqJRzoc6dETRggpKKi0V6ogFcejOKWkCCESAKlyo4d4pCOQRxBSUFArQe6br06mQhEeUa8jf+lvwUpJNXghVVRWbvQQj/QQUlBQK0QpgRQTT7wAShWV4gQhBQX1rMl9a5U6FUIQhPUv/QXXxhTKfWsVuL1RSD3UQUhBQa0AeW6tmkqFEASh/41TXDJmmpTUYWpqyiMMUg91BPJQRxggpKCg0l6eWxm6VCiCG+p15C/9BdfGFMpzKwPc3qKycgOEFBTUCpL3dgaaCiEIwvqX+SLu09TKe1swpB7oCIMbQgoKKt3lvb3alFIhCBL3ltpC3856dS8lpXtv89zMubu03OAmuqdx5ME0hBQU1AqQr2G15RkS7x3nu0uPojN4tzaIdENIQUGtBPkaMu3PkHwNfN/d238UdeGdmiDSPU2gEFJQUGmv7x2k9h3Ru4JtqgCEFBTUytDc5b93Oe3L8UCCpyCnfe7y34Pbu6vksM6x2Doxh3RBSEFBrQR5H5X6eso86gaP/tHKtrrB11PmfVQKbm/B3kPT9sC9MS/SpYWQgoJaGfIozvtac32Nr69st+Z6FOd5G5tffFBrD9wd8SCdEFJQUFDpp/w9B6Zs/qahGQgpKCiodNS7ew5M2fx3BiGkoKCg0lJUJNU46EI6IKSgoKDST/nFB6ds/jtDM0iHlkBnIKSgoKDSSzRITRF6CCkoKKg0U/6eAxqr/47CBSEFBQWVjnp3zwGN1X9b4ULaIaSgoKDST1Qk1UBBSuMkqy7dLiorT9Kl5btLy3eXHt29/2jhviO7Sj4s2Hsov/hgfvGBd/cceHfPBzvf+2Dnex+8S3lPxAeEmbYLSyYs+eTvOZBffCC/+CCHD+TvCVloufS37zEsuDl8FYOGho76wrfXJ8z+O0NupH2KkGGkxknqZwj9DKHjsivqaXbj005c6whq7AtqW0BlmVdZ5ifNc5PmOSU2q8RmqdfxtnCYNTHYljmqUJVlXmXxqy1+tZXFKouflozynGqJRXM1h7VioZoE1NaA2gYN/f2yhs9T9pAnLIG+qbnGYS/SNkW0TRFtGqJNQ9ynuZVuddQtTKuIe5N482SwWbnYOOZvGPbdVLivyxx/kdiu9VuvisxX+rArfdgVEXZVZL4qtlC+1m8N23ZNYvuLxHZNYrvWT9l6rd96VWy5KrJcFZmv9Jmv9GGXe7HLvaYY92GXQzmbr4osV8XWa/22v0js16WOGwOu7+QzNxXumwrPzUHPrUHPrUHPTYX7pnzmuwHXDZnjutRxXWr/i8ROKzdcH7E1UskYiyxXIm3pwy73YVQdroQaZY3mEMoz+vYvUvt1mTNSq1uD3ttDvtvDvobh2ZBHoKG/L75DeTTGjTQ3jc42jYV8d2zu/wOAIhYywXIq2wAAAABJRU5ErkJggg==" alt="技术分享" />

同理为目标数据库创建物理方案,方案选择刚才创建的ODI_TAG,工作方案选择ODI_TAG_WORK 点击全部保存

最后的效果如下

ODI Studio拓扑结构的创建与配置(Oracle)

2.4. 创建逻辑方案

Step1: 点击拓扑->逻辑体系结构->选择Oracle->右键选择新建逻辑方案:

aaarticlea/png;base64,iVBORw0KGgoAAAANSUhEUgAAAUMAAAE1CAIAAADyKhWMAAAgAElEQVR4nO2de5AUx53n8+Ji/7gLb8TdrsIRJ+LCCuPV+W7XupglzHXfSj5bvvBK2LeSrcAC2RuSkKb2BLZlQGs0YoQbECBeJWmEjgFsPOgBCCEkIbptowGNESBbMMNTRtMzzAAjhoF5NPNihsfwuz+qKysrMyu7qqe6q6v694kMVFOdlVXdqm99M+vxLbIuecQop053ZBAE8c6fWzuojtYlj4DAUOEhdPWHjrdiwYIlv1JCSr6JIEi+lJCSr9+40Y8giHdujI2VkJKvXrse9A+CIKHk2vUbqGQECT2lpeTR0WuXEQTxztWr10tIycMjo0H/IAgSSq6MXi0hJQ8OX8nvYhohhE6I5KwmbYqbVqw6ZztOTXldF4I4MXRltISU3D843MfQ2dUjLXOrl/UJEEIU/7J1nGbm/IjOZBEr5GzW/boQxCUDQ1dKWsniBgGAVMkGCj2z2nNSoxv5ufmUPWSIuKmmWC+CiJSWkjP9Q90MnV09N2+CWOZWL+t2QKoc+pHTUuzi6ka4mtI/pWsU67MtK1pDEDdkBoZLSMm9lwfYjevs6hm5ekMsnJJFsUmVwMpGKlRRsU6KUuvcaaa0nW6Z8lHJiFd6Lw+WkJIv9fazG9fZ1dM3MDpp9sr4v+r/MO/F+L/qk2av7BsYlXoyp2Sp6eV0S2kjip9PUYFdl1TzCrWjkhGvXOrtLyElX+jO9DB0dvV0XBrsuDQ4eu0GW+ZWL+sRIIQY/xoT0vn0U05dXGV2KXYm16x0ReK0E9zavS6OICwXujMlpOTzXb3sxnV29Xx2NiMWhZK5aSexOcmGk65TfQU97o4a6hWhkhGvnO/qLWklNzZfEktOJffIPJOdqfBktchzrlRdR3Fk4cQvtoMgCkpLyec6u3sZ5lYvcyq9AoQQ418D8VN2PltBOp+TunRd0gmxWW5d0nbEbyF+QQRRcK6zu4SU3N5xMb+v4VIAnNpFoeZUWq+zMrmjADvf6aDgtMGoZMQr7R0XS0jJp89eyOOaOLHfayEirem0uNNHTutS18+jfWkjCKKm9eyFElJyuv180D8IgoSS5rbzqGQECT2lpWTM1kSQ/MBsTSxYIlJKSMni6gOnbTM5uZEcriX7a8julWTnErJ1Aal7mgS9XUhZ0NHRcf369atXr46MjAwPD9N7M3t6evr6+jKZTH9//+Dg4PDwcEdHKXmym++WSCTy/l08Ldu5nbRtJtDxAl+O/iM03aXPJEsfRz0jhSXKSi4OndsJHJgAHS9A8xPQ/AScehQ+nQ7H7zNkDIe/Dp98DT6e+NSDKGakgERZycXx5LbNBADUMobz62beh0pGCoio5J6enl27du3atcs40RViJReHkxsJHKoAADgwQSLjc6vhdBUcmDDjXqrkpEYIiekt0KLHCCFa0ppPpwtPUjNvh3G3UmNjbUuYs2J6i61FZYOSdhAf4JRMZWxw+fLlECvZqyenUqmEjFQqpVjqcC2B7veyYgaA8+ts5XRV+jVycA156Nt2JRMtaU0Un6Rm6o+Zo9gSW/2krrcAtOgxY4EWPWZ+lvNgJGkH8QVOybsEBgYGwqpkrzgpX31E2F9DoPs96NyQFfOhimw5MOHy++TMFmIo+f47WSXHYrGYntRjsVgsMCXb19uiK7dElCgVMitlN0pGIy4IrJJFGRsMDQ2FUslePTmRSNy4cX1s7PrY2HVCyI0b12/cuDZyZVDdzu6VppJPVwEAnK6Ck1NFJd8zmVWypmlE07SYrpt7tsyfaUdUS1oVsjMZFTEdXGB7zXQeX8eqQmxrV3YQuPXaNJlkvkUuofLtiFvIf9Nd5ubF9Bbj0+w3US5VbscLquTR0dHR0dHh4eErJiMjI4ZRh1XJXkkkEiMjwyMjwyMjQ4SQK1eG+i93nz+bVit55xJXSv7GHTYlJ5MaIcZ/nMbJ1CWp+9EBNlsnlu3pOrqiWEdazaVb0u5xvkrm22G2EJIaO+Rmvyn7Y1g6zrVUOcF68pUrtjT4/v5+o2sdViXn4cnDw/3c01HtLceNdpz+3brAlZInf9Wu5BY9RmJ6i0LJbsQmlZDhTqwDS+vkp+RszV3Qosc0TaM26FXJ3IaJfQS+HUP6zAeuliofonwVyiuJRGJgoO/y5Z7e3guEkEsXOzrONLf8+bD6iFD3tCsl3/Flu5KzTuLGk6ElmXTtt/QsEq3s0ZOTSZkYWnSd2Uyzm2ucgK+MxYisRyA7oSVpxzbkdtw8sy9tfQV3S5UNUVZyHp78+dnm1s+OfHbiT4SQPx87ePxww5E/fqBup3aOKyV/ZQKnZGOfFn2J2RfNeXR8KBnK8mNg5iIPrZh7nMzMd9CCbBlzXdm/2SqOg275uulWx/S086CdV6q7pcqEKCvZK4lE4vjhDw/u3bHvd1v/8Lstf/jdlobfbv5o9za1krcuICc3EoWSD64h237JnvGKGsw5KCQwoqzk4lxPBoCtC8hTDxJOyZffJ+nXSPo18pUJUZYxUiJEWclFZsa95KFvk/vvJPdMJt+4g0z+Krnjy2ynGkEKSJSVXLRnoRAkcKKsZAQpH6KsZPRkpHyIspKLDGaGIAESZSVjZghSPkRZycUBM0OQUiDKSsbMEKR8iLKSi4N/mSF2/MroQMqDKCs5zJkhfmV0IOVClJXslVLKDPErowMpF6Ks5LBkhtgyMbKT2i6/MjqQ8iDKSvZKoJkh5oTtKWLwL6MDiThRVnK4MkOM3rNMmn5ldCBRJspK9koJZIYwYXP+ZHQg5UKUlRyqzBAAe56NXxkdSJkQZSV7JejMEJoRmbMeZnQgPFFWcngyQ7g0TATxTJSVXGQwMwQJkCgrGZ9PRsqHKCsZQcqHKCsZPRkpH6Ks5CKDmSFIgERZyZgZgpQPUVZyccDMEKQUiLKSMTMEKR+irOTikGdmSPbxCfe3WdruzcSbSBCOKCu5VDNDgLnhUv0wk8Mbla1noRAkS5SV7JViZYZANmxA556FEuAVi0pGHImykks1MwTMsAGdfT7Z+S3HkuejhDcP0zQCYjxnZeSN7BLmoP6jSpSV7JViZYYAfbAxmdRNJdOsEPaJKGnvmg3rE5dq0WNE0zTuPej2OUgEibKSSzUzBKhEW5KVTPqH+JyxfJzMdK6dnmK2nxET5yCRI8pK9kqxMkNANuJlUwaEasmkPeuH2rK4FHpymRJlJZdwZgh1UXv2reQSkznQtQ+bW/QYsY4F2aXS9PpW0j5OZuagmKNKlJXslaAzQwqC9LoaghSZonpycJkhBcTrj4AgvjNeJReZ0swMQSUjgVNsT/Zr2ZIiMl8ECS8h8+TSBJWMBA56sg9E5osg4SWRSHR1dXV3d2cymYGBgcHBwZL25NLMDEElI4GTSCSOHj3a3Nx84cKFTCbjWclF8+RSzgxBJSOBk0gktm/fvnfv3ubm5kuXLg0MDJSiJ5d4ZggqGQmcRCKxZs2a7du3Hz16tKury7OSi+PJJZ4ZUhglp/V4XE87f57iX1nFv8EqxxV6JFIkEokVK1a88cYbhw8fvnDhQn9/fyl6crEyQ/KkwEqWSZaRaUpjBW//y2zIqp/W41YrVtWURpSHDaTUSSQSzz///Ouvv37o0KF8lFyce7yKmBmSD74r2aZdVmFpPS5YbQ4ls9ae0mzNpfW4dUzI1QVASpvxKjmP9Xmab1DEzJB8KF7v2ruSUxrVakoTu9zsPKYqEjqK7cmJUs8MEevQJ6FoNX5OEEq29ZLlxPVmthF5B5qZi64cZgLw5NLODBHrGA8usyki/JyCKVnoXnv2ZLslS4TKDqLRlENMAJ5c8pkhYh1JB52dU7BxspveNeekdiVzg2S5kulcNOUQE4Anl3ZmiKSO1UC2Dj8n0HEyZ6TOnpxznIyeHGYC8OQSzgyR1mFc2mFOgEq2XWECkCnZ+jutx53PXUvaQkJEAJ4cycyQArSaW8lpPS50mBXnrukyzDkxVVUkTITjejKUWWaIKTfJ/RzsoFZ+LlpxPTnHOnGQHGKK7cnjBDND8sDoNauvWOE9XmGn2J7s17IlRWS+CBJeQubJpQkqGQkc9GQfiMwXQcJLyDwZM0MQREpoPBkzQxBEQTg8GTNDEERNODy5LDNDEMQD4fBk75khYN11Kd5iKXmdKnEKFbFVcniQGZWMBE447vHKIzOkRa/M3lptPcJovRuZue1anRnSkky2MI9VJaUvSEYlI4ET1cwQ9pEm60lj6+kox+eTpeSog0pGAieqmSGs9tiXm3MTkKeS7bkiBVeyJGYPcoVr4sMQ5UVUM0MKqmTT083/+q/kXAm4orDlYgcA/mlF7lFGTNWMCFHNDClo75o/IhTUk1NaXNe1uK5rkrQQF57MPeOU1uPxuP05ZHwKKgpENjPEkvK4znhJ6xTekwHANGYtZRqu9TeHKiKAe+jYUC3/JDI+mRx+opoZAn5dhXKTv1mwHC+V4+auw2VrAlj2y3Wp0ZXDD2aG+EBhPFk68hWDvNK6ztspU8nutpaAOSmjKYeecFxPhjLLDAEAZ2N2DvMRK9nNlpWvXcpoyqEnHPd4UcopM8SFJ6d1LS4ZIjt4snhowFTN6BCO+65LnGA8mZ68UlVirJcPyWX+xlTN8BMyTy5NAjkkpYyrUjI3ZY2bfi6mXVtz0JLDD3qyDwRy7lpd1XYnSI4hMA6So0DIPBkzQ/JAna2J93hFg9B4MmaGIIiCcHgyZoYgiJpweDJmhiCImnB4sk+ZITG9xbgJO6kRbZf9bk3bK98s3NRBJSPBE457vHzJDElqREu26DGiaRpz6zX3ZlaR3HVQyUjglFFmSIsei+m6ZnNX6XOOHKhkJASUUWZIix6LVVbGeCUr+81snezDUMafWtKc2AVJVDISOOWUGZLUCCGxWIxYDyi692RjmM01rkoakA4iEMQvxP2tbDJDkhohRNP1mLMmZViWzo+ui5IZgiBuGK+S81hfYJkhLXqMxPSkTMluxsmWLfMjZ1QyEjgBeHJAmSHA9JOpMpkbleWObAsMadFjzITZUyf3oJKRwAnAkzEzBEF8p9iejJkhCFIIiu3J46ScMkMQxAPF9mS/li0pIvNFkPASMk8uTRRKdnqgevfa24u5hUjkQU/2AekXUTxQvXvt7TfHMihmxEdC5slhyQxRPFCdfGlismbizbFMsmZismain9uBMT5lTGg8OVyZIU4PVO9Y8aWxoaNjw8dg+OjY0LGxoWM7VnzJsV15ME82SM8K8IrrKSH1GhVdboTDk0OXGaJ4oPqNRbe+sehW6Nq0edGtmxfeKm1QyKNnXx7DJ9dboqV/2KOyaQauLb2PCc9F2UeAcHhy6DJD1A9Ub6z64vXTizdWfZF9oNqOFXSblac0yDarQod8TUOgjNa5d1DIX1SBhJNweLIfmSEFRFRyzgeq1z311/YHqgUMfVFFS5QszJJ5MvcSCjrfFlaPedfhJxz3ePmSGeIrtmenxB/B+wPVLJKXPWmaxvltM3Vi1TjZ5reMkoW3o6Mrh5wA7rv2NN/Al8wQP7Hnh4gb7/2BaikSbxXeFsXMkAjS5rbScbJYDQkjATwLFUhmiJm/l/U2S9q2NyGbeSDZmdkWzG46m09gmyFuvPcHqm3Iz3jZlZztd6f1uPRdysIgGbiTW7a3y6Aph54APDmwzBBIavShROuRZVPD7AvTbR4uTSPI0bvO44FqG9nOb0qLa5opWH4InNbjcT3FvrvRhSc7v4MVPTnclFNmiEST7CPKzuEh1JRdKzmvB6opnGxTWlzXTQGzveuURrhLy3YfB9GG5Z6M72oMP+WUGSJJCGEFD7Y6kjnSbLCkNDPEpweqTdnariRxSiZENU5WvECZkS5acvgpt8wQ3lstv43paWEALCwntKYlnX6E8T1QbY6UhTerpixztsbCMks2pYrvaiwPyiozRBG7Ny4UG18KD1TjuxrLgXBcTwYfMkMc/NYPIvNQFxJewnGPF6UULE4ElYwETjjuuy5xIvNFkPASMk8uTVDJSOCgJ/tAZL4IEl5C5sluMkMmaeuKXFDJSOCExpPdZ4agkpEyJBye7CkzBJWMlCHh8GRPmSGoZKQMCYcne8oMMdRVUbmt7gIAAFxonFZZm59EKyrrG7Kb0PascyOoZCRwwnGPl6fMEENd05JtdYnaSdq6ig1tZ5LbxmO5FZX1DUEo2e0TSkL4gHUrdVqPszEh9IHm8axT+uQVPoARNBHMDDENOau9isr6hnHYcmBKdnwwwlIODeuzPXUc19O2hyIUsX1U7Qr4ZZknISXyNY8E/BEB7+4uNEFmhoyNXS9EZginPWO6+vEPGgAA2p5NNJ4xJiprJ2nrpiUzxioaNmSFWpGtANBU76Rks07GsP0CKDmlxePyJ5Qs3YraNMIJOCWbda0kTYccP4ft4BPBZCljKb4p0dvxiavCEmRmyMjIUCEyQ6RKfrayNjvoZfzZ/pExsa3uAjRsqOVdnVFyReW2uguZukQtdXvflZzS4nraIfuWCfbJSsXBk1c3ZzVnF5C6d+0Mq2Rbi+yGKLML8CnoQhLBzBCn3rW0k2w5sF3Sit41cxosu1RhxsmS4S8zW94nNsNF+GgCx6OClsrRuaYHAkHJzH/FJ6FlSkZXLiRBZob0dHcWIjPEPOOVMTrM9IyXpJPs7MmTtHXTNtRPc/RkWzuFUrJaWkxF1TjZnr0pz+dkcfLs3EpmPVd65gxNuYAEmRly6vjHhcgMYfQGANnutNP1pIoNbdZqjJrmnDPJbXb7tZa1nLwwvWsT9Xki0U1l42Q3SbvcOy9cK9k878aef7O2TWgGTbmARDAzZDwXnPIrAXkyZ7HGn85Ktg4L5izbaTA2017WATDnxzXNqMuEjKEnB084rieDl8yQKCjZTM0ESGn25Dz7myNEJdOPbMNb9royK1brVBVxPLdtfm5XIZ8GCIqX1YDzPMQvwnGPF8VNZkgElJzS7QIhduFlYZSsaXGbrEwlpzRC4vEcAjIUmNKMBlyc207rcXNb2GMAf+6aN3a05EISjvuuSxz/vwgrBM6TRU3bhr20E8x1gB166tbLLeztc6Nv+4Zxg13La1UDYRwkF5aQeXJpEplD0vhxyvHEe7wKDXqyD0TmiyDhBT3ZB1DJSOCE1ZPdL6vV9P37H3Te8lCdumg1fUXYGAQpENH35L97vh3gFMCp2h3NTa3XmlqvLf/NJwCfwI190L4JBt+Fvs1wbMktD9W5aY0QIk6jkpHAib4nZ5V8rXH15s8Onrq29fetC9b+CW7sg9HdkF4LfZvh0kY4PD+nkg3div+O84sgiC+Uhyef3g5Ha2Yt3bt0/b6l6/f9eN470L4J0muh/ik4tgQOz4d3Htr1kKsXWaAnI6VJmDw5v/vD/nZZq5ve9RvfVSlZvKzCzkQlI4ETJk/OL2/kvy1Ju+ldv/St3J5MNQyMIYtKvnHt2pFXX60lZM/cudJ2kjNnLiXk+Jtv5lwjgrgkTJ7M5o0QQlzmjfzXxZ+56V3nVDLrw9wcbgOaNm2qJQTenFtLyI7HH+faefdf/mUpIfDm3KWEHNiwwdMvgCBOhMyTad4IIcRl3shXF34K/R9A/wdVaz9NHRpNHRqd+fxB2qmG82vg7CrYP0utZFG94KxkQ8bwBIEnSC0h2xkxv6NphozhOwS+Q5YScuHs2Xx/DwSxCJkn55E38l8SJ6D/A+h9f/ZLJ98+MPLCluYZiw7QTjWcXQWnn4MPH3XZuxb/FJX80apVtYQYSjbE/PbMmQCwrbKSk3Htgw/u2bNHtip6p7QV6sE/Ziy5CRufNipfQubJNG+EEOIyb+T2BUfh0PNwtOZ7P9/95PIPn1z+4V2PvkU71bB/Fnz4KLz6neV3eTjjRWeCTMkAsHfx4hpBzKyMnyGk5oEHdu7c2draKluh+bCxoWTzuWPjKQRLycZ/bJl5uvjAkV3fkocz8Kbo3NgeLnH+tRyfE1HmtPhByDyZ5o0QQlzmjdxe3QSfb4LPN/1o0Ylf7x7+9e7h783dTzvV8NkzcHIOpO5TKxmEDjY7Ld2A7Y89lhXzPxOYThJ2Gb+kkjF4UDL7uJP04UE+Xcv+bBUf0oU4kDNGgX4k/SEL/wOHzJPzyBv5m2cOw+eboH3t9+cff2XX8Lz/d+run3xEO9Vwcg4c+b/wXg5PNmANGZSebLBj1qylhMB0AvcTQ8PwTfIMITXTpillDK6VrBs7CKdQNlcgR94lBR8eVmP/fay/qFdzz3Xa5tsHSNwiPhEmT87vevJXqv4Ee34C+37x33/02x/O2/PDeXtu+95W2qmG1H3w3ndgjaveNZ0GuzMrvshHq1YliCXjhFsZEylGBjajZE0znjAm8bh9EU3TSFxv5mJ91KFg6MoK7EpO0yMod8RM6/G43uwwn8sY9vfgGSZPzg+tpu+lb5GXvkVueejVW6b/6pbpv/qL77780rfI8rtsZcv3XN3jJcVJyVkZG53qbxL4JoHbyDOEvDh1aq4mPfeu2cUYmL2FD+fhfAFNWYlUyfZkBqrtZof5NkPOMeD2TJg82a9lfUe6MTYZf4fMIARuy5a5hGyqrFQ26emMl5H9w2OzApCe1+IGf2jKzkh71+LRjypZNr+gEUjR9+QiICpZlHHNtGmcmDc+9phzk6bhejl3DWpPlkiZ+xQ92RnpGS/rhIQ5i/auZfPT0kV8Aj3ZB8TryaKMd+7c+eLUqayYNUJedXJmq/empQypirHVZj/NjN7TzBcxsruITb1CCJfb02GI41UoV2e8zL9L+YwXAoKSORm/+MADO3fuND56r6qKFfMMQk4cOyY2yERjappmC9cDsWvHZOey2dNmyq59h5GFXoKkHhIyou/JJ47sO3Fk3+5ddW+9tuqt11blvUb3G/PuvHnG+eoZsts/qJhnELL+kUeoyFlSmnlrVzwej+spPZuBywVn8u81lZ5DcTX+xUFy6Im4J584si/dD2f6buw/c3X/mat1H18cj5gJcyGKRTysvDtv3gxC1j74oPSCkyFmQ8aff/553tvjEqe8Swre4xUBIu7Ju3fVGTJ+eW8nLVvXL6Hl12sWb3jx2TXLn3bTGrFfUqbT0o3pOHtWcd34xLFjO3fu7OjocLNeBMlJxD35rddWjWa2XKm/e/CdiWwZTt5By9A7tw29c9sh/d/kbM29JyNIkQmTJ+dxj5eh5MF3Jhp/jma2jLYuutn8i5vNv4ATGpzQbh5+8Pr+716pv3v9U/9ZsWpWt+P/IgjiO2Hy5DwyQ1glK2Q89M5taiUbEHvoD51GJSOBEyZPziMzZOv6JdfPvzz4zkQqY0PDnIzPbPiCJyVz/6KSkcAJmSd7zQz59ZrFo62LBt78j4YVP7By79QVDT9YtufeJb//1i93ZycSqcnVv51c/dsfz1qh3gBueAzoyUjJEDJP9poZsuHFZ282/8JQMpzQvr/y9xvf3OtUvn6v4+2T0kEy/ROVjAROyDzZa2aIoeQzG75g9KjvfDaZn5INuHGy+ty19OQcgviFuL+FyZO9Zoa8kNDghHZmwxduHn7wSv3d/+mx7eNXMp2mLj2eHwFBfGG8Si4mCe+ZIS8ktCv1d5/Z8AWj3PLj131RMnfSC5WMBE6YPDm/zJBlVY88M+uHT874px/cEx+PktmzXHROfl8EQXwnTJ48fsbpyU6gkpHACZMnj3/Zr9/7mLqMc2MmaeuwYClyoTthGXlygUAlYwmw0J2wjDy5QKCSsQRY6E6InjxeFEr+ySvw6Er44XPw3Wfgm7Phzp9m6+xee3vgewCWaBS6E0bfk9esWbNmzZr58+fPnz8/7zW62Rj29523EeZthLuetJU7fwZxDXavvf3mWAbFjMWXQnfCiHvymjVr6HR3d/fs2bPH3yZ326ao5Ko6XsO0JF+amKyZeHMsk6yZmKyZ6OP/0YqFje2djdMrawPft7AUs9CdMMqeTGXcbdLa2pqfmMWbNMW7NY1f9plNACCX8Y4VXxobOjo2fAyGj44NHRsbOrZjxZec/g9VrG8DQZkVlfUNAA3ra6ubzC3rbKxO9nFb2558axKj7Yr1bdIv1bA+23h1U1/dwtqKyrfqOrkqbdXCoaG6Kdu+oripg8WXYvx/irgnG0r+/ve/v3z5ckPGra2tg4ODs2fPnj179nwBl82qPfnJWjjUAQDwZK1EzG8suvWNRbdC16bNi27dvPBW6f+b6bwy26otKdqkNT3ZRwXD6pbONCoYc8wKb9V1tlVX1lY3ZZVcUVnfYCxY+VZdZ1/dwmz7FWZNbvMqKusbwKpmrV31m1n1pyf7oKmeacqkqX4SHgKCUnKJ3+NlKHn58uUA0MowODg4ODjIVZ4yZYpTOwpDFj1ZewkOdcDeZnivCZ6s5cudP4ONVV+8fnrxxqovOv2/YSVEpUj3fqta1rQZMbBQcTY1TndWsuXtANDZ1iDzZFsdKU31FQsb25vqzY233N4ohudPsg8BjJ4CrZk93NiPJliKpORi4qR8xRHBsFnqxq2trfv379+/f/+OHTvi8fiOHTumTJnS2tpq/KlYNffshNMGGL/sPy+3lHznz+Rl3VN//WSt6qpVdo+n8hCUXFFZ32D3Z6knU5FIv5ehIiqznIXtAogfKX5AMDv8to4A8IK3tlY4bGFxKnQnDI0nJ7xnhsyfP5/K2BDwpk2bDNFOmTJl1qxZAFBdXW1MuEEqaU7JDyQsJcPQCdj3l9ny4b81ylCK0ALnVvL7sWSwCg1Ndil2Nk6j4nQeJxteanW/pca+sLG9qd5yfhFmrD492SfVnpMIucMN67fSswDWJuGpuyIruZgkvGeGAMCmTZt27NhhaJjKmPKHF6bOnBJzuQFcp5rdMGPC+GXvnsMoed9fGh/VziFGAfgjwF4Y2w7XX4erv9q1lDiqwhy+sgrh/NNWRyYA6s+ScWxn4/TKWpuXdjbWNTHdXcH2Zd1s2/ZMX8gdDuy9BqZBlZKF9WJRFLoThsmTvWaGGAtOmZ5+kTkAAA+aSURBVDJlypQp8XhclPHF9oZF9//dL/7337jfDNGWOSXf+VNOyT0w8kHtHAIAtXMI9L4MvS9Dx0+g4yeZA/8oVbL8jJddyYY9Go4qERhzCMiOkO2S404s0W6z0JTcUSXKtA/X2S40COfSJ+VQMg6Vi67kYpLwnhmiZtv6Z05u/3n67Vm/W/hPOSu7P+P1P2cxSv7DvwM4B1cPWp7c+zJ0r4Tz8xRKrljY2A5t1ZX1DZ1tDZ1t1ZW1jNJsp46qme6usyfXG8KobgKAvrqF9Q3Anx/OCljpyRXr2xQey38FYaw+SaJ8uVzRkz0Vqo4webLXzJCcpN+etf3/VHhdKuedIbHHTSU3/AVAGoZ3Qv+W2jkEuldC90roWkQ9ue5pXsnUkcyec31DZ2OdKWC2d13dBGAIXraRWVdkFGV2sDmbBQBo78zhyUZN/kQac+zIecYLmuo59U5P9rGdc/tAAJVcXCUXkzwyQxQ8/OJg3Z5Ro6xfv/7hF/mLUiJixoC0d22UyY/Ak7Vwcy8B+CNkNlJPtsy55b7Mu0RUsqUTepmXEYygZKYjLXgyHbI2rK9vAHDqzU6y967NE9rm1+5snPb4trpOyeLye1cMHa5va082iq5b3WQ7X20bVNOLzHju2kuh6giNJ+eXGSLl4RcH3//k6vufXK16dbjq1eGHXxz8qx/1/dWPVK7CqpcbKiueoLjyOwKQgq5FtXMIdC2C8/Pg/Dw4Pa12DoHT0zLvkto5st41PX1t3izB3Yw1iRnoOpphU71555bDBWewxGkomTXkhvW1tJdb3cTIzHZqXTismG0yF4et7Znk4rw0DpK9FuPXDZMn+4j2ypAh4x8sG/hfz/QbMv4P9+X5lRVK7ttJ4Oqv6OmuTMOkzJ6/tf50UHKJlAKNV417vJx+TLzHy2uhO2FoPNlHvvbTjFGoho2SX2sKJcO5lZ/+xupRf/obwv0Jjf8Q+K6AJdSF7oTl6Mn+gkkDWAIsdCcsR0/2F1QylgAL3QnD5Mltm8nJjeRwLdlfQ3avJDuXkK0LSN3T/I3QRQaVjCXAQnfCcHhy53bStplAxwt8OfqP0HSXPpMsfTwwPUemc4GEl3B4cud2AgcmQMcL0PwEND8Bpx6FT6fD8fsMGcPhr8MnX4OPJz71YDBiRiUjgRMOT27bTABALWM4v27mfahkpEwJhyef3EjgUAUAwIEJEhmfWw2nq+DAhBn3skpu0WOEEEJiekv+a05q2XurtaRzJamSpTexIIhfiPtbUT05v/u0DtcS6H4vK2YAOL/OVk5XpV8jB9eQh75tKblFr8wqOKmNS8tGE96VjCDFZLxKzmN9nuYb7K8h0P0edG7IivlQRbYcmHD5fXJmCzGUfP+dVMkteoxqb/xSRiUjpU6xPTnhPfcDAHavNJV8ugoA4HQVnJwqKvmeyVTJrPaSGtF2ZfvJWjLb6c5+anbBGaVKZglKztbJHiFQyUjgBODJeeR+7FziSsnfuMNRycnsBDdsZj8yJlr0mDFld3Wbklv0mNFK1u1RyUjgBODJeeR+bF3gSsmTv6ruXcs6ydSBeUmzcDPpabDsUqhkJHAC8OQ8cj/qnnal5Du+zJ7xMqVsDZNFlSo8GVqSyRa+Gt82/VJ5/BQI4iMBeHIeuR+1c1wp+SsTFFehHK4nsf5qdpmZv9iPmWWpk2PvGikNAvDkPHI/ti4gJzcShZIPriHbfsme8SoqqGQkcMJxPRkAti4gTz1IOCVffp+kXyPp18hXJgQmY0AlIyVAsT15nMy4lzz0bXL/neSeyeQbd5DJXyV3fJnrVAcAKhkJnGJ7sl/LlhT+f5G0rulpgLQe11L0PymNaCmuWlxLAUDKPprPjumNuimNkLieNiazEwApzZwpWTiup7PrslZAl+Q2Q9wo57lOW8pvcvarERLXU3rcuQ7CoFLyTcQdhTgkpfW4lkrrcU3X44aKTFXxlcAuNANWSmk9bsjWrGaIO5VOC9XpYpySxQbt1WUb7+o78tudlTBVLNeSbYXmZqTtarcqMIer6KNS8vUbN/oRF/iu5LTEiexuFtc3WH9rmsKTGUTBW5/kUjJAStNSTp6aPVC49FvmazpsEN0OZyVbC9MDi1mFSCpFHpWSr167HrRGwkGBhgkpXdPiWZVQX+X3ZgdPzrag1BYhJLZ6t3DQMI8NvJLFtrmPHLvUTh/JdGY7iCl61/Zfwd46O0OxUdEClewDBVCysTOm9biWSmlxPaVrmmaIit39RSXLTSg7Vs4KW9yz6VIOnmzIyaxiryp0wLkOhWnXXjzZ2FCVArlfgavLzCkbV1YpeXT02mXEBb4r2VSLoRJ6+ktjB7sApmjiui713lhVVdzmY9aZM7vDWeNJXnGMJ1sKtv9XpmRWZHkoOaXH40TTdU36xYQGlUouG1NWKXl4ZDRojYSDwvSuhf08pRnDZdMKqRSZmkoLknfC2V3dmjblzpzttk6XKTu841ZyStd1jWgpY2QurWn7W6pkYROijkrJg8NXMt4hhNAJKU71w0sBPFliQ/TKjLVbMpendH5AGV/dLJ44k/qbDceRMXcYSIun1P3pXad1jV4Ec7hEBjk82XbOGj05eaR/cLiPobOrR1rmVi/rs0MIUfwpkrNCiVOI68nmzsl1FGVKTuvxuJ7iT/IKGklpJB7n3ctqN5fWbWNxIj81Lngy95H4LUUlp3Q9LevlC/0Th3Eyc/3c9iE9ZyhORAJvSpY2ISqZIu4YTvOl1cJCYXrXjL7Myz+GbG37sJYydmrBf5l91GjJGgpLdQhMk44bo6WyUnPY4PGfu5bXF2ty566l39tWr5yVnOkf6mbo7Oq5eROMMnPtNjo9t3pZtzOEEOl0lChM75qTov2+KvN6clzXNXO35DzZ6l07nM0mhD0rprLlDXQdTnXk96Axi7i44swcYYymHNZHe/W5ZVgug2RQK7n38gC7v3Z29YxcvWGUh194fWzspjHNKdn4tdk/naadKJjiCkVkbjsNF0bHWbEj4T1eWSVf6u1n99fOrp6+gdG///mKyXNX/4+nVk+eu/rvf76ib2BU9GRDjZERak5QyUjgqJR8oTvTw9DZ1dNxabDj0uDotRsTtUWj124YZW71sh47hJCeXCgOpTmXLTVQyUjgqJR8vquX3V87u3o+O5sxykRt0fDIdWNaoeQIqNQNqGQkcLwpubH5Ei0Dw9eMCbWSpfN70JMRxFdUSj7X2d3LMLd6mVPptWMI0pjg5kunneqEBVQyEjgqJbd3XMxvz6ZqFP2WreOED9oqLqhkJHBUSj599sI4b5kgzjd7EYfbP5zmlzKoZCRwVEpOt58PWiPhQKpkafAggvgFKtl/xJ8VQYqMSsmnTncE/ZRROEAlI4GjUvKh461Y3BRUMhI4KiUHHVkZGlDJSOColIzZmi5BJSOBo1IyJvK5BJWMBA4q2QdQyUjgqJSM2ZouQSUjgaNSMmZrugSVjASOSsn5ZWtm7HGZxDk6U/oRN1P9p5sG867mHlQyEjgqJeedrdnH3D4tPiAh1uHqi+2In9L5apy2Qbo9eVMIJTtnZkle81YeObCICm9KljahztZ0UqCTSp0eulAsIk47rb1AFEjJsgwqefSlOnhO8U7Dskq6CheEeHsruErJ48nWJEIQH7EneNEdymlBdqeTNitW41BsjL8E68lmdQdJOr3TMOeCSKAY/7Pd11cpefzZmqKicgpMFHy3g1zFatIWnBaXtpMfxfZkSRyt7V2j3AeO7zQUaiClA90/XdZXKTnvbM2cSLVEBOtWKE0hV0XlQhhyd1GV7PBR9n0y0pfDKN5pmGtNSHCwAnFTX6Xk8WRrOsFVEzOx2GrSpdhlpS1L5/Q4p4uNn4Kcu1a91InToylRuVfb3p8kawNNuRTxU8njz9ZUT1O9SdUuyk9xUBDbF+dLNeFWrEqKdhVKrjnrtJVgrzneaSiphJQInmQMhc7WdJpmVUqURp2HOJ0OCjnbzBvflZzzHYv2dxEq/FX9nmH5Mkgp4EnGUKBsTQoxEzaJLGfPzUxpHadqRBbo2atM/3Nq3xOF8uTsu88tRM2Jl5Hsc5zfacisBa9HlyCeZAwFytbslalXOke6oPinWoGEifJUNKJe73gokJLTqZSu8W96YzSX1uPS89W2dxA6vtOQVkFLjgQqJeeXrWnsJopPpdNOM52aIsw9Xk6NE9mtJoo286bg42RLg7Z+tPPolhFzjlEwDpIjAiby+UCJ33eteKch3uMVGVDJPlDiSkbKAczW9AFUMhI4mK2J2ZpIFMBsTR9AJSOBg9maPoBKRgIHE/l8AJWMBA4q2QdQyUjgYLamD6CSkcDBbE0fQCUjgVOQbE33kFwxl7QCd3OStFrO1goEKhkJnEJla7pBvE1avGebeAnf8/2GapeUQI6XQ1QfUjYUNltTASddqWK5+W7UrqhWOILK1mT/4KbZZeXZmnF9A950HSEKla2ZE+IQ30WU2ZqKpogQA1Y0gvJkV0pWZWvig1DRwf9sTZdQiXJaFf/stqftcfKW1i8yQWVrulFyjmxNfDg5KgSTrdltl6ibajn/pfVdOrmPBJWtqQjtM5fNla2JrhwV/M/WdNq3KGKdHoeUTHVNaS4X8Tujyw1BZ2tmq8s82TFbExNDIkZBsjXdQJwzNOmEVNiKppwqFJqAsjUdz34BpDTq2jmyNdGUI0JBsjXdwHpsj0zJ7J9O3i4u4lSnoASSrdnsRsm5szXRkyNCYbM1FRAhdpOd5qqxFXLWyWNjxklA2ZoulZxrnEzPnhk1xQkkDCQSiQULFtTW1u7Zs+fUqVNnzpzxJ1szJ8Seg0lyxWIS5xzcqCrZVbams2kL42DluWtUcshJJBKrV6/etm3b8ePHM5nMtWvXxput6QYi3Muh+LRPdt8IcY7ULNA2KwgkW1MJ9WT1QBgHydEhkUisWrVq69atx44d6+3tHR0dxUQ+z5T4fddO2ZoYrBklEonEypUrt2zZcuTIke7u7itXrqCSPVPiSkbKAXrG6/Dhw11dXQMDA5it6RlUMhI4iURi8eLFGzdu/Oijj9ra2i5evIjZmpitiYQPVsnt7e07d+60lPzhH09icVNQyUjgsEo+e/asTcktZy7cQFyASkYChyp5//79586ds90Z0v75xWuIC1DJSOAkEoklS5bU1dUdPHjw3LlzmUzGdo/XKOKCBIKUAIaSP/7443PnzvX29lpK/ryrdxjxzsWLF48ePfr222+/8sorK1aseB6JKFOnTp06dSo7QVmQWDy1ci4tDz/yqM5gXM+nE8a08SdXLee0rusPP/Loc88999xzz9XU1Gzbtq2xsfH8+fOZTOb/A3HwTSQdOxBdAAAAAElFTkSuQmCC" alt="技术分享" />

Step2:创建逻辑方案ODI_SRC,这里可以使用ODI 已建好的上下文Global,也可以自己使用下面自己创建的上下文。物理方案对应到刚才创建好的源数据物理方案ODI_SRC.ODI_SRC,点击全部保存。

ODI Studio拓扑结构的创建与配置(Oracle)

此时点击物理方案ODI_SRC.ODI_SRC,会发现上下文自动已经配置上了。这里实际反映了物理方案-上下文-逻辑方案直接的关系,这种设计 的目的是为了实现物理与逻辑上的分离。实现一个逻辑方案可以根据开发、生成等不同上下文,关联到不同的物理方案,而同一物理方案也可以支撑多个逻辑方案这 种灵活的配置需要。

ODI Studio拓扑结构的创建与配置(Oracle)

Step3:同理创建逻辑方案ODI_TAG,物理方案对应到刚才创建好的源数据物理方案ODI_TAG.ODI_TAG,点击全部保存,最终效果如下

ODI Studio拓扑结构的创建与配置(Oracle)

三、新建上下文

在系统中已经有了一个上下文Global,我们可以采用此上下文,也可以新建。

ODI Studio拓扑结构的创建与配置(Oracle)

填入名称和代码,这里develop表示开发环境,代理先不填,保存效果如下

ODI Studio拓扑结构的创建与配置(Oracle)

四、创建代理

代理同样需要创建物理代理和逻辑代理,如果是在本地进行开发,暂时不需要创建代理。

4.1创建物理代理

参照Configuring the Domain for the Java EE Agent

ODI Studio拓扑结构的创建与配置(Oracle)

4.2创建逻辑代理

上下文选择刚刚创建的Develop,也可以使用Global,物理代理方案选择刚才创建的OracleDIAgent

ODI Studio拓扑结构的创建与配置(Oracle)

至此,拓扑结构就配置完成了,下面可以新建项目、模型、然后设计接口进行ETL了。