Planning an Integration Project

When beginning the development process for an integration project you must define the integration scenario before using Studio to translate the project requirements into an orchestration.

Defining an integration scenario

When defining an integration scenario, specify a clear goal. With this goal in mind, identify the high level project requirements:
  • Endpoints - From what source system and to what target system are you moving the data?
  • Formats - What is the format of the data from the source system? What data format does the target system accept?
  • Transformation - If the source data and target data have different formats or structure, then what type of data transformation is needed? Are there any special processing rules?
For example, if your goal is to consolidate multiple purchase orders and place the consolidated purchase order into a supplier's database. High level project requirements might include the following details:
  • Endpoints - The source system is an FTP server. The target system is an Oracle database.
  • Formats - The source data is pulled from CVS flat files stored on the FTP server. The target database requires data in table format.
  • Transformation - A flat file to table transformation is required. Also orders from locations that have sales tax should be processed differently than orders from locations without sales tax.
  • Overall goal of the integration project. For example, combining a flat file purchase order with an XML purchase order, into a singe large purchase order that is stored in the supplier's database.
For example, you want to consolidate multiple purchase orders, verify that they conform to a specific format, and then:
  • A few Flat File sources need to be consolidated into a target XML file.
  • Files from one FTP site need to be moved to another.



Feedback | Notices


Timestamp icon Last updated: Thursday, 2 June 2016


http://pic.dhe.ibm.com/infocenter/wci/v7r0m0/topic/com.ibm.wci.gettingstarted.doc/getstart_planninganintegrationproject.html