Get Data Moving 1
Results 1 to 2 of 2

Thread: Adding tables without Attunity Studio

  1. #1
    JeffInFlorida's Avatar
    JeffInFlorida is offline US Technical Team
    Join Date
    Oct 2006
    Posts
    95
    Rep Power
    13

    Adding tables without Attunity Studio

    Sometimes you may want to add tables to DB2 solutions in environment where using the Attunity Studio may be difficult. These directions are for manually adding tables to the solution but keep in mind that if you do a deploy using Studio they will be lost.

    Note: The Adapter must already exist before following the below steps, the easiest way is to use Studio and add a single table to it then deploy.

    Step 1: Export the adpater metadata:
    NAV_UTIL -B <binding name> EXPORT ADAPTER_DEF <adapter name> <output file name>


    Step 2: Edit the medadata and modify the table list:
    Example of output file from export:
    <?xml version='1.0' encoding='windows-1252'?>
    <navobj version='5.3.2.50'>
    <adapter name='LUWDB2_ag' type='DB2LUWCDCA'>
    <interaction mode='async-send' name='eventStream'>
    <interactionSpec>
    <capturedTable name='EMPLOYEE'/>
    <capturedTable name='DEPARTMENT'/>
    <disabledTables/>
    <filters/>
    </interactionSpec>
    </interaction>
    <schema/>
    </adapter>
    </navobj>


    Step 3: Import the adapter metadata:
    NAV_UTIL IMPORT SYS <output file name>


    Step 4: Disable and then Enable the agent workspace.
    Last edited by JeffInFlorida; 05-21-2014 at 10:15 AM.
    To Find Out more About Attunity Technology:
    Attunity
    or:
    Contact Us

  2. #2
    lucyjohn9090 is offline Junior Member
    Join Date
    Aug 2018
    Posts
    3
    Rep Power
    0
    Thanks for sharing

Posting Permissions

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