Data Replication 2
Results 1 to 1 of 1

Thread: HOW TO: Create a simple Data Flow in Business Objects Data Integrator XI

  1. #1
    Adeeb Mass'ad is offline Support Manager
    Join Date
    Aug 2006
    Location
    Jaffa of Nazareth
    Posts
    169
    Rep Power
    14

    HOW TO: Create a simple Data Flow in Business Objects Data Integrator XI

    DESCRIPTION

    The Business Objects Data Integrator product includes direct support for the Attunity Server ODBC interface.

    In this article we will create a simple process which will copy the contents of one table to another. Both the Source and the Target can be Attunity Connect servers, or mixed with other native DI providers.

    This example was created in Data Integrator XI (v11.0).

    SCENARIO

    A simple scenario where we want to copy the CUSTOMER table from an RMS file on the AlphaVMS to a SQLServer table on Windows.

    STEP 1 - Create the DI Datastores

    1.1. Create the RMS Datastore
    • Click on the Datastore symbol, located at the bottom left panel.
    • Right-Click within the Datastore panel, and click on New.
    • Choose a Database name for the RMS DataSource, for example TestRMS.
    • Keep the Datastore type set to Database, and choose Attunity Connector from the Database type drop down list.
    1.2. Create the SQLServer Datastore
    • Perform the same steps and create a SQLServer DataSource named TestSQL.
    • The SQLServer DataSource could be created using Attunity if you own a license on the Windows platform, this is the preferable method since your DI processes will enjoy the Query Processor capabilities of Attunity Server.
    Another method which is less efficient is by creating a native SQLServer DataSource, for example:STEP 2 - Import the tables into Data Integrator

    Now that you have both DataSources defined in the Data Integrator as Datastores, you can start importing tables into the Designer.

    Importing the tables enables you among others to drag and drop the tables into the DI Designer.

    2.1. Import the Customer table
    • Double-Click on the TestSQL Datastore. this will retrieve the list of tables in the Designer.
    • Right-Click on the required table, for example Customer in this case, and click on Import.
    • Perform the same on the TestSQL Datastore.
    Note that both tables may not have the same fields, you can map whatever fields are required.STEP 3 - Create a Batch Job
    • Click on the Designer tab in the upper left panel.
    • Right-Click within the panel and click on New Batch Job, name the new job, for example Test.
    • Double-Click on the Test job to show it in the Designer.
    • Drag the Data Flow icon from the Palette and drop it on the Designer, call it TestData.
    STEP 4 - Design the process
    • Double-Click on the newly created TestData Data Flow.
    • Drag the "Query Transform" from the Palette to the Designer.
    • Drag the Customer table from TestRMS to the Designer, and select to make it the Source.
    • Drag the Customer table from TestSQL to the Designer, and mke it the Target.
    • Connect both tables to the "Query Transform" symbol.
    STEP 5 - Map the data

    Now that we have designed a process to copy data from the Customer table from RMS at the AlphaVMS machine, to the Customer table on the SQLServer, we need to map the data fields between the two tables.

    If both tables are similar the mapping will be straightforward, if the fields are different you can map them using the Drag and Drop capabilities of DI, and apply your customizations.
    • Double-Click on the Query Transform symbol in the Designer.
    • Drag and Drop the fields from the Schema In to the Schema Out table.
    When finished, close the Query Editor.

    STEP 6 - Execute the process

    Now we are ready to execute the process.
    • Right-Click on the Test process and click on Execute
    CONCLUSION

    Data Integrator is a capable ETL tool, it also includes full support for the Attunity AIS platforms.

    In this article we demonstrated a simple process which copies data from one Attunity DataSource to another. You can utilize the full power of DI with Attunity including Changed Data Capture.
    Last edited by Adeeb Mass'ad; 05-25-2007 at 07:57 AM.
    To Find Out more About Attunity Technology:
    Attunity
    or:
    Contact Us

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •