1 Reply Latest reply: Apr 25, 2008 9:05 AM by 461680 RSS

    Can DB adapter poll the table for data

    554596
      Hi

      is below requirement possible with interconnect?.

      requirement:
      DB adapter should check/poll the table in the database on regular intervals and pick data new records from table and send to the hub.

      Please get back to me if this can be done using Interconnect DB adapter.Please suggest different ways to handle this using Oracle INterconnect.

      Thanks
      Aruneshwar
        • 1. Re: Can DB adapter poll the table for data
          461680
          No in Interconnect the DB adapter works by polling the tables owned by the OAI user, aotable, and messageobjecttable. In order to publish data from a table you must use the stubs generated in iStudio. You can write a package using those stubs which you can call from a trigger on the table.