熱點推薦:
您现在的位置: 電腦知識網 >> 編程 >> Oracle >> 正文

OracleDataConvertion簡單方法

2013-11-13 15:39:32  來源: Oracle 

  Oracle EBS各模塊之間及與處部系統之間的數據轉換和傳遞都是經過Interface表來完成的上線前需要做Data Convertion工作比起常規的APIDataLoad等方式PL/SQL Developer的文本導入器功能來實現更簡單

  PL/SQL Developer的提供多種導入功能其中工具——>文本導入器可以導入CVS等文本數據提供字段對應功能可以生成導入腳本或直接導入還可以保存Import Definition為一個文件來反復修改有多種參數設置十分方便

  EBS有哪些接口表?

  

  select *   from dba_objects db   where dbobject_type = TABLE   and dbobject_name like %INTERFACE%   select *   from dba_objects db   where dbobject_type = TABLE   and dbobject_name like %INTERFACE% and owner like PO   select *   from dba_objects db   where dbobject_type = TABLE   and dbobject_name like %INTERFACE%

  建議去研究一下系統的標准並行程序會了解在系統內部數據是如何拋轉的這裡面用了很多接口表

  Oracle EBS 數據導入方法比較

  API INTERFACEMANUAL TYPING DATALOAD

  dataload是免費可以使用的~大家不要寄希望於這種工具它只是讓用戶把鍵盤輸入動作和鼠標坐標編成一張類似於Excel的指令表然後沒有任何判斷地傻傻地一邊讀一邊執行作為使用者你必須蹲在邊上看著它完成如果出錯也不會停下來必須要你手動干預極易出錯!!!可就想不通ORACLE的顧問怎麼就這麼喜歡向用戶推薦這種工具如果我有時間的話甚至用VB就可以編寫一個類似的工具!!!

  這只能說明一點ORACLE那邊太刁蠻根本看不起用戶的工作根本就不考慮用戶在實施工作中對歷史數據的遷移!!!再次鄙視!

  Dataload is not an Oracle tool Well that sells which means if you can come up with a better tool you may sell it and big money will be waiting D

  Oracle provides some tools to help data migration

  API

   Rocjing mentioned ——提及的 API and said it is the fastest That is true API is not a tool but a term ie an abbreviation ——縮寫 for Application Procedure(?) Interface An API is really a (hook) function/procedure provided in Oracle code to create data in Oracle For example if you want to create a user in Oracle you will call FND_USER_PVTcreate_user(……) (a lot of parameters) This procedure is an API Using API is really for you to code a sql script and call the APIs in your script In another word this is coding and programming

  INTERFACE

   Another popular method is through interface tables Almost all Oracle products provide interface tables for high volumn transaction data For example AP has ap_invoice_interface GL has GL_journal_interface etc (Invoices are the basic transactions in AP journals are the basic transactions for GL etc) AP may also have an interface table for suppliers which are also very common for AP How do you populate these interface tables? Mostly through uploading spreadsheets ie xsl files (MicroSoft Excel) The key here is a spreadsheet ——電子表格軟件 and its target interface table have the same column structure (including column names column type column count etc

  Oracle also provides tools like ADI to help you to upload data from spreadsheets to interface tables

  Usually after you load your data into an interface table you will submit a concurrent program to validate the data and transfer that into the real transaction table

  Hence ——因此 this is really a spreadsheetADIinterface tableimport process combination ——結合 聯合 method

  MANUAL TYPING

   It is pretty hard to deal with every high volumn data issue in an ideal ——理想 way So manual typing is sometimes the only way Even in this case users should find ways to use say batches default values existing auto triggers (like distribution sets in AP) etc to reduce the amount of manual typing

  DATALOAD

   Dataload is also kind of tools that help but of course it is not ideal in every case Dataload is very similar to Oracles Regression Test tool which was very popular even inside Oracle years ago Nowadays it is not that attractive any more People just have to live that

  Hope this is of a little help for you guys

  What you said was like Interface Tables which were in Oracle for years If you have not used that you should find a chance to try I would say all interface tables were created to support spreadsheets (XSL files) and I believe that is still the best solution


From:http://tw.wingwit.com/Article/program/Oracle/201311/17092.html
    推薦文章
    Copyright © 2005-2013 電腦知識網 Computer Knowledge   All rights reserved.