Visokio website     Downloads     Video tutorials     KnowledgeBase  
Database output drop table - Visokio Forums
Database output drop table
  •     Mees February 16, 2012 10:06AM
    We are updating data in tables on an external database using the Database output in DM.
    As the table is dropped and rebuilt by omniscope, all fieldsettings and indexes are changed or completely removed.
    This is causing the system running on these tables, to crash completely.

    We basically need a solution that just updates or adds records in an existing table without changing any structures.

    Is anything like this possible?

    Thanks
  • 3 Comments
  •     steve February 16, 2012 12:14PM
    Sure. You need to check the "Publish method" tab of "Database output". I think you want "Replace row data". Requires 2.7.
  •     OmarKhan July 20, 2012 5:14AM
    Hi Steve,

    I am trying to achieve the same using Server Plus and Scheduler.
    I would like to automate this step of updating data to the data table in my database.
    Can you please tell me which action to use in Scheduler
  •     chris July 20, 2012 5:18AM
    Hi,

    You need to setup a workflow in DataManager and then use the "Publish Data Manager Output Blocks" file action operation.
Add a Comment

Welcome!

It looks like you're new here. If you want to get involved, click one of these buttons!

Sign In Apply for Membership

Categories